ISPConfig, AWStats & Postfix: Email statistics 0
Very good source that I did not use: http://www.howtoforge.com/mail_statistics_mailgraph_pflogsumm
I setup AWStats package on my server using instructions on this DjTremors site.
And everything worked, besides the fact that I must disable suexec in ISPConfig (Management / Server - Settings / Web / suexec Checkbox).
At first, I tried adding this statistics inside a ISPConfig’s http server. Just to remember, whenever I need something to be an option in ISPConfig, under the Tools menu. This is done by creating a subdirectory in /home/admispconfig/ispconfig/web/tools/tools, and creating a nav.inc.php file there
But the problem arises because Perl can not be enabled without larger modifications in a /root/ispconfig/httpd/conf/httpd.conf. I always got an error
mod_perl.so: undefined symbol: apr_bucket_shared_split
So I made a Tools link, but pointing to a main Apache server (where I have Perl enabled).
File: nav.inc.php
<? if($go_api->auth->check_admin(0,1)) {
/*
Only Admin can see this
Copyright (c) 2008, cvladan.com, Vladan Colovic - All rights reserved.
*/
?>
<!-- Mail AWStats for all domains //-->
menuDaten.neu(new LinkEintrag('root','<? echo $go_api->lng("Mail Server Statistics")?>','http://www.duplonucleo.com/ispcstats/awstats.pl?config=mail','_blank','email.gif','Ma
il Server Stats','n',''));
<? } ?>
Let me explain important files in AWStats for ISPConfig. There is /root/ispconfig/scripts/shell/awstats.php file that periodically recreates .conf files in /etc/awstats, based on virtual domains created in web home /var/www. There is no need to change this file. Another important file is/home/admispconfig/ispconfig/web/ispc.awstats/awstats_updateall.pl which is executed periodically too. This file launches update process for all AWStats config files, except awstats.model.conf found in a particular directory (in our case /etc/awstats), so you can easily setup.
As we see, there is no need to change anything. It will automaticly update our mail statistics. So, lets go there…
First, I needed to add a script maillogconvert.pl where it sould be in a first place - in: /home/admispconfig/ispconfig/web/ispc.awstats
Then edit the /etc/awstats/awstats.mail.conf and … Not so good link, and much better (original).
And do not be shooked with the amount of mails recieved by admispconfig@. Thats ok. The admispconfig mailbox is a script that generates your mail statistics. The emails that go to admispconfig contain the size of the original email sent to one of your users in bytes.
And, after everything, I just updated AWStats from 6.5 to version 6.8 (latest one)