Paolo Cravero as2594 wrote:
Attempting a self-reply
Which SQL query would allow me to differentiate quarantine length
according to content type?
I think this one should do:
DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 15*24*60*60 AND
CONTENT = 'V';
[viruses don't live in quarantine longer than 15 days]
So, running it (before?) the suggested:
DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 30*24*60*60;
DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 60*60 AND content
IS NULL;
would delete viruses from quarantine sooner than other contents.
One more. Everything here gets tagged (-999, 3.5, 3.5) and nothing gets
killed (everything goes to quarantine). But I could delete earlier high
scoring messages, whose probability of being a false positive is null.
Is this kind of query possible? How?
And this one should be:
DELETE FROM msgs WHERE time_num < UNIX_TIMESTAMP() - 15*24*60*60 AND
spam_level > 20;
[score > 20 doesn't live in quarantine longer than 15 days]
Am I missing something? Would these queries achieve what I need? If so,
perhaps they can go in the official docs?
Paolo
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
