You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@bugzilla.spamassassin.org on 2014/03/06 18:04:36 UTC
[Bug 7021] TxRep - suggested replacement of
Mail::SpamAssassin::Plugin::AWL
https://issues.apache.org/SpamAssassin/show_bug.cgi?id=7021
Kevin A. McGrail <km...@pccc.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kmcgrail@pccc.com
--- Comment #1 from Kevin A. McGrail <km...@pccc.com> ---
Some notes on files from the list:
http://truxoft.com/resources/CHANGELOG
http://truxoft.com/resources/txrep.htm
http://truxoft.com/resources/TxRep.pm
Plug looks like it covers some of the open tickets for history / AWL but needs
more cross checking like Bug 3082, Bug 6908, Bug 4239, bug 4508, bug 6121, and
bug 6357
I also do this currently thanks to Kris Deugau:
add a column:
alter table awl add column `lastupdate` timestamp NOT NULL default
CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
mysql spamassassin -e 'DELETE FROM awl WHERE lastupdate <= DATE_SUB(SYSDATE(),
INTERVAL 2 WEEK);'
Add this to cron:
DELETE FROM awl WHERE lastupdate <= (now() - INTERVAL 15 day) and count < 5;
DELETE FROM awl WHERE lastupdate <= (now() - INTERVAL 30 day) and count < 10;
DELETE FROM awl WHERE lastupdate <= (now() - INTERVAL 60 day) and count < 20;
DELETE FROM awl WHERE lastupdate <= (now() - INTERVAL 120 day);
--
You are receiving this mail because:
You are the assignee for the bug.