• 0
jasonjay

make_connection: connect failed (socket #5, error 111: Connection refused)!

Question

Hi!


 


im just new here, i don't know if my post is right.


 


i'm having a error's in running the ./map-server and ./char-server but my ./login-server seems to be ok.


 


map-server


 


[status]: Event 'OnInit' executed with '1740' NPCs.

[status]: Server is 'ready' and listening on port '5121'.


[status]: Attempting to connect to Char Server. Please wait.

[status]: Connecting to 10.10.11.70:6121

[Error]: make_connection: connect failed (socket #6, error 111: Connection refused)!


[status]: Connecting to 10.10.11.70:6121

[Error]: make_connection: connect failed (socket #6, error 111: Connection refused)!


 


char-server


 


[status]: Done reading '50' entries in 'db/re/exp_guild.txt'.

[status]: Finished Reading GeoIP Database.

[status]: Characters per Account: '9'.

[status]: The char-server is ready (Server is listening on the port 6121).


[info]: Attempt to connect to login-server...

[status]: Connecting to 10.10.11.70:6900

[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!


 


hope you could help me thanks!
 
 

Share this post


Link to post
Share on other sites

Recommended Posts

login table

username: ragnarok pw: ragnarok sex: S(erver).

 

NEVER FORGET

To set privilages for root on ragnarok database.

 

privilage_zps59b67496.png

 

 

 

CHECK:

 

char_athena.conf

// 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 // change to your host server ip

// 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:  127.0.0.1 // change to your server host ip

 

 

map_athena.conf

 

//--------------------------------------------------------------
//			Configuration Info			
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: ragnarok
passwd: ragnarok

// 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 change to your host server ip

// 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:  127.0.0.1 // change to your host server ip

 

 

if you are using a host.

 

inter_athena.conf.

 

// 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: 127.0.0.1 // do not change
sql.db_port: 3306
sql.db_username: ragnarok //your mysql username
sql.db_password: ragnarok // your mysql password
sql.db_database: ragnarok
sql.codepage:

// MySQL Character SQL server
char_server_ip: 127.0.0.1 // do not change
char_server_port: 3306
char_server_id: ragnarok // your mysql username
char_server_pw: ragnarok //your mysql password
char_server_db: ragnarok

// MySQL Map SQL Server
map_server_ip: 127.0.0.1 //do not change
map_server_port: 3306
map_server_id: ragnarok //your mysql username
map_server_pw: ragnarok //your mysql password
map_server_db: ragnarok

// MySQL Log SQL Database 
log_db_ip: 127.0.0.1 //do not change
log_db_port: 3306
log_db_id: ragnarok //your mysql username
log_db_pw: ragnarok //your mysql password
log_db_db: log
log_codepage:

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi Jlance,

 

I have made my user rathena4444 granted all privilages on mysql, i could also connect to it from another computer.

here's my config files.

 

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: rathena4444
passwd: rathena4444

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

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

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

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

// Character Server Port
char_port: 6121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server output more silent by ommitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Type of server.
// No functional side effects at the moment.
// Displayed next to the server name in the client.
// 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P
char_maintenance: 0

// Enable or disable creation of new characters.
// Now it is actually supported [Kevin]
// Display (New) in the server list.
char_new_display: 0

// Maximum users able to connect to the server.
// Set to 0 to disable users to log-in. (-1 means unlimited)
max_connect_user: -1

// Group ID that is allowed to bypass the server limit of users.
// Default: -1 = nobody (there are no groups with ID < 0)
// See: conf/groups.conf
gm_allow_group: 99

// How often should the server save all files? (In seconds)
// Note: Applies to all data files on TXT servers.
// On SQL servers, it applies to guilds (character save interval is defined on the map config)
autosave_time: 60

// Display information on the console whenever characters/guilds/parties/pets are loaded/saved?
save_log: yes

// Starting point for new characters
// Format: <map_name>,<x>,<y>
start_point: new_1-1,53,111

// Starting items for new characters
// Max number of items is MAX_STARTITEM in char.c (default 32)
// Format: <id>,<amount>,<position>:<id>,<amount>,<position>:...
// To auto-equip an item, include the position where it will be equipped; otherwise, use zero.
start_items: 1201,1,2:2301,1,16

// Starting zeny for new characters
start_zeny: 0

// Size for the fame-lists
fame_list_taekwon: 10

// Guild earned exp modifier.
// Adjusts taxed exp before adding it to the guild's exp. For example, if set
// to 200, the guild receives double the player's taxed exp.
guild_exp_rate: 100

// Name used for unknown characters
unknown_char_name: Unknown

// To log the character server?
log_char: 1

// Allow or not identical name for characters but with a different case (upper/lower):
// example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed
name_ignoring_case: no

// NOTE: Applies to character, party and guild names.
// 0: no restriction (default)
// 1: only letters/symbols in 'char_name_letters' option.
// 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.
char_name_option: 1

// Set the letters/symbols that you want use with the 'char_name_option' option.
// Note: Don't add spaces unless you mean to add 'space' to the list.
char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890

// How many Characters are allowed per Account ? (0 = disabled)
// You can not exceed the limit of MAX_CHARS slots, defined in mmo.h
// Doing that, chars_per_account will be default to MAX_CHARS.
chars_per_account: 0

// Restrict character deletion by BaseLevel
// 0: no restriction (players can delete characters of any level)
// -X: you can't delete chars with BaseLevel <= X
// Y: you can't delete chars with BaseLevel >= Y
// e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel)
char_del_level: 0

// Amount of time in seconds by which the character deletion is delayed.
// Default: 86400 (24 hours)
// NOTE: Requires client 2010-08-03aragexeRE or newer.
char_del_delay: 86400

// What folder the DB files are in (item_db.txt, etc.)
db_path: db

//===================================
// Pincode system
//===================================
// NOTE: Requires client 2011-03-09aragexeRE or newer.
// A window is opened before you can select your character and you will have to enter a pincode by using only your mouse.
// Default: yes
pincode_enabled: yes

// How often does a user have to change his pincode?
// 0: never (default)
// X: every X days
pincode_changetime: 0

// How often can a user enter the wrong pincode?
// Default: 3 (client maximum)
pincode_maxtry: 3

// Are users forced to use a pincode when the system is enabled?
// Default: yes
pincode_force: yes

//===================================
// Addon system
//===================================
// Character moving
// NOTE: Requires client 2011-09-28aragexeRE or newer.
// Allows users to move their characters between slots.
// Default: yes
char_move_enabled: yes

// Allow users to move a character to a used slot?
// If enabled the characters are exchanged.
// Default: yes
char_movetoused: yes

// Allow users to move characters as often as they like?
char_moves_unlimited: no

import: conf/import/char_conf.txt

map_athena.conf

//--------------------------------------------------------------
//rAthena Map-Server 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.

//--------------------------------------------------------------
//                     Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: rathena4444
passwd: rathena4444

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

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

// Map Server Port
map_port: 5121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server log selected message types to a file in the /log/ folder
//1: Log Warning Messages
//2: Log Error and SQL Error messages.
//4: Log Debug Messages
//Example: "console_msg_log: 7" logs all 3 kinds
//Messages logged by this overrides console_silent setting
console_msg_log: 0

//Makes server output more silent by omitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

//Where should all database data be read from?
db_path: db

// Enable the @guildspy and @partyspy at commands?
// Note that enabling them decreases packet sending performance.
enable_spy: no

// Read map data from GATs and RSWs in GRF files or a data directory
// as referenced by grf-files.txt rather than from the mapcache?
use_grf: no

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Database autosave time
// All characters are saved on this time in seconds (example:
// autosave of 60 secs with 60 characters online -> one char is saved every
// second)
autosave_time: 300

// Min database save intervals (in ms)
// Prevent saving characters faster than at this rate (prevents char-server
// save-load getting too high as character-count increases)
minsave_time: 100

// Apart from the autosave_time, players will also get saved when involved
// in the following (add as needed):
// 1: after every successful trade
// 2: after every vending transaction
// 4: after closing storage/guild storage.
// 8: After hatching/returning to egg a pet.
// 16: After successfully sending a mail with attachment
// 32: After successfully submitting an item for auction
// 64: After successfully get/delete/complete a quest
// NOTE: These settings decrease the chance of dupes/lost items when there's a
// server crash at the expense of increasing the map/char server lag. If your
// server rarely crashes, but experiences interserver lag, you may want to set
// these off.
save_settings: 127

// Message of the day file, when a character logs on, this message is displayed.
motd_txt: conf/motd.txt

// When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands.
help_txt: conf/help.txt
help2_txt: conf/help2.txt
charhelp_txt: conf/charhelp.txt

// Maps:
import: conf/maps_athena.conf

import: conf/import/map_conf.txt

inter_athena.conf.

 

/ Athena InterServer configuration.
// Contains settings shared/used by more than 1 server.

// Options for both versions

// Log Inter Connections, etc.?
log_inter: 1

// Inter Log Filename
inter_log_filename: log/inter.log

// Level range for sharing within a party
party_share_level: 15

// SQL version options only

// You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage:


// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1
// Under windows, you want to use 127.0.0.1.  If you see a message like
// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
// and you have localhost, switch it to 127.0.0.1

// 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: 10.10.11.70
sql.db_port: 3306
sql.db_username: rathena4444
sql.db_password: rathena4444
sql.db_database: rathena4444_rag
sql.codepage:

// MySQL Character SQL server
char_server_ip: 10.10.11.70
char_server_port: 3306
char_server_id: rathena4444
char_server_pw: rathena4444
char_server_db: rathena4444_rag

// MySQL Map SQL Server
map_server_ip: 10.10.11.70
map_server_port: 3306
map_server_id: rathena4444
map_server_pw: rathena4444
map_server_db: rathena4444_rag

// MySQL Log SQL Database
log_db_ip: 10.10.11.70
log_db_port: 3306
log_db_id: rathena4444
log_db_pw: rathena4444
log_db_db: rathena4444_log
log_codepage:
log_login_db: loginlog

// MySQL Reconnect Settings
// - mysql_reconnect_type:
//   1: When MySQL disconnects during runtime, the server tries to reconnect
//      mysql_reconnect_count times and shuts down if unsuccessful.
//   2: When mysql disconnects during runtime, it tries to reconnect indefinitely.
mysql_reconnect_type: 2
mysql_reconnect_count: 1

// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
// this is meant for people who KNOW their stuff, and for some reason want to change their
// database layout. [CLOWNISIUS]

// ALL MySQL Database Table names

// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
storage_db: storage
reg_db: global_reg_value
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
ragsrvinfo_db: ragsrvinfo

// Map Database Tables
item_db_db: item_db
item_db_re_db: item_db_re
item_db2_db: item_db2
item_cash_db_db: item_cash_db
item_cash_db2_db: item_cash_db2
mob_db_db: mob_db
mob_db2_db: mob_db2
mob_skill_db_db: mob_skill_db
mob_skill_db2_db: mob_skill_db2
mapreg_db: mapreg

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: no

import: conf/import/inter_conf.txt



 

Hi edward L,

 

here's my the allowed ports in my firewall,

 

[email protected] ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:6900
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:6121
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:5121
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:mysql
ACCEPT     all  --  anywhere             anywhere            state RELATED,ESTABLISHED
ACCEPT     icmp --  anywhere             anywhere
ACCEPT     all  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:ssh
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:6900
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:6121
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:5121
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:mysql

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

 

 

am i doing it right?

Edited by jasonjay

Share this post


Link to post
Share on other sites

Hi Anyone,

 

Please help me on the problem, don't have any clue on what to do.

If you have solved yours maybe your solutions could help to.

 

thanks and God bless,

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

just create a database log and then import the logs.sql there, if this problem still occur import the logs.sql into your ragnarok database, this happen many times to me

Edited by MagRO

Share this post


Link to post
Share on other sites

Hi Edward,

 

I have tried what you have suggested, but sitll i got the same problem.

here's my config files.

 

Map_conf

//--------------------------------------------------------------
//rAthena Map-Server 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.

//--------------------------------------------------------------
//                     Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: rathena4444
passwd: rathena4444

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

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

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

// Map Server Port
map_port: 5121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server log selected message types to a file in the /log/ folder
//1: Log Warning Messages
//2: Log Error and SQL Error messages.
//4: Log Debug Messages
//Example: "console_msg_log: 7" logs all 3 kinds
//Messages logged by this overrides console_silent setting
console_msg_log: 0

//Makes server output more silent by omitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

//Where should all database data be read from?
db_path: db

// Enable the @guildspy and @partyspy at commands?
// Note that enabling them decreases packet sending performance.
enable_spy: no

// Read map data from GATs and RSWs in GRF files or a data directory
// as referenced by grf-files.txt rather than from the mapcache?
use_grf: no

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Database autosave time
// All characters are saved on this time in seconds (example:
// autosave of 60 secs with 60 characters online -> one char is saved every
// second)
autosave_time: 300

// Min database save intervals (in ms)
// Prevent saving characters faster than at this rate (prevents char-server
// save-load getting too high as character-count increases)
minsave_time: 100

// Apart from the autosave_time, players will also get saved when involved
// in the following (add as needed):
// 1: after every successful trade
// 2: after every vending transaction
// 4: after closing storage/guild storage.
// 8: After hatching/returning to egg a pet.
// 16: After successfully sending a mail with attachment
// 32: After successfully submitting an item for auction
// 64: After successfully get/delete/complete a quest
// NOTE: These settings decrease the chance of dupes/lost items when there's a
// server crash at the expense of increasing the map/char server lag. If your
// server rarely crashes, but experiences interserver lag, you may want to set
// these off.
save_settings: 127

// Message of the day file, when a character logs on, this message is displayed.
motd_txt: conf/motd.txt

// When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands.
help_txt: conf/help.txt
help2_txt: conf/help2.txt
charhelp_txt: conf/charhelp.txt

// Maps:
import: conf/maps_athena.conf

import: conf/import/map_conf.txt

 

Char_athena

// 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: rathena4444
passwd: rathena4444

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

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

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

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

// Character Server Port
char_port: 6121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server output more silent by ommitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Type of server.
// No functional side effects at the moment.
// Displayed next to the server name in the client.
// 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P
char_maintenance: 0

// Enable or disable creation of new characters.
// Now it is actually supported [Kevin]
// Display (New) in the server list.
char_new_display: 0

// Maximum users able to connect to the server.
// Set to 0 to disable users to log-in. (-1 means unlimited)
max_connect_user: -1

// Group ID that is allowed to bypass the server limit of users.
// Default: -1 = nobody (there are no groups with ID < 0)
// See: conf/groups.conf
gm_allow_group: 99

// How often should the server save all files? (In seconds)
// Note: Applies to all data files on TXT servers.
// On SQL servers, it applies to guilds (character save interval is defined on the map config)
autosave_time: 60

// Display information on the console whenever characters/guilds/parties/pets are loaded/saved?
save_log: yes

// Starting point for new characters
// Format: <map_name>,<x>,<y>
start_point: new_1-1,53,111

// Starting items for new characters
// Max number of items is MAX_STARTITEM in char.c (default 32)
// Format: <id>,<amount>,<position>:<id>,<amount>,<position>:...
// To auto-equip an item, include the position where it will be equipped; otherwise, use zero.
start_items: 1201,1,2:2301,1,16

// Starting zeny for new characters
start_zeny: 0

// Size for the fame-lists
fame_list_taekwon: 10

// Guild earned exp modifier.
// Adjusts taxed exp before adding it to the guild's exp. For example, if set
// to 200, the guild receives double the player's taxed exp.
guild_exp_rate: 100

// Name used for unknown characters
unknown_char_name: Unknown

// To log the character server?
log_char: 1

// Allow or not identical name for characters but with a different case (upper/lower):
// example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed
name_ignoring_case: no

// NOTE: Applies to character, party and guild names.
// 0: no restriction (default)
// 1: only letters/symbols in 'char_name_letters' option.
// 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.
char_name_option: 1

// Set the letters/symbols that you want use with the 'char_name_option' option.
// Note: Don't add spaces unless you mean to add 'space' to the list.
char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890

// How many Characters are allowed per Account ? (0 = disabled)
// You can not exceed the limit of MAX_CHARS slots, defined in mmo.h
// Doing that, chars_per_account will be default to MAX_CHARS.
chars_per_account: 0

// Restrict character deletion by BaseLevel
// 0: no restriction (players can delete characters of any level)
// -X: you can't delete chars with BaseLevel <= X
// Y: you can't delete chars with BaseLevel >= Y
// e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel)
char_del_level: 0

// Amount of time in seconds by which the character deletion is delayed.
// Default: 86400 (24 hours)
// NOTE: Requires client 2010-08-03aragexeRE or newer.
char_del_delay: 86400

// What folder the DB files are in (item_db.txt, etc.)
db_path: db

//===================================
// Pincode system
//===================================
// NOTE: Requires client 2011-03-09aragexeRE or newer.
// A window is opened before you can select your character and you will have to enter a pincode by using only your mouse.
// Default: yes
pincode_enabled: yes

// How often does a user have to change his pincode?
// 0: never (default)
// X: every X days
pincode_changetime: 0

// How often can a user enter the wrong pincode?
// Default: 3 (client maximum)
pincode_maxtry: 3

// Are users forced to use a pincode when the system is enabled?
// Default: yes
pincode_force: yes

//===================================
// Addon system
//===================================
// Character moving
// NOTE: Requires client 2011-09-28aragexeRE or newer.
// Allows users to move their characters between slots.
// Default: yes
char_move_enabled: yes

// Allow users to move a character to a used slot?
// If enabled the characters are exchanged.
// Default: yes
char_movetoused: yes

// Allow users to move characters as often as they like?
char_moves_unlimited: no

import: conf/import/char_conf.txt

 

Login_athena

// Athena Login Server configuration file.
// Translated by Peter Kieser <[email protected]>

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

// The login 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: 10.10.11.70

// Login Server Port
login_port: 6900

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server output more silent by omitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Can you use _M/_F to make new accounts on the server?
new_account: yes

//If new_account is enabled, minimum length to userid and passwords should be 4?
//Must be 'Yes' unless your client uses both 'Disable 4 LetterUserID/Password' Diffs
new_acc_length_limit: NO

// Account registration flood protection system
// allowed_regs is the number of registrations allowed in time_allowed (in seconds)
allowed_regs: 1
time_allowed: 10

// Log Filename. All operations received by the server are logged in this file.
login_log_filename: log/login.log

// To log the login server?
// NOTE: The login-sql server needs the login logs to enable dynamic pass failure bans.
log_login: yes

// Indicate how to display date in logs, to players, etc.
date_format: %Y-%m-%d %H:%M:%S

// Required account group id to connect to server.
// -1: disabled
// 0 or more: group id
group_id_to_connect: -1

// Minimum account group id required to connect to server.
// Will not function if group_id_to_connect config is enabled.
// -1: disabled
// 0 or more: group id
min_group_id_to_connect: -1

// Starting additional sec from now for the limited time at creation of account
// -1: new account are created with UNlimited time (default value)
start_limited_time: -1

// Check The clientversion set in the clientinfo ?
check_client_version: no

// What version we would allow to connect? (if the options above is enabled..)
client_version_to_connect: 20

// Store passwords as MD5 hashes instead of plaintext ?
// NOTE: Will not work with clients that use <passwordencrypt>
use_MD5_passwords: yes

// Ipban features (SQL only)
ipban.enable: yes
ipban.sql.db_hostname: 10.10.11.70
ipban.sql.db_port: 3306
ipban.sql.db_username: rathena4444
ipban.sql.db_password: rathena4444
ipban.sql.db_database: rathena4444_rag
ipban.sql.codepage:
ipban.sql.ipban_table: ipbanlist
//Dynamic password failure ipban system
ipban.dynamic_pass_failure_ban: yes
ipban.dynamic_pass_failure_ban_interval: 5
ipban.dynamic_pass_failure_ban_limit: 7
ipban.dynamic_pass_failure_ban_duration: 5

// Interval (in seconds) to clean up expired IP bans. 0 = disabled. default = 60.
// NOTE: Even if this is disabled, expired IP bans will be cleaned up on login server start/stop.
// Players will still be able to login if an ipban entry exists but the expiration time has already passed.
ipban_cleanup_interval: 60

// Interval (in minutes) to execute a DNS/IP update. Disabled by default.
// Enable it if your server uses a dynamic IP which changes with time.
//ip_sync_interval: 10

// DNS Blacklist Blocking
// If enabled, each incoming connection will be tested against the blacklists
// on the specified dnsbl_servers (comma-separated list)
use_dnsbl: no
dnsbl_servers: bl.blocklist.de, socks.dnsbl.sorbs.net
// Here are some free DNS Blacklist Services: http://en.wikipedia.org/wiki/Comparison_of_DNS_blacklists
//==============================================================================
//   dnsbl_servers                 Description
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// bl.blocklist.de                 IP-Addresses who attack other servers/honeypots over SSH, FTP, IMAP, etc.
// ircbl.ahbl.org                  AHBL (open proxies, compromised machines, comment spammers)
// safe.dnsbl.sorbs.net            All zones in dnsbl.sorbs.net except "recent" and "escalations"
// sbl-xbl.spamhaus.org            Spamhaus blacklist (spammers, open proxies)
// socks.dnsbl.sorbs.net           Open SOCKS proxy servers
// tor.ahbl.org                    Current tor relay and exit nodes

// Which account engine to use.
// 'auto' selects the first engine available (txt, sql, then others)
// (defaults to auto)
account.engine: auto

// Account data storage configuration
// SQL
//account.sql.db_hostname: 10.10.11.70
//account.sql.db_port: 3306
//account.sql.db_username: rathena4444
//account.sql.db_password: rathena4444
//account.sql.db_database: rathena4444_rag
//account.sql.codepage:
//account.sql.case_sensitive: no
//account.sql.account_db: login
//account.sql.accreg_db: global_reg_value

// Client MD5 hash check
// If turned on, the login server will check if the client's hash matches
// the value below, and will not connect tampered clients.
// Note: see doc\md5_hashcheck.txt for more details.
client_hash_check: on

// Client MD5 hashes
// A player can login with a client hash at or below the account group_id.
// Format: group_id, hash
client_hash: 0, 113e195e6c051bb1cfb12a644bb084c5
client_hash: 99, cb1ea78023d337c38e8ba5124e2338ae

import: conf/inter_athena.conf
import: conf/import/login_conf.txt

 

Inter_athena

// Athena InterServer configuration.
// Contains settings shared/used by more than 1 server.

// Options for both versions

// Log Inter Connections, etc.?
log_inter: 1

// Inter Log Filename
inter_log_filename: log/inter.log

// Level range for sharing within a party
party_share_level: 15

// SQL version options only

// You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage:


// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1
// Under windows, you want to use 127.0.0.1.  If you see a message like
// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
// and you have localhost, switch it to 127.0.0.1

// 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: 10.10.11.70
sql.db_port: 3306
sql.db_username: rathena4444
sql.db_password: rathena4444
sql.db_database: rathena4444_rag
sql.codepage:

// MySQL Character SQL server
char_server_ip: 10.10.11.70
char_server_port: 3306
char_server_id: rathena4444
char_server_pw: rathena4444
char_server_db: rathena4444_rag

// MySQL Map SQL Server
map_server_ip: 10.10.11.70
map_server_port: 3306
map_server_id: rathena4444
map_server_pw: rathena4444
map_server_db: rathena4444_rag

// MySQL Log SQL Database
log_db_ip: 10.10.11.70
log_db_port: 3306
log_db_id: rathena4444
log_db_pw: rathena4444
log_db_db: rathena4444_log
log_codepage:
log_login_db: loginlog

// MySQL Reconnect Settings
// - mysql_reconnect_type:
//   1: When MySQL disconnects during runtime, the server tries to reconnect
//      mysql_reconnect_count times and shuts down if unsuccessful.
//   2: When mysql disconnects during runtime, it tries to reconnect indefinitely.
mysql_reconnect_type: 2
mysql_reconnect_count: 1

// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
// this is meant for people who KNOW their stuff, and for some reason want to change their
// database layout. [CLOWNISIUS]

// ALL MySQL Database Table names

// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
storage_db: storage
reg_db: global_reg_value
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
ragsrvinfo_db: ragsrvinfo

// Map Database Tables
item_db_db: item_db
item_db_re_db: item_db_re
item_db2_db: item_db2
item_cash_db_db: item_cash_db
item_cash_db2_db: item_cash_db2
mob_db_db: mob_db
mob_db2_db: mob_db2
mob_skill_db_db: mob_skill_db
mob_skill_db2_db: mob_skill_db2
mapreg_db: mapreg

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: no

import: conf/import/inter_conf.txt

 

and here's my Firewall status:

[[email protected] ~]# /etc/init.d/iptables status
iptables: Firewall is not running.
[[email protected] ~]#


just create a database log and then import the logs.sql there, if this problem still occur import the logs.sql into your ragnarok database, this happen many times to me

 

Where do i locate the logs.sql? Could you instruct me in doing this in CentOS?

Edited by jasonjay

Share this post


Link to post
Share on other sites

log.sql is located in your trunk sql-files

 

had done these commands but i still got the same error.

 

[[email protected] trunk]$ cd sql-files/
[[email protected] sql-files]$ mysql -u rathena4444 -p rathena4444_log < logs.sql
Enter password:
[[email protected] sql-files]$
[[email protected] sql-files]$ mysql -u rathena4444 -p rathena4444_rag < logs.sql
Enter password:
[[email protected] sql-files]$

I hope we could figure this out :)

Hi,

 

Anyone Please help, im really having trouble with these errors.

Any solution? will be worth a try.

 

thanks and God  bless,

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi jasonjay,

 

Please remove '>' in your login_athena.conf. Also, what happens when you run your login-server? No errors? It seems that the issue is that your char-server is un-able to connect to your login-server.

Yes, when i ran my login-server i didn't have any error

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/login_msg.conf.
[Info]: Finished reading conf/import/inter_conf.txt.
[Info]: Finished reading conf/inter_athena.conf.
[Info]: Finished reading conf/import/login_conf.txt.
[Info]: Finished reading conf/login_athena.conf.
[Status]: The login-server is ready (Server is listening on the port 6900).

So how can i connect my char-server to my login-server?

Share this post


Link to post
Share on other sites

Hi Edward L. (COO),

 

are there any work arounds that i can do?

 

thanks for the help.

Edited by jasonjay

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi Edward L. (COO),

 

are there any work arounds that i can do?

 

thanks for the help.

Hi jasonjay,

 

Can you run all 3 map/char/login servers? Then show us anything that would resemble an error message? It's really hard to figure out the solution for your issue, because there's not enough specific info.

 

hi Edward here's what i get when i ran the servers.

 

./map-server

[Status]: Memory manager initialised: log/map-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Char Server IP Address : '10.10.11.70' -> '10.10.11.70'.
[Info]: Map Server IP Address : '10.10.11.70' -> '10.10.11.70'.
[Status]: Using SQL dbs: no
[Info]: Logging item transactions to table 'picklog'.
[Info]: Logging commands to table 'atcommandlog'.
[Info]: Logging Cash transactions to table 'cashlog'.
[Info]: Connecting to the Map DB Server....
[Status]: connect success! (Map Server Connection)
[Info]: [SQL]: Connecting to the Log Database rathena4444_log At 10.10.11.70...
[Status]: [SQL]: Successfully 'connected' to Database 'rathena4444_log'.
[Status]: Loading maps (using db/re/map_cache.dat as map cache)...
[Info]: Successfully loaded '862' maps.
[Info]: Finished reading conf/msg_conf/map_msg.conf.
[Status]: Done reading '63' command aliases in 'conf/atcommand_athena.conf'.
[Status]: Done reading '11' entries in 'db/re/instance_db.txt'.
[Status]: Done reading '4' channels in 'conf/channels.conf'.
[Status]: Done reading '911' entries in 'packet_db.txt'.
[Status]: Using default packet version: 30.
[Status]: Done reading '8236' entries in 're/item_db.txt'.
[Status]: Done reading '0' entries in 'item_db2.txt'.
[Status]: Done reading '218' entries in 'item_combo_db'.
[Status]: Done reading '1022' entries in 'db/re/item_bluebox.txt'.
[Status]: Done reading '923' entries in 'db/re/item_violetbox.txt'.
[Status]: Done reading '440' entries in 'db/re/item_cardalbum.txt'.
[Status]: Done reading '20' entries in 'db/item_findingore.txt'.
[Status]: Done reading '617' entries in 'db/re/item_giftbox.txt'.
[Status]: Done reading '1158' entries in 'db/re/item_misc.txt'.
[Status]: Done reading '0' entries in 'db/re/item_group_db.txt'.
[Status]: Done reading '1' entries in 'db/item_avail.txt'.
[Status]: Done reading '50' entries in 'db/re/item_noequip.txt'.
[Status]: Done reading '1818' entries in 'db/re/item_trade.txt'.
[Status]: Done reading '13' entries in 'db/item_delay.txt'.
[Status]: Done reading '10' entries in 'db/item_stack.txt'.
[Status]: Done reading '1057' entries in 'db/re/item_buyingstore.txt'.
[Status]: Done reading '124' entries in 'db/item_nouse.txt'.
[Status]: Done reading '0' entries in 're/item_cash_db.txt'.
[Status]: Done reading '0' entries in 'item_cash_db2.txt'.
[Status]: Done reading '1056' entries in 'db/re/skill_db.txt'.
[Status]: Done reading '826' entries in 'db/re/skill_require_db.txt'.
[Status]: Done reading '777' entries in 'db/re/skill_cast_db.txt'.
[Status]: Done reading '40' entries in 'db/re/skill_castnodex_db.txt'.
[Status]: Done reading '140' entries in 'db/re/skill_unit_db.txt'.
[Status]: Done reading '104' entries in 'db/re/skill_nocast_db.txt'.
[Status]: Done reading '263' entries in 'db/produce_db.txt'.
[Status]: Done reading '136' entries in 'db/create_arrow_db.txt'.
[Status]: Done reading '155' entries in 'db/abra_db.txt'.
[Status]: Done reading '17' entries in 'db/spellbook_db.txt'.
[Status]: Done reading '23' entries in 'db/magicmushroom_db.txt'.
[Status]: Done reading '133' entries in 'db/skill_reproduce_db.txt'.
[Status]: Done reading '25' entries in 'db/skill_improvise_db.txt'.
[Status]: Done reading '75' entries in 'db/skill_changematerial_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_item_ratio.txt'.
[Status]: Done reading '40' entries in 'db/mob_chat_db.txt'.
[Status]: Done reading '1316' entries in 'db/re/mob_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_db2.txt'.
[Status]: Done reading '7979' entries in 'db/re/mob_skill_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_skill_db2.txt'.
[Status]: Done reading '0' entries in 'db/mob_avail.txt'.
[Status]: Done reading '480' entries in 're/mob_branch.txt'.
[Status]: Done reading '14' entries in 're/mob_poring.txt'.
[Status]: Done reading '47' entries in 're/mob_boss.txt'.
[Status]: Done reading '331' entries in 'mob_pouch.txt'.
[Status]: Done reading '25' entries in 'mob_classchange.txt'.
[Status]: Done reading '6' entries in 'db/re/mob_race2_db.txt'.
[Status]: Done reading '5169' entries in 'db/re/skill_tree.txt'.
[Status]: Done reading '35' entries in 'db/re/level_penalty.txt'.
[Status]: Done reading '160' entries in 're/statpoint.txt'.
[Status]: Done reading '133' entries in 'db/re/job_db1.txt'.
[Status]: Done reading '132' entries in 'db/job_db2.txt'.
[Status]: Done reading '53' entries in 'db/re/job_maxhpsp_db.txt'.
[Status]: Done reading '15' entries in 'db/re/job_exp.txt'.
[Status]: Done reading '1' entries in 'conf/motd.txt'.
[Status]: Done reading '7' groups in 'conf/groups.conf'.
[Status]: Done reading '4' entries in 'db/re/attr_fix.txt'.
[Status]: Done reading '3' entries in 'db/size_fix.txt'.
[Status]: Done reading '5' entries in 'db/re/refine_db.txt'.
[Status]: Done reading '34' entries in 'db/castle_db.txt'.
[Status]: Done reading '15' entries in 'db/guild_skill_tree.txt'.
[Status]: Done reading '58' pets in 'pet_db.txt'.
[Status]: Done reading '0' pets in 'pet_db2.txt'.
[Status]: Done reading '13' entries in 'db/re/homunculus_db.txt'.
[Status]: Done reading '150' levels in 're/exp_homun.txt'.
[Status]: Done reading '82' entries in 'db/homun_skill_tree.txt'.
[Status]: Done reading '61' entries in 'db/mercenary_db.txt'.
[Status]: Done reading '153' entries in 'db/mercenary_skill_db.txt'.
[Status]: Done reading '12' elementals in 'db/elemental_db.txt'.
[Status]: Done reading '36' entries in 'db/elemental_skill_db.txt'.
[Status]: Done r

 

./char-server

[Status]: Memory manager initialised: log/char-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/char_msg.conf.
[Status]: Login server IP address : 10.10.11.70 -> 10.10.11.70
[Status]: Character server IP address : 10.10.11.70 -> 10.10.11.70
[Info]: Done reading conf/import/char_conf.txt.
[Info]: Done reading conf/char_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Connect Character DB server.... (Character Server)
[Status]: Done reading '50' entries in 'db/re/exp_guild.txt'.
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '9'.
[Status]: The char-server is ready (Server is listening on the port 6121).

[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...

 

./login-server

[Status]: Memory manager initialised: log/login-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/login_msg.conf.
[Info]: Finished reading conf/import/inter_conf.txt.
[Info]: Finished reading conf/inter_athena.conf.
[Info]: Finished reading conf/import/login_conf.txt.
[Info]: Finished reading conf/login_athena.conf.
[Status]: The login-server is ready (Server is listening on the port 6900).

 

thanks and God bless

Edited by jasonjay

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi Edward,

 

i changed my map/char config with my wan IP and here's my error after changing both.

 

./map-server

[Status]: Memory manager initialised: log/map-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Char Server IP Address : '10.10.11.70' -> '10.10.11.70'.
[Info]: Map Server IP Address : '122.55.53.34' -> '122.55.53.34'.
[Status]: Using SQL dbs: no
[Info]: Logging item transactions to table 'picklog'.
[Info]: Logging commands to table 'atcommandlog'.
[Info]: Logging Cash transactions to table 'cashlog'.
[Info]: Connecting to the Map DB Server....
[Status]: connect success! (Map Server Connection)
[Info]: [SQL]: Connecting to the Log Database rathena4444_log At 10.10.11.70...
[Status]: [SQL]: Successfully 'connected' to Database 'rathena4444_log'.
[Status]: Loading maps (using db/re/map_cache.dat as map cache)...
[Info]: Successfully loaded '862' maps.
[Info]: Finished reading conf/msg_conf/map_msg.conf.
[Status]: Done reading '63' command aliases in 'conf/atcommand_athena.conf'.
[Status]: Done reading '11' entries in 'db/re/instance_db.txt'.
[Status]: Done reading '4' channels in 'conf/channels.conf'.
[Status]: Done reading '911' entries in 'packet_db.txt'.
[Status]: Using default packet version: 30.
[Status]: Done reading '8236' entries in 're/item_db.txt'.
[Status]: Done reading '0' entries in 'item_db2.txt'.
[Status]: Done reading '218' entries in 'item_combo_db'.
[Status]: Done reading '1022' entries in 'db/re/item_bluebox.txt'.
[Status]: Done reading '923' entries in 'db/re/item_violetbox.txt'.
[Status]: Done reading '440' entries in 'db/re/item_cardalbum.txt'.
[Status]: Done reading '20' entries in 'db/item_findingore.txt'.
[Status]: Done reading '617' entries in 'db/re/item_giftbox.txt'.
[Status]: Done reading '1158' entries in 'db/re/item_misc.txt'.
[Status]: Done reading '0' entries in 'db/re/item_group_db.txt'.
[Status]: Done reading '1' entries in 'db/item_avail.txt'.
[Status]: Done reading '50' entries in 'db/re/item_noequip.txt'.
[Status]: Done reading '1818' entries in 'db/re/item_trade.txt'.
[Status]: Done reading '13' entries in 'db/item_delay.txt'.
[Status]: Done reading '10' entries in 'db/item_stack.txt'.
[Status]: Done reading '1057' entries in 'db/re/item_buyingstore.txt'.
[Status]: Done reading '124' entries in 'db/item_nouse.txt'.
[Status]: Done reading '0' entries in 're/item_cash_db.txt'.
[Status]: Done reading '0' entries in 'item_cash_db2.txt'.
[Status]: Done reading '1056' entries in 'db/re/skill_db.txt'.
[Status]: Done reading '826' entries in 'db/re/skill_require_db.txt'.
[Status]: Done reading '777' entries in 'db/re/skill_cast_db.txt'.
[Status]: Done reading '40' entries in 'db/re/skill_castnodex_db.txt'.
[Status]: Done reading '140' entries in 'db/re/skill_unit_db.txt'.
[Status]: Done reading '104' entries in 'db/re/skill_nocast_db.txt'.
[Status]: Done reading '263' entries in 'db/produce_db.txt'.
[Status]: Done reading '136' entries in 'db/create_arrow_db.txt'.
[Status]: Done reading '155' entries in 'db/abra_db.txt'.
[Status]: Done reading '17' entries in 'db/spellbook_db.txt'.
[Status]: Done reading '23' entries in 'db/magicmushroom_db.txt'.
[Status]: Done reading '133' entries in 'db/skill_reproduce_db.txt'.
[Status]: Done reading '25' entries in 'db/skill_improvise_db.txt'.
[Status]: Done reading '75' entries in 'db/skill_changematerial_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_item_ratio.txt'.
[Status]: Done reading '40' entries in 'db/mob_chat_db.txt'.
[Status]: Done reading '1316' entries in 'db/re/mob_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_db2.txt'.
[Status]: Done reading '7979' entries in 'db/re/mob_skill_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_skill_db2.txt'.
[Status]: Done reading '0' entries in 'db/mob_avail.txt'.
[Status]: Done reading '480' entries in 're/mob_branch.txt'.
[Status]: Done reading '14' entries in 're/mob_poring.txt'.
[Status]: Done reading '47' entries in 're/mob_boss.txt'.
[Status]: Done reading '331' entries in 'mob_pouch.txt'.
[Status]: Done reading '25' entries in 'mob_classchange.txt'.
[Status]: Done reading '6' entries in 'db/re/mob_race2_db.txt'.
[Status]: Done reading '5169' entries in 'db/re/skill_tree.txt'.
[Status]: Done reading '35' entries in 'db/re/level_penalty.txt'.

 

and heres my map config (need to change my WAN IP for security)

//--------------------------------------------------------------
//rAthena Map-Server 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.

//--------------------------------------------------------------
//                     Configuration Info
//--------------------------------------------------------------
// Interserver communication passwords, set in account.txt (or equiv.)
userid: rathena4444
passwd: rathena4444

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

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

// 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: XXX.XX.XX.XX

// Map Server Port
map_port: 5121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server log selected message types to a file in the /log/ folder
//1: Log Warning Messages
//2: Log Error and SQL Error messages.
//4: Log Debug Messages
//Example: "console_msg_log: 7" logs all 3 kinds
//Messages logged by this overrides console_silent setting
console_msg_log: 0

//Makes server output more silent by omitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

//Where should all database data be read from?
db_path: db

// Enable the @guildspy and @partyspy at commands?
// Note that enabling them decreases packet sending performance.
enable_spy: no

// Read map data from GATs and RSWs in GRF files or a data directory
// as referenced by grf-files.txt rather than from the mapcache?
use_grf: no

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Database autosave time
// All characters are saved on this time in seconds (example:
// autosave of 60 secs with 60 characters online -> one char is saved every
// second)
autosave_time: 300

// Min database save intervals (in ms)
// Prevent saving characters faster than at this rate (prevents char-server
// save-load getting too high as character-count increases)
minsave_time: 100

// Apart from the autosave_time, players will also get saved when involved
// in the following (add as needed):
// 1: after every successful trade
// 2: after every vending transaction
// 4: after closing storage/guild storage.
// 8: After hatching/returning to egg a pet.
// 16: After successfully sending a mail with attachment
// 32: After successfully submitting an item for auction
// 64: After successfully get/delete/complete a quest
// NOTE: These settings decrease the chance of dupes/lost items when there's a
// server crash at the expense of increasing the map/char server lag. If your
// server rarely crashes, but experiences interserver lag, you may want to set
// these off.
save_settings: 127

// Message of the day file, when a character logs on, this message is displayed.
motd_txt: conf/motd.txt

// When @help or @h is typed when you are a gm, this is displayed for helping new gms understand gm commands.
help_txt: conf/help.txt
help2_txt: conf/help2.txt
charhelp_txt: conf/charhelp.txt

// Maps:
import: conf/maps_athena.conf

import: conf/import/map_conf.txt

 

this is the error of my

 

./char-server

[Status]: Memory manager initialised: log/char-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/char_msg.conf.
[Status]: Login server IP address : 10.10.11.70 -> 10.10.11.70
[Status]: Character server IP address : 122.55.53.34 -> 122.55.53.34
[Info]: Done reading conf/import/char_conf.txt.
[Info]: Done reading conf/char_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Connect Character DB server.... (Character Server)
[Status]: Done reading '50' entries in 'db/re/exp_guild.txt'.
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '9'.
[Status]: The char-server is ready (Server is listening on the port 6121).

[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!

here's my char config

// 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: rathena4444
passwd: rathena4444

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

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

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

// 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: XXX.XX.XX.XX

// Character Server Port
char_port: 6121

//Time-stamp format which will be printed before all messages.
//Can at most be 20 characters long.
//Common formats:
// %I:%M:%S %p (hour:minute:second 12 hour, AM/PM format)
// %H:%M:%S (hour:minute:second, 24 hour format)
// %d/%b/%Y (day/Month/year)
//For full format information, consult the strftime() manual.
//timestamp_format: [%d/%b %H:%M]

//If redirected output contains escape sequences (color codes)
stdout_with_ansisequence: no

//Makes server output more silent by ommitting certain types of messages:
//1: Hide Information messages
//2: Hide Status messages
//4: Hide Notice Messages
//8: Hide Warning Messages
//16: Hide Error and SQL Error messages.
//32: Hide Debug Messages
//Example: "console_silent: 7" Hides information, status and notice messages (1+2+4)
console_silent: 0

// Console Commands
// Allow for console commands to be used on/off
// This prevents usage of >& log.file
console: off

// Type of server.
// No functional side effects at the moment.
// Displayed next to the server name in the client.
// 0=normal, 1=maintenance, 2=over 18, 3=paying, 4=P2P
char_maintenance: 0

// Enable or disable creation of new characters.
// Now it is actually supported [Kevin]
// Display (New) in the server list.
char_new_display: 0

// Maximum users able to connect to the server.
// Set to 0 to disable users to log-in. (-1 means unlimited)
max_connect_user: -1

// Group ID that is allowed to bypass the server limit of users.
// Default: -1 = nobody (there are no groups with ID < 0)
// See: conf/groups.conf
gm_allow_group: 99

// How often should the server save all files? (In seconds)
// Note: Applies to all data files on TXT servers.
// On SQL servers, it applies to guilds (character save interval is defined on the map config)
autosave_time: 60

// Display information on the console whenever characters/guilds/parties/pets are loaded/saved?
save_log: yes

// Starting point for new characters
// Format: <map_name>,<x>,<y>
start_point: new_1-1,53,111

// Starting items for new characters
// Max number of items is MAX_STARTITEM in char.c (default 32)
// Format: <id>,<amount>,<position>:<id>,<amount>,<position>:...
// To auto-equip an item, include the position where it will be equipped; otherwise, use zero.
start_items: 1201,1,2:2301,1,16

// Starting zeny for new characters
start_zeny: 0

// Size for the fame-lists
fame_list_taekwon: 10

// Guild earned exp modifier.
// Adjusts taxed exp before adding it to the guild's exp. For example, if set
// to 200, the guild receives double the player's taxed exp.
guild_exp_rate: 100

// Name used for unknown characters
unknown_char_name: Unknown

// To log the character server?
log_char: 1

// Allow or not identical name for characters but with a different case (upper/lower):
// example: Test-test-TEST-TesT; Value: 0 not allowed (default), 1 allowed
name_ignoring_case: no

// NOTE: Applies to character, party and guild names.
// 0: no restriction (default)
// 1: only letters/symbols in 'char_name_letters' option.
// 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.
char_name_option: 1

// Set the letters/symbols that you want use with the 'char_name_option' option.
// Note: Don't add spaces unless you mean to add 'space' to the list.
char_name_letters: abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890

// How many Characters are allowed per Account ? (0 = disabled)
// You can not exceed the limit of MAX_CHARS slots, defined in mmo.h
// Doing that, chars_per_account will be default to MAX_CHARS.
chars_per_account: 0

// Restrict character deletion by BaseLevel
// 0: no restriction (players can delete characters of any level)
// -X: you can't delete chars with BaseLevel <= X
// Y: you can't delete chars with BaseLevel >= Y
// e.g. char_del_level: 80 (players can't delete characters with 80+ BaseLevel)
char_del_level: 0

// Amount of time in seconds by which the character deletion is delayed.
// Default: 86400 (24 hours)
// NOTE: Requires client 2010-08-03aragexeRE or newer.
char_del_delay: 86400

// What folder the DB files are in (item_db.txt, etc.)
db_path: db

//===================================
// Pincode system
//===================================
// NOTE: Requires client 2011-03-09aragexeRE or newer.
// A window is opened before you can select your character and you will have to enter a pincode by using only your mouse.
// Default: yes
pincode_enabled: yes

// How often does a user have to change his pincode?
// 0: never (default)
// X: every X days
pincode_changetime: 0

// How often can a user enter the wrong pincode?
// Default: 3 (client maximum)
pincode_maxtry: 3

// Are users forced to use a pincode when the system is enabled?
// Default: yes
pincode_force: yes

//===================================
// Addon system
//===================================
// Character moving
// NOTE: Requires client 2011-09-28aragexeRE or newer.
// Allows users to move their characters between slots.
// Default: yes
char_move_enabled: yes

// Allow users to move a character to a used slot?
// If enabled the characters are exchanged.
// Default: yes
char_movetoused: yes

// Allow users to move characters as often as they like?
char_moves_unlimited: no

import: conf/import/char_conf.txt

 

thanks!

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi jasonjay,

Please only use your WAN IP for all your ip configurations in the conf files, do not use your LAN ip at all.

 

how about the the inter_athena.conf what ip will i use?

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi edward

 

I had changed my Lan ip to WAN and also had done a port forward. and here's the error that was generated when i started the ./athena-start

Athena Starting...
            (c) 2013 rAthena Project


checking...
Check complete.
Looks good, a nice Athena!
Logging is disable
./athena-start: line 49: .login-server.pid: Permission denied
Server 'login-server' started at 09-25-09:59-10
[Status]: Memory manager initialised: log/login-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/login_msg.conf.
[Info]: Finished reading conf/import/inter_conf.txt.
[Info]: Finished reading conf/inter_athena.conf.
[Info]: Finished reading conf/import/login_conf.txt.
[Info]: Finished reading conf/login_athena.conf.
./athena-start: line 49: .char-server.pid: Permission denied
Server 'char-server' started at 09-25-09:59-10
[Status]: Memory manager initialised: log/char-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Finished reading conf/msg_conf/char_msg.conf.
./athena-start: line 49: .map-server.pid: Permission denied
Server 'map-server' started at 09-25-09:59-10
Now Started Athena.
[[email protected] trunk]$ [Status]: Memory manager initialised: log/map-server.leaks


                   rAthena Development Team presents
                      ___   __  __
                _____/   | / /_/ /_  ___  ____  ____ _
               / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/
              / /  / ___ / /_/ / / /  __/ / / / /_/ /
             /_/  /_/  |_\__/_/ /_/\___/_/ /_/\__,_/

                     http://rathena.org/board/

[Info]: SVN Revision: '17498'
[Info]: Server supports up to '1024' concurrent connections.
[Info]: Char Server IP Address : '122.55.53.34' -> '122.55.53.34'.
[Info]: Map Server IP Address : '122.55.53.34' -> '122.55.53.34'.
[Status]: Using SQL dbs: no
[Info]: Logging item transactions to table 'picklog'.
[Info]: Logging commands to table 'atcommandlog'.
[Info]: Logging Cash transactions to table 'cashlog'.
[Info]: Connecting to the Map DB Server....
[Status]: connect success! (Map Server Connection)
[Info]: [SQL]: Connecting to the Log Database rathena4444_log At 122.55.53.34...
[Status]: Character server IP address : 122.55.53.34 -> 122.55.53.34
[Info]: Done reading conf/import/char_conf.txt.
[Info]: Done reading conf/char_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Done reading conf/import/inter_conf.txt.
[Info]: Done reading conf/inter_athena.conf.
[Info]: Connect Character DB server.... (Character Server)
[Status]: [SQL]: Successfully 'connected' to Database 'rathena4444_log'.
[Status]: Loading maps (using db/re/map_cache.dat as map cache)...
[Info]: Successfully loaded '862' maps.
[Info]: Finished reading conf/msg_conf/map_msg.conf.
[Status]: Done reading '63' command aliases in 'conf/atcommand_athena.conf'.
[Status]: Done reading '11' entries in 'db/re/instance_db.txt'.
[Status]: Done reading '4' channels in 'conf/channels.conf'.
[Status]: Done reading '911' entries in 'packet_db.txt'.
[Status]: Using default packet version: 30.
[Status]: Done reading '8236' entries in 're/item_db.txt'.
[Status]: Done reading '0' entries in 'item_db2.txt'.
[Status]: Done reading '218' entries in 'item_combo_db'.
[Status]: Done reading '1022' entries in 'db/re/item_bluebox.txt'.
[Status]: Done reading '923' entries in 'db/re/item_violetbox.txt'.
[Status]: Done reading '440' entries in 'db/re/item_cardalbum.txt'.
[Status]: Done reading '20' entries in 'db/item_findingore.txt'.
[Status]: Done reading '617' entries in 'db/re/item_giftbox.txt'.
[Status]: Done reading '1158' entries in 'db/re/item_misc.txt'.
[Status]: Done reading '0' entries in 'db/re/item_group_db.txt'.
[Status]: Done reading '1' entries in 'db/item_avail.txt'.
[Status]: Done reading '50' entries in 'db/re/item_noequip.txt'.
[Status]: Done reading '1818' entries in 'db/re/item_trade.txt'.
[Status]: Done reading '13' entries in 'db/item_delay.txt'.
[Status]: Done reading '10' entries in 'db/item_stack.txt'.
[Status]: Done reading '1057' entries in 'db/re/item_buyingstore.txt'.
[Status]: Done reading '124' entries in 'db/item_nouse.txt'.
[Status]: Done reading '0' entries in 're/item_cash_db.txt'.
[Status]: Done reading '0' entries in 'item_cash_db2.txt'.
[Status]: Done reading '1056' entries in 'db/re/skill_db.txt'.
[Status]: Done reading '826' entries in 'db/re/skill_require_db.txt'.
[Status]: Done reading '777' entries in 'db/re/skill_cast_db.txt'.
[Status]: Done reading '40' entries in 'db/re/skill_castnodex_db.txt'.
[Status]: Done reading '140' entries in 'db/re/skill_unit_db.txt'.
[Status]: Done reading '104' entries in 'db/re/skill_nocast_db.txt'.
[Status]: Done reading '263' entries in 'db/produce_db.txt'.
[Status]: Done reading '136' entries in 'db/create_arrow_db.txt'.
[Status]: Done reading '155' entries in 'db/abra_db.txt'.
[Status]: Done reading '17' entries in 'db/spellbook_db.txt'.
[Status]: Done reading '23' entries in 'db/magicmushroom_db.txt'.
[Status]: Done reading '133' entries in 'db/skill_reproduce_db.txt'.
[Status]: Done reading '25' entries in 'db/skill_improvise_db.txt'.
[Status]: Done reading '75' entries in 'db/skill_changematerial_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_item_ratio.txt'.
[Status]: Done reading '40' entries in 'db/mob_chat_db.txt'.
[Status]: Done reading '1316' entries in 'db/re/mob_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_db2.txt'.
[Status]: Done reading '7979' entries in 'db/re/mob_skill_db.txt'.
[Status]: Done reading '0' entries in 'db/mob_skill_db2.txt'.
[Status]: Done reading '0' entries in 'db/mob_avail.txt'.
[Status]: Done reading '480' entries in 're/mob_branch.txt'.
[Status]: Done reading '14' entries in 're/mob_poring.txt'.
[Status]: Done reading '47' entries in 're/mob_boss.txt'.
[Status]: Done reading '331' entries in 'mob_pouch.txt'.
[Status]: Done reading '25' entries in 'mob_classchange.txt'.
[Status]: Done reading '6' entries in 'db/re/mob_race2_db.txt'.
[Status]: Done reading '5169' entries in 'db/re/skill_tree.txt'.
[Status]: Done reading '35' entries in 'db/re/level_penalty.txt'.
[Status]: Done reading '160' entries in 're/statpoint.txt'.
[Status]: Done reading '133' entries in 'db/re/job_db1.txt'.
[Status]: Done reading '132' entries in 'db/job_db2.txt'.
[Status]: Done reading '53' entries in 'db/re/job_maxhpsp_db.txt'.
[Status]: Done reading '15' entries in 'db/re/job_exp.txt'.
[Status]: Done reading '1' entries in 'conf/motd.txt'.
[Status]: Done reading '7' groups in 'conf/groups.conf'.
[Status]: Done reading '4' entries in 'db/re/attr_fix.txt'.
[Status]: Done reading '3' entries in 'db/size_fix.txt'.
[Status]: Done reading '5' entries in 'db/re/refine_db.txt'.
[Status]: Done reading '34' entries in 'db/castle_db.txt'.
[Status]: Done reading '15' entries in 'db/guild_skill_tree.txt'.
[Status]: Done reading '58' pets in 'pet_db.txt'.
[Status]: Done reading '0' pets in 'pet_db2.txt'.
[Status]: Done reading '13' entries in 'db/re/homunculus_db.txt'.
[Status]: Done reading '150' levels in 're/exp_homun.txt'.
[Status]: Done reading '82' entries in 'db/homun_skill_tree.txt'.
[Status]: Done reading '61' entries in 'db/mercenary_db.txt'.
[Status]: Done reading '153' entries in 'db/mercenary_skill_db.txt'.
[Status]: Done reading '12' elementals in 'db/elemental_db.txt'.
[Status]: Done reading '36' entries in 'db/elemental_skill_db.txt'.
[Status]: Done reading '2669' entries in 'quest_db.txt'.
[Info]: Done loading '15500' NPCs:
        -'3466' Warps
        -'233' Shops
        -'11801' Scripts
        -'2989' Spawn sets
        -'47321' Mobs Cached
        -'0' Mobs Not Cached
[Status]: Event 'OnInit' executed with '1740' NPCs.
[Status]: Server is 'ready' and listening on port '5121'.

[Status]: Attempting to connect to Char Server. Please wait.
[Status]: Connecting to 122.55.53.34:6121
[Error]: make_connection: connect failed (socket #6, error 111: Connection refused)!
[Status]: Done reading '50' entries in 'db/re/exp_guild.txt'.
[Status]: Finished Reading GeoIP Database.
[Status]: Characters per Account: '9'.
[Status]: Defaulting to 10.10.11.70 as our IP address
[Status]: The char-server is ready (Server is listening on the port 6121).

[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Error]: make_connection: connect failed (socket #5, error 111: Connection refused)!
[Status]: The login-server is ready (Server is listening on the port 6900).

[Status]: Connecting to 122.55.53.34:6121
[Status]: Logging in to char server...
[Status]: Successfully logged on to Char Server (Connection: '6').
[Status]: Sending maps to char server...
[Status]: Event 'OnInterIfInit' executed with '0' NPCs.
[Status]: Event 'OnInterIfInitOnce' executed with '0' NPCs.
[Status]: Requested '34' guild castles from char-server...
[Status]: Map-Server 0 connected: 863 maps, from IP 122.55.53.34 port 5121.
[Status]: Map-server 0 loading complete.
[Info]: Loaded guild castle (0 - guild 0)
[Info]: Loaded guild castle (1 - guild 0)
[Info]: Loaded guild castle (2 - guild 0)
[Info]: Loaded guild castle (3 - guild 0)
[Info]: Loaded guild castle (4 - guild 0)
[Info]: Loaded guild castle (5 - guild 0)
[Info]: Loaded guild castle (6 - guild 0)
[Info]: Loaded guild castle (7 - guild 0)
[Info]: Loaded guild castle (8 - guild 0)
[Info]: Loaded guild castle (9 - guild 0)
[Info]: Loaded guild castle (10 - guild 0)
[Info]: Loaded guild castle (11 - guild 0)
[Info]: Loaded guild castle (12 - guild 0)
[Info]: Loaded guild castle (13 - guild 0)
[Info]: Loaded guild castle (14 - guild 0)
[Info]: Loaded guild castle (15 - guild 0)
[Info]: Loaded guild castle (16 - guild 0)
[Info]: Loaded guild castle (17 - guild 0)
[Info]: Loaded guild castle (18 - guild 0)
[Info]: Loaded guild castle (19 - guild 0)
[Info]: Loaded guild castle (20 - guild 0)
[Info]: Loaded guild castle (21 - guild 0)
[Info]: Loaded guild castle (22 - guild 0)
[Info]: Loaded guild castle (23 - guild 0)
[Info]: Loaded guild castle (24 - guild 0)
[Info]: Loaded guild castle (25 - guild 0)
[Info]: Loaded guild castle (26 - guild 0)
[Info]: Loaded guild castle (27 - guild 0)
[Info]: Loaded guild castle (28 - guild 0)
[Info]: Loaded guild castle (29 - guild 0)
[Info]: Loaded guild castle (30 - guild 0)
[Info]: Loaded guild castle (31 - guild 0)
[Info]: Loaded guild castle (32 - guild 0)
[Info]: Loaded guild castle (33 - guild 0)
[Status]: Map Server is now online.
[Info]: Received Fame List of '0' characters.
[Status]: Received '34' guild castles from char-server.
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Info]: Connection request of the char-server '' @ 122.55.53.34:6121 (account: 'rathena4444', pass: '4737648c6882178ea3020fe68502f268', ip: '10.10.11.70')
[Notice]: Invalid password (account: 'rathena4444', pass: 'rathena4444', received pass: '4737648c6882178ea3020fe68502f268', ip: 10.10.11.70)
[Notice]: Connection of the char-server '' REFUSED.
[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.

[Info]: Closed connection from '10.10.11.70'.
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 10.10.11.70:6900
[Info]: Connection request of the char-server '' @ 122.55.53.34:6121 (account: 'rathena4444', pass: '4737648c6882178ea3020fe68502f268', ip: '10.10.11.70')
[Notice]: Invalid password (account: 'rathena4444', pass: 'rathena4444', received pass: '4737648c6882178ea3020fe68502f268', ip: 10.10.11.70)
[Notice]: Connection of the char-server '' REFUSED.
[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.

Share this post


Link to post
Share on other sites
Posted (edited) · Hidden by Emistry, November 17, 2013 - Contents removed by Author.
Hidden by Emistry, November 17, 2013 - Contents removed by Author.

Don't feel like helping anymore; post is now removed.

Edited by Asura

Share this post


Link to post

Hi jasonjay,

 

Well, it should be obvious what the issue is... your server communication user/pass is incorrect.

 

i have checked my user/password its rathena4444/rathena4444. i can access mysql with this and also remotely.

here's my config

 

map_config

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

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

char_config

// Server Communication username and password.
userid: rathena4444
passwd: rathena4444

inter_config

sql.db_hostname: XXX.XX.XX.XX
sql.db_port: 3306
sql.db_username: rathena4444
sql.db_password: rathena4444
sql.db_database: rathena4444_rag
sql.codepage:

// MySQL Character SQL server
char_server_ip: XXX.XX.XX.XX
char_server_port: 3306
char_server_id: rathena4444
char_server_pw: rathena4444
char_server_db: rathena4444_rag

// MySQL Map SQL Server
map_server_ip: XXX.XX.XX.XX
map_server_port: 3306
map_server_id: rathena4444
map_server_pw: rathena4444
map_server_db: rathena4444_rag

// MySQL Log SQL Database
log_db_ip: XXX.XX.XX.XX
log_db_port: 3306
log_db_id: rathena4444
log_db_pw: rathena4444
log_db_db: rathena4444_log
log_codepage:
log_login_db: loginlog

mysql

[[email protected] ~]# mysql -u rathena4444 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| rathena4444_log    |
| rathena4444_rag    |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> use rathena4444_rag
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now