Jump to content
  • 0

logserv_sql issue

omimo

Asked by omimo,

 Share

Question

omimo Poring

omimo

Posted
Posted (edited)

after i change the log_db_db: ragnarok to log_db_db: log it says this:

http://img829.images...65/68612118.png

sir these are the step i did for setting up mysql server:

1.new instance

>localhost

>username:ragnarok

>password:ragnarok

2.Query Database

>New schema>ragnarok

>New schema>log

>ragnarok schema>open script>main.sql

>log schema>open script>logs.sql

3.management security

>new account>login name: ragnarok>connectivity: 127.0.0.1>password: ragnarok

>new account>login name: logs>connectivity: 127.0.0.1>password: ragnarok

4.Schema Privilege

>ragnarok>selected port>selected schema: ragnarok>select all

>logs>selected port>selected schema: log>select all

my inter_athena.conf(didn't do anything here)


// 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: ragnarok
log_codepage:
log_login_db: loginlog

my logs.sql

#PickLog types (M)onsters Drop, (P)layers Drop/Take, Mobs Drop (L)oot Drop/Take,
# Players (T)rade Give/Take, Players (V)ending Sell/Take, (S)hop Sell/Take, (N)PC Give/Take,
# ©onsumable Items, (A)dministrators Create/Delete, Sto®age, (G)uild Storage,
# (E)mail attachment,(B)uying Store, Pr(O)duced Items/Ingredients, Auct(I)oned Items,
# (X) Other, (D) Stolen from mobs, (U) MVP Prizes

#Database: ragnarok
#Table: picklog
CREATE TABLE `picklog` (
 `id` int(11) NOT NULL auto_increment,
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `char_id` int(11) NOT NULL default '0',
 `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P',
 `nameid` int(11) NOT NULL default '0',
 `amount` int(11) NOT NULL default '1',
 `refine` tinyint(3) unsigned NOT NULL default '0',
 `card0` int(11) NOT NULL default '0',
 `card1` int(11) NOT NULL default '0',
 `card2` int(11) NOT NULL default '0',
 `card3` int(11) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`id`),
 INDEX (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators,(E)Mail,(B)uying Store
#Database: ragnarok
#Table: zenylog
CREATE TABLE `zenylog` (
 `id` int(11) NOT NULL auto_increment,
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `char_id` int(11) NOT NULL default '0',
 `src_id` int(11) NOT NULL default '0',
 `type` enum('M','T','V','S','N','A','E','B','I','D') NOT NULL default 'S',
 `amount` int(11) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`id`),
 INDEX (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok
#Table: branchlog
CREATE TABLE `branchlog` (
 `branch_id` mediumint(9) unsigned NOT NULL auto_increment,
 `branch_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) NOT NULL default '0',
 `char_id` int(11) NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`branch_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok
#Table: mvplog
CREATE TABLE `mvplog` (
 `mvp_id` mediumint(9) unsigned NOT NULL auto_increment,
 `mvp_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `kill_char_id` int(11) NOT NULL default '0',
 `monster_id` smallint(6) NOT NULL default '0',
 `prize` int(11) NOT NULL default '0',
 `mvpexp` mediumint(9) NOT NULL default '0',
 `map` varchar(11) NOT NULL default '',
 PRIMARY KEY  (`mvp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok
#Table: atcommandlog
CREATE TABLE `atcommandlog` (
 `atcommand_id` mediumint(9) unsigned NOT NULL auto_increment,
 `atcommand_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_id` int(11) unsigned NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 `command` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`atcommand_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok
#Table: npclog
CREATE TABLE `npclog` (
 `npc_id` mediumint(9) unsigned NOT NULL auto_increment,
 `npc_date` datetime NOT NULL default '0000-00-00 00:00:00',
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_id` int(11) unsigned NOT NULL default '0',
 `char_name` varchar(25) NOT NULL default '',
 `map` varchar(11) NOT NULL default '',
 `mes` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`npc_id`),
 INDEX (`account_id`),
 INDEX (`char_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#ChatLog types Gl(O)bal,(W)hisper,(P)arty,(G)uild,(M)ain chat
#Database: ragnarok
#Table: chatlog
CREATE TABLE `chatlog` (
 `id` bigint(20) NOT NULL auto_increment,
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `type` enum('O','W','P','G','M') NOT NULL default 'O',
 `type_id` int(11) NOT NULL default '0',
 `src_charid` int(11) NOT NULL default '0',
 `src_accountid` int(11) NOT NULL default '0',
 `src_map` varchar(11) NOT NULL default '',
 `src_map_x` smallint(4) NOT NULL default '0',
 `src_map_y` smallint(4) NOT NULL default '0',
 `dst_charname` varchar(25) NOT NULL default '',
 `message` varchar(150) NOT NULL default '',
 PRIMARY KEY  (`id`),
 INDEX (`src_accountid`),
 INDEX (`src_charid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#Database: ragnarok
#Table: loginlog
CREATE TABLE `loginlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL default '',
 `user` varchar(23) NOT NULL default '',
 `rcode` tinyint(4) NOT NULL default '0',
 `log` varchar(255) NOT NULL default '',
 INDEX (`ip`)
) ENGINE=MyISAM ;

every time i run the logserv_sql it always says this part (frustrated)

http://imageshack.us...51/37915219.png

i've tried everything X_x

did i do anything wrong to have an error in my logserv_sql console

Thank You

Edited by Emistry
Please use CODEBOX for Long Contents.

3 answers to this question

Recommended Posts

Emistry Deviling

Emistry

Posted
Posted

based on your image...

you didnt load ur log files... or maybe load in a wrong place....

log_db_db: ragnarok    <--------Should be ur Log Table.....
log_codepage:
log_login_db: loginlog

Join the conversation

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

Guest
Answer this question...

×   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 question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...