Michael Monnerie wrote: > On Donnerstag, 3. Juli 2008 Paul J Stevens wrote: >> I checked. I see a similar pattern in my setups. Those are imap users >> that delete messages, but never expunge their mailboxes. > > And therefore Outlook. Anybody know a way to force outlook to expunge? > That's the most common problem here, people don't do this manually > until they receive the "your account near over quota" message.
Heh, I'm still in BOFH mode :-) tested on mysql: create view messages_nonexpunged as select p.internal_date, m.* from dbmail_messages m, dbmail_physmessage p where p.id=m.physmessage_id and m.status=0 and m.deleted_flag=1; update messages_nonexpunged set status=2 where to_days(internal_date) < to_days(now())-14; this will forcibly expunge messages with status=0 and deleted_flag=1 that are older than 14 days. But please do note: This method doesn't reveal how long ago the messages were marked as 'deleted'. Someone may very well have deleted such a messages only a minute ago. No way to tell. If you want to use this method, you might want to add a timestamp column to dbmail_messages to keep track of last-modified time for them. That way you can do more fine-grained and safer auto-expiry. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
