Achhandrian Posted August 31, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 51 Reputation: 2 Joined: 07/31/12 Last Seen: September 23, 2020 Share Posted August 31, 2012 (edited) Das ist der Inhalt meiner inter_athena.conf // Athena InterServer configuration. // 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: 50 // 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 // overriden by local settings when the hostname is defined there // (currently only the login-server reads/obeys these settings) sql.db_hostname: new-legends-ro.de sql.db_port: 3306 sql.db_username: newlegendsro sql.db_password: ### sql.db_database: newlegendsro sql.codepage: // MySQL Character SQL server char_server_ip: new-legends-ro.de char_server_port: 3306 sql.db_username: newlegendsro sql.db_password: ### sql.db_database: newlegendsro // MySQL Map SQL Server map_server_ip: new-legends-ro.de map_server_port: 3306 sql.db_username: newlegendsro sql.db_password: ### sql.db_database: newlegendsro // MySQL Log SQL Database log_db_ip: new-legends-ro.de log_db_port: 3306 sql.db_username: newlegendsro sql.db_password: ### sql.db_database: newlegendsro log_codepage: log_login_db: loginlog // 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 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 use_sql_db: no // Nick for sending mainchat // messages like whisper main_chat_nick: Main import: conf/import/inter_conf.txt Und das das Ergebnis beim starten: Athena Starting... © 2003 Athena Project modified by [email protected] checking... Check complete. Looks good, a nice Athena! Now Started Athena. [newlegendsro@s15402499 server]$ [status]: Memory manager initialised: log/login-server_sql.leaks rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [info]: SVN Revision: '16724'. [status]: Memory manager initialised: log/char-server_sql.leaks rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [info]: SVN Revision: '16724'. [status]: Memory manager initialised: log/map-server_sql.leaks rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [info]: SVN Revision: '16724'. [info]: Server supports up to '1024' concurrent connections. [info]: Reading configuration file conf/login_athena.conf... [status]: set login_port : 6900 [info]: Console Silent Setting: 0 [info]: Reading configuration file conf/inter_athena.conf... [info]: Reading configuration file conf/import/inter_conf.txt... [info]: Finished reading conf/import/inter_conf.txt. [info]: Finished reading conf/inter_athena.conf. [info]: Reading configuration file conf/import/login_conf.txt... [info]: Finished reading conf/import/login_conf.txt. [info]: Finished reading conf/login_athena.conf. [info]: Reading the configuration file conf/subnet_athena.conf... [status]: Read information about 1 subnetworks. [info]: Initializing random number generator. [info]: Server supports up to '1024' concurrent connections. [info]: Server supports up to '1024' concurrent connections. [info]: Initializing random number generator. [Warning]: Unknown setting 'login_ip' in file conf/map_athena.conf [Warning]: Unknown setting 'login_ip' in file conf/map_athena.conf [info]: Console Silent Setting: 0 [info]: Reading configuration file conf/char_athena.conf... [status]: New-Legends-Ragnarok-Online server has been initialized [status]: Login server IP address : 127.0.0.1 -> 127.0.0.1 [info]: Console Silent Setting: 0 [info]: Reading configuration file conf/import/char_conf.txt... [status]: New-Legends-Ragnarok-Online server has been initialized [info]: Done reading conf/import/char_conf.txt. [info]: Done reading conf/char_athena.conf. [info]: Reading the configuration file conf/subnet_athena.conf... [status]: Read information about 1 subnetworks. [info]: Reading file conf/inter_athena.conf... [info]: Reading file conf/import/inter_conf.txt... [Warning]: Unknown setting 'login_ip' in file conf/import/map_conf.txt [info]: Done reading conf/import/inter_conf.txt. [Warning]: Unknown setting 'login_ip' in file conf/import/map_conf.txt [info]: Done reading conf/inter_athena.conf. [info]: Finished reading the char-server configuration. [info]: interserver initialize... [info]: reading file conf/inter_athena.conf... [status]: set char_server_ip : new-legends-ro.de [status]: set char_server_port : 3306 [info]: reading file conf/import/inter_conf.txt... [status]: set char_server_ip : new-legends-ro.de [status]: set char_server_port : 3306 [info]: done reading conf/import/inter_conf.txt. [info]: done reading conf/inter_athena.conf. [info]: Connect Character DB server.... (Character Server) : Access denied for user 'newlegendsro'@'s15402499.onlinehome-server.info' (using password: NO)[/color][Debug]: at loginlog_sql.c:110[Warning]: Not all IP addresses in map_athena.conf configured, autodetecting...[info]: Defaulting to 87.106.37.153 as our IP address[info]: Map Server IP Address : '87.106.37.153' -> '87.106.37.153'.[info]: Char Server IP Address : '87.106.37.153' -> '87.106.37.153'.[color=#ff0000][sql]: Access denied for user 'ragnarok'@'%' to database 'ragnarok'[/color][Debug]: at inter.c:778[status]: Using SQL dbs: no[info]: Logging item transactions to table 'picklog'.[info]: Logging commands to table 'atcommandlog'.[info]: Connecting to the Map DB Server....[color=#ff0000][sql]: Access denied for user 'ragnarok'@'%' to database 'ragnarok'[/color]Ich habe mittlerweile um zu testen den user ragnarok mit den richtigen rechten erstelle für mysql klappt auch nicht, er versucht halt auf teufel komm raus auf die standarteinstellungen zu connecten die schlichtweg nicht existent sind und nicht in der inter_athena.conf drinstehen, kann mir wer sagen wieso ? bzw beim ersten mal fehler versucht er ja sogar mit dem user mit dem ich putty offen habe auf mysql zu connecten aber ohne passwort, ich verstehs grade echt nicht....EDIT:Habe grade mal Testweise versucht alle DBs, User und PW ragnarok zu nennen......klappt trotzdem nicht selber fehler....... Athena Starting... © 2003 Athena Project modified by [email protected] checking... Check complete. Looks good, a nice Athena! Now Started Athena. [ragnarok@s15402499 server]$ [status]: Memory manager initialised: log/login-server_sql.leaks rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [info]: SVN Revision: '16726'. [status]: Memory manager initialised: log/char-server_sql.leaks rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [status]: Memory manager initialised: log/map-server_sql.leaks [info]: SVN Revision: '16726'. rAthena Development Team presents ___ __ __ _____/ | / /_/ /_ ___ ____ ____ _ / ___/ /| |/ __/ __ \/ _ \/ __ \/ __ `/ / / / ___ / /_/ / / / __/ / / / /_/ / /_/ /_/ |_\__/_/ /_/\___/_/ /_/\__,_/ http://rathena.org/board/ [info]: SVN Revision: '16726'. [info]: Server supports up to '1024' concurrent connections. [info]: Reading configuration file conf/login_athena.conf... [status]: set login_port : 6900 [info]: Console Silent Setting: 0 [info]: Reading configuration file conf/inter_athena.conf... [info]: Reading configuration file conf/import/inter_conf.txt... [info]: Finished reading conf/import/inter_conf.txt. [info]: Finished reading conf/inter_athena.conf. [info]: Reading configuration file conf/import/login_conf.txt... [info]: Finished reading conf/import/login_conf.txt. [info]: Finished reading conf/login_athena.conf. [info]: Reading the configuration file conf/subnet_athena.conf... [status]: Read information about 1 subnetworks. [info]: Initializing random number generator. [info]: Server supports up to '1024' concurrent connections. [info]: Server supports up to '1024' concurrent connections. [info]: Initializing random number generator. [info]: Reading configuration file conf/char_athena.conf... [status]: New-Legends-Ragnarok-Online server has been initialized [info]: Char Server IP Address : 'new-legends-ro.de' -> '87.106.37.153'. [status]: Login server IP address : new-legends-ro.de -> 87.106.37.153 [info]: Map Server IP Address : 'new-legends-ro.de' -> '87.106.37.153'. [info]: Console Silent Setting: 0 [status]: Character server IP address : new-legends-ro.de -> 87.106.37.153 [info]: Console Silent Setting: 0 [info]: Reading configuration file conf/import/char_conf.txt... [info]: Done reading conf/import/char_conf.txt. [info]: Done reading conf/char_athena.conf. [info]: Reading the configuration file conf/subnet_athena.conf... [status]: Read information about 1 subnetworks. [info]: Reading file conf/inter_athena.conf... [info]: Reading file conf/import/inter_conf.txt... [info]: Done reading conf/import/inter_conf.txt. [info]: Done reading conf/inter_athena.conf. [info]: Finished reading the char-server configuration. [info]: interserver initialize... [info]: reading file conf/inter_athena.conf... [status]: set char_server_ip : 127.0.0.1 [status]: set char_server_port : 3306 [status]: set char_server_id : ragnarok [status]: set char_server_pw : ragnarok [status]: set char_server_db : ragnarok [info]: reading file conf/import/inter_conf.txt... [info]: done reading conf/import/inter_conf.txt. [info]: done reading conf/inter_athena.conf. [info]: Connect Character DB server.... (Character Server) [color=#ff0000][sql]: Access denied for user 'ragnarok'@'localhost' to database 'ragnarok'[/color] [Debug]: at loginlog_sql.c:110 [color=#ff0000][sql]: Access denied for user 'ragnarok'@'localhost' to database 'ragnarok'[/color] [Debug]: at inter.c:778 [status]: Using SQL dbs: no [info]: Logging item transactions to table 'picklog'. [info]: Logging commands to table 'atcommandlog'. [info]: Connecting to the Map DB Server.... [color=#ff0000][sql]: Access denied for user 'ragnarok'@'localhost' to database 'ragnarok'[/color] Edited September 1, 2012 by Achhandrian Quote Link to comment Share on other sites More sharing options...
tr0n Posted September 1, 2012 Group: Members Topic Count: 28 Topics Per Day: 0.01 Content Count: 562 Reputation: 153 Joined: 02/21/12 Last Seen: February 27, 2024 Share Posted September 1, 2012 hast du was vllt. in den Import ordner geschrieben und das wird nun überschrieben dauernd ? Ist mir auch mal passiert. Quote Link to comment Share on other sites More sharing options...
Achhandrian Posted September 1, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 51 Reputation: 2 Joined: 07/31/12 Last Seen: September 23, 2020 Author Share Posted September 1, 2012 Ich habe es sowohl versucht alles in den Import Ordner zu schreiben als auch mit meinem leeren Import Ordner alles zu starten Quote Link to comment Share on other sites More sharing options...
Rynbef Posted September 1, 2012 Group: Forum Moderator Topic Count: 48 Topics Per Day: 0.01 Content Count: 941 Reputation: 125 Joined: 05/23/12 Last Seen: Yesterday at 06:19 AM Share Posted September 1, 2012 Wenn MySQL sowie die DB auf dem Server ist, wo du auch rAthena drauf hast, musst du statt sql.db_hostname: new-legends-ro.de das sql.db_hostname: 127.0.0.1 angeben. Bei mir lag es schon mal daran. Ansonsten sagt mir die Fehler Meldung, das der Server nicht zu MySQL Connecten kann bzw. Anmeldung Fehlgeschlagen, d.h. du müsstest nochmal die Daten überprüfen. Ansonsten würde ich dir noch empfehlen DB Name und User Name nicht gleich zunennen. Gruß Rynbef Quote Link to comment Share on other sites More sharing options...
bimbi Posted October 6, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 59 Reputation: 1 Joined: 01/15/12 Last Seen: April 19, 2017 Share Posted October 6, 2012 falls du ein server passtwort festgelegt hast, solltest du das mal mit dem ersten eintrag in der login db vergleichen Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.