MySQL Login Problem

[worwick]

Hi guys and gals,

I am having a little problem that I can not figure out. I have an Ubuntu server (Latest version) set up. I installall the server files and follow directions to the max. I had a problem with the IP addresses needing to be set in all conf files. Did that and fixed one problem. Now I get a failure to login to GameDB. I check to make sure I used the correct password for MySQL and it worked fine through phpadmin. But when I try to login manually at the server, it won't let me. I think this is why I get a Failed Login to GameDB.

Any ideas why?

Also, there was one piece that I could not figure out that was in Romulan's instructions for server setup.
that will give you access to the MySql database from BATGM.

"You need to configure Batgm too, it's very easy:
1. Enter the server ip and select the MySQL option in the dropbox of the SQL server type!"

This line went swoosh right over my head. Where do you put in the IP address at? And what drop down box?

setting up batgmadmin, was easy. Just cant figure out the second part for batgm.

Thanks in advance for any information possible.

[MentaL]

[rbb138]

gameDB usualy doesnt mean your mysql

usualy GameDB refers to the process gamedbd which houses all your character data.

check the file /PWServer/gamedbd/gamesys.conf


also to setup batGM you need to edit batgm.ini and put in all your server infomation. then batgm should work.

if you are still having problems with your mysql, check the file /etc/table.xml
this file needs to have the correct infomation about your mysql database.
you can verify the infomation to login to it by either using batGM or annother remote mysql program such as navicat.

[redravensc]

thanks for the information. I now have a place to start lookint for the problem.

Thanks again.