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....