eqemulogin database problems

[fzzzty]

This might not be the right forum but I'm not sure where it should go... I'm trying to get a server up and running on Windows and am receiving this error when starting the login server:

[Debug] [05.22.12 - 10:38:56] Logging System Init.
[Debug] [05.22.12 - 10:38:56] Config System Init.
[Error] [05.22.12 - 10:38:56] Database Initialization Failure.
[Debug] [05.22.12 - 10:38:56] Config System Shutdown.
[Debug] [05.22.12 - 10:38:56] Log System Shutdown.

The config file is there and correct, I can log in via the mysql shell just fine... I am however using mysql 5.5 right now. Is that unsupported? I'm looking for a 5.0 installer; I won't be able to build it from scratch, and that so far is all I've found on Oracle's site...

[lerxst2112]

http://downloads.mysql.com/archives....sql-5.0&o=-win

Don't know if it will fix your problem though. I suspect you may be missing the tables necessary for the login server to work as that is a common problem. This guide: http://www.eqemulator.org/forums/showthread.php?t=31783 has details on what you need to do if you search for "Install EQEmuLoginServer" on the page. Skip anything you've done as the result of whatever guide you have been following, and don't get confused if you compiled your own login server (which I recommend), and you should be fine. The important parts are creating the tables for registration and accounts and getting the right values into them.

[fzzzty]

Great, thanks! Everywhere I went to took me to dev.mysql.com, and apparently only displayed the latest version, which has no MSI... This should be a lot easier. I suspect it won't help either, since the code can create the MySQL database object, but it's worth a try.

Regarding the tables, they're in there. I only created the tables listed in the eqemuloginserver repository install file, though. The statements in:

http://projecteqemu.googlecode.com/s...rDBInstall.sql

If it requires other tables, they aren't there (this is a separate DB from the "main" world DB). I might just modify the login server to actually output an error message from MySQL...if I can get it to compile...and that information is available.

[lerxst2112]

Check your login.ini file. Chances are the [Database] section is incorrect, as that is the only way to trigger that particular error message as far as I can tell.

If you do not have that file in your server directory you can find the default copy in trunk\EQEmuServer\EQEmuLoginServer\login_util. Edit it to match your database username/password.