using peqdb_rev1549.sql with EQEmuLoginServer

[eski2]

I followed that guide before and found the executables weren't connecting to the database. At the time i thought it must be my ini or xml files, but they were working with the downloaded binaries fine.

Using the compiled binaries, i get[Debug] [06.28.10 - 19:10:48] Logging System Init.
[Debug] [06.28.10 - 19:10:48] Config System Init.
[Debug] [06.28.10 - 19:10:48] MySQL Database Init.
[Debug] [06.28.10 - 19:10:48] Encryption Initialize.
[Debug] [06.28.10 - 19:10:48] Encryption Loaded Successfully.
[Debug] [06.28.10 - 19:10:48] Server Manager Initialize.
[Network] [06.28.10 - 19:10:48] ServerManager listening on port 5998
[Debug] [06.28.10 - 19:10:48] Client Manager Initialize.
[Network] [06.28.10 - 19:10:48] ClientManager listening on Titanium stream.
[Network] [06.28.10 - 19:10:48] ClientManager listening on SoD stream.
[Debug] [06.28.10 - 19:10:48] Server Started.
[Network] [06.28.10 - 19:10:55] New world server connection from 127.0.0.1:1283
[Database] [06.28.10 - 19:10:55] 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 = 'soloman' AND WSR.ServerShortName = 'soloman'
[World] [06.28.10 - 19:10:55] Server soloman(soloman) attempted to log in but da
tabase couldn't find an entry but unregistered servers are allowed.
[Database] [06.28.10 - 19:10:55] Mysql query failed: SELECT max(ServerID) FROM t
blWorldServerRegistration
[Database] [06.28.10 - 19:10:55] Mysql query failed: UPDATE tblWorldServerRegist
ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where Ser
verID = 0
[Network] [06.28.10 - 19:11:58] New Titanium client connection from 127.0.0.1:12
95
[Network] [06.28.10 - 19:11:58] Application packet recieved from client (size 14
)
[Network] [06.28.10 - 19:11:58] Session ready recieved from client.
[Network] [06.28.10 - 19:11:59] Application packet recieved from client (size 28
)
[Network] [06.28.10 - 19:11:59] Login recieved from client.
[Client] [06.28.10 - 19:11:59] User: Eski
[Client] [06.28.10 - 19:11:59] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110
[Database] [06.28.10 - 19:11:59] Mysql query failed: SELECT LoginServerID, Accou
ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski'
[Client Error] [06.28.10 - 19:11:59] Error logging in, user Eski does not exist
in the database.
[Network] [06.28.10 - 19:12:06] Client disconnected from the server, removing cl
ient.
[Network] [06.28.10 - 19:12:06] New Titanium client connection from 127.0.0.1:12
96
[Network] [06.28.10 - 19:12:06] Application packet recieved from client (size 14
)
[Network] [06.28.10 - 19:12:06] Session ready recieved from client.
[Network] [06.28.10 - 19:12:07] Application packet recieved from client (size 28
)
[Network] [06.28.10 - 19:12:07] Login recieved from client.
[Client] [06.28.10 - 19:12:07] User: Eski
[Client] [06.28.10 - 19:12:07] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110
[Database] [06.28.10 - 19:12:07] Mysql query failed: SELECT LoginServerID, Accou
ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski'
[Client Error] [06.28.10 - 19:12:07] Error logging in, user Eski does not exist
in the database.
[Network] [06.28.10 - 19:12:08] Client disconnected from the server, removing cl
ient.


I don't know why it seems blind to the server name and to the account names.