Database error(s)

[stinkbeer]

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.

[deazone]

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

[stinkbeer]

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.

[Belfedia]

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

[stinkbeer]

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

[fathernitwit]

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