connection login-server/char-server refused

[kitty14]

hello I followed this guide

http://rathena.org/board/topic/59529-setting-up-a-centos-vps-w-rathena-vnc/

 

char_athena:

userid: server
passwd: password

// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces or any of these characters which are not allowed in
//       Windows filenames \/:*?"<>|
//       ... or else guild emblems won't work client-side!
server_name: TestServer

// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 192.157.***.***

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 192.157.***.***

// Character Server Port
char_port: 6121

map_athena.conf
 

// Interserver communication passwords, set in account.txt (or equiv.)
userid: server
passwd: password

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 192.157.***.***

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 192.157.***.***

// Map Server Port
map_port: 5121

inter_athena.conf:

// Global SQL settings
// overridden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: 192.157.***.***
sql.db_port: 3306
sql.db_username: root
sql.db_password: Testpass
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 192.157.***.***
char_server_port: 3306
char_server_id: root
char_server_pw: Testpass
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 192.157.***.***
map_server_port: 3306
map_server_id: root
map_server_pw: Testpass
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 192.157.***.***
log_db_port: 3306
log_db_id: root
log_db_pw: Testpass
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

Sub_net// Subnet support file

// Format is:
// subnet: net-submask:char_ip:map_ip
// you can add more than one subnet (max 16)
// check is if((net-submask & char_ip ) == (net-submask & servip)) => ok

subnet: 255.0.0.0:192.157.***.***:192.157.***.***

already change phpmyadmin

UPDATE `login` SET userid='server', user_pass='password' WHERE account_id='1';

and Im recieving this error:
[Error]: can not connet to login-server. 

[Error]: The server communication passwords (default s1/p1) are probably invalid
[Error]:  Also, please make sure your log-in db has correct communication user name/passwords and gender of the account is S
[Error]:  The communication passwords are set in map_athena.conf and char_athena.conf

[warning] Connection to Login Server Lost
[info] closed connection from 127.0.0.1

 

im always getting connection refused..

i already ran the server but when i stop it and start back i cant start i back.,  

please help wwhat did i miss.. im using linux centos 6

 

[Renzadic]

Make sure all your IPs are matching except login server. Basically the login server is your dedicated host and if your running your sql on another server you will have to make sure to put the right credentials. The only things you should edit are the map athena config, login athena config, and char athena config.

[kitty14]

Make sure all your IPs are matching except login server. Basically the login server is your dedicated host and if your running your sql on another server you will have to make sure to put the right credentials. The only things you should edit are the map athena config, login athena config, and char athena config.

 

Hello!

here look (got error first pic)

char_athena.conf:

// Athena Character configuration file.

// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.

// Server Communication username and password.
userid: TestServer
passwd: Password1234

// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces or any of these characters which are not allowed in
//       Windows filenames \/:*?"<>|
//       ... or else guild emblems won't work client-side!
server_name: TestServer

// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 127.0.0.1

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 192.157.***.***

// Character Server Port
char_port: 6121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.

map_athena.conf:

// Interserver communication passwords, set in account.txt (or equiv.)
userid: TestServer
passwd: Password1234

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 127.0.0.1

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 192.157.***.***

// Map Server Port
map_port: 5121

inter_athena.conf:

 

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: TessPass
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: TessPass
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: TessPass
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: TessPass
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

subnet:

 

subnet: 255.0.0.0:127.0.0.1:127.0.0.1

then this

char_athena.conf:

// Athena Character configuration file.

// Note: "Comments" are all text on the right side of a double slash "//"
// Whatever text is commented will not be parsed by the servers, and serves
// only as information/reference.

// Server Communication username and password.
userid: TestServer
passwd: Password1234

// Server name, use alternative character such as ASCII 160 for spaces.
// NOTE: Do not use spaces or any of these characters which are not allowed in
//       Windows filenames \/:*?"<>|
//       ... or else guild emblems won't work client-side!
server_name: TestServer

// Wisp name for server: used to send wisp from server to players (between 4 to 23 characters)
wisp_server_name: Server

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 192.157.***.***

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 192.157.***.***

// Character Server Port
char_port: 6121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.

map_athena.conf:

// Interserver communication passwords, set in account.txt (or equiv.)
userid: TestServer
passwd: Password1234

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 192.157.***.***

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 192.157.***.***

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 192.157.***.***

// Map Server Port
map_port: 5121

inter_athena.conf

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: TessPass
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: root
char_server_pw: TessPass
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: root
map_server_pw: TessPass
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: root
log_db_pw: TessPass
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

subnet:

 

subnet: 255.0.0.0:192.157.***.***:192.157.***.***

still the same

and i i change 

inter_athen.conf to:

sql.db_hostname: 192.157.***.***
sql.db_port: 3306
sql.db_username: root
sql.db_password: TessPass
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 192.157.***.***
char_server_port: 3306
char_server_id: root
char_server_pw: TessPass
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 192.157.***.***
map_server_port: 3306
map_server_id: root
map_server_pw: TessPass
map_server_db: ragnarok

// MySQL Log SQL Database
log_db_ip: 192.157.***.***
log_db_port: 3306
log_db_id: root
log_db_pw: TessPass
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog

this error promted

sql: Access denied for 'root'@'testserver' (using password : yes)

debug: at loginlog.c:191

for map

debug: at inter.c:706

please help

anyone?

Edited August 26, 2014 by kitty14

[Idolo]

Can you take screenshot from your login table ?

[Renzadic]

looks like your using your own home pc according 192.168.*.* if you had anyway to connect to your pc maybe team viewer i could help.

[Microsoft]

Go to your phpMyAdmin

 

Choose your database

 

Click the login table

 

Edit the first line with the "S" gender

 

change the username and password the same in your char_athena.conf, map_athena.conf

[kitty14]

hello! thank you for the respond.. yup I already did that.. and still got connection refused..

[Microsoft]

hello! thank you for the respond.. yup I already did that.. and still got connection refused..

 

Do not change the ip in inther_athena.conf

 

sql.db_hostname, char_server_ip, map_server_ip, log_db_ip

[kitty14]

so remain as 127.0.0.1?

kk wait let me try

 

hello! thank you for the respond.. yup I already did that.. and still got connection refused..

 

Do not change the ip in inther_athena.conf

 

sql.db_hostname, char_server_ip, map_server_ip, log_db_ip

 

got same error..

how about the priviliges in phpadmin?

sorry too noob.. 

i already ran the this and was able to log-in, and i dont know now what happen.. 

Edited August 25, 2014 by kitty14

[Microsoft]

so remain as 127.0.0.1?

kk wait let me try

 

hello! thank you for the respond.. yup I already did that.. and still got connection refused..

 

Do not change the ip in inther_athena.conf

 

sql.db_hostname, char_server_ip, map_server_ip, log_db_ip

 

got same error..

how about the priviliges in phpadmin?

sorry too noob.. 

i already ran the this and was able to log-in, and i dont know now what happen.. 

 

What is your username and password in your login table?

[kitty14]

already change it to
userid: TestServer

passwd: Password1234

let me try to import new sqls

Edited August 25, 2014 by kitty14

[Microsoft]

 

already change it to

userid: TestServer

passwd: Password1234

let me try to import new sqls

 

 

See? You are not following me.

 

Your password in char_athena.conf, map_athena.conf is:

 

userid: server

passwd: password

 

then your user and password in login table is:

 

userid: TestServer

passwd: Password1234

 

I told you to use the same username and password of your char_athena.conf and map_athena.conf for your login table.

Edited August 25, 2014 by Microsoft

[kitty14]

 

so remain as 127.0.0.1?

kk wait let me try

 

hello! thank you for the respond.. yup I already did that.. and still got connection refused..

 

Do not change the ip in inther_athena.conf

 

sql.db_hostname, char_server_ip, map_server_ip, log_db_ip

 

got same error..

how about the priviliges in phpadmin?

sorry too noob.. 

i already ran the this and was able to log-in, and i dont know now what happen.. 

 

What is your username and password in your login table?

 

no.. 

map_thena.conf

// Interserver communication passwords, set in account.txt (or equiv.)

userid: TestServer

passwd: Password1234

char_athena.conf

// Server Communication username and password.

userid: TestServer

passwd: Password1234

phpadming

login database

1 TestServer Password1234 

Edited August 25, 2014 by kitty14