EQEmulator Forums - error 2006 Mqsql server has gone away

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - error 2006 Mqsql server has gone away (https://www.eqemulator.org/forums/showthread.php?t=11681)

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:

Create EQ Database

1. Make sure you followed the instructions in the cvs section for adding mysql binaries to the %path%.
2. Open a DOS prompt
Win98/95/ME - start->run->command
Win2k/XP/2k3 - start->run->cmd
3. Type in the following:
c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql
4. Inside of mysql, type these commands:
create database eq;
grant all privileges on *.* to test@localhost identified by 'test' with grant option;
quit
5. You should see the following as output from above:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.57-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database eq;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on eq.* to test@localhost identified by 'test'
with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

C:\EqEmu\cvs\eqemu\EQEMu Release>

6. Back in the DOS prompt, type this command:
mysql -u test -p eq
7. You should see a password prompt - enter in your password ('test' in this sample). You should see the following:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u test -p eq
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 3.23.57-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

: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:

i believe your worldaddress in the login.ini should be your external ip..(ie real ip addy)

I did that and i am back with the 1017 error.

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