Rathena char2 & map2 cannot connect to login1 server..

[rakuzas]

 

Ok.. i have 1 working server hosting at my Windows 2008 Server.. But.. Im going to run another server #2.. Using same login but different char and map.. I also already open new port and already port forward too.. Then, i also make new schema for the 2nd server.. But.. what make me frustated is, the login server refused to connect the char #2.. I dont know how to make it works.. I already follow guide at rathena wiki.. 

[MonsTTer]

default s1, p1 are wrong, have checked this? Checks whether in your db are the same as configured in mapserv and logserv.

[rakuzas]

Yup.. Multiple check it.. If im using the #1 server user/pass it still refuse it.. When im use the #2 server user/pass it will shows this kind of error.. Hmmmm.. Any working guide how to setup 2 server at once? im use wiki guide and got this error.. I dont know which wrong.. I also already change inter_athena hmmmm...

[Scylla]

Yup.. Multiple check it.. If im using the #1 server user/pass it still refuse it.. When im use the #2 server user/pass it will shows this kind of error.. Hmmmm.. Any working guide how to setup 2 server at once? im use wiki guide and got this error.. I dont know which wrong.. I also already change inter_athena hmmmm...

 

Did you already made 2 databases?

 

For example, database for server #1 = ragnarok and database for server #2 = ragnarok2 same with log database. (log, log2)

[rakuzas]

Yup.. Multiple check it.. If im using the #1 server user/pass it still refuse it.. When im use the #2 server user/pass it will shows this kind of error.. Hmmmm.. Any working guide how to setup 2 server at once? im use wiki guide and got this error.. I dont know which wrong.. I also already change inter_athena hmmmm...

 

Did you already made 2 databases?

 

For example, database for server #1 = ragnarok and database for server #2 = ragnarok2 same with log database. (log, log2)

 

Yes.. I already make new database.. But stil shows same error..

[Scylla]

On phpmyadmin:

 

create ragnarok2 and log2 database for server #2. Then of course import main.sql and log.sql of your server #2's rathena

 

Go inside ragnarok2 database and edit the login table then set s1 and p1 passwords.

 

-------

 

On char_athena, login_athena, map_athena and inter_athena of server #2:

 

Edit char_athena and map_athena with your s1 and p1 passwords from ragnarok2 database.

 

On login_athena:

 

Edit this lines:

 

// Account data storage configuration

// TXT

account.txt.account_db: save/account.txt

account.txt.case_sensitive: no

// SQL

account.sql.db_hostname: localhost

account.sql.db_port: 3306

account.sql.db_username: PHPMYADMIN USERNAME HERE

account.sql.db_password: PHPMYADMIN PASSWORD HERE

account.sql.db_database: ragnarok2

account.sql.codepage: 

account.sql.case_sensitive: no

account.sql.account_db: login

account.sql.accreg_db: global_reg_value

 

On inter_athena:

 

// Global SQL settings

// overriden by local settings when the hostname is defined there

// (currently only the login-server reads/obeys these settings)

sql.db_hostname: localhost

sql.db_port: 3306

sql.db_username: ragnarok2 login table username

sql.db_password: ragnarok2 login table password

sql.db_database: ragnarok2

sql.codepage:

 

// MySQL Character SQL server

char_server_ip: localhost

char_server_port: 3306

char_server_id: ragnarok2 login table username

char_server_pw: ragnarok2 login table password

char_server_db: ragnarok2

 

// MySQL Map SQL Server

map_server_ip: localhost

map_server_port: 3306

map_server_id: ragnarok2 login table username

map_server_pw: ragnarok2 login table password

map_server_db: ragnarok2

 

// MySQL Log SQL Database

log_db_ip: localhost

log_db_port: 3306

log_db_id: ragnarok2 login table username

log_db_pw: ragnarok2 login table password

log_db_db: log2

log_codepage:

 

Sorry if it's hard to understand. Just if there's still to be a problem here.