failed to connect, map server is UP already :(

[kitty14]

hello, please help me with this, try to create test server 
 

• followed some guide here for vnc vnc viewer and mysql followed this CREATE USER 'root'@'192.157.***.***'IDENTIFIED BY 'mypassword'; then GRANT ALL PRIVILEGES ON ragnarok.* to 'root'@'%' IDENTIFIED BY 'mypassword';
• also this sql guide [ CREATE USER 'root'@'%' IDENTIFIED BY 'mypassword';
  GRANT ALL PRIVILEGES ON ragnarok.* to 'root'@'%' IDENTIFIED BY 'mypassword';
• and lastly this guide

first i tried this

char_athena.conf

// 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

map_athena.conf
 

// 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.***.***

inther_athen.conf

sql.db_hostname: 127.0.0.1
sql.db_port: 3306
sql.db_username: root
sql.db_password: mypassword
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: mypassword
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: mypassword
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: mypassword
log_db_db: ragnarok
log_codepage:
log_login_db: loginlog
subnet: 255.0.0.0:127.0.0.1:127.0.0.1

i cant connect so i decided to change again and followed this

char_athena.conf

// 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

// 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.***.***

inther_athen.conf
 

sql.db_hostname: 192.157.***.***
sql.db_port: 3306
sql.db_username: root
sql.db_password: mypassword
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: mypassword
char_server_db: ragnarok

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

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

still cant connect.. 

what did i miss? map server is already UP.. got no sql, debug error. but i cant connect. always failed to connect. its non RO vps.. 
thanks 


FIX clientinfo.xml patched at wrong grf.. hahaha.. thanks!

Edited August 23, 2014 by kitty14

[Ragnar Lothbrok]

login-server, map-server & char-server are connected?

 

check your clientinfo.xml

[kitty14]

thanks for the responds

and about the clientinfo.xml

how will i add test server choices?

like this 

>>>>>> Real Server <<<<<<<
>>>>>>Test Server <<<<<<<

Edited August 23, 2014 by kitty14

[mightyryan]

add this at the bottom after the first </connection>(your first server configuration) of your clientinfo.xml

 

<connection>

<display>Test Server</display>
<desc>Ragnarok Online</desc>
<balloon>this is a tool tip</balloon>
<address>yourIP</address>
<port>yourport</port>
<version>yourversion</version>
<langtype>1</langtype>
<registrationweb>REGISTRATION URL HERE</registrationweb>
</connection>

Edited August 23, 2014 by mightyryan