no one can log in

[yosif]

hello guys

whats proplem in my server no on can log in my server

i change ip from :

ACCServer :

config.ini


GameServer :

config.ini
shell.ini


its work from me but other pple cant log in whats wrong ??

i use hamachi

[apoxdeath]

First off stop using hamachi :P and to be sure of the problem paste your config files and hamachi ip and ill tell you the problem

[yosif]

ACCServer

AuthorizeDB.cfg -----> when i change the ip to 25.75.239.205 accserver crash

127.0.0.1 root test my account name password id
count_stat server_name status
127.0.0.1 test 4871344843773d3d111 my

config

[System]
LOGINLISTENPORT = 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS = 5000
SERVER_BUSY_DELAY_SECS = 3000
SERVERNAME = TEST
LOGINNAME = root
PASSWORD = test
SERVERIP =25.75.239.205
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

GameServer :

config

; ÅäÖÃÎļþ


[System]
SERVERNAME = TEST
MONSTER_ACTIVE_LIMIT = 4000


[GameServer]
GAMESERVER_IP =25.75.239.205
GAMESERVER_PORT = 5816
SND_SIZE = 64000
RCV_SIZE = 16000


[Database]
DB_IP = 127.0.0.1
DB_USER = root
DB_PW = test
DB_NAME = my


[InternetPort]
MASTER_IP = 25.75.239.205
MASTER_PORT = 8653
PORT_SIZE = 53
LOGIN_KEY = dfkKO23k'[cvK934
CURRENT_PORTID = 2


[BusySleep]
LEVEL1 = 20 ; > 1000 sleep 20%
LEVEL2 = 30 ; > 2000
LEVEL3 = 40 ; > 3000
LEVEL4 = 50 ; > 4000
LEVEL5 = 60 ; > 5000

shell.dat

127.0.0.1. TEST root test ‰&

shell

; Íâ¿ÇÅäÖÃÎļþ
; 2002.10.23

[System]
MAPGROUP_SIZE = 1
ACCEPT_MS = 500

[StreamType]
TYPE = 0 ;0=Õý³£´ÓSOCKET£¬1=SOCKET¼Ç¼µ½Îļþ, 2=´ÓÎļþ¶Á(³ÌÐòµ÷ÊÔÓÃ)

[Database]
DB_IP = 127.0.0.1
DB_USER = root
DB_PW = test
DB_DB = my


[AccountServer]
ACCOUNT_IP =25.75.239.205
ACCOUNT_PORT = 9865
SERVERNAME = TEST
LOGINNAME = root
PASSWORD = test
; µÇ¼±í³ß´ç, 10-5000
MAXLOGINTABLESIZE=1500
; µÇ¼±í³¬Ê±ÃëÊý£¬0-86400
LOGINOVERTIMESECS=120




[InternetPort]
MASTER_IP = 25.75.239.205
MASTER_PORT = 8653
PORT_SIZE = 53
LOGIN_KEY = dfkKO23k'[cvK934
CURRENT_PORTID = 1

and tjis not work for me

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';

when i add this say to me

mysql> 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';
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OLD_PASSWORD('test')' at line 1
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_bin NOT NULL' at line 1
1146 - Table 'account.account' doesn't exist
Query OK, 0 rows affected

Query OK, 0 rows affected

mysql>

please help me

[yosif]

any one can help ??

[georgeion92]

test account maybe already exist in acc server?

[yosif]

guys i fix it i want shell.dat and shell.ini only change the ip and now every one can log in thanks guys

[magewarior2]

account.ini?

have you changed this?

[yosif]

yup

[magewarior2]

i guess your config.ini (gameserver) has not all the information. because the config of my gameserver has lots more data.

[yosif]

i fixed its now non hamachi you can test it if you want