Acc creation problem

[Andy20081]

Hey when i use query to make account i put in the line of code given from the register.HTML

i put it in query new one press run it all goes through but on login it says wrong pass or id but yet the test account works i don't understand whats wrong Ive tried so many ways i tried restarting server reloading db but nothing

[Gekru]

What query does the html file give you?

[Andy20081]

i did a test this is
user test
pass test

insert into my.account (name,password) values('test','53b6320eb06e2c62888a6d1739cd24bd');

[Gekru]

When you run the query does it show the new account in the account table?

If it does, then it sounds like the client isn't getting all the keys that you're entering. There's nothing wrong with the acct/pw you provided.

[Andy20081]

ye it goes into the account table

ive tryed keys i try it slowly and press them quite hard to make sure

[Gekru]

The client issue I recommended is the only other reason, I see for it not working.

What db are you using? I will download it and run some local tests.

[Andy20081]

im using
i havent downloaded the patch update though

[Gekru]

Sorry for the late reply, I've downloaded the files you linked me to, I had no issues signing in with any created accounts.

So as of right now, I'm sticking with the client not catching all the keys you're typing.

[PowerChaos]

@ Gekru
the client has nothing to do with it , exept if you mess up a few things

1) check oem.dat that it match the server name
2) be sure that the client is above version 1070 you wont even need to try to connect

thats all for the client side
now the server side

if you edited the server name , be sure that it is updated for the account server
that the DAT files are HEX edited (so it does not show a mess at the message server bar )

also do not forget to check if you got only a single database or 2 databases
putting value's in my.account does not work if you use account.account
or ofcourse you need to update the account.exe settings to point to my.account

i do not know what exactly you all changed , but if gekru says that it works out of the box does it means that you changed something that is related to the account server

a wrong value in account does not harm , it just wont work as it always give a wrong password ( pass is md5 salted )

hopely this helps you
Greetings From PowerChaos

[Gekru]

Originally Posted by PowerChaos

@ Gekru
the client has nothing to do with it , exept if you mess up a few things

First of all, I'm not wrong. I reckon you need to go back and look at the client again, because you have no clue how it works or its flaws obviously. Second of all, re-read his ****** post.

Originally Posted by Andy20081

Hey when i use query to make account i put in the line of code given from the register.HTML
i put it in query new one press run it all goes through but on login it says wrong pass or id but yet the test account works i don't understand whats wrong Ive tried so many ways i tried restarting server reloading db but nothing

I've made the relevant parts bold so you can read it. He clearly states that the test acct works and that it tells him his user/password is wrong. If it was server related, it would tell him the server was down or under maintenance.

Before you try to correct someone, make sure you at least understand the initial problem.

[PowerChaos]

i forgot that part

it is indeed in querty and some commands are not working good (some symbols)
but eahter way , if he use the html page to create a password then it still should be fine as the regex should filter out the bad stuff (unless he dit not use that )

i readed parts of the post and noticed this line

i did a test this is
user test
pass test

insert into my.account (name,password) values('test','53b6320eb06e2c62888a6d1739cd24bd');

so i probaly misted the line that he says that test/test was working

then it is indeed only 2 things
or he fills in the wrong password (querty/azerty/lowercase/mixed/caps)
or he filled in the wrong username ( lowercase only)

or he messsed up the hash code to insert into the db
but the part i do not get is why he would use a html page to generate a mysql querry when there are plenty of register pages avaible to do that stuff for you

Greetings From PowerChaos

[Gekru]

Originally Posted by PowerChaos

but the part i do not get is why he would use a html page to generate a mysql querry when there are plenty of register pages avaible to do that stuff for you

Greetings From PowerChaos

It's included with the download, that would be my guess.

[Andy20081]

ill give it a try again in a few had to re-dl database as when i click the AccServer it said i might not have permision to use this then it disapeard

it says i may not have the appropriate permission

sorted all the issues out just about to try again with account creation and ill update this post for more information if its sorted or not.

thank you for all your help you both have been wonderful im over the moon as its all working me and my team can release a new server now this problem is over come thanks

the problem was to do with the database we did a completely look through and found the issue so we amended it obviously one of the team member had done something by accident