Hello, I have several Postfix+Amavisd-new+MySQL mail gateways. I have configured syslog service on that machines to send logs to a centralized syslog server, which stores received logs on mysql DBMS.
BTW, I lookup the logs using Php-Syslog-NG. Anyway, logs on each machine are stored also as usual (into files, /var/log/mail and so on). >From '/var/log/mail' I also tell to 'pflogsumm' to compute mail gateway statistics. Now, I would like to switch off logging into files and to do so I need to get statistics from log stored into mysql. Could someone suggest me an utility to do so? Or, better, point me if there already exists an hacked version of 'pflogsumm' that does so? TIA, rocsca