Database error(s)
 

Hello guy's

I have followed this tutorial:
http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6

I have done the database setups in the tutorial but i receive alot of errors when i start minilogon.exe and world.exe
Have changed the login opcodes in the opcodes.conf.

Can you tell me what i have done wrong with the database ?
The only two .sql files i have loaded in my eq1 database are: load_system.sql and load_empty_users.sql.

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.2-DR1
[Status] Loading opcodes..
[Status] EMuShareMem loaded
Opcode OP_Command is missing from ./opcodes.conf
Opcode OP_MailboxHeader is missing from ./opcodes.conf
Opcode OP_MailHeader is missing from ./opcodes.conf
Opcode OP_MailBody is missing from ./opcodes.conf
Opcode OP_NewMail is missing from ./opcodes.conf
Opcode OP_SentConfirm is missing from ./opcodes.conf
Opcode OP_RAWSessionRequest is missing from ./opcodes.conf
Opcode OP_RAWSessionResponse is missing from ./opcodes.conf
Opcode OP_RAWCombined is missing from ./opcodes.conf
Opcode OP_RAWSessionDisconnect is missing from ./opcodes.conf
Opcode OP_RAWKeepAlive is missing from ./opcodes.conf
Opcode OP_RAWSessionStatRequest is missing from ./opcodes.conf
Opcode OP_RAWSessionStatResponse is missing from ./opcodes.conf
Opcode OP_RAWPacket is missing from ./opcodes.conf
Opcode OP_RAWFragment is missing from ./opcodes.conf
Opcode OP_RAWOutOfOrderAck is missing from ./opcodes.conf
Opcode OP_RAWAck is missing from ./opcodes.conf
Opcode OP_RAWAppCombined is missing from ./opcodes.conf
Opcode OP_RAWOutOfSession is missing from ./opcodes.conf
005418D0
[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] Clearing temporary merchant lists..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in ClearMerchantTemp query 'delete from merchantlist_temp' #2006: MySQL se
rver 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(*),sum(length(serialization)+
1) FROM items' #2006: MySQL server 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 guild link..
[Status] EMuShareMem loaded
[Status] Loading GuildList from database...
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in DBLoadGuildList query 'SELECT eqid,name from guilds order by eqid asc'
#2006: MySQL server has gone away
Error: EMuShareMem: DLLLoadGuildList: !cbDBLoadGuildList
[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
Breaking bards...done
TCP listening on: localhost:9000
World server listening on: localhost:9000
Connected to LoginServer: Database Error: Lost 127.0.0.1:5999
connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone
away'


Thnxs for reading.

Looks like you are missing your opcodes.conf from your server's directory or you have the incorrect ones, and mysql is not started.

My mysql system tray monitor says that the database service is started.

I have grant my created account all priviliges to all databases (eq1 and mysql)
Have grant then those priviliges with Mysql Administrator. Have move all priviliges to my created account (in the Schema priviliges window)

But still get the #2006 error.

Can you post all your config files ?
Db.ini
Boot5zones.bat
loginserver.ini ?
(with your password blanked of course)

Ok here are my config files:


db.ini

[Database]
host=localhost
user=username (no root)
password=password
database=eq1

Loginserver.ini

[LoginServer]
loginserver=127.0.0.1
loginserver2=newlogin1.eqemulator.net
loginport=5999
loginport2=5998
worldname=EQemulator
worldaddress=localhost
locked=false
account=username (no root)
password=password

[WorldServer]
Defaultstatus=0
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=minilogin
ServerPort=5999

Boot5zones.bat

REM: REM: Read this first!!!
REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zoneperl . localhost 8780 localhost
start zoneperl . localhost 8781 localhost
start zoneperl . localhost 8782 localhost
start zoneperl . localhost 8783 localhost
start zoneperl . localhost 8784 localhost
exit
cls
:NOSPELL echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup. PAUSE


End of files

might help
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

if you find the solution, please post it on the wiki, this has been run into several times, but I cannot recall the solution

Worth reminding people that if you have logging turned on in mysql, and have set to log hostnames (not just ip addresses), then unless you have good name resolution (i.e. right entries in /etc/hosts or equivalent, or a local nameserver with in-addr.arpa zones properly set up) you can get DB timeouts very very easily.

4.0
 

I think this is a bug with max packets in mysql 4.0 , I have never seen this happen with 3.0

I've seen it happen with windows clients and Linux based MySQL v 3.x, when the server was protected by tcpwrappers, and the windows machine had that "update the DNS" setting turned on. I can't recall the exact number of times I've walked Users through turning off that checkmark, or have talked to clueless ISP people ( I can't call them admins and still preserve my self-respect. How can you "admin" an ISP and not have a clue about basic DNS and Bind?) about how to setup their DNS so that the Dyn-IP update works.

But little of this is relevant to the OP. Still, checking the hosts file is a good idea - if it's the problem, then it's easy to fix.

I have checked the host file and didn't find any problems with it.
Can reach my host with the Windows ping command without any problem.

Cause im not a database expert, I gona install Mysql 3.23, run the DB part of the tutorial again. ;)

Ok guy's,

With Mysql 3.23 no databasedrops anymore. (dont know why. But the latest version of Mysql is not gona work for me)

Now im gona try to get connected with the client.

I recieve the same ./opcodes.conf error, does anyone have a link to a version that might work for this version? Thanks.

Opcode error aren't a problem, don't need fix for that. In this post we speak about mysql error (2006). All eqemu version have this opcode error and working :)

OK i have my EQemu server finaly up and running.
After some stupid rtfm things from my side (Pathing mobs/NPC's (maps dir ;) )
This weekend i can join without any problems.

Still running on Mysql 3.23
When i install 4.1+ the database drops constantly. (have tryed that out)

Now im gona try to fix some (safe)zone points in the DB. (pok and Cabilis)

Bit offtopic
I have a seperate Server and Client PC. Have split them because some strange latency problems. Now my server is running on a diffrent PC than my client and no strange packet lose and big lag spikes anymore.

I can write down a small network tutorial if needed.