Username/PW issues w/ EQ client

[mandg]

Hello,

Decided to set up my own server again after some years. Followed this guide: http://www.eqemulator.org/forums/showthread.php?t=31783

First, I was having issues with EQEmuloginserver connecting to my MySQL database but I finally figured that out this morning.

Next, and this is potentially still part of my problem, I was having a problem with my EQEmuloginserver connecting to but not starting(?) my actual server. Got the message "Server [...] did not attempt to log in but this server requires a password". The way I fixed this was by specifying "Admin" and "Password" (from my tblserveradminregistration database in peqlogindb) under <Loginserver information><loginserver> in my eqemu_config.xml. This fixed the problem, and my EqEmuloginserver now gave me the message "Server [...] successfully logged in". Great, right? Nope.

I boot up my client, happy and ready to play or at least encounter my next issue in-game, so I type in my created username and password, it logs in, but the server select screen is blank. Hmm... I log out and try logging in with Admin/Password. Same result. I look at my EqEmuloginserver and it's telling me that a new connection on 5999 is started. Ok, I'm not trying to run SoD, so I figure oh, ok I'll just change that in my eqhost file. I do so, change it to 5998, boot up the client, type in my username/password and... the client gives me the error popup saying "Error - the username and/or Password were not valid...". Buhhh?

I check my EQEmuLoginserver and it's not giving me any error messages, all it's saying is:
"New Titanium client connection from [mylocalIP]
Application packet received from client (size 14)
Session ready received from client.
Application packet received from client (size 2
Login received from client.
User: myusername
Hash: longstringofcharacters"

And that's it. When I try to log in with Admin/Password now (I don't actually have an account called Admin, just that one that came in the serveradminregistration table mentioned above), it gives me the error message that there is no such account (after the same string of 'New Titanium client... etc).

And, to top things off, only when I then close the actual EQ client does EqEmuloginserver give me the message "Client disconnected from the server, removing the client". Does this mean that I have actually in fact connected, but the EQ client does not recognize it?

Also, one last issue (that I was going to assess upon getting into the game/server and see if I needed to actually fix it) is that my eqlaunch.exe fails when I run my serverstart.bat file and zone.exe never starts running or anything like that. Not sure if this is A. a part of the problem listed above, or B. a separate issue that may or may not need to be resolved in order to play succesfully.

Thanks in advance for your time.

Cheers

[Zothen]

The EQLoginServer message "Client disconnected from the server..." is absolute normal, even if the login is successful, so dont worry about that.

Reading your post, I get the feeling youre mixing up server and user logins. You say your server is logging in, so far so good, but you need an entry in the table [tblloginserveraccounts] created with the sql-script in the guide you followed:

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');

To verify your login info is entered correctly, you can modify your login.ini to

[options]
unregistered_allowed = FALSE

Otherwise you will always get to the server select screen, but you will never know if youre supposed to be there.