EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Plz Help, mysql 2006 problem (https://www.eqemulator.org/forums/showthread.php?t=17683)

dnk 01-16-2005 02:12 AM
Plz Help, mysql 2006 problem
 
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:

Code:
[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
Quote:
Originally Posted by RangerDown
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:

Code:
[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
Quote:
Originally Posted by Cisyouc
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
Quote:
Originally Posted by Branks
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:
Quote:
GRANT ALL PRIVILEGES ON EQDATABASEHERE.* TO MYMYSQLUSERNAME@localhost IDENTIFIED BY 'MYMYSQLPASSWORD' WITH GRANT OPTION;


All times are GMT -4. The time now is 01:01 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.