Database error(s)

[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

[johane]

Originally Posted by 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

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.

[sdabbs65]

Originally Posted by johane

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.

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