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.
