I was having a problem setting up Public Login so that it would add users to the eq database. I kept getting incorrect login/password...
The first step is to use Lurkers set-login.bat file found in a previous tread. Thanks Lurker for saving me a ton of typing!
The other important thing is to make sure that the IP you are using in your eqhosts.txt file matches the IP for the account you are authorizing/reauthorizing. (e.g use 127.0.0.1 if eqhosts.txt uses localhost/127.0.0.1, use 192.x.x.x if eqhosts.txt uses 192.x.x.x etc...) This assumes you're adding the account from the same machine as the world/login servers.
I discovered this little revelation after many hours of failing to be able to add new accounts to my loginserver.
BTW, Lurker I found a couple minor problems with your set-login.bat file.
1. I get a syntax error in the two reauthorize sections with the DELETE lines... This error gets masked in the reauthorize from the menu because of problem # 2 below...
2. Your INSERT INTO line for reauthorizing from the menu only uses '>' instead of '>>' so the previous DELETE command is reset.
I just changed the line to be:
echo DELETE FROM login_authchange; > set-account.sql
This deletes the contents of the whole table. No big deal if your only adding one account at a time. Or just REM the line out - about the same difference...
Mark