Line 1: |
Line 1: |
| + | === Version === |
| + | {{ #smeversion: smeserver-mailstats}} |
| + | |
| ==Mailstats== | | ==Mailstats== |
| Brian Read's mailstats contrib analyzes your qpsmtpd log files and sends a periodic email to the address you specify summarizing your server's email activity. | | Brian Read's mailstats contrib analyzes your qpsmtpd log files and sends a periodic email to the address you specify summarizing your server's email activity. |
Line 5: |
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 61: |
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 93: |
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 == |