Error #2006

Kran · #1 11-08-2003, 04:35 AM

When i start "Boot5zones.bat" it say this :

Code:

Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[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 varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zone names
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 s
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 s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Loading items FAILED!
Failed.  But ignoring error and going on...
[Status] Loading npcs
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetNPCTypesCount query 'SELECT MAX(id), count(*) FROM npc_types' #2006:
 MySQL server has gone away
Error: Database::LoadNPCTypes-ShareMem: GetNPCTypesCount() returned &lt; 0
[Error] Loading npcs FAILED!
===============================
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?id
=3

Hit any key to exit

my Boot5zones.bat

Code:

REM:--------------Start-----------------------

@echo off



if NOT exist spells_en.txt goto NOSPELL



start zone . localhost 7995 localhost

start zone . localhost 7996 localhost

start zone . localhost 7997 localhost

start zone . localhost 7998 localhost

start zone . localhost 7999 localhost

exit

cls



:NOSPELL

echo You did not copy the spells_en.txt from your everquest directory to this one.  Please do so or zones will crash on startup.

PAUSE



REM:---------------END------------------------

my db.ini

Code:

[Database]

host=localhost

user=****

password=***

database=eq

compression=off

my loginserver.ini

Code:

[LoginServer]

loginserver=localhost

loginport=5997

worldname=French_Knight's

worldaddress=localhost

locked=false

account=

password=



[WorldServer]

Defaultstatus=

Unavailzone=



[LoginConfig]

ServerMode=Standalone

ServerPort=5997

UplinkAddress=

UplinkPort=

UplinkAccount=

UplinkPassword=

I have try

Code:

grant all privileges on *.* to test@localhost identified by 'test' with grant option;

that's change anythings !

if some one help that will be fine

#2 11-08-2003, 07:00 AM

Tried the suggestions in the sticky topic a few posts up ... 'Possible Solutions to #2006' ? If so, delete your db.ini and type everything back in manually, sometimes there is white space or strange characters in there.

E.g. if you launch a command prompt and load the default db.ini into the 'DOS' editor, you will see 'music' symbols in there at the end of each line, like this:

Quote:

# READ README.TXT!♪
♪
[Database]♪
host=localhost♪
user=YourMysqlUsername♪
password=YourMysqlPassword♪
database=eq♪
compression=off♪
♪
♪
### --- This file tells world.exe what computer mySQL is on. Host should♪
### --- be left "localhost" unless mysql is on a differant computer than world

Kran · #3 11-08-2003, 09:22 AM

Thanks but I have try 'Possible Solutions to #2006' but that still not work ! :cry: :cry: :cry:

kai_shadowbane · #4 11-08-2003, 01:34 PM

retype the db.ini by hand, it's an error in the db file, hence it not readint the correct compression parameters

Kran · #5 11-08-2003, 07:31 PM

thanks all that's work now !! :lol: :lol: :P