Pserver All things Guide[UPDATED]

Page 5 of 7 « First 34 5 67
09/19/2009 04:04 King_Arthur#61
Quote:
Originally Posted by SpongeBox View Post
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...
Code:
GRANT SELECT, INDEX, SHOW DATABASES ON *.* TO 'OBDC'@'localhost';
09/19/2009 13:51 .Ash#62
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
09/19/2009 15:30 eliasjuh1234#63
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:
[Only registered and activated users can see links. Click Here To Register...]

MSG:
[Only registered and activated users can see links. Click Here To Register...]

NPC:
[Only registered and activated users can see links. Click Here To Register...]
09/22/2009 00:34 Nis@#64
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..?
09/22/2009 02:37 Nis@#65
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
09/22/2009 06:26 King_Arthur#66
Quote:
Originally Posted by Nis@ View Post
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.
09/22/2009 15:07 nooneatall#67
or just run this query.. this will work
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
09/23/2009 23:31 Nis@#68
after work i must restart the server then log in with user=test pss=test..??
09/23/2009 23:39 Nis@#69
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
09/24/2009 02:09 purple21#70
Quote:
server down please come back later...server maintenance
can anyone help me how to resolve this
09/24/2009 05:16 King_Arthur#71
Quote:
Originally Posted by Nis@ View Post
after work i must restart the server then log in with user=test pss=test..??
Quote:
Originally Posted by Nis@ View Post
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.
10/01/2009 23:46 Necron33#72
Changelog:
Quote:
1- Added Spoilers and changed titles.
2 - Added a mini release box
3 - General update on all scripts.
4 - Posted this post ^^
10/31/2009 20:45 Nis@#73
Quote:
Originally Posted by King_Arthur View Post
Sounds like you already have an account named test in your account table then. You cant have duplicate account names.
thx ya:rolleyes:

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...???:confused:
11/05/2009 11:08 Fish*#74
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.
11/06/2009 02:38 karnyge#75
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)
Page 5 of 7 « First 34 5 67