Pserver All things Guide[UPDATED]

[King_Arthur]

Originally Posted by SpongeBox

Okay.. I got the AccountServer to work.. But Its saying :

"DB real connect error: Access denied for user : 'ODBC@localhost' (using password: NO)

Any Tips..??

Instead of ignoring it you can just add a user named OBDC with no password on localhost like...

GRANT SELECT, INDEX, SHOW DATABASES ON *.* TO 'OBDC'@'localhost';

[.Ash]

uhh right.. soo.. i downloaded v1130 like necron said..but his link is broken so i dont know if i got the right now... But when i did everything and trying to log into the game.. it says Logging into the server and just poof..dissapears lol

[eliasjuh1234]

Cant seem to get connected with navicat, keeps giving an error( 1045 - Acces denied for user : 'root@localhost' (using password :YES)
And what do I put in Connection name?
Please answer as soon as possible, Thanks

Problem solved

Sorry but i have another problem, I followed all the steps till step 12 then i run those 3 progs:
Acc server:


MSG:


NPC:

[Nis@]

im have a question..
when we make a p,server..
the server must be on9..??
i mean my ID must be on9 when we want create a p,server..?

[Nis@]

ok..now everything is ok..but.....
when i want to create account

insert into account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());

its show error like this..

[SQL] insert into account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
[Err] 1146 - Table 'my.account' doesn't exist

[King_Arthur]

Originally Posted by Nis@

ok..now everything is ok..but.....
when i want to create account

insert into account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());

its show error like this..

[SQL] insert into account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
[Err] 1146 - Table 'my.account' doesn't exist

Your in your my database instead of your account database when running the query. I assume you are using navicat so after you connect to the server double click account instead of my, go to query, then try the query again.

[nooneatall]

or just run this query.. this will work
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());

[Nis@]

after work i must restart the server then log in with user=test pss=test..??

[Nis@]

now this error coming..huhu..


[SQL] insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
[Err] 1062 - Duplicate entry 'test-53b6320eb06e2c62888a6d1739cd24bd' for key 2

[purple21]

server down please come back later...server maintenance

can anyone help me how to resolve this

[King_Arthur]

Originally Posted by Nis@

after work i must restart the server then log in with user=test pss=test..??

Originally Posted by Nis@

now this error coming..huhu..

No. As you probably know once you make an account on most servers you can login right away.

[SQL] insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
[Err] 1062 - Duplicate entry 'test-53b6320eb06e2c62888a6d1739cd24bd' for key 2

Sounds like you already have an account named test in your account table then. You cant have duplicate account names.

[Necron33]

Changelog:

1- Added Spoilers and changed titles.
2 - Added a mini release box
3 - General update on all scripts.
4 - Posted this post ^^

[Nis@]

Originally Posted by King_Arthur

Sounds like you already have an account named test in your account table then. You cant have duplicate account names.

thx ya

but 1 think....why i cannot go into the serv..??
have stuck in welcome page...

Necron33 said i must have a good client patch..
but where i can get it...???

[Fish*]

i like that you are using Spoilers, so peoples dont have to look through everything to search for what they need to know and if they have error in a part, they dont have to view everything to search for error place.

[karnyge]

ok i posted elsewhere and no reply so if you dont mind i will ask here as well

i have got everything connected to navicat and mysql, but i dont know what my authorisedb.cfg should be looking like in the hexeditor

i also cannot open the accountserver, and i am unsure as to why it says i dont have permission to access the file

yet to try and do anything past that point, so some help would be greatly appreciated.

(if you can include images it would probably help more)