Jump to content
  • 0

logserv_sql issue

omimo

Asked by omimo,

 Share

Question

omimo Poring

omimo

Posted
  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  97
  • Reputation:   0
  • Joined:  03/03/12
  • Last Seen:  
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.
Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Brynner Metaling

Brynner

Posted
  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  
Posted

did you include the log on MySQL Administrator?

Link to comment
Share on other sites
Emistry Deviling

Emistry

Posted
  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2348
  • Joined:  10/28/11
  • Last Seen:  
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

Link to comment
Share on other sites
omimo Poring

omimo

Posted
  • Group:  Members
  • Topic Count:  32
  • Topics Per Day:  0.01
  • Content Count:  97
  • Reputation:   0
  • Joined:  03/03/12
  • Last Seen:  
  • Author
Posted (edited)

ok i see, thank you

Edited by omimo
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
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
×
×
  • Create New...