If you do large volumes of email, expect to have a table with millions
upon
millions of records, and slow access times :(
The altered script I'm using outputs spam/ham total summaries for each user,
and spam/ham message hits for each rule. In a properly built database, that
shouldn't be too terribly difficult to maintain, and I wouldn't think you'd
need to retain history for very long.
On 12/15/05 12:48 PM, "Mike Jackson" <[EMAIL PROTECTED]> wrote:
I have been trying to find a script which would allow me to copy data
from spamd logfile to MySQL database. It would be usefull, since then I
could provide datailed statistics to my users.
Does anybody know a way to do it or I will just have to write a small
script myself? Has anyone probably done it before? Any tips?
There's competing scripts out there named sa-stats.pl (one's included in
the
contrib directory with the SA distribution, the other's listed in
Freshmeat
as "SpamAssassin logfile analyser"). While neither one does exactly what
you
want, it should be trivial to hack them to save to SQL rather than
outputting as text.
If you're interested, I've made modifications to David Ramsden's script
that
also outputs stats on the rules, not just user statistics.
--
Matthew Yette
Senior Engineer (NOC/Operations)
M.A. Polce Consulting
315-838-1644
