2005 MYSQL world error
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 |
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 :
Code:
set-variable = max_allowed_packet=1M |
Quote:
|
Use MySQL 4.0.18
|
Yes, do what McFoxx says. The latest version of MySQL(4.1) has problems with permissions. Use 4.0.22
|
I will try that and see if it works, i'll get back to you.
I will try that and see if it works, i'll get back to you.
|
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 |
search for c:\my.cnf or c:\my.ini, check in your windows directory too, my.ini could be there :)
|
ok 2005 error fixed, but more have arrived :(
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? |
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? |
Something seems wrong with your perl IOscalar install. Check the guides/tutorials on how to setup a server and do that step again.
|
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?
|
| All times are GMT -4. The time now is 12:31 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.