[Dovecot] Problems with Expire Plugin

[Robert Schetterer]

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

-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria