Re: [Dovecot] finding messages deleted before timespec

2012-09-04 Thread Dennis Guhl 
On Mon, Sep 03, 2012 at 01:31:18PM +0200, Sven Hartge wrote:
 Hi!

[..]

 I want to use this to expunge all DELETED messages which have been in
 that state for 24h or longer.

http://wiki2.dovecot.org/Tools/Doveadm/Expunge

HTH
Dennis

[..]

Re: [Dovecot] finding messages deleted before timespec

2012-09-04 Thread Sven Hartge 
Dennis Guhl d...@dguhl.org wrote:
 On Mon, Sep 03, 2012 at 01:31:18PM +0200, Sven Hartge wrote:
 Hi!

 I want to use this to expunge all DELETED messages which have been in
 that state for 24h or longer.

 http://wiki2.dovecot.org/Tools/Doveadm/Expunge

Yes, I know about doveadm expunge.

I am searching for a search_query which only matches messages with the
flag \Deleted whose flag has been set 24h or longer ago.

Doing something like

  doveadm expunge -A mailbox \* DELETED

is not the solution, since it will expunge all deleted mails without
looking at the time when they have been deleted.

Using savedbefore does not work either, since a message may have been
saved 2 years ago but only recently deleted.

Grüße,
Sven.

-- 
Sigmentation fault. Core dumped.

Re: [Dovecot] finding messages deleted before timespec

2012-09-04 Thread Timo Sirainen 
On 3.9.2012, at 14.31, Sven Hartge wrote:

 I want to use this to expunge all DELETED messages which have been in
 that state for 24h or longer.

Dovecot doesn't keep track of that information, so you can't.

Re: [Dovecot] finding messages deleted before timespec

2012-09-04 Thread Sven Hartge 
Timo Sirainen t...@iki.fi wrote:
 On 3.9.2012, at 14.31, Sven Hartge wrote:

 I want to use this to expunge all DELETED messages which have been in
 that state for 24h or longer.

 Dovecot doesn't keep track of that information, so you can't.

I suspected this. Would be nice though.

Grüße,
Sven.

-- 
Sigmentation fault. Core dumped.

Re: [Dovecot] finding messages deleted before timespec

2012-09-04 Thread Joseph Tam 

On Tue, 4 Sep 2012, Sven Hartge wrote:


I am searching for a search_query which only matches messages with the
flag \Deleted whose flag has been set 24h or longer ago.

Doing something like

 doveadm expunge -A mailbox \* DELETED

is not the solution, since it will expunge all deleted mails without
looking at the time when they have been deleted.

Using savedbefore does not work either, since a message may have been
saved 2 years ago but only recently deleted.


You could work out a cron job that does a doveadm search ..., then diff
it with one generated 24 hours ago, extract the common GID/UUIDs, then do a
second pass to delete them.

Not elegant, but it would probably work.

(I just read the man page, and there doesn't seem to be an option
to pipe the search like doveadm search ... | doveadm expunge 
You'll have to expunge one message at a time.  Ugh.)

Or maybe the advice don't worry, be happy applies here.  I find that
too many mistake mitigation features is counterproductive as users
habitually relying on them, rather than being careful.  Extending your
grace period to a week will lessen the probability of this race condition.

Joseph Tam jtam.h...@gmail.com