[Dovecot] Expire plugin with Mysql

[Dino Ming]

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..
>