MySQL Error #2005

[hikaze]

Well, first off I'd like to admit I'm a complete n00b at running EQemu and have run into the error upon loading the Worlddebug.exe. Here's what it's listing and the place it says for me to visit looks like has expired or moved...

Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.6-DR1
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM vari
bles where unix_timestamp(ts) >= 0' #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
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL
erver 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 in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[LoginServer] block not found in './LoginServer.ini'.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ra
k5, rank5title from guilds' #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
Warning: Pants may change during online play.
TCP listening on: port 9000
World server listening on: port 9000
===============================
Runtime errors:

MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?i
=3

Hit any key to exit

Any help would be great! I've tried searching for that error in the forums and the web... but came to no help. Thanks!

[samandhi]

Check out THIS thread for your error... You also have a problem in your loginserver.ini..

I see that you are trying to run a 5.6 server.. Unless you have a compatible DB for that then you will also get that error..

[hikaze]

Thank you for your prompt response... I did notice about the version that came up during world debug... however I'm afraid I'm not aware how to fix this exactly. The database that I populated the eq database with was PEQ_Classic_058.sql... here's what is in my loginserver.ini..

### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.

### --- Public Login is un-supported as is LAN playing. We recommend using the eqemulator.

net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginport=5997
worldname=Isamu's World of EQ
worldaddress=xxx.xxx.xxx.xxx
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

XXX being my external IP. Thanks for your help, I appreciate it. =)

[samandhi]

You are trying to use a database that is NOT compatible with the version of the emu you are running.... Unless you are patched to the date that 5.6 was still good (equal with live) then you will also have problems connecting with your server when/if you get the server running correctly. I am not sure of the date that 5.6 was still compatible with the live client, as I was away from the boards during this period, but the best way to check is to read the changelog.txt file that comes with the source. Use the last date on that as a general rule of thumb that you have to be patched (your client) to around that time..

If in fact you CAN get a 5.6 DB, AND your client is of the right patch, then you need to change your loginserver.ini to port 5995 instead of 5997.... and you will also have to change your eqhost.txt file to reflect this change.....