[Dovecot] Expire plugin with Mysql
Dino Ming
dino.ming at gmail.com
Tue Aug 5 07:03:07 EEST 2008
Dear Timo,
I tried to change back to
expire: Trash 1
and it seem still not work whenever I delete email within Mail.app &
Thunderbird.
the dict_expire table not being updated.
Here is my dict.conf file
connect = host=sql dbname=vmail user=xxxxxx password=xxxxxxxxxx
table = dict_expire
select_field = timestamp
where_field = path
username_field = username
How can I debug the imap and check why the table didn't got updated
when we delete email ?
Thanks
Dino
On 21 Jul 2008, at 12:11 AM, Timo Sirainen wrote:
> On Tue, 2008-07-08 at 15:07 +0800, Dino Ming wrote:
>> Hi Timo,
>>
>> I had setup the expire plugin using proxy dict method with mysql
>> table.
>>
>> Whenever I run the command : dovecot --exec-mail ext
>> /usr/local/libexec/dovecot/expire-tool , I saw dovecot query the
>> table :
>> Query SELECT path, timestamp FROM dict_expire ORDER BY
>> timestamp
>>
>> But then, nothing happened at all. No mails being expunge from the
>> mailbox
>> Trash folder. Also, What is the purpose for the table to store
>> username,
>> path & timestamp ? Because the table is empty and no data populated.
>
> If there are no rows in the table, then that's the reason expire-tool
> doesn't do anything. IMAP should insert rows into the table when
> you're
> copying messages to Trash.
>
>> expire: Trash 1 Trash/* 1
>
> I guess by Trash/* you're thinking about mailboxes thare are renamed
> there by Thunderbird? That won't work currently..
>
More information about the dovecot
mailing list