Re: Problems with flags and status

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