dovecot - May 2011 - Dovecot 2 and Expire plugins : doesn't have record in DB

Dovecot 2 and Expire plugins : doesn't have records in db
Hide Details
FROM:
	* San San
TO:
	* ?dovecot at dovecot.org
Message flagged
Tuesday, May 24, 2011 1:09 PM
Dear Dovecot

I have already config dovecot server with 2.0.13, and I need to enable expire
plugins (in dovecot1 I have already used)
but I see in my db doesn't have any record how about to debug or trace to
solve this problem

doveconf -n :

auth_verbose = yes
default_internal_user = vmail
dict {
? expire = mysql:/usr/local/etc/dovecot/dovecot-dict-expire.conf
}
disable_plaintext_auth = no
first_valid_gid = 200
first_valid_uid = 200
last_valid_gid = 200
last_valid_uid = 200
login_greeting = mail ready.
mail_gid = vmail
mail_location = maildir:~/Maildir
mail_nfs_storage = yes
mail_plugins = expire
mail_uid = vmail
maildir_very_dirty_syncs = yes
namespace {
? hidden = no
? inbox = yes
? list = yes
? location =?
? prefix = INBOX.
? separator =?
? subscriptions = yes
? type = private
}
passdb {
? args = /usr/local/etc/dovecot/dovecot-ldap.conf
? driver = ldap
}
plugin {
? autocreate = INBOX.Drafts
? autocreate2 = INBOX.Sent
? autocreate3 = INBOX.Trash
? autocreate4 = INBOX.Spam
? autosubscribe = INBOX.Drafts
? autosubscribe2 = INBOX.Sent
? autosubscribe3 = INBOX.Trash
? autosubscribe4 = INBOX.Spam
? expire = INBOX.Trash 15d
? expire2 = INBOX.Spam 30d
? expire_dict = proxy::expire
? quota = maildir
? quota_rule = INBOX.Trash:storage=+200M
}
protocols = imap
service anvil {
? chroot = empty
? client_limit = 0
? drop_priv_before_exec = no
? executable = anvil
? extra_groups =?
? group =?
? idle_kill =?4294967295?secs
? privileged_group =?
? process_limit = 1
? process_min_avail = 1
? protocol =?
? service_count = 0
? type = anvil
? unix_listener anvil-auth-penalty {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? unix_listener anvil {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? user = $default_internal_user
? vsz_limit = 18446744073709551615 B
}
service auth-worker {
? chroot =?
? client_limit = 1
? drop_priv_before_exec = no
? executable = auth -w
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 1
? type =?
? unix_listener auth-worker {
? ? group =?
? ? mode = 0600
? ? user = $default_internal_user
? }
? user =?
? vsz_limit = 18446744073709551615 B
}
service auth {
? chroot =?
? client_limit = 4096
? drop_priv_before_exec = no
? executable = auth
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 1
? process_min_avail = 0
? protocol =?
? service_count = 0
? type =?
? unix_listener auth-client {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? unix_listener auth-login {
? ? group =?
? ? mode = 0600
? ? user = $default_internal_user
? }
? unix_listener auth-master {
? ? group = vmail
? ? mode = 0600
? ? user = vmail
? }
? unix_listener auth-userdb {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? unix_listener login/login {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user = root
? vsz_limit = 18446744073709551615 B
}
service config {
? chroot =?
? client_limit = 0
? drop_priv_before_exec = no
? executable = config
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 0
? type = config
? unix_listener config {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? user =?
? vsz_limit = 18446744073709551615 B
}
service dict {
? chroot =?
? client_limit = 1
? drop_priv_before_exec = no
? executable = dict
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 0
? type =?
? unix_listener dict {
? ? group =?
? ? mode = 0600
? ? user = vmail
? }
? user = $default_internal_user
? vsz_limit = 64 M
}
service director {
? chroot =?
? client_limit = 0
? drop_priv_before_exec = no
? executable = director
? extra_groups =?
? fifo_listener login/proxy-notify {
? ? group =?
? ? mode = 00
? ? user =?
? }
? group =?
? idle_kill = 4294967295 secs
? privileged_group =?
? process_limit = 1
? process_min_avail = 0
? protocol =?
? service_count = 0
? type =?
? unix_listener director-admin {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? unix_listener login/director {
? ? group =?
? ? mode = 00
? ? user =?
? }
? user = $default_internal_user
? vsz_limit = 18446744073709551615 B
}
service dns_client {
? chroot =?
? client_limit = 1
? drop_priv_before_exec = no
? executable = dns-client
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 0
? type =?
? unix_listener dns-client {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? unix_listener login/dns-client {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user = $default_internal_user
? vsz_limit = 18446744073709551615 B
}
service doveadm {
? chroot =?
? client_limit = 1
? drop_priv_before_exec = no
? executable = doveadm-server
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 1
? type =?
? unix_listener doveadm-server {
? ? group =?
? ? mode = 0600
? ? user =?
? }
? user =?
? vsz_limit = 64 M
}
service imap-login {
? chroot = login
? client_limit = 800
? drop_priv_before_exec = no
? executable = imap-login
? extra_groups =?
? group =?
? idle_kill = 0
? inet_listener imap {
? ? address =?
? ? port = 143
? ? ssl = no
? }
? inet_listener imaps {
? ? address =?
? ? port = 993
? ? ssl = yes
? }
? privileged_group =?
? process_limit = 255
? process_min_avail = 10
? protocol = imap
? service_count = 0
? type = login
? user = nobody
? vsz_limit = 64 M
}
service imap {
? chroot =?
? client_limit = 1024
? drop_priv_before_exec = no
? executable = imap
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 1024
? process_min_avail = 8
? protocol = imap
? service_count = 1
? type =?
? unix_listener login/imap {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user =?
? vsz_limit = 64 M
}
service lmtp {
? chroot =?
? client_limit = 0
? drop_priv_before_exec = no
? executable = lmtp
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol = lmtp
? service_count = 0
? type =?
? unix_listener lmtp {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user =?
? vsz_limit = 0
}
service log {
? chroot =?
? client_limit = 0
? drop_priv_before_exec = no
? executable = log
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 1
? process_min_avail = 0
? protocol =?
? service_count = 0
? type = log
? user =?
? vsz_limit = 18446744073709551615 B
}
service pop3-login {
? chroot = login
? client_limit = 255
? drop_priv_before_exec = no
? executable = pop3-login
? extra_groups =?
? group =?
? idle_kill = 0
? inet_listener pop3 {
? ? address =?
? ? port = 110
? ? ssl = no
? }
? inet_listener pop3s {
? ? address =?
? ? port = 995
? ? ssl = yes
? }
? privileged_group =?
? process_limit = 255
? process_min_avail = 10
? protocol = pop3
? service_count = 0
? type = login
? user = nobody
? vsz_limit = 64 M
}
service pop3 {
? chroot =?
? client_limit = 1
? drop_priv_before_exec = no
? executable = pop3
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 1024
? process_min_avail = 0
? protocol = pop3
? service_count = 1
? type =?
? unix_listener login/pop3 {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user =?
? vsz_limit = 18446744073709551615 B
}
service ssl-params {
? chroot =?
? client_limit = 0
? drop_priv_before_exec = no
? executable = ssl-params
? extra_groups =?
? group =?
? idle_kill = 0
? privileged_group =?
? process_limit = 0
? process_min_avail = 0
? protocol =?
? service_count = 0
? type =?
? unix_listener login/ssl-params {
? ? group =?
? ? mode = 0666
? ? user =?
? }
? user =?
? vsz_limit = 18446744073709551615 B
}
ssl = no
userdb {
? args = /usr/local/etc/dovecot/dovecot-ldap.conf
? driver = ldap
}
protocol imap {
? imap_client_workarounds = tb-extra-mailbox-sep
? mail_max_userip_connections = 200
? mail_plugins = quota imap_quota expire autocreate
}
protocol pop3 {
? pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
? pop3_uidl_format = %v-%u
}
protocol lda {
? postmaster_address =?postmaster at example.com
}
?
and dovecot-dict-expire.conf is?

connect = host=10.3.1.31?dbname=dovecot user=dovecot password=dovecot

# CREATE TABLE expires (
# ? username varchar(100) not null,
# ? mailbox varchar(255) not null,
# ? expire_stamp integer not null,
# ? primary key (username, mailbox)
# );

map {
? pattern = shared/expire/$user/$mailbox
? table = expires
? value_field = expire_stamp

? fields {
? ? username = $user
? ? mailbox = $mailbox
? }
}

?
Sincerely,
Nantharat Puwarang