Configure Awstats for Qmail Log

You may have Qmail statistic before read this article. I don't know what you have is better or similar with this one, Awstats Qmail log analyzer. But if you have time you may try this one.

To create Awstats to analyze Qmail Log you have to prepare :

1. Log repository, put on crontab and will grep qmail log every 10 minutes. May this not accurate because the log can be duplicate but you can sort this for unique row. Place this log at /var/log/awstats.qmail
   
   [getlog.sh]
   #!/bin/sh
   

   #!/bin/sh
   cat /var/log/qmail/qmail-pop3d/current > /var/log/awstats.qmail
   cat /var/log/qmail/qmail-send/current >> /var/log/awstats.qmail
   cat /var/log/qmail/qmail-smtpd/current >> /var/log/awstats.qmail
   

   
   


2. Awstats, download this cute statistics from http://awstats.sourceforge.net/
3. Get the script tools that will be used for at ../path/to/awstats/tools. You only need maillogconvert.pl script.
   
4. Create the small program from Phil Hagen named "qmail2awstats.pl" and
   [qmail2awstats.pl]
   

   #!/usr/bin/perl
   # written by phil hagen on 27sep03
   
   while (<>) {
   @months = ('NUL', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); $hostname = `hostname`;
   # $hostname = `hostname -s`;
   chomp $hostname;
   $line = $_;
   $line =~ s/\d{4}-(\d{2})-(\d{2}) (\d{2}:\d{2}:\d{2}).\d{9} (.*)/$months[$1] $2 $3 $hostname qmail: 0000000000.000000 $4/; print $line;
   }
   

   
   
5. Edit the Awstats configuration that placed or may have to create at /etc/awstats/awstats.mail.conf that called only short name "mail" later in awstats command.
   
   [/etc/awstats/awstats.mail.conf]
   

   LogFile="/usr/local/bin/tai64nlocal < /var/log/awstats.qmail |\
   /var/www/htdocs/awstats/tools/qmail2awstats.pl | \
   /var/www/htdocs/awstats/tools/maillogconvert.pl standard | "
   
   SiteDomain="mail.mydomain.com"
   HostAliases="mail.mydomain.com"
   DirData="/data/awstats"
   DirCgi="/awstats"
   DirIcons="/awstatsicons"
   AllowToUpdateStatsFromBrowser=0
   AllowFullYearView=2
   LogType=M
   LogFormat="%time2 %email %email_r %host %host_r %method %url %code %bytesd"
   LevelForBrowsersDetection=0
   LevelForOSDetection=0
   LevelForRefererAnalyze=0
   LevelForRobotsDetection=0
   LevelForWormsDetection=0
   LevelForSearchEnginesDetection=0
   LevelForFileTypesDetection=0
   ShowMenu=1
   ShowSummary=HB
   ShowMonthStats=HB
   ShowDaysOfMonthStats=HB
   ShowDaysOfWeekStats=HB
   ShowHoursStats=HB
   ShowDomainsStats=0
   ShowHostsStats=HBL
   ShowAuthenticatedUsers=0
   ShowRobotsStats=0
   ShowEMailSenders=HBML
   ShowEMailReceivers=HBML
   ShowSessionsStats=0
   ShowPagesStats=0
   ShowFileTypesStats=0
   ShowFileSizesStats=0
   ShowBrowsersStats=0
   ShowOSStats=0
   ShowOriginStats=0
   ShowKeyphrasesStats=0
   ShowKeywordsStats=0
   ShowMiscStats=0
   ShowHTTPErrorsStats=0
   ShowSMTPErrorsStats=1
   
   Why the awstats configuration must be at /etc/awstats ? Here is the DOC:
   
   # AWSTATS CONFIGURE FILE 6.6
   #-----------------------------------------------------------------------------
   # Copy this file into awstats.www.mydomain.conf and edit this new config file
   # to setup AWStats (See documentation in docs/ directory).
   # The config file must be in /etc/awstats, /usr/local/etc/awstats or /etc (for
   # Unix/Linux) or same directory than awstats.pl (Windows, Mac, Unix/Linux...)
   # To include an environment variable in any parameter (AWStats will replace
   # it with its value when reading it), follow the example:
   # Parameter="__ENVNAME__"
   # Note that environment variable AWSTATS_CURRENT_CONFIG is always defined with
   # the config value in an AWStats running session and can be used like others.
   #-----------------------------------------------------------------------------
   

   
   
   
6. Create directory to save the log data
   # mkdir -p /data/awstats
   
   
7. Add and change the cgi alias on apache, the configuration is :
   

   ScriptAlias /cgi-bin/ "/var/www/cgi-bin/"
   
   <Directory "/var/www/cgi-bin">
     AllowOverride None
     Options None
     Order allow,deny
     Allow from all
   </Directory>
   
   Alias /awstatsclasses "/var/www/htdocs/awstats/wwwroot/classes/"
   Alias /awstatscss "/var/www/htdocs/awstats/wwwroot/css/"
   Alias /awstatsicons "/var/www/htdocs/awstats/wwwroot/icon/"
   ScriptAlias /awstats/ "/var/www/htdocs/awstats/wwwroot/cgi-bin/"
   
   <Directory "/var/www/htdocs/awstats/wwwroot">
     Options None
     AllowOverride None
     Order allow,deny
     Allow from all
   </Directory>
   

   
   Restart apache.
   
8. Create and or add in crontab :
   

   #Awstats mail statistics
   */10 * * * * /var/www/htdocs/awstats/tools/getlog.sh
   */15 * * * * /var/www/htdocs/awstats/wwwroot/cgi-bin/awstats.pl -update -config=mail > /dev/null
   

   
   
9. Run at your browser to access your mail statistics :
   http://www.mydomain.com/awstats/awstats.pl?config=mail
   
   
10. Done.