Private Login Setup help

[Nightrider84]

Ive got everything setup for my home server to login for private use but everytime i try and login it gives me a invalid username/password. ive added the accounts into tblloginserveraccounts but no matter what i add i cant get in. the only thing that works is if i login with admin username. no errors on launching the server so im stumped

[Vexyl]

How are you storing the account password? It should be stored as a SHA hash.

For example:

UPDATE tblLoginServerAccounts SET AccountPassword=SHA('foo') WHERE AccountName='bar';

[Nightrider84]

yeah that did the trick althow now when i login, my characters are stuck and wont move. any thoughts?

[Scalefiend]

I create a public server (everything works fine). But now i wanted to make it private, so I followed this guide to the T http://www.eqemulator.org/forums/showpost.php?p=220659&postcount=14 and i ended up not being able to log in. So, was wondering if this guide is even functional right now, and if so, explain in details any workarounds or extra steps ya might have done for it to work.

I'm running xp sp3 btw. Thx