I am using the always_bcc setting in postfix to archive all emails. But I only need to do it for a certain time. Once a mail item is more than a few weeks old, I'm happy to delete it.
What's the best way to do this in Zimbra?
The mail filters don't have an 'older than' clause.
I tried something like delete from mail_item where date < xxxx; in the database, but got scary warnings about hierarchical keys:
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`mboxgroup20/mail_item`, CONSTRAINT `fk_mail_item_folder_id` FOREIGN KEY (`mailbox_id`, `folder_id`) REFERENCES `mail_item` (`mailbox_id`, `id`))
I'd like to be able to script this in a cron job, rather than having to use the web interface or IMAP.