EQEmulator Forums - SQL Version

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - SQL Version (https://www.eqemulator.org/forums/showthread.php?t=12670)

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:

Code:

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.

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.

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

Code:

cd /mysql/bin

mysql -u root mysql

GRANT ALL PRIVILEGES ON *.* TO &lt;username>@localhost IDENTIFIED BY '&lt;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....:)