PDA

View Full Version : 2005 MYSQL world error

sileosicarius
11-15-2004, 12:04 PM
Can anyone help out with this probelm, i get the error when i run world.exe..?
Got signal 0
[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
[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
Abort/retry/cancel?
TCP listening on: XX.XX.XX.XX:9000
World server listening on: XX.XX.XX.XX: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?id
=3

Hit any key to exit
Muuss
11-15-2004, 08:27 PM
It may (I say 'may', notice) come from a problem with packet's size. In your my.cnf, there's a row that looks like :
set-variable = max_allowed_packet=1M

replace the 1M by 8M, and retry.
Cisyouc
11-16-2004, 02:21 AM
#2006: MySQL server has gone away Make sure your DB.INI is correct.
McFox666
11-16-2004, 02:39 AM
Use MySQL 4.0.18
mrea
11-16-2004, 02:46 AM
Yes, do what McFoxx says. The latest version of MySQL(4.1) has problems with permissions. Use 4.0.22
sileosicarius
11-17-2004, 10:38 AM
I will try that and see if it works, i'll get back to you.
sileosicarius
11-17-2004, 02:44 PM
Couldnt find the my.cnf, i uninstalled 4.1 and installed 4.0.18, but still no luck saying the same thing.
--------------------------------------------------------------------------
Got signal 0
[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
[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
Abort/retry/cancel?
TCP listening on: XX.XX.XX.XX:9000
World server listening on: XX.XX.XX.XX: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?id
=3

Hit any key to exit
Muuss
11-17-2004, 08:45 PM
search for c:\my.cnf or c:\my.ini, check in your windows directory too, my.ini could be there :)
sileosicarius
11-18-2004, 09:44 AM
OK, i fixed the 2005 error through the db.ini, but now i get this and dont know what to do.

World.exe
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
HELP I WORK IN THE EQEMU SWEATSHOP, YOU'RE MY ONLY HOPE!
TCP listening on: 68.48.0.13:9000
World server listening on: 68.48.0.13:9000
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10061'

db.ini
# READ README.TXT!

[Database]
host=localhost
user=root
password=admin
database=eq

login.ini


# READ README.TXT

[LoginServer]
loginserver=192.168.1.101
loginserver2=192.168.1.101
loginport=5999
loginport2=5999
worldname=testserver
worldaddress=68.48.0.13
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

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

and bootzone5
I have installed IO Scalar, and it prints the Intstalled, so i am at a loss on this one too!

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Status] Error initializing perlembed: failed to install plugin printhook, do yo
u lack IO::Scalar?
[Status] Fatal error initializing perl: failed to install plugin printhook, do y
ou lack IO::Scalar?
sileosicarius
11-18-2004, 11:09 AM
OK fixed login with minilogin, so thats done, but i am still getting the boot5zone.bat error posted below, so what should i do? Cause i installed io right cuase it prints out the Installed on my screen......

other code above removed for space

-------------------------------------------------
[Status] Loading embedded perl XS
[Status] Error initializing perlembed: failed to install plugin printhook, do yo
u lack IO::Scalar?
[Status] Fatal error initializing perl: failed to install plugin printhook, do y
ou lack IO::Scalar?
Muuss
11-18-2004, 08:39 PM
Something seems wrong with your perl IOscalar install. Check the guides/tutorials on how to setup a server and do that step again.
sileosicarius
11-19-2004, 09:46 AM
Ok, i have reinstalled it and after manually adding the .pms, it still tells me that it is installed correctly. so now what..? can anyone post a good version of the perl, with the io scalar and wraptie that i might try?