Why do all server files do not work with WAMPSERVER 5.0?

06/27/2015 05:49 huudai2003#1
I tried to make ACCServer and MSG + NPC work with WAMPSERVER 5.0

[Only registered and activated users can see links. Click Here To Register...]

But ACCServer and 2 others couldn't connect to mysql server even phpMyAdmin as well as Navicat could connect to 127.0.0.1 / User: root / User: test
What did I do wrong?

----------------------------
The reason why I chose WAMP because I think I could use PHP + AJAX to write an app in order to make changes inside the database easier.

Can anyone help?
06/27/2015 06:50 idlemonkey#2
first off the server files come with a mysql 4.x install inside them wamp server 5.0 uses an incompatible version of mysql 5.x

second off wamp doesnt come with the account or game databases inside it or the users or user info for the account or game server.

to make those server files work literally all you need to do is the following.

open the folder mysql/bin/ and click the mysqlmyadmin.exe and type root test and press continue in the window that opens.

click the accountserver.exe and let it load.
click the gameserver.exe and let it load.
click the npc server and let it load.
log into the game from the same computer it is on by copying the "servername" from the account server to your 00client.


i dont advise anyone to use wamp xamp easyapache or iis or windows at all to host a website anyways they all have their flaws which can cripple your server
06/27/2015 08:48 huudai2003#3
I converted all the database 4x to the new format 5x and worked perfectly with mysql server.

What I do understand is those SQL code inside ACCServer ain't update itself. Everytime I turn on the server it keeps crashing and give me no log or what so ever. I did read them and see that 2 out of 3 couldn't connect to the server so I assumed that the last one was the same. I tried a few decompile programs but seem like none of them was working.

If I hosted it on another computer in LAN, how can I access the server from a different computer?
06/27/2015 16:43 idlemonkey#4
net framework framework windows firewall and proper login details .... why are u bothering with wamp install u dont need it lol the mysql install included with the files has the right user info ...
if u dont create a user test test or change the user pass for the accserver it cant login to mysql

to host it on another computer change the accserver ip and gameserver ip in the config.ini and shell.ini in the gameserver and config.ini in the accserver folder also you may need to add lines to the config.ini for servername server ip and database ip depending on your environment
06/27/2015 17:13 huudai2003#5
Quote:
Originally Posted by idlemonkey View Post
if u dont create a user test test or change the user pass for the accserver it cant login to mysql
The problem is I did change but they wont connect.
However, thanks for the instruction. I will try to follow it myself.
06/27/2015 17:17 idlemonkey#6
if you changed the password then you need to also change the password in the config files