[Dovecot] Expire plugin with Mysql

[Eric Toczek]

Dino Ming wrote:
> 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
>

That looks good

> How can I debug the imap and check why the table didn't got updated
> when we delete email ?

When I was having issues previous with mysql quota I turned on mysql
query logging to see what exactly was being done on the database side,
and discovered what the errors were. You may want to give it a shot:

http://dev.mysql.com/doc/refman/5.0/en/query-log.html