PDA

View Full Version : Mysql has gone away, the sequel.


DeathMan
07-08-2004, 11:25 AM
I think I misspelled sequel, but anyway, I run the Mysql database thingy (the one that makes a stoplight thingamajig next to the time.) and It still comes up with this.


Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.7-DR6
[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] 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
[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: *.* 9000
World server listening on: *.* 9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1



*.* = Not for you to know.

Hit any key to exit

eristole
07-09-2004, 01:54 AM
you mean, winmysqladmin.exe.

hit ctrl, shift, esc.

(or to be stupid about it, just go start, run, type in "taskman" and hit enter.)

then look under processes. the one you should be mostly concerned about seeing there is "mysqld-nt.exe"

thats the big bopper of databases.. make sure thats running.
(if it isnt, it usually gets booted up when you run mysql admin so this probably isnt your problem but i'd check it so you have a solid base to stand on when you start to trouble shoot this.)

another thing to check, look in your "DB.ini" file, and double/quadruple check that your login/password matches what you see in winmysqladmin.exe(or as you so eloquently put it) that flashy green red light thingy next to my clock.

to find your l/p in that green red lighty thingy next to your clock.. right click on it, goto show me. look under the "my.ini setup" tab. and find your user and password.

i'm chalking this error up to a simple mistake in either your entering the L/P in your DB.ini or your granting permissions for it when you setup your Database.

imho however.. i'm a f***ing retard.

go figure, just some things that you might want to check out.