Changes

From SME Server
Jump to navigationJump to search

Email Statistics (view source)

Revision as of 14:45, 11 April 2008

4,635 bytes added ,  14:45, 11 April 2008
Add MySQL database information
Line 56: Line 56:  
  config setprop mailstats Base ("Midnight"|Midday"|"Now"|"##")
 
  config setprop mailstats Base ("Midnight"|Midday"|"Now"|"##")
 
Note: a number is interpreted as the hour of the day (0-23)
 
Note: a number is interpreted as the hour of the day (0-23)
 +
 +
In order to log your data to a MySQL database, you will need to create a database named 'mailstats'.  Here are the notes from spamfilter-stats-7.pl on what is required:
 +
<nowiki>#############################################################################
 +
#
 +
#  Table structure for MySQL table for saving data
 +
#
 +
# Database : `mailstats`
 +
#
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `ColumnStats`
 +
#
 +
#
 +
#CREATE TABLE `ColumnStats` (
 +
#  `ColumnStatsid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `timeid` int(11) NOT NULL default '0',
 +
#  `descr` varchar(20) NOT NULL default '',
 +
#  `count` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`ColumnStatsid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `JunkMailStats`
 +
#
 +
#CREATE TABLE `JunkMailStats` (
 +
#  `JunkMailstatsid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
# `user` varchar(12) NOT NULL default '',
 +
#  `count` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) default NULL,
 +
#  PRIMARY KEY  (`JunkMailstatsid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
#
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `SARules`
 +
#
 +
#CREATE TABLE `SARules` (
 +
#  `SARulesid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `rule` varchar(50) NOT NULL default '',
 +
#  `count` bigint(20) NOT NULL default '0',
 +
#  `totalhits` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`SARulesid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `SAscores`
 +
#
 +
#CREATE TABLE `SAscores` (
 +
#  `SAscoresid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `acceptedcount` bigint(20) NOT NULL default '0',
 +
#  `rejectedcount` bigint(20) NOT NULL default '0',
 +
#  `hamcount` bigint(20) NOT NULL default '0',
 +
#  `acceptedscore` decimal(20,2) NOT NULL default '0.00',
 +
#  `rejectedscore` decimal(20,2) NOT NULL default '0.00',
 +
#  `hamscore` decimal(20,2) NOT NULL default '0.00',
 +
#  `totalsmtp` bigint(20) NOT NULL default '0',
 +
#  `totalrecip` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`SAscoresid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `VirusStats`
 +
#
 +
#CREATE TABLE `VirusStats` (
 +
#  `VirusStatsid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `descr` varchar(40) NOT NULL default '',
 +
#  `count` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`VirusStatsid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
#
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `date`
 +
#
 +
#CREATE TABLE `date` (
 +
#  `dateid` int(11) NOT NULL auto_increment,
 +
#  `date` date NOT NULL default '0000-00-00',
 +
#  PRIMARY KEY  (`dateid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
#
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `domains`
 +
#
 +
#CREATE TABLE `domains` (
 +
#  `domainsid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `domain` varchar(40) NOT NULL default '',
 +
#  `type` varchar(10) NOT NULL default '',
 +
#  `total` bigint(20) NOT NULL default '0',
 +
#  `denied` bigint(20) NOT NULL default '0',
 +
#  `xfererr` bigint(20) NOT NULL default '0',
 +
#  `accept` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`domainsid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `qpsmtpdcodes`
 +
#
 +
#CREATE TABLE `qpsmtpdcodes` (
 +
#  `qpsmtpdcodesid` int(11) NOT NULL auto_increment,
 +
#  `dateid` int(11) NOT NULL default '0',
 +
#  `reason` varchar(40) NOT NULL default '',
 +
#  `count` bigint(20) NOT NULL default '0',
 +
#  `servername` varchar(30) NOT NULL default '',
 +
#  PRIMARY KEY  (`qpsmtpdcodesid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
# --------------------------------------------------------
 +
#
 +
# Table structure for table `time`
 +
#
 +
#CREATE TABLE `time` (
 +
#  `timeid` int(11) NOT NULL auto_increment,
 +
#  `time` time NOT NULL default '00:00:00',
 +
#  PRIMARY KEY  (`timeid`)
 +
#) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 +
#
 +
#############################################################################</nowiki>
    
=====Handling @*.u Logfiles=====
 
=====Handling @*.u Logfiles=====
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/9066"

Navigation menu