can't start my server. login-server, char-server, and map-server crash

[gpedro153]

hey everybody, i am new here and i am trying to create my own server

 

i followed all the tutorials doing exactly what they were telling me to do (i think).

 

but when i try to run my server the login-server, char-server, and map-server crash. they open and a few seconds later they close (it is really fast)

 

i took a screenshot of the login-server just before it closes automatically, here it is.

 

 

 

does anyone have any clue what it might be?

 

if you guys need more information of my configurations to help me out just let me know and i will post here

[rayn]

Login server isn't crashing. It's exiting due to an error.

Your login server config file is telling login server to connect to MySQL database on your localhost (127.0.0.1) and connect using username "ragnarok" and the password you edited out.

 

Make sure your MySQL server is running, and listening on localhost, port 3306. Make sure you have created a MySQL user named 'ragnarok' and assigned it whatever password you have in the config file.

 

Try to access your MySQL server directly, and see if it connects.

[gpedro153]

Thank you for replying

 

so, MySQL is running and listening on localhost:

 

 

 

 

I have changed inter_athena.conf a little bit and now all of the login-server, char-server, and map-server open and communicate to each other

 

here are the changes I made on my inter_athena.conf:

// MySQL Login server
login_server_ip: 127.0.0.1
login_server_port: 3306
login_server_id: ragnarok
login_server_pw: [ADDED THE PASSWORD I CREATED]
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no

ipban_db_ip: 127.0.0.1
ipban_db_port: 3306
ipban_db_id: ragnarok
ipban_db_pw: [ADDED THE PASSWORD I CREATED]
ipban_db_db: ragnarok
ipban_codepage:

// MySQL Character server
char_server_ip: 127.0.0.1
char_server_port: 3306
char_server_id: ragnarok
char_server_pw: [ALREADY HAD MY PASSWORD]
char_server_db: ragnarok

// MySQL Map Server
map_server_ip: 127.0.0.1
map_server_port: 3306
map_server_id: ragnarok
map_server_pw: [ALREADY HAD MY PASSWORD]
map_server_db: ragnarok

// MySQL Log Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: [ALREADY HAD MY PASSWORD]
log: ragnarok
log_codepage:
log_login_db: loginlog

the tutorial i followed however didn't mentioned to change the lines i just changed.

 

 

now as i said, all three (login, char, and map-server) communicate to each other.

 

 

 

However when i try to log in with the game username and password i created in the database it says "Failed to Connect to Server"

 

here is a screenshot of my login-server after i try to login

 

as you can see it says DB errer - No database selected. 

But it also says "Connection of the account accepted". so it is recognizing my game account, right?

I am assuming this is the problem, but how do i fix it?

Edited February 17, 2015 by gpedro153