On Wed, April 4, 2007 11:06, Tom Sommer wrote: > On Tue, April 3, 2007 14:33, Mark Martinec wrote: > >> 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 >>
> But that doesn't work, just throws errors when mail comes in: > > > TROUBLE in process_request: sql exec: err=16, S1000, DBD::mysql::st > bind_param failed: Illegal parame Sorry, the full error message is: (!!)TROUBLE in process_request: sql exec: err=16, S1000, DBD::mysql::st bind_param failed: Illegal parameter number at (eval 51) line 160, <GEN7> line 20. Regards -- Tom ------------------------------------------------------------------------- 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/
