jasonjay

Hi Edward, Please have patience with me, i am only a beginner and sorry if you have expected too much of me. i just learned all this when i tried doing it hope you could still answer my query. i really don't understand what you meant on this and you did not convert your passwords to MD5 within your MySQL database; deet deet deeee??? I didn't know that my response of "server communication user/pass is incorrect" had anything to do with client checksum

i did turned of the md5 in my login config // 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: off here's still the error. [rathena4444@chaos trunk]$ ./athena-start 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-13:57-15 [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-13:57-15 [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-13:57-15 Now Started Athena. [rathena4444@chaos 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) [ how about this? is this alright? / 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: XXX.XX.XX.XX 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 my XXX.XX.XX.XX is WAN ip.

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 [root@chaos ~]# 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>

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. [rathena4444@chaos 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.

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

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!

oops sorry i have edited it again thanks

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

Hi anyone, anyone can help please. thanks!

Hi Edward L. (COO), are there any work arounds that i can do? thanks for the help.

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?

had done these commands but i still got the same error. [rathena4444@chaos trunk]$ cd sql-files/ [rathena4444@chaos sql-files]$ mysql -u rathena4444 -p rathena4444_log < logs.sql Enter password: [rathena4444@chaos sql-files]$ [rathena4444@chaos sql-files]$ mysql -u rathena4444 -p rathena4444_rag < logs.sql Enter password: [rathena4444@chaos 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,

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: [root@chaos ~]# /etc/init.d/iptables status iptables: Firewall is not running. [root@chaos ~]# Where do i locate the logs.sql? Could you instruct me in doing this in CentOS?

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,

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, root@chaos ~]# 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?