astonerii
01-09-2004, 02:37 PM
I had this the first time I ever tried to start my server package, and it looks really close to the same today. Here it is
Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR2
[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..
[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(*) FROM items' #2006: MySQL s
erver 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 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: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
===============================
Runtime errors:
MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3
Hit any key to exit
MySQL looks like this:
Local IP Address: 169.254.180.218
My ODBC: Driver 3.51 Not Found
Server Info: 4.0.16-nt
Client Info: 4.0.16
Host Info: Localhost via TCP/IP
Protocol Info: 10
I am sorry if this has been asked before, and I am sorry if someone has to repeat themselves or feels the need to belittle me, but in reality, I am just so confused by the sheer number of answers that all seem to be different and none seem to help me solve my issue.
Thanks in advance for any help you have to offer. If anyone wants to help me figure out what to do, here is my listing of files and system information....
LAN setup (in order of connection)
Comcast cable modem
Outside IP XXX.XXX.XXX.XXX (from whatismyip.com)
Linksys router
(I have no control of this router, its my room mates)
Netgear router IP 192.168.XXX.1
Port forwarding everquest 5997 to 5999
Port forwarding EQEmu 7990 to 7999
Firewall: off
DynDNS on
Account is supposed to forward my outside IP as accountname.DynDNS.org
(Router says connection working ok)
PC2.4 IP 192.168.XXX.2 (100Mb/s Ethernet connection)
2.4Ghz P4 (Overclocked to 2.7 Ghz)
1024MB RDRAM800
GeForce4 4800 128MB
60GB IDE HDD
Installed software:
C:\EverQuest\ (updated to live)
eqhost.txt:
[/quote]
[Registration Servers]
{
"192.168.XXX.2:5999"
}
[Login Servers]
{
"192.168.XXX.2:5999"
} [/quote]
DataRate.txt:
8.0
C:\EverQuest\minilogin
LoginServer.ini:
[LoginServer]
loginserver=192.168.XXX.2
loginport=5999
loginport2=5999
worldname=My World Name
worldaddress=127.0.0.1
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
MiniLoginAccounts.ini:
192.168.XXX.3 MyAccount MyAccountPW
192.168.XXX.3 eqemu eqemuPW
192.168.XXX.3 admin adminPW
DataRate.txt
8.0
C:\EverQuest\EQEmu 5.2 PERL\ EQEmu-0.5.2-Win32-PERL.zip
LoginServer.ini:
[LoginServer]
loginserver=192.168.XXX.2
loginport=5999
loginport2=5999
worldname=My World Name
worldaddress=127.0.0.1
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
Boot5zones.bat:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when
REM: you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to
REM: say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zone . 192.168.XXX.2 7995 192.168.XXX.2
start zone . 192.168.XXX.2 7996 192.168.XXX.2
start zone . 192.168.XXX.2 7997 192.168.XXX.2
start zone . 192.168.XXX.2 7998 192.168.XXX.2
start zone . 192.168.XXX.2 7999 192.168.XXX.2
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------
db.ini:
[Database]
host=192.168.XXX.2
user=My Server Name
pasword=********
database=eq
compression=off
spells_en.txt
spells_us.txt
DataRate.txt:
8.0
C:\MySQL 4.0.16\ MySQL 4.0.16
C:\ MySQL 4.0.16\bin\db.sql
ActivePerl 5.8.2 build 808 Default installation
PC2.6 IP 192.168.XXX.3 (Gigabit 1000Mb/s Ethernet connection)
2.6Ghz P4 Multithreading (Overclocked to 3.2Ghz)
1024MB DDR3200
GeForce4 4800 128MB
Audigy2
120GB (C:\) and 160GB (D:\) IDE HDD
Installed software:
D:\EverQuest (updated to live)
the eqhost.txt is:
[Registration Servers]
{
"192.168.XXX.2:5999"
}
[Login Servers]
{
"192.168.XXX.2:5999"
}
DataRate.txt:
8.0
LINK to D:\EverQuest.exe (with patchme addendum)
Unknown 'compression' setting in db.ini. Expected 'on' or 'off'.
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.3-DR2
[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..
[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(*) FROM items' #2006: MySQL s
erver 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 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: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
===============================
Runtime errors:
MySQL Error #2005 means you there are too many connections on the mysql server.
The server is overloaded.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=3
Hit any key to exit
MySQL looks like this:
Local IP Address: 169.254.180.218
My ODBC: Driver 3.51 Not Found
Server Info: 4.0.16-nt
Client Info: 4.0.16
Host Info: Localhost via TCP/IP
Protocol Info: 10
I am sorry if this has been asked before, and I am sorry if someone has to repeat themselves or feels the need to belittle me, but in reality, I am just so confused by the sheer number of answers that all seem to be different and none seem to help me solve my issue.
Thanks in advance for any help you have to offer. If anyone wants to help me figure out what to do, here is my listing of files and system information....
LAN setup (in order of connection)
Comcast cable modem
Outside IP XXX.XXX.XXX.XXX (from whatismyip.com)
Linksys router
(I have no control of this router, its my room mates)
Netgear router IP 192.168.XXX.1
Port forwarding everquest 5997 to 5999
Port forwarding EQEmu 7990 to 7999
Firewall: off
DynDNS on
Account is supposed to forward my outside IP as accountname.DynDNS.org
(Router says connection working ok)
PC2.4 IP 192.168.XXX.2 (100Mb/s Ethernet connection)
2.4Ghz P4 (Overclocked to 2.7 Ghz)
1024MB RDRAM800
GeForce4 4800 128MB
60GB IDE HDD
Installed software:
C:\EverQuest\ (updated to live)
eqhost.txt:
[/quote]
[Registration Servers]
{
"192.168.XXX.2:5999"
}
[Login Servers]
{
"192.168.XXX.2:5999"
} [/quote]
DataRate.txt:
8.0
C:\EverQuest\minilogin
LoginServer.ini:
[LoginServer]
loginserver=192.168.XXX.2
loginport=5999
loginport2=5999
worldname=My World Name
worldaddress=127.0.0.1
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
MiniLoginAccounts.ini:
192.168.XXX.3 MyAccount MyAccountPW
192.168.XXX.3 eqemu eqemuPW
192.168.XXX.3 admin adminPW
DataRate.txt
8.0
C:\EverQuest\EQEmu 5.2 PERL\ EQEmu-0.5.2-Win32-PERL.zip
LoginServer.ini:
[LoginServer]
loginserver=192.168.XXX.2
loginport=5999
loginport2=5999
worldname=My World Name
worldaddress=127.0.0.1
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=
Boot5zones.bat:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "YourIP" when
REM: you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to
REM: say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
if NOT exist spells_us.txt goto NOSPELL
start zone . 192.168.XXX.2 7995 192.168.XXX.2
start zone . 192.168.XXX.2 7996 192.168.XXX.2
start zone . 192.168.XXX.2 7997 192.168.XXX.2
start zone . 192.168.XXX.2 7998 192.168.XXX.2
start zone . 192.168.XXX.2 7999 192.168.XXX.2
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------
db.ini:
[Database]
host=192.168.XXX.2
user=My Server Name
pasword=********
database=eq
compression=off
spells_en.txt
spells_us.txt
DataRate.txt:
8.0
C:\MySQL 4.0.16\ MySQL 4.0.16
C:\ MySQL 4.0.16\bin\db.sql
ActivePerl 5.8.2 build 808 Default installation
PC2.6 IP 192.168.XXX.3 (Gigabit 1000Mb/s Ethernet connection)
2.6Ghz P4 Multithreading (Overclocked to 3.2Ghz)
1024MB DDR3200
GeForce4 4800 128MB
Audigy2
120GB (C:\) and 160GB (D:\) IDE HDD
Installed software:
D:\EverQuest (updated to live)
the eqhost.txt is:
[Registration Servers]
{
"192.168.XXX.2:5999"
}
[Login Servers]
{
"192.168.XXX.2:5999"
}
DataRate.txt:
8.0
LINK to D:\EverQuest.exe (with patchme addendum)