EQEmuLoginServer mysql query fail
I have gotten done installing a fresh server on my fresh and updated XP computer. I am using Secrets of Faydwer. I know i am tired and my eyes are glazing over so what silly thing am I missing?
I run the startup.bat file and the world seems to load fine, however the login server gives this message:
[Debug] [01.24.11 - 01:55:34] Logging System Init.
[Debug] [01.24.11 - 01:55:34] Config System Init.
[Debug] [01.24.11 - 01:55:34] MySQL Database Init.
[Database] [01.24.11 - 01:55:34] Failed to connect to MySQL database.
[Debug] [01.24.11 - 01:55:34] Encryption Initialize.
[Debug] [01.24.11 - 01:55:34] Encryption Loaded Successfully.
[Debug] [01.24.11 - 01:55:34] Server Manager Initialize.
[Network] [01.24.11 - 01:55:34] ServerManager listening on port 5999
[Debug] [01.24.11 - 01:55:34] Client Manager Initialize.
[Network] [01.24.11 - 01:55:34] ClientManager listening on Titanium stream.
[Network] [01.24.11 - 01:55:34] ClientManager listening on SoD stream.
[Debug] [01.24.11 - 01:55:34] Server Started.
[Network] [01.24.11 - 01:55:48] New world server connection from 192.168.1.73:12
88
[Database] [01.24.11 - 01:55:48] Mysql query failed: SELECT WSR.ServerID, WSR.Se
rverTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeD
escription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblSer
verListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.Serv
erLongName = 'Heraldics World of Fun' AND WSR.ServerShortName = 'HWoF'
[World] [01.24.11 - 01:55:48] Server Heraldics World of Fun(HWoF) attempted to l
og in but database couldn't find an entry but unregistered servers are allowed.
[Database] [01.24.11 - 01:55:48] Mysql query failed: SELECT max(ServerID) FROM t
blWorldServerRegistration
[Database] [01.24.11 - 01:55:48] Mysql query failed: UPDATE tblWorldServerRegist
ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '192.168.1.73' where
ServerID = 0
My current eqemu_config.xml file:
<?xml version="1.0"?>
<server>
<world>
<shortname>HWoF</shortname>
<longname>Heraldics World of Fun</longname>
<!-- address has to be specified for minilogin to work -->
<address>99.99.***.***</address>
<localaddress>127.0.0.1</localaddress>
<!-- Loginserver information. -->
<loginserver>
<host>192.168.1.73</host>
<port>5999</port>
<account>root</account>
<password*****1234</password>
</loginserver>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>make up some random string of characters here</key>
<!-- Enable and set the port for the HTTP service -->
<http port="9080" enable="true" mimefile="mime.types"/>
</world>
<!-- Database configuration, replaces db.ini -->
<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>*****1234</password>
<db>peq</db>
</database>
</server>
My eqemulogin.ini file:
[LoginConfig]
loginserver=99.99.***.***
loginport=5999
DumpPacketsIn=false
DumpPacketsOut=false
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=PEQLoginServerDB
DatabaseUserName=root
DatabaseUserPassword=*****1234
OPCodePathAndFileName=login_opcodes_sod.conf
and finally my login.ini:
[database]
host = 192.168.1.73
port = 3306
db = peqlogindb
user = root
password = *****1234
subsystem = MySQL
[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5999
local_network = 192.168.1.
[security]
plugin = EQEmuAuthCrypto
mode = 5
[Titanium]
port = 5998
opcodes = login_opcodes.conf
[SoD]
port = 5999
opcodes = login_opcodes_sod.conf
[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType
Thank you for your time
H
|