Jump to content
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×

Server scheint inter_athena.conf nicht zu lesen.

Achhandrian

By Achhandrian
in rAthena-Server

 Share

Recommended Posts

Achhandrian Poring

Achhandrian

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   2
  • Joined:  07/31/12
  • Last Seen:  
Posted (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 by Achhandrian
Link to comment
Share on other sites
tr0n Eggring

tr0n

Posted
  • Group:  Members
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  562
  • Reputation:   153
  • Joined:  02/21/12
  • Last Seen:  
Posted

hast du was vllt. in den Import ordner geschrieben und das wird nun überschrieben dauernd ?

Ist mir auch mal passiert.

Link to comment
Share on other sites
Achhandrian Poring

Achhandrian

Posted
  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  51
  • Reputation:   2
  • Joined:  07/31/12
  • Last Seen:  
  • Author
Posted

Ich habe es sowohl versucht alles in den Import Ordner zu schreiben als auch mit meinem leeren Import Ordner alles zu starten

Link to comment
Share on other sites
Rynbef Ghostring

Rynbef

Posted
  • Group:  Forum Moderator
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  948
  • Reputation:   125
  • Joined:  05/23/12
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
  • 1 month later...
bimbi Poring

bimbi

Posted
  • Group:  Members
  • Topic Count:  17
  • Topics Per Day:  0.00
  • Content Count:  59
  • Reputation:   1
  • Joined:  01/15/12
  • Last Seen:  
Posted

falls du ein server passtwort festgelegt hast, solltest du das mal mit dem ersten eintrag in der login db vergleichen

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...