Changes

From SME Server
Jump to navigationJump to search

Mailstats (view source)

Revision as of 08:09, 14 April 2020

521 bytes removed ,  08:09, 14 April 2020
→‎Manual report generation
Line 8: Line 8:     
Read the original announcement here: http://forums.contribs.org/index.php?topic=40651.0
 
Read the original announcement here: http://forums.contribs.org/index.php?topic=40651.0
 +
 +
{{Note box| For GeoIP reporting you may need updated rpms and GeoIP plugin - please see bugs below and the GeoIP wiki page https://wiki.contribs.org/GeoIP}}
    
==Installation==
 
==Installation==
Line 64: Line 66:  
  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)
−
  −
==Logging to a MySQL database==
  −
In order to log your data to a MySQL database, you will need to create a database named 'mailstats'. 
  −
  −
There is a script to create the mailstats database held in Brian Read's contrib area, courtesy of Hartmut Trepkau.
  −
  −
http://mirror.contribs.org/smeserver/contribs//bread/mailstats/sql%20create/
  −
  −
You can use this to create the database and tables, and it will also set the configuration entry to enable the saving to the database.
  −
  −
Note that the create-mysql.sh script will delete any previous database (and the associated data) of the name "mailstats". 
  −
Also note the that script requires the tables.sql file in the same directory.
      
==Additional Notes==
 
==Additional Notes==
Line 96: Line 86:     
You can use the following command to generate a report
 
You can use the following command to generate a report
−
  perl /usr/bin/spamfilter-stats-7.pl /var/log/qpsmtpd/@* /var/log/qpsmtpd/current
+
  perl /usr/bin/mailstats.pl /var/log/qpsmtpd/@* /var/log/qpsmtpd/current
    
== Bug Reporting & Tracking ==
 
== Bug Reporting & Tracking ==
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/30536...38728"

Navigation menu