I finished the setup tonight for my private server using Titanium based off Kavren's guide
http://www.eqemulator.org/forums/showthread.php?t=31783.
I ran the .bat file to load up the necessary components, and, despite the initial
"WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
worldserver.Connect()FAILED! Will retry."
It ends up starting main loop and "Connected to World: localhost:9000" and begins loading zones. I am not sure why it is :9000 when the focus has been on 5998 or 5999. Anyway, it seems to load up fine there. The title for that shell is "0: sleeping", I thought that was odd too.
The "World.exe" shell seems to be starting all the zones just fine.
However, the EQEmu Login Server is where I get my problems..
"Logging System Init.
Config System Init.
MySQL Database Init.
Failed to connect to MySQL database. <-------
Encryption Initialize.
Encryption Loaded Successfully.
Server Manager Initialize.
ServerManager listening on port 5998
Client Manager Initialize.
ClientManager listening on Titanium stream.
ClientManager listening on SoD stream.
Server Started.
New world server connection from 192.168.1.103:1260
MySql query failed: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerLongName = 'xxxxMy server namexxxx' AND WSR.ServerShortName = 'xxmyShortxx'
Server xxxxMyServerxxx(xxxshortxxx) attempted to log in but database couldn't find any entry but unregistered servers are allowed.
MySql query failed: SELECT max(ServerID) FROM tblWorldServerRegistration
Mysql query failed: UPDATE tblWorldServerRegistration SET ServerLastLoginDate = now(), ServerLastIPAddr = '192.168.1.103' where ServerID = 0"
Then it does the session once I fire up my client:
"New Titanium client connection from 192.168.1.101:64888
Application packet recieved from client (size 14)
Session ready recieved from client.
Application packet recieved from client (size 36)
Login recieved from client.
User: xxxxx
Hash: xxxxx
Mysql query failed: SELECT LoginServerID, AccountPassword FROM tblLoginServerAccounts WHERE AccountName = 'xxxx'
Error logging in, user xxxx does not exist in the database."
Not sure why it is saying this, because when I open Navicat and check the 'tblLoginServerAccounts' DB, the user I set up is listed there, with appropriate client IP. Now I'm wondering if it is because of the failed connection to MySql database at the beginning, but why then does it proceed as if it sorted it out?
I'm quite confused, and the only other bit of information that may be a factor is that I'm running the server (Win2k3 ES) as a VM over the host which I'm using as the client to log in. Clearly, the connection is working because it is seeing the request and printing the user plain-text and hashing the pass in the request. That tells me it shouldn't be the connection to my VM over the host (however, I am bridging the NIC--though I've never had any issues before doing this). My firewall has a specific rule for accepting and allowing traffic over all ports (I'm going to cut it down to 5998 and 5999 once this is resolved).
If anyone could help me figure out what is going on here, I would be quite grateful. I feel like I'm close enough to taste it, and it would be nice to see all this come to fruition. Thanks!
Private Server - User not found in DB
Linear Mode
