If you do large volumes of email, expect to have a table with millions upon millions of records, and slow access times :(
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
