[Re-Upload Audition Server v1.7] Server Files & Client & Tools

[gyokujin]

So when I use the user and password in sqlyog, it said "access denied for user 'ragezone'@'localhost'", but when I use the OLD_PASSWORD command on mysql, it said user doesn't exist (again).
How do I create a new user with navicat (which, I'm sorry, I have never used)?

 

[ulfman]

So when I use the user and password in sqlyog, it said "access denied for user 'ragezone'@'localhost'", but when I use the OLD_PASSWORD command on mysql, it said user doesn't exist (again).
How do I create a new user with navicat (which, I'm sorry, I have never used)?

With Navicat its easy :

1.Connect to MySQL with your "root" account
2.Then click on "Manage Users"
3.Click from there on "New User"
4.Insert the Acccount Informations
5.After all the Informations are complete, click on "save"

I hope it will work

 

[gyokujin]

It's a trial, but could I uninstall after without consequences db?

 

[ulfman]

It's a trial, but could I uninstall after without consequences db?

Yea no Problem.

 

[dahsyat]

Hi sir, this is can make to private server online ?

 

[gyokujin]

So, I create the new user on navicat, gave all permissions for whatever, was able to execute the databases onto sqlyog, and there're still problems.

Logindbagent:

[2020-09-26 01:52:41.548] [Connect Error] 127.0.0.1 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
[2020-09-26 01:52:41.615] DB Agent Server Start !!!
[2020-09-26 01:52:41.929] connected from [127.0.0.1]

[2020-09-26 01:54:22.822] [Connect Error] 127.0.0.1 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
[2020-09-26 01:54:22.822] Query Error : 629, SELECT lq.Level, li.Exp, lq.Score, lq.Perfect, lq.ConsecutivePerfect, lq.GameMode, lq.MusicCode, lq.StageCode, lq.Fee, lq.WinDen, lq.WinExp FROM Level_Quest lq, LevelInfo li WHERE lq.Level = li.Level , [2006 MySQL server has gone away]
[2020-09-26 01:54:22.822] Query Error : 629, SELECT MusicIndex, MusicFile FROM music, [2006 MySQL server has gone away]
[2020-09-26 01:54:22.860] DB Agent Server Start !!!

And it'll say on gameserver:

[2020-09-26 01:54:58.697] DBAgent Server[127.0.0.1] connecting...
[2020-09-26 01:54:58.797] DBAgent Server connect OK~~ [101] !
[2020-09-26 01:54:59.198] Agent Server connecting...[2020-09-26 01:54:59.701] Wait For Responsing from DBAgentServer!

And nothing else.
Hopefully there're more solutions, but I'm convinced otherwise that something hates me.

 

[ulfman]

Re: [Re-Upload Audition Server v1.7] Server Files & Client & Tools

Hi sir, this is can make to private server online ?

Try with Hamachi or something like this. Dont tested it.

So, I create the new user on navicat, gave all permissions for whatever, was able to execute the databases onto sqlyog, and there're still problems.

Logindbagent:

[2020-09-26 01:52:41.548] [Connect Error] 127.0.0.1 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
[2020-09-26 01:52:41.615] DB Agent Server Start !!!
[2020-09-26 01:52:41.929] connected from [127.0.0.1]

[2020-09-26 01:54:22.822] [Connect Error] 127.0.0.1 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
[2020-09-26 01:54:22.822] Query Error : 629, SELECT lq.Level, li.Exp, lq.Score, lq.Perfect, lq.ConsecutivePerfect, lq.GameMode, lq.MusicCode, lq.StageCode, lq.Fee, lq.WinDen, lq.WinExp FROM Level_Quest lq, LevelInfo li WHERE lq.Level = li.Level , [2006 MySQL server has gone away]
[2020-09-26 01:54:22.822] Query Error : 629, SELECT MusicIndex, MusicFile FROM music, [2006 MySQL server has gone away]
[2020-09-26 01:54:22.860] DB Agent Server Start !!!

And it'll say on gameserver:

[2020-09-26 01:54:58.697] DBAgent Server[127.0.0.1] connecting...
[2020-09-26 01:54:58.797] DBAgent Server connect OK~~ [101] !
[2020-09-26 01:54:59.198] Agent Server connecting...[2020-09-26 01:54:59.701] Wait For Responsing from DBAgentServer!

And nothing else.
Hopefully there're more solutions, but I'm convinced otherwise that something hates me.

I think the best would be, if you start from scratch again.

 

[gyokujin]

Actually, I think I did something right for the first time, and now the game works fine now.

Now I want to learn how to set up a localhost website for buying clothing. I downloaded the xampp and replaced the files.

 

[ulfman]

Actually, I think I did something right for the first time, and now the game works fine now.

Now I want to learn how to set up a localhost website for buying clothing. I downloaded the xampp and replaced the files.

Great to hear that the Game & Server is running fine now

For the Website you can use "AppServ" too that is linked in here. For your Browser you need to have install "Adobe Flash",
then it should work fine.

 

[gyokujin]

Oh, so I didn't have to download xampp as told from the older guide?
I downloaded it, so a better question would be whether I can use xampp, if you know how to set up through xampp.
And use as an example, the website link would be the (ip address)/audition, right?

 

[ulfman]

Oh, so I didn't have to download xampp as told from the older guide?
I downloaded it, so a better question would be whether I can use xampp, if you know how to set up through xampp.
And use as an example, the website link would be the (ip address)/audition, right?

I dont tested it with XAMPP, only with AppServ. Yea the Address is correct, you need to edit the Database Settings in the
following File :
..\audition\include\config.inc.php

Good Luck

 

[gyokujin]

I have mysql 4.1.21 setup. Is this AppServ/mysql installer separate, or will it override my already installed mysql?

 

[ulfman]

I have mysql 4.1.21 setup. Is this AppServ/mysql installer separate, or will it override my already installed mysql?

Yea its separate, but if you have already installed "XAMPP" then use it. Because you need to redo the Database Part if you want to use
"AppServ".

 

[gyokujin]

I'm going to install that appserv because at least you're active so I can ask questions, unless you know someone that can help me set up with xampp.
Evidently, I don't know how to either way, so please help me with the appserv.

I just installed appserv, what do I do to get a website that functions to buy clothes?

 

[ulfman]

I just installed appserv, what do I do to get a website that functions to buy clothes?

Some Instructions that worked for me :

1.First you need to put Clothes Ingame into your Shopping Cart and then Exit the Game
2.Go to your Audition Website (Flash is needed) and login to your Account under CashShop Area -> Cash Items
3.Now you should see the Entrys about your Shopping Cart. Finally buy them
4.Go Ingame again to the Shopping Mall, if the buyed Articles are not there. You need to Exit the Shopping Mall
and go in her again and the Articles should now finally be there

For the Clothes you need Money that you can edit in the following Websitefile :
...\www\audition\include\config.inc.php

There is a Bug where you can buy Clothes that you already have. I dont know how to fix that

Good Luck

 

[gyokujin]

That helped. Thank you.

Final questions, hopefully.

I'm making custom abm, do you know what I put under "string" for each song?
And something that probably no nobody has, but it's worth asking, do you know if ANYONE still has 1.75, or at least a patcher for it?

 

[naumenox]

Friend have error ,

[2020-10-20 00:40:02.312] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.313] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.313] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.314] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.315] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.315] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.315] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.315] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.315] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.316] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.316] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.317] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.317] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.318] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.319] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.319] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.320] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.325] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.326] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.332] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.499] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.500] [connect error] 127.0.0.1 - client does not support authentication protocol requested by server; consider upgrading mysql client[2020-10-20 00:40:02.500] query error : 44, select lq.level, li.exp, lq.score, lq.perfect, lq.consecutiveperfect, lq.gamemode, lq.musiccode, lq.stagecode, lq.fee, lq.winden, lq.winexp from level_quest lq, levelinfo li where lq.level = li.level , [2006 mysql server has gone away][2020-10-20 00:40:02.500] query error : 44, select musicindex, musicfile from music, [2006 mysql server has gone away][2020-10-20 00:40:02.962] db agent server start !!!

 

[gyokujin]

Look like you're having the same problem I had. Here's some questions to help you.

- Do you have all the programs and files from the guide except for appserv? You can use xamp instead, which I find a bit easier to use.
- Are you using the "ragezone" credentials? How did you create that ragezone credential? You need to create a new user using either the mysql command line, or an external program. I use HeidiSQL, which is free.
- Do those credentials have administrative access to sql databases? Again, I use HeidiSQL to check whether the "ragezone" credentials have full access to ALL database files.

 

[naumenox]

Look like you're having the same problem I had. Here's some questions to help you.

- Do you have all the programs and files from the guide except for appserv? You can use xamp instead, which I find a bit easier to use.
- Are you using the "ragezone" credentials? How did you create that ragezone credential? You need to create a new user using either the mysql command line, or an external program. I use HeidiSQL, which is free.
- Do those credentials have administrative access to sql databases? Again, I use HeidiSQL to check whether the "ragezone" credentials have full access to ALL database files.

I am using mysql 4.1 and IIS , if I activate with sqlyog create a user ragezone @ localhost, with the password ragezone, but anyway it throws me that error, do you have discord to be able to communicate with you? Cheers

 

[gyokujin]

I don't understand much of what you said. Can you reword your last message into something more comprehensible?