Re: [AMaViS-user] Spam Tests in SQL

Stuart,

> I would like add to the amavisd-new SQL-storage in order to record the
> spam tests that a message hit. This would be so that I can track how
> often certain rules are hitting. Has anyone done this and would like to
> share their implementation?

Modify updating of msgs table in sub save_info_final:

# update message record with additional information
$conn_h->execute($sql_cl_r->{'upd_msg'},
$content_type, $quar_type, $q_to, $dsn_sent,
untaint($spam_level), untaint($m_id), untaint($from),
untaint($subj), $mail_id);

and the 'upd_msg' clause in %sql_clause, adding another field
to table msgs. The information you want to store is
kept in $msginfo->spam_status

Mark


_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/