Stop logging message over sacore 20
Glenn Steen
glenn.steen at gmail.com
Fri Jul 3 10:09:34 IST 2009
2009/7/3 Mikael Syska <mikael at syska.dk>:
> Hi,
>
> We have a failrly large mailwatch db ... about 2 mill rows ... to
> speed things up we could delete mesaage with a sascore over 20. that
> could cut off 1.5 mill rows ... :-)
>
> using:
> SpamAssassin Rule Actions = SpamScore>20=>delete
>
> But what about mailwatch? Do I need to edit the MailWatch.pm file or
> can it be dont within MailScanner ?
>
> best regards
> Mikael Syska
Well, either edit MailWatch.pm or ... just do it after the fact with a
silly little SQL script. Should be easy enough (use the database
cleaning script as a template)... Then cron it to run every few
minutes. It'll only be the first run that would have a panfully long
run;-).
Cheers
--
-- Glenn
email: glenn < dot > steen < at > gmail < dot > com
work: glenn < dot > steen < at > ap1 < dot > se
More information about the MailScanner
mailing list