problems with public login - bad password

[Falcon]

hi,

i still got problems

ok i've set up my SQL DB and db.ini and so on.
wanted to set a lan server.
so i used public login.exe then started world.exe and then the 5 zones, all run well.
but when i try to connect from my other machine i get bad username / password.

i think i did something wrong with the creation of the account.

in the readme there are 2 parts :

create account for login / world servers
create account onto a world server

first i did :

mysql : use eq

INSERT INTO login_accounts set name='Falcon', password='test', ip='192.168.0.2', ircnick='Falcon';

wonder why i need ircnick *shrug*

then

SELECT id from login_accounts where name='Falcon';

ID was 1

then:

INSERT INTO login_authchange (account_id, ip) values(1, '192.168.0.2');

ok is this all for the login account ? because now the readme says : onto a world server:

i did this too, just to be sure

INSERT INTO login_worldservers set account='Falcon', password='test', name='Falcon's Server', greenname='1';

wondered why name of server is wanted...

now it said i have to put this into my loginserver.ini ?

ok so i put Falcon and test into the loginserver.ini:

[LoginServer]
loginserver=localhost
worldname=Test
locked=false
account=Falcon
password=test
worldaddress=localhost
loginport=5999

so the world server runs fine on the login server but i can't login with Falcon / or falcon and password test. i tried to make a second account, using sheva as account name and only completed step one (create an account for login / world servers) but it always says : bad username / or password.

so guys, anybody know what i did wrong ?

thx

[Falcon]

oh i forgot to say i also did:

mysql : GRANT ALL ON *.* to '%'@'192.168.%' IDENTIFIED BY '%';

[Falcon]

woah delete my thread, i finally found lurkers batch file and re-inserted the login.sql

i didn't know that i have to run my world server while creating user accounts. now it works

[Lurker_005]

When the world server starts it wipes out the authent_login table. So you have to run your server first, then add the authentication, and login in to validate it while world is still running.