SQL Version

[Pneu]

Hello EqEmu folks, i'm back after a very long break and thought i'd check out EqEmu again to see how it has progressed ;)

However i'm stuck setting up my server because it refuses to talk to the SQL database and i'm not sure why. I have vigorously checked logins/passwords for it, I even tried downing my firewall just incase.

I piped World.exe's error to a text file and got this:


Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10 characters.
[Status] LoginServer.ini read.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: 192.168.0.1:9000
World server listening on: 192.168.0.1:9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit


Which very much seems to imply I have not set up my SQL username/password properly, but I am sure I have and have even deleted the my.ini in my Windows folder.

So I was wondering - as I am a fresh download - does EqEmu require an older version of SQL? I am using MySql 4.0.18.

I am using XP Professional, and it is a fresh install from just a few weeks back. I am using Minilogin which I found in my archive of downloads. Everything else is the latest version as of last night.

[ndnet]

I was able to reproduce the same world.exe output but with a different SQL error message, (#2003 opposed to yours). I just stopped the sql service that was running in the taskbar and instant error spam ~.~

Your text implies that you're able to connect to the sql server, you're just getting blocked by the name/pw.

Make sure that it's running, anywho, will only take a moment to check (ctrl-alt-del -> processes tab and look for sql).

Check your db.ini file to make sure that you did enter that name/password correctly, also check to make sure you didn't accidentally tack on a space at the end of a line.

Hrmm, also maybe you want to redo the granting of privileges for your username/password step of the how-to's.

If you're still having problems you may want to start posting config file text for us.

[samandhi]

You'll be using the UN/PW that you assinged MySQL when you ran winmysqladmin.exe Just open up a dos command and type the following...
cd /mysql/bin
mysql -u root mysql
GRANT ALL PRIVILEGES ON *.* TO <username>@localhost IDENTIFIED BY '<password>' WITH GRANT OPTION;
quit
Note the all caps, and also the ' (apostrophe) keys before and after your password (this IS needed)... One more thing to note, dont use the < and > keys in your UN/PW This SHOULD solve your problem..

If it doesnt open up windows explorer or mycomputer and browse to C:/windows find the file my.ini and delete it... Now browse to C:/mysql/bin (assuming you intalled mysql in default location), and run winmysqladmin.exe, and it should ask you for a new username and password, then repeat the GRANT command from above....
Hope this helps you out....:)