I got Public Login to work finally!

[MarkK]

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

[Lurker_005]

BUG! Kill it!!!!

The problem with the IP when running the server and host on the same computer makes some sense. Perhaps I'll update the file to fix the bug and put some more help/docs with it...

BTW, don't try to set eqhosts.txt it won't work :p (no 's' See typos get us all)

[Hmm]

yeah i have created a guide to setting publiclogin in this tread but it didnt get a sticky darn heh

[Lurker_005]

Ahh... http://forums.eqemu.net/showthread.p...;threadid=1613 I knew there was something a little familiar about the client/server needing the same IP EXACTLY. He did find out a bit more though

That should pull the about last tooth/claw out of setting up publiclogin!

[MarkK]

Hmm,

Thanks for bringing up your work. Your article and Lurker's set-login.bat file got me a LONG way down the path to finally getting it all running.

My problem was that my eqhost.txt file contained my real internet IP address so your suggestion of using the address 127.0.0.1 did not work for me. :( When I made the two addresses match exactly, Voila! The added accounts authorized without a problem. Whew.

Hmm, thanks for putting the article together and posting it.

Mark

[Hmm]

hmm yeah i will edit my guide with this tidbit.