error 2006 Mqsql server has gone away
can anyone tell me how to resolve this.
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2 [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.. [Error] LoadEMuShareMemDLL::Load() failed to load library 'EMuShareMem'. Error= 126 [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.. [Error] Could not load EQTime file ./eqtime.cfg I also see many more error 2006 mysql server error has gone away. |
sounds like the grant statement wasnt done.
from the server setup guide Quote:
|
:oops: I closed mysql thats what happened. I have another question. I uninstalled mysql a while back but when i reinstalled it for EQEMU it didn't ask to enter in a new ID and sometimes the grant command won't work for my ID.. It's kind of confusing to explain :shock:
|
|
I have a new and unique problem.
I've searched around and i think i have a unique problem. I finally have my server up and running. I can see it and get to a char select screen. But when i go to get on a character. I get sent out to the server select screen or even the title screen and sometimes it crashes my computer!!! with no err. messages. Other people get 1017 when trying to login. Here is my info: db.ini [Database] host=localhost user=******* password=**** database=eq compression=off loginserver.ini [LoginServer] loginserver=eqlogin1.eqemulator.net loginserver2=eqlogin2.eqemulator.net loginserver3=eqlogin3.eqemulator.net loginport=5997 loginport=5997 loginport=5997 worldname=you don't need to know that worldaddress=internal ip locked=false [WorldServer] Defaultstatus=0 Unavailzone= [LoginConfig] ServerMode=Standalone ServerPort=5999 UplinkAddress= UplinkPort= UplinkAccount= UplinkPassword= boot5zones.bat @echo off if NOT exist spells_us.txt goto NOSPELL start zone . external IP 7995 internal ip start zone . external ip 7996 internal ip start zone . external ip 7997 internal ip start zone . external ip 7998 internal ip start zone . external ip 7999 internal ip exit cls Now the output world.exe [Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR2 [Status] Loading variables.. [Status] Loading zones.. [Status] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=26679, max id=68199 [Status] LoginServer.ini read. [Status] Loading guild ranks.. [Status] Loading addon.ini.. [Status] Loading EQ time of day.. [Error] Could not load EQTime file ./eqtime.cfg [Error] Unable to load ./eqtime.cfg [Status] Reboot zone modes ON [Status] Deleted 0 stale player corpses from database [Status] Deleted 0 stale player backups from database Breaking bards...done TCP listening on: internal ip:9000 World server listening on: internal ip:9000 Connected to LoginServer: eqlogin1.eqemulator.net:5997 16625 New TCP connection: internal ip:1570 New zoneserver: #1 internal ip:1570 Zoneserver SetConnectInfo: internal ip:1570: external ip:7999 16719 New TCP connection: internal ip:1571 16719 New TCP connection: internal ip:1572 16719 New TCP connection: internal ip:1573 16719 New TCP connection: internal ip:1574 New zoneserver: #2 internal ip:1574 New zoneserver: #3 internal ip:1573 New zoneserver: #4 internal ip:1572 New zoneserver: #5 internal ip:1571 Zoneserver SetConnectInfo: internal ip:1571: external ip:7996 Zoneserver SetConnectInfo: internal ip:1572: external ip:7995 Zoneserver SetConnectInfo: internal ip:1573: external ip:7997 Zoneserver SetConnectInfo: internal ip:1574: external ip:7998 450453 New client from ip: internal ip port: 1582 Logged in: FirstLogin LS#43313: nascarfan1888 Attempting autobootup of gfaydark (54) for Tester Zoneserver SetZone: external ip:7996 gfaydark (54) Outgoing connection made to ZoneProxy Alias zone name: tutorial Zone gfaydark is NOT third-party Enter world: Tester: gfaydark (54) Broadcasting a world time update Zoneserver SetZone: external ip:7996 gfaydark (54) Client disconnected Removing client from ip:internal ip port:1582 Zoneserver SetZone: external ip:7996 (0) Zoneserver SetZone: external ip:7996 (0) zone.exe [Status] CURRENT_ZONE_VERSION: EQEMu 0.5.3-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] Loading guilds [Status] Loading factions [Status] Loading corpse timers [Status] Loading what ever is left [Status] Loading commands [Status] 149 commands loaded [Status] Entering sleep mode Connected to worldserver: internal ip:9000 [Status] Weather should change in 6728 seconds Init: Loading zone lists, zone state or spawn list, player corpses Zonepoints loaded into memory , timezone data - Done. ZoneID = 54; Time Offset = 0 Reading zhdr file './cfg/gfaydark.cfg' Using database for safe coords. Zone safe coords are x = -140; y = 73; z= 1 [Status] Loading Objects from DB... [Status] Loading Ground Spawns from DB... [Status] Loading doors for gfaydark ... [Status] Done loading doors for gfaydark ... [Status] Zone Bootup: gfaydark (54) Got ServerOP_SetAliasZone Got SetAliasZone_Struct Not a third-party zone Received Message SyncWorldTime Time Broadcast Packet: EQTime [11:40 am] [Status] Zone Shutdown: gfaydark (54) Any suggestions would be helpful :D |
i believe your worldaddress in the login.ini should be your external ip..(ie real ip addy)
|
Quote:
|
Did you try and read and DO the things listed in THIS post?
|
Try updating your self also.
http://www.eqemulator.net/forums/viewtopic.php?t=12723 That might help also |
Yea that post is good so check the should help you with any error you have. One thing I notice is that to make sure your using the right version of Eqemu that can work with your latest EQLive update. Remeber not to update Feb 10th, so if your uptodate with EQLive, then the server should still run good. Also make sure your Spell file from your EQ Live Dir is copy and replace for update on your Eqemu. That should help alot but follow that site it will help get most of your common problems figure out.
Good Luck |
I am going to start over from scratch because i found other problems. I will use the 053 dr3 source and create my own.
Thanks for all help. :D |
All times are GMT -4. The time now is 08:05 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.