PDA

View Full Version : Plz Help, mysql 2006 problem


dnk
01-16-2005, 02:12 AM
This 2006 almost kill me.
I have been reading thread and trying all kinds of solutions mentioned in them, but it still does't work.

When I start world.exe, it gives me this:


[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[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 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 s
erver has gone away
[Status] Clearing groups..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Unable to clear groups: #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 in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver 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.
Invalid worldshortname, please edit LoginServer.ini. Short server name must be
at least 3 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
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
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
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: 'Login server responded with
FatalError. Disabling reconnect.#2006: MySQL server has gone away
Error message: 'Bad server name. Unknown reason.'
'
127.0.0.1:5999: TCPConnection::RecvData(): Error: 10053


Some info:
1, System: Windows XP
2, mysql version: 4.1

I have tried these:
1, add a space after host, user, password in db.ini
2, start mysql with --max_allowed_packet=16M
3, tried change host in db.ini, localhost, 127.0.0.1, 192.168.0.6(this is my ip)
4, All kinds of the grant staff

Please help me, Thanks a lot

RangerDown
01-16-2005, 04:58 AM
Post db.ini too.
(Edit: when you do, mask out the password if feel it necessary. But be sure the password is correct and you have no trailing space on that line.)

Cisyouc
01-16-2005, 06:36 AM
Make sure that mysqld-nt.exe is running in the task manager (It will be in the processes tab and labeled as SYSTEM. If this is not running, thats your problem).

dnk
01-16-2005, 12:57 PM
Post db.ini too.
(Edit: when you do, mask out the password if feel it necessary. But be sure the password is correct and you have no trailing space on that line.)

db.ini:


[DataBase]
host=192.168.0.6
user=root
password=********
database=eq


"host" I have tried localhost, 127.0.0.1

dnk
01-16-2005, 12:59 PM
Make sure that mysqld-nt.exe is running in the task manager (It will be in the processes tab and labeled as SYSTEM. If this is not running, thats your problem).

I am sure Mysql is running, because mysql-front can connect to mysql server with the same address, user name and password I used in db.ini....

Branks
01-16-2005, 01:08 PM
i had this problem and fixed it by remaking db.ini manually in notepad, dont copy/paste just retype it all etc and make sure theres no white space after lines.

dnk
01-16-2005, 01:29 PM
i had this problem and fixed it by remaking db.ini manually in notepad, dont copy/paste just retype it all etc and make sure theres no white space after lines.

Thanks Branks, I have tried this but didn't work.
I used UltraEdit instead of Notepad, I thought this shouldn't be a problem, UltraEdit is a very good editing software =P...

Seb
01-19-2005, 01:26 AM
I solved same problem by executing this at mysql:

GRANT ALL PRIVILEGES ON EQDATABASEHERE.* TO MYMYSQLUSERNAME@localhost IDENTIFIED BY 'MYMYSQLPASSWORD' WITH GRANT OPTION;