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
You can use this: supportmii.com/ro1/JudasBible.pdf