[Dovecot] Expire plugin with Mysql

[Dino Ming]

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.

Spec.
FreeBSD 7.0 AMD64
dovecot-1.1.1 from Port

Dovecot Config
-----------------------------
[root at dove /usr/local/etc]# dovecot -n
# 1.1.1: /usr/local/etc/dovecot.conf
base_dir: /var/run/dovecot/
log_path: /var/log/dovecot.log
protocols: imap pop3
listen: 192.168.2.20
ssl_disable: yes
disable_plaintext_auth: no
shutdown_clients: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/local/libexec/dovecot/imap-login
login_executable(imap): /usr/local/libexec/dovecot/imap-login
login_executable(pop3): /usr/local/libexec/dovecot/pop3-login
login_greeting: Service Ready.
login_greeting_capability(default): yes
login_greeting_capability(imap): yes
login_greeting_capability(pop3): no
login_process_size: 32
login_processes_count: 10
login_max_processes_count: 256
max_mail_processes: 1024
verbose_proctitle: yes
first_valid_uid: 26
last_valid_uid: 26
first_valid_gid: 26
last_valid_gid: 26
mail_access_groups: mail
mail_location: maildir:~/Maildir
mmap_disable: yes
dotlock_use_excl: no
mail_nfs_storage: yes
mail_nfs_index: yes
maildir_stat_dirs: yes
mail_executable(default): /usr/local/libexec/dovecot/imap
mail_executable(imap): /usr/local/libexec/dovecot/imap
mail_executable(pop3): /usr/local/libexec/dovecot/pop3
mail_plugins(default): expire fts quota imap_quota
mail_plugins(imap): expire fts quota imap_quota
mail_plugins(pop3): expire fts quota
mail_plugin_dir(default): /usr/local/lib/dovecot/imap
mail_plugin_dir(imap): /usr/local/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3
imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh
tb-extra-mailbox-sep
imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh
tb-extra-mailbox-sep
imap_client_workarounds(pop3):
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
  list: yes
  subscriptions: yes
auth default:
  cache_size: 8192
  cache_ttl: 900
  verbose: yes
  worker_max_count: 10
  passdb:
    driver: sql
    args: /usr/local/etc/dovecot-mysql.conf
  userdb:
    driver: sql
    args: /usr/local/etc/dovecot-mysql.conf
  socket:
    type: listen
    client:
      path: /var/run/dovecot/auth-client
      mode: 438
    master:
      path: /var/run/dovecot/auth-master
      mode: 438
plugin:
  quota: maildir
  quota_rule: *:storage=2G
  quota_rule2: Trash:storage=10M
  expire: Trash 1 Trash/* 1
  expire_dict: proxy::expiredict
  auth_socket_path: /var/run/dovecot/auth-master
  fts: squat
  fts_squat: partial=4 full=10
dict:
  expiredict: mysql:/usr/local/etc/dovecot-dict-expire.conf


Thx
Dino

On Tue, Jun 3, 2008 at 3:21 AM, Timo Sirainen <tss at iki.fi> wrote:

> On Mon, 2008-06-02 at 14:50 -0400, Eric T wrote:
> >
> > >
> > > Seems to work in my tests. Could you do a bit more with gdb:
>
> Wonder why it worked :) Fixed:
> http://hg.dovecot.org/dovecot-1.1/rev/d73cc550b389
>
>