[TUTORIAL] Create your EO server

[keving]

Re: Guide for EO server

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

 

[forcer_]

Re: Guide for EO server

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

 

[keving]

Re: Guide for EO server

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_]

Re: Guide for EO server

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]

Re: Guide for EO server

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]

Re: Guide for EO server

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

 

[Pete107]

Re: Guide for EO server

Can you use MSSQL?

 

[forcer_]

Re: Guide for EO server

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

 

[xichen2000]

Re: Guide for EO server

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]

Re: Guide for EO server

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]

Re: Guide for EO server

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 (thats if Accountserver,msgserver and npcserver is running with no errors)

 

[leavemealone]

Re: Guide for EO server

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

 

[pfinboy69]

Re: Guide for EO server

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]

Re: Guide for EO server

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]

Re: Guide for EO server

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

 

[baloo2008]

Re: Guide for EO server

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

/uplev (number here) becareful though if you do this then can't login go into navicat and manually change your lvl or whoever elses etc have fun also if u used jonhs ready server you wont need to use navicat =D

 

[forlove]

Re: Guide for EO server

hey where can i download english 1079 i have 1094 is this work or not

 

[forlove]

Re: Guide for EO server

hey the first guide for offline or online when i do this i found newyork server and london and all the TQ server when i put my id and password test test its say wrong password or id so when i do this right i found my server name or TQ server name

 

[john007]

Re: Guide for EO server

i did everything as this guide said, but i cant get connected to the client...
Start client but dont see my servers there.. any help? i re-checked evrything... all working but just cant connect on client....

 

[forcer_]

Re: Guide for EO server

client has changed with patch 1095+, you need to rename oem.ini to oem.dat ini ini/ folder of the client.