[TUTORIAL] Create your EO server

[keving]

If i start AccountServer it quits directly with no error.
Can somebody say me why?

[forcer_]

kevig: database not online/tables are not at the correct place/old_password query not executed

[keving]

I have change passwords in all files to my own and sql too but dont work.
I think all it online.
Im not noob at Apache mysql php etc

[forcer_]

I have change passwords in all files to my own and sql too but dont work.
I think all it online.
Im not noob at Apache mysql php etc

remember that old_password is used due compatibility problems with EO server.
so if you change the passwords to something else, you must also run query old_password + parameter must be your user defined pass.

[FroZenFiRe]

If i start AccountServer it quits directly with no error.
Can somebody say me why?

You forgot step 8 I belive. you must start the sql command line server 1st using " test " as the p/w then copy and paste this into it :
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';

[keving]

argh i have use sql from phpmyadmin ok sql command line works thx for all.

[Pete107]

Can you use MSSQL?

[forcer_]

nope, mssql does have different syntax, so I fear not.

[xichen2000]

Nehelp PLease?? I get an Error of
1034 - Incorrect key file for table 'account': try to repair it
when i try to open the file in Navicat...
Whats wrong?

[Xris]

Hey guys a few nooby questions but not to bad =P

i keep getting this error when starting up AccountServer

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

And get server is down error when logging into game.

Second question is you guys are legends for getting this to work i was wonder if it was possable for another tq game called monster and me? Is it possable? let me know ^^ thank you <3

[nooneatall]

Hey guys a few nooby questions but not to bad =P

i keep getting this error when starting up AccountServer

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

And get server is down error when logging into game.

Second question is you guys are legends for getting this to work i was wonder if it was possable for another tq game called monster and me? Is it possable? let me know ^^ thank you <3

read trough forcers guide in how to add the ODBC account

server is down is usually because u dont have the right servername in all files :D (thats if Accountserver,msgserver and npcserver is running with no errors)

[leavemealone]

I have followed the guide and its not establishing a connection to the database, don't know why but its all setup correctly.

[pfinboy69]

it gives me an error when i put the obdc in the command lin eexplain to to me wat i have to do in navicat

[dustin33]

when i try and do this in the MySQL Command Line Client it says "ERROR 1146 <42S02> Table 'account'.'account' doesn't exist. plz help

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';

[devilavenger200]

what code levels up the [PM] to lvl 255?