[Dovecot] Problems with Expire Plugin

[Robert Schetterer]

Robert Schetterer schrieb:
> Timo Sirainen schrieb:
>> On Fri, 2009-07-17 at 00:07 +0200, Robert Schetterer wrote:
>>> Timo Sirainen schrieb:
>>>> I'm getting tired of explaining again and again how expire plugin is
>>>> supposed to work, so I added now Example #1 timeline and Example #2
>>>> timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
>>>> what is supposed to happen with a couple of examples. Do they finally
>>>> help understanding how exactly things are supposed to work?
>>> Hi Timo, your examples are well to understand,
>>> i ve tested the mysql setup also using ... --test
>>> everything looks fine and works as it should but
>>> mails dont get deleted, 
>> Then everything doesn't look fine and work.. What exactly do you have in
>> the database and what exactly does --test say?
>>
>>> Anyway the time should be set more shortly for testing
>>> waiting 1 day minimum isnt really fun
>> You could try it in a test machine and just use "date --set". That's how
>> I made the wiki examples.
> 
> ok, lets see
> delete a mail to Trash
> ask in sql
> mysql> select mailbox, from_unixtime(expire_stamp), username from
> expireplugin;
> +---------+-----------------------------+-----------------------+
> | mailbox | from_unixtime(expire_stamp) | username              |
> +---------+-----------------------------+-----------------------+
> | Trash   | 2009-07-18 09:10:57         | robert at schetterer.com |
> +---------+-----------------------------+-----------------------+
> 1 row in set (0.00 sec)
> 
> looks fine
> 
> /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext
> /usr/lib/dovecot/expire-tool.sh --test
> Info: Loading modules from directory: /usr/lib/dovecot/modules/imap
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib01_acl_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
> Info: Module loaded:
> /usr/lib/dovecot/modules/imap/lib20_autocreate_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_expire_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_fts_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_virtual_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib21_fts_squat_plugin.so
> Info: Quota root: name= backend=dict args=:proxy::quotadict
> Info: Quota warning: bytes=0 (95%) messages=0
> command=/usr/local/bin/quota-warning.sh 95
> Info: Quota warning: bytes=0 (80%) messages=0
> command=/usr/local/bin/quota-warning.sh 80
> Info: expire: pattern=Trash type=expunge secs=86400
> Info: expire: pattern=Trash/* type=expunge secs=86400
> Info: robert at schetterer.com/Trash: stop, expire time in future: Sat Jul
> 18 09:10:57 2009
> 
> looks fine too
> 
> running cron
> */10   * * * *   root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
> --exec-mail ext /usr/lib/dovecot/expire-tool.sh >/dev/null 2>&1
> 
> so lets see if mail gets deleted on 2009-07-18 09:10:57
> 
> in my former tests it wasnt
> 
Hi Timo,
the mail did not got deleted
 so whats now ?
any hint where in the log i might find the problem ?
running now

/usr/sbin/dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext
/usr/lib/dovecot/expire-tool.sh --test
Info: Loading modules from directory: /usr/lib/dovecot/modules/imap
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib01_acl_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Info: Module loaded:
/usr/lib/dovecot/modules/imap/lib20_autocreate_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_expire_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_fts_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_virtual_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib21_fts_squat_plugin.so
Info: Quota root: name= backend=dict args=:proxy::quotadict
Info: Quota warning: bytes=0 (95%) messages=0
command=/usr/local/bin/quota-warning.sh 95
Info: Quota warning: bytes=0 (80%) messages=0
command=/usr/local/bin/quota-warning.sh 80
Info: expire: pattern=Trash type=expunge secs=86400
Info: expire: pattern=Trash/* type=expunge secs=8640

shows nothing
-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria