-
Posts
2 -
Joined
-
Last visited
Profile Information
-
Gender
Female
Haruka-404's Achievements
-
Hello Everyone, I hope someone can help me? Despite my configurations, rAthena is not recognizing the database credentials specified in conf/import/inter_conf.txt I have set up everything exactly as it was explained in every post or rAthena wiki. Nothing I do will change the response of my attempt to start athena. I am attempting to run Ragnarok from a GCE Linux based server, not locally. Please help. Please find below a copy of my exact setup/files, please advise if you require any other details that will help benefit troubleshooting this issue. Many thanks! - Haruka inter_conf.txt file: --------- use_sql_db: yes userid: ragnarok passwd: ragnarokpass hostname: 127.0.0.1 char_db: ragnarok log_db: log map_db: ragnarok inter_athena.conf file: --------- // 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 // Amount of status points a new character will start with start_status_points: 48 // Do we allow to change guild emblem during woe_time? emblem_woe_change: yes // How many transparent pixel can be found in emblem before detected as invalid? (Note 2) emblem_transparency_limit: 80 // 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 // MySQL Login server login_server_ip: 127.0.0.1 login_server_port: 3306 login_server_id: ragnarok login_server_pw: ragnarok login_server_db: ragnarok login_codepage: login_case_sensitive: no ipban_db_ip: 127.0.0.1 ipban_db_port: 3306 ipban_db_id: ragnarok ipban_db_pw: ragnarok ipban_db_db: ragnarok ipban_codepage: // MySQL Character server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: ragnarok char_server_pw: ragnarok char_server_db: ragnarok // MySQL Map Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: ragnarok map_server_pw: ragnarok map_server_db: ragnarok // MySQL Web Server web_server_ip: 127.0.0.1 web_server_port: 3306 web_server_id: ragnarok web_server_pw: ragnarok web_server_db: ragnarok // MySQL Log Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: ragnarok log_db_pw: ragnarok log_db_db: ragnarok 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 // Login Database Tables login_server_account_db: login ipban_table: ipbanlist global_acc_reg_num_table: global_acc_reg_num global_acc_reg_str_table: global_acc_reg_str // Char Database Tables char_db: char hotkey_db: hotkey scdata_db: sc_data cart_db: cart_inventory inventory_db: inventory charlog_db: charlog 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 mail_attachment_db: mail_attachments auction_db: auction quest_db: quest homunculus_db: homunculus skill_homunculus_db: skill_homunculus skillcooldown_homunculus_db: skillcooldown_homunculus mercenary_db: mercenary mercenary_owner_db: mercenary_owner skillcooldown_mercenary_db: skillcooldown_mercenary elemental_db: elemental skillcooldown_db: skillcooldown bonus_script_db: bonus_script acc_reg_num_table: acc_reg_num acc_reg_str_table: acc_reg_str char_reg_str_table: char_reg_str char_reg_num_table: char_reg_num clan_table: clan clan_alliance_table: clan_alliance // Map Database Tables barter_table: barter buyingstore_table: buyingstores buyingstore_items_table: buyingstore_items item_table: item_db renewal-item_table: item_db_re item2_table: item_db2 renewal-item2_table: item_db2_re mob_table: mob_db renewal-mob_table: mob_db_re mob2_table: mob_db2 renewal-mob2_table: mob_db2_re mob_skill_table: mob_skill_db renewal-mob_skill_table: mob_skill_db_re mob_skill2_table: mob_skill_db2 renewal-mob_skill2_table: mob_skill_db2_re mapreg_table: mapreg partybookings_table: party_bookings sales_table: sales vending_table: vendings vending_items_table: vending_items market_table: market roulette_table: db_roulette guild_storage_log: guild_storage_log // Web Database Tables // NOTE: The web server reads the login (login) and char (party,guild) tables and map (party_bookings), so it needs // the ability to connect to those databases. guild_emblems: guild_emblems user_configs: user_configs char_configs: char_configs merchant_configs: merchant_configs // Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no) use_sql_db: yes inter_server_conf: inter_server.yml import: conf/import/inter_conf.txt My DB: --------- MariaDB [ragnarok]> SHOW TABLES; +--------------------------+ | Tables_in_ragnarok | +--------------------------+ | acc_reg_num | | acc_reg_str | | achievement | | atcommandlog | | auction | | barter | | bonus_script | | branchlog | | buyingstore_items | | buyingstores | | cart_inventory | | cashlog | | char | | char_configs | | char_reg_num | | char_reg_str | | charlog | | chatlog | | clan | | clan_alliance | | db_roulette | | elemental | | feedinglog | | friends | | global_acc_reg_num | | global_acc_reg_str | | guild | | guild_alliance | | guild_castle | | guild_emblems | | guild_expulsion | | guild_member | | guild_position | | guild_skill | | guild_storage | | guild_storage_log | | homunculus | | hotkey | | interlog | | inventory | | ipbanlist | | login | | loginlog | | mail | | mail_attachments | | mapreg | | market | | memo | | mercenary | | mercenary_owner | | merchant_configs | | mob_db_re | | mvplog | | npclog | | party | | party_bookings | | pet | | picklog | | quest | | sales | | sc_data | | skill | | skill_homunculus | | skillcooldown | | skillcooldown_homunculus | | skillcooldown_mercenary | | storage | | user_configs | | vending_items | | vendings | | zenylog | +--------------------------+ And still all these errors: Info]: Connecting to the Login DB server..... [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok' [Info]: Done reading conf/inter_athena.conf. [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok' [Info]: Connect Character DB server.... (Character Server) [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with username = 'ragnarok', host = '127.0.0.1', port = '3306', database = 'ragnarok' Info]: Connecting to the Map DB Server.... [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'
-
Access denied for user Ragnarok@localhost
Haruka-404 replied to Gouki's question in Installation Support
I'm new to this, what does it mean exactly? I have this same issue Does it mean all these guides are out of date and we can no longer do this with rAthena? Despite my configurations, rAthena is not recognizing the database credentials specified in conf/import/inter_conf.txt I have set up everything EXACTLY as it was explained in literally either every post or rAthena wiki. Nothing I do fixes this.... inter_conf.txt file: --------- use_sql_db: yes userid: ragnarok passwd: ragnarokpass hostname: 127.0.0.1 char_db: ragnarok log_db: log map_db: ragnarok inter_athena.conf file: --------- // 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 // Amount of status points a new character will start with start_status_points: 48 // Do we allow to change guild emblem during woe_time? emblem_woe_change: yes // How many transparent pixel can be found in emblem before detected as invalid? (Note 2) emblem_transparency_limit: 80 // 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 // MySQL Login server login_server_ip: 127.0.0.1 login_server_port: 3306 login_server_id: ragnarok login_server_pw: ragnarok login_server_db: ragnarok login_codepage: login_case_sensitive: no ipban_db_ip: 127.0.0.1 ipban_db_port: 3306 ipban_db_id: ragnarok ipban_db_pw: ragnarok ipban_db_db: ragnarok ipban_codepage: // MySQL Character server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: ragnarok char_server_pw: ragnarok char_server_db: ragnarok // MySQL Map Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: ragnarok map_server_pw: ragnarok map_server_db: ragnarok // MySQL Web Server web_server_ip: 127.0.0.1 web_server_port: 3306 web_server_id: ragnarok web_server_pw: ragnarok web_server_db: ragnarok // MySQL Log Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: ragnarok log_db_pw: ragnarok log_db_db: ragnarok 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 // Login Database Tables login_server_account_db: login ipban_table: ipbanlist global_acc_reg_num_table: global_acc_reg_num global_acc_reg_str_table: global_acc_reg_str // Char Database Tables char_db: char hotkey_db: hotkey scdata_db: sc_data cart_db: cart_inventory inventory_db: inventory charlog_db: charlog 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 mail_attachment_db: mail_attachments auction_db: auction quest_db: quest homunculus_db: homunculus skill_homunculus_db: skill_homunculus skillcooldown_homunculus_db: skillcooldown_homunculus mercenary_db: mercenary mercenary_owner_db: mercenary_owner skillcooldown_mercenary_db: skillcooldown_mercenary elemental_db: elemental skillcooldown_db: skillcooldown bonus_script_db: bonus_script acc_reg_num_table: acc_reg_num acc_reg_str_table: acc_reg_str char_reg_str_table: char_reg_str char_reg_num_table: char_reg_num clan_table: clan clan_alliance_table: clan_alliance // Map Database Tables barter_table: barter buyingstore_table: buyingstores buyingstore_items_table: buyingstore_items item_table: item_db renewal-item_table: item_db_re item2_table: item_db2 renewal-item2_table: item_db2_re mob_table: mob_db renewal-mob_table: mob_db_re mob2_table: mob_db2 renewal-mob2_table: mob_db2_re mob_skill_table: mob_skill_db renewal-mob_skill_table: mob_skill_db_re mob_skill2_table: mob_skill_db2 renewal-mob_skill2_table: mob_skill_db2_re mapreg_table: mapreg partybookings_table: party_bookings sales_table: sales vending_table: vendings vending_items_table: vending_items market_table: market roulette_table: db_roulette guild_storage_log: guild_storage_log // Web Database Tables // NOTE: The web server reads the login (login) and char (party,guild) tables and map (party_bookings), so it needs // the ability to connect to those databases. guild_emblems: guild_emblems user_configs: user_configs char_configs: char_configs merchant_configs: merchant_configs // Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no) use_sql_db: yes inter_server_conf: inter_server.yml import: conf/import/inter_conf.txt My DB: --------- MariaDB [ragnarok]> SHOW TABLES; +--------------------------+ | Tables_in_ragnarok | +--------------------------+ | acc_reg_num | | acc_reg_str | | achievement | | atcommandlog | | auction | | barter | | bonus_script | | branchlog | | buyingstore_items | | buyingstores | | cart_inventory | | cashlog | | char | | char_configs | | char_reg_num | | char_reg_str | | charlog | | chatlog | | clan | | clan_alliance | | db_roulette | | elemental | | feedinglog | | friends | | global_acc_reg_num | | global_acc_reg_str | | guild | | guild_alliance | | guild_castle | | guild_emblems | | guild_expulsion | | guild_member | | guild_position | | guild_skill | | guild_storage | | guild_storage_log | | homunculus | | hotkey | | interlog | | inventory | | ipbanlist | | login | | loginlog | | mail | | mail_attachments | | mapreg | | market | | memo | | mercenary | | mercenary_owner | | merchant_configs | | mob_db_re | | mvplog | | npclog | | party | | party_bookings | | pet | | picklog | | quest | | sales | | sc_data | | skill | | skill_homunculus | | skillcooldown | | skillcooldown_homunculus | | skillcooldown_mercenary | | storage | | user_configs | | vending_items | | vendings | | zenylog | +--------------------------+ And still all these errors: Info]: Connecting to the Login DB server..... [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok' [Info]: Done reading conf/inter_athena.conf. [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok' [Info]: Connect Character DB server.... (Character Server) [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with username = 'ragnarok', host = '127.0.0.1', port = '3306', database = 'ragnarok' Info]: Connecting to the Map DB Server.... [SQL]: Access denied for user 'ragnarok'@'localhost' (using password: NO) [Error]: Couldn't connect with uname='ragnarok',host='127.0.0.1',port='3306',database='ragnarok'