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

If you look at your database, do you have a table named tblWorldServerRegistration?

i'm getting this error

[Debug] [01.23.11 - 23:44:38] Logging System Init.
[Debug] [01.23.11 - 23:44:38] Config System Init.
[Debug] [01.23.11 - 23:44:38] MySQL Database Init.
[Debug] [01.23.11 - 23:44:38] Encryption Initialize.
[Debug] [01.23.11 - 23:44:38] Encryption Loaded Successfully.
[Debug] [01.23.11 - 23:44:38] Server Manager Initialize.
[Network] [01.23.11 - 23:44:38] ServerManager listening on port 5999
[Debug] [01.23.11 - 23:44:38] Client Manager Initialize.
[Network] [01.23.11 - 23:44:38] ClientManager listening on Titanium stream.
[Network] [01.23.11 - 23:44:38] ClientManager listening on SoD stream.
[Debug] [01.23.11 - 23:44:38] Server Started.
[Network] [01.23.11 - 23:45:08] New world server connection from 127.0.0.1:51503
[Network Error] [01.23.11 - 23:45:08] Recieved application packet from server that had an unknown operation code 0x1000.

I have two databases. I have peq, for the world server, and I have peqlogindb for the login server. Peqlogindb contains:
tblloginserveraccounts
tblserveradminregistration
tblserverlisttype
tblworldserverregistration

tblworldserverregistration contains 1 row:
INSERT INTO `tblworldserverregistration` (`ServerID`, `ServerLongName`, `ServerTagDescription`, `ServerShortName`, `ServerListTypeID`, `ServerLastLoginDate`, `ServerLastIPAddr`, `ServerAdminID`, `ServerTrusted`, `Note`)
VALUES (1, 'Heraldics World of Fun', 'the server', 'HWoF', 3, '2011-01-24 00:27:08', '0.0.0.0', 1, 0, 'This is the server.');

edit config.ini to look like this your welcome
[Database]
host=192.168.1.73
user=root
password=*****1234
database=peq
compression=off

[General]
quests=C:\EQEmu\quests\

if using sof client change all ports=5998 not 5999

edit eqemulogin.ini file
[LoginConfig]
loginserver=99.99.***.***
loginport=5998
DumpPacketsIn=false
DumpPacketsOut=false
Trace=false
DatabaseServerName=localhost
DatabaseCatalogName=PEQLoginServerDB
DatabaseUserName=root
DatabaseUserPassword=*****1234
OPCodePathAndFileName=login_opcodes.conf <-- if using sof client

just a note: you have it like this PEQLoginServerDB
now you need to make a new directory in peq server to say the same
not unless your going to change all of them back to peqlogindb

Sorry Noport,
I tried it all and had same error message.

Come on Lerxst I know you can tell me the answer! The priests of syrinx are counting on us!

Well, it would seem you have a DB problem somewhere. I'd try following the steps under "Setup PEQLoginDB DB and Logins" in this guide again and hope for the best. :)

http://www.eqemulator.org/forums/showthread.php?t=31783