Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion
Reload this Page 2005 MYSQL world error

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2004, 12:04 PM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default 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
Reply With Quote
  #2  
Old 11-15-2004, 08:27 PM
Muuss
Dragon
  
Join Date: May 2003
Posts: 539
Default
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
replace the 1M by 8M, and retry.
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote
  #3  
Old 11-16-2004, 02:21 AM
Cisyouc
Demi-God
  
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default
Quote:
#2006: MySQL server has gone away
Make sure your DB.INI is correct.
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
Reply With Quote
  #4  
Old 11-16-2004, 02:39 AM
McFox666
Sarnak
  
Join Date: Nov 2004
Posts: 62
Default
Use MySQL 4.0.18
Reply With Quote
  #5  
Old 11-16-2004, 02:46 AM
mrea
Discordant
  
Join Date: Sep 2004
Location: Camp Hill,PA
Posts: 370
Default
Yes, do what McFoxx says. The latest version of MySQL(4.1) has problems with permissions. Use 4.0.22
__________________


Reply With Quote
  #6  
Old 11-17-2004, 10:38 AM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default 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.
Reply With Quote
  #7  
Old 11-17-2004, 02:44 PM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default
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
Reply With Quote
  #8  
Old 11-17-2004, 08:45 PM
Muuss
Dragon
  
Join Date: May 2003
Posts: 539
Default
search for c:\my.cnf or c:\my.ini, check in your windows directory too, my.ini could be there
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote
  #9  
Old 11-18-2004, 09:44 AM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default 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?
Reply With Quote
  #10  
Old 11-18-2004, 11:09 AM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default
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?
Reply With Quote
  #11  
Old 11-18-2004, 08:39 PM
Muuss
Dragon
  
Join Date: May 2003
Posts: 539
Default
Something seems wrong with your perl IOscalar install. Check the guides/tutorials on how to setup a server and do that step again.
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote
  #12  
Old 11-19-2004, 09:46 AM
sileosicarius
Fire Beetle
  
Join Date: Oct 2004
Posts: 9
Default
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?
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

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

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3