Question?

[Croud]

ung nka indicate na kulay pula na circle po sa picture... ok lang po ba yan? or may kulang po? pa help namn po... ang gamit ko po na svn ung rAThena-Server[16797]... d pa po ako nag sstart ng client modification tinitignan ko kng wlang error bago ako mag proceed sa client... 

[Brynner]

main lang ba ang nilagay mo sa database mo?kelangan mo din isama yung log.

[Croud]

nkagawa na po ako ng log schema then inopen ko na rin ung logs.sql sa SQL browser but still the same pa rin ang error... tinry ko ung dati kng SVN wla namn error d2 lang po sa bagong SVN meron... 

[Yoona]

Just follow this if, nothing happens just let me know

 

 

trunk/conf/Inter_athena.conf 

 

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: root    // < Mysql username

sql.db_password: password  // < Mysql password

sql.db_database: myragnarok  // Your Mysql main database ( Main.sql )

 

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: root    // < Mysql username

char_server_pw: password    // < Mysql password

char_server_db: myragnarok     // Your Mysql main database  ( Main.sql )

 

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: root      // < Mysql username

map_server_pw: password    // < Mysql password

map_server_db: myragnarok    // Your Mysql main database  ( Main.sql )

 

 

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: root    // < Mysql username

log_db_pw: password   // < Mysql Password

log_db_db: logs    // maybe you missconfig this by putting your main Database but it should be your log ( Change it to your log.sql )

Edited August 18, 2013 by Yoona

[Croud]

yoona - same error pa rin... ganun pa rin ang lumalabas...

Edited August 18, 2013 by Croud

[Yoona]

yoona - same error pa rin... ganun pa rin ang lumalabas...

 

 

Ohh, wait check your main.sql and open login table the user and password should be match with your conf char_athena.conf and map_athena.conf 

 

this one is for char_athena.conf

 

// Server Communication username and password.

userid: ragnarok                   // < very important thing ( depends on you what you want )

passwd: password              // < same a very important thing ( put a conflict password )

 

 

and this one is for map_athena.conf

 

// Interserver communication passwords, set in account.txt (or equiv.)

userid: ragnarok               // < put the userid same as what you put at char_athena.conf

passwd: password          // < the same as your password at char_athena.conf

 

 

 

 

Edited August 18, 2013 by Yoona

[Croud]

I already did that too... many times... still the same problem...

[Brynner]

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: mysqlid
log_db_pw: mysqlpassword
log_db_db: yourdatabase
log_codepage:
log_login_db: loginlog

just try this.

[Croud]

still the same error... 

[Magnetix]

I want to see your .../conf/inter_athena.conf or your .../conf/import/inter_conf.txt if you imported the settings.

Make sure main.sql and logs.sql were executed in the same database. This is the default settings.

Edited August 19, 2013 by Magnetix

[Croud]

there is my inter_athena.conf the inter athena.txt d ma upload kci wlang laman un... ung main.sql at logs.sql sineparate ko sa query browser ung main.sql sa ragnarok scheme ung logs.sql sa log scheme... nilagay ko rin ung username at password sa login tab sa ragnarok scheme ko... then mysql admin gumawa ako dun ng username both ragnarok and my own username na nilagay ko sa char.conf and map.conf pati privelege nila nilagay ko na... but still ganun pa rin ung lumalabas gnawa ko na lahat ng possible na paraan... tinry ko na rin dati kng svn ung galing sa eathena pa... wala namn error d2 lang... pero ayoko na nun kci outdated na... are there any new rathena svn na pde ma try? 

inter_athena.conf

[Tonetzkii]

my problema po sa loginlog database tables mo. try mo ulit import baka may na delete kang mga tables sa sql.

[Yoona]

what did you name when making the new schema for main.sql and log.sql ? 

 

so for example you create a new schema " rathena " then you execute the main.sql on it.

 

NOTE: rathena ( or your main.sql will be the database )

 

and now you do the same thing create a new schema " logs " with the log.sql on it.

 

NOTE: this will be your log tables

 

 

go to your inter_athena.conf 

 

 

sql.db_hostname: 127.0.0.1

sql.db_port: 3306

sql.db_username: ragnarok    <<<<<< change this with your Mysql username ( ex. root )

sql.db_password: ragnarok     <<<<<< your Mysql password

sql.db_database: ragnarok      <<<<<< THIS WILL BE THE DATABASE which is your " rathena "

sql.codepage:

 

// MySQL Character SQL server

char_server_ip: 127.0.0.1

char_server_port: 3306

char_server_id: ragnarok     <<<<<< do the same thing, Mysql username ( ex. root )

char_server_pw: ragnarok   <<<<<< your Mysql password again

char_server_db: ragnarok    <<<<<< again.. THIS WILL BE THE DATABASE which is your " rathena " 

 

// MySQL Map SQL Server

map_server_ip: 127.0.0.1

map_server_port: 3306

map_server_id: ragnarok     <<<<<< Mysql username again ( ex. root )

map_server_pw: ragnarok   <<<<<< your Mysql password again

map_server_db: ragnarok    <<<<<< also THIS WILL BE THE DATABASE which is your " rathena "

 

// MySQL Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok    <<<<<< Mysql username again ( ex. root )

log_db_pw: ragnarok  <<<<<< your Mysql password again

log_db_db: ragnarok   < This must be your problem, you should put the name of the schema of log ( Not the Main.sql schema ) it should be logs

log_codepage:

log_login_db: log 

 

 

 

i hope i explained it very well

[Croud]

my schema is ragnarok that is where my main.sql put and log is where logs.sql put also... i'll try your suggestion... i let you know if its okay or not...  

[Jayz]

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: ragnarok <-- change to log
log_codepage:
log_login_db: log
 

Like this

 

 

// MySQL Log SQL Database
log_db_ip: 127.0.0.1
log_db_port: 3306
log_db_id: ragnarok
log_db_pw: ragnarok
log_db_db: log
log_codepage:
log_login_db: log
 

 

after nyan gawa ka ng bagong schema ang lgy mong name is log tapos double click mo ung log schema hangang sa maging bold font sya. Tapos upper left click File then open new script tpos open mo ung rA/sql-files/logs.sql tpos execute mo

[Croud]

still got some error... i try to find the error the best as i can... but failed...  

[Magnetix]

If you're still having this issue, I suggest you drop your database. recreate everything and then both main.sql and logs.sql should be imported on the same database or schema if you will.

[Tonetzkii]

If you're still having this issue, I suggest you drop your database. recreate everything and then both main.sql and logs.sql should be imported on the same database or schema if you will.

Parang yan narin ung sinabi ko sa kanya pero parang di nya pinansin.

[Croud]

fixed* pinalitan ko ung inter_athena.conf ko... with this... wla na error...  

 

 

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

 

 

// TXT version options only

 

// Storage flatfile database, used for Karfa storage.

storage_txt: save/storage.txt

 

// Party flatfile database, for party names, members and other party info.

party_txt: save/party.txt

 

// Hotkeys flatfile database, where character skill shortcuts are stored.

hotkeys_txt: save/hotkeys.txt

 

// Guild flatfile database, for guild names, members, and other guild info.

guild_txt: save/guild.txt

 

// Pet flatfile database, for pet names, and other pet info.

pet_txt: save/pet.txt

 

// Homunculus flatfile database, for homunculus information.

homun_txt: save/homun.txt

 

// Castle flatfile database, for emperium war castles, etc.

castle_txt: save/castle.txt

 

// Status change flatfile database, for status changes that are saved between sessions.

scdata_txt: save/scdata.txt

 

// Mapserver permanent script variables ($-type)

mapreg_txt: save/mapreg.txt

 

 

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

sql.db_port: 3306

sql.db_username: ragnarok

sql.db_password: ragnarok

sql.db_database: ragnarok

sql.codepage:

 

// MySQL Character SQL 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 SQL 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 Log SQL Database

log_db_ip: 127.0.0.1

log_db_port: 3306

log_db_id: ragnarok

log_db_pw: ragnarok

log_db_db: log

log_codepage:

 

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

loginlog_db: loginlog

 

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

 

// Map Database Tables

item_db_db: item_db

item_db2_db: item_db2

mob_db_db: mob_db

mob_db2_db: mob_db2

mapreg_db: mapreg

 

//Use SQL item_db and mob_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