https://issues.apache.org/SpamAssassin/show_bug.cgi?id=7021
Kevin A. McGrail <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Kevin A. McGrail <[email protected]> --- 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.
