Amavis stats

[Savvas Karagiannidis]

Hi Nick,

you can use the SQL logging feature of amavis 
(https://www.ijs.si/software/amavisd/README.sql.txt)

You need to set the @storage_sql_dsn variable and have the proper 
database structure in mysql

When everything is working this way, you can get all the information you 
need by querying the database.

Regards,

Savvas Karagiannidis


On 3/2/2021 16:15, Nikolaos Milas wrote:
> Hello,
>
> Do you know of any external script (like pflogsumm) or built-in amavis 
> option(s) that will provide a daily stats report with info like:
>
> - Messages processed by amavis
>
> - No. of messages classified as clean/virus-infected/banned/spam
>
> - Top sending domains and servers in each of the above categories 
> (clean/virus-infected/banned/spam)
>
> - Top senders (mail addresses) in each of the above categories 
> (clean/virus-infected/banned/spam)
>
> - Issues / Errors during processing (e.g. bad communication with ClamAV)
>
> etc. ..??
>
> How do you extract amavis stats?
>
> I'll appreciate your feedback.
> Thanks in advance!
>
> Cheers,
> Nick
>