rAthena connection failed

[drifterxxxx2]

hi guys

Debian 9 x64 (vps)

i'm having an issue when starting rAthena  ./athena-start start

after login-server, char-server and map-server start (all green) this error starts to show up when they try to connect 

 

[Info]: Attempt to connect to login-server...
[Status]: Connecting to xx.xx.xx.xx:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
root@xxxxxxxx:~/rAthena# [Status]: Done reading '11561' entries in 'db/re/item_db.txt'.
[Status]: Done reading '0' entries in 'db/import/item_db.txt'.
[Status]: Done reading '1' entries in 'db/item_avail.txt'.
[Status]: Done reading '8' entries in 'db/re/item_stack.txt'.
[Status]: Done reading '125' entries in 'db/item_nouse.txt'.
[Status]: Done reading '0' entries in 'db/re/item_group_db.txt'.

[Status]: Event 'OnInit' executed with '2146' NPCs.
[Status]: Server is 'ready' and listening on port '5121'.

[Status]: Attempting to connect to Char Server. Please wait.
[Status]: Connecting to xx.xx.xx.xx:6121
[Error]: make_connection: connect failed (socket #7, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to xx.xx.xx.xx:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Status]: Connecting to xx.xx.xx.xx:6121
[Error]: make_connection: connect failed (socket #7, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to xx.xx.xx.xx:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Status]: Connecting to xx.xx.xx.xx:6121
[Error]: make_connection: connect failed (socket #7, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to xx.xx.xx.xx:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!

this is my inter_athena.conf

 

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: user1
sql.db_password: password1
sql.db_database: server1
sql.codepage:

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: user1
login_server_pw: password1
login_server_db: server1
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: user1
ipban_db_pw: password1
ipban_db_db: server1
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: user1
char_server_pw: password1
char_server_db: server1

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: user1
map_server_pw: password1
map_server_db: server1

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: user1
log_db_pw: password1
log_db_db: server1
log_codepage:
log_login_db: loginlog

 

I tried:

- adding ports to iptables

- changing ports

- triple check char_athena, map_athena, login_athena

- mysql is running all good, the user has privileges, etc

 

 

any ideas? i'm not very familiarized with debian commands so please put the full input

ty!

Edited October 29, 2017 by Rolf

[Vinsmoke Sanji]

I'm having a problem like this. My console it's all green too, but I can't connect by the hexed. And when I try to connect, there's no error in the console.

[Pandoras]

in your inter_athena.conf change 127.0.0.1 to your Public IP/Internal IP.

[drifterxxxx2]

changed it

now is worst  

[SQL]: Can't connect to MySQL server on 'xx.xx.xx.xx' (111)
[Error]: Couldn't connect with uname='user1',passwd='password1',host='xx.xx.xx.xx',port='3306',database='server1'
[Debug]: at map.cpp:4073
[Debug]: at map.cpp:4075

 

 

I also modified my log_db_db from "server1" to "log" and the error message change into this

 

[Error]: Can not connect to login-server.
[Error]: The server communication passwords (default s1/p1) are probably invalid.
[Error]: Also, please make sure your login db has the correct communication username/passwords and the 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.

 

map_athena.conf and char_athena.conf username and passwords are the same as inter_athena.conf

 

EDIT:

what are the login tables? 

 

 

Edited October 29, 2017 by Rolf