Tom, > Perhaps a common question, but I am interested in doing some logging on > e-mails which gets blocked due to SPAM or VIRUS. > > I am running amavis in a cluster behind a loadbalancer, so I need some > central point to collect these data. Preferably the simplest way would be > to insert a row into a MySQL database each time a BLOCK occurs, and I > could then use these data to generate some statistics.
Does existing SQL logging (tables: msgs, msgrcpt, maddr) not provide the information you need? For each message it stores a content type (Virus, Spam, ...), spam score, sender, recipients, timestamp, size, host name of the reporting amavisd, ... See README_FILES/README.sql Mark ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
