[Dovecot] expire plugin + dovecot 1.1.7

[Georg Käfer]

Hi,
 
testing expire plugin I get an error message "User lookup failed":
/usr/sbin/dovecot --exec-mail ext /usr/libexec/dovecot/expire-tool -test
 
Error: userdb(lukas at manual.at) didn't return uid
Info: User lookup failed: lukas at manual.at
Info: gkaefer2 at manual.at/INBOX.Sent: stop, expire time in future: Wed Mar 31 14:38:33 2010
 
Reviewing the expires database I see simmilar entries like for gkaefer2 at manual.at (which is working)
 
lukas at manual.at/INBOX.Trash    1241181173
lukas at manual.at/INBOX          1270238935
lukas at manual.at/INBOX.Sent     1271417514
 
Dovecot -n
# 1.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.26-gentoo-r3 i686 Gentoo Base System release 1.12.11.1 ext3
syslog_facility: local0
protocols: pop3 pop3s imap imaps
ssl_cert_file: /etc/ssl/dovecot/xxx.pem
ssl_key_file: /etc/ssl/dovecot/xxx.key
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/libexec/dovecot/imap-login
login_executable(imap): /usr/libexec/dovecot/imap-login
login_executable(pop3): /usr/libexec/dovecot/pop3-login
login_process_per_connection: no
login_greeting_capability(default): yes
login_greeting_capability(imap): yes
login_greeting_capability(pop3): no
login_process_size: 128
login_processes_count: 10
login_max_processes_count: 256
mail_max_userip_connections(default): 10
mail_max_userip_connections(imap): 10
mail_max_userip_connections(pop3): 30
first_valid_uid: 8
last_valid_uid: 8
first_valid_gid: 12
last_valid_gid: 12
mail_privileged_group: mail
mail_uid: mail
mail_gid: mail
mail_location: maildir:/var/mail/%d/%n/Maildir/:INDEX=/var/mail/%d/%n/indexes
mail_debug: yes
mail_full_filesystem_access: yes
mail_executable(default): /usr/libexec/dovecot/imap
mail_executable(imap): /usr/libexec/dovecot/imap
mail_executable(pop3): /usr/libexec/dovecot/pop3
mail_plugins(default): quota imap_quota trash expire
mail_plugins(imap): quota imap_quota trash expire
mail_plugins(pop3): quota expire
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/pop3
imap_client_workarounds(default): outlook-idle delay-newmail
imap_client_workarounds(imap): outlook-idle delay-newmail
imap_client_workarounds(pop3): 
pop3_client_workarounds(default): 
pop3_client_workarounds(imap): 
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
auth default:
  mechanisms: plain login
  verbose: yes
  debug: yes
  debug_passwords: yes
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  userdb:
    driver: prefetch
  userdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  socket:
    type: listen
    client:
      path: /var/spool/postfix/private/auth
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: mail
      group: mail
plugin:
  quota: maildir:User quota
  quota_rule: *:storage=500M
  quota_rule2: *:messages=5000
  quota_rule3: Trash:storage=10%%
  quota_rule4: Spam:storage=20%%
  quota_warning: storage=90%% /usr/bin/quota-warning.sh 90
  quota_warning2: storage=70%% /usr/bin/quota-warning.sh 70
  quota_warning3: messages=70%% /usr/bin/quota-warning.sh 70
  trash: /etc/dovecot/dovecot-trash.conf
  expire: Trash 30 Trash/* 30 INBOX.Trash 30 Spam 30 Junk-E-Mail 30 INBOX.Sent 365 Sent 365 INBOX 365
  expire_dict: proxy::expire
dict:
  expire: mysql:/etc/dovecot/dovecot-dict-expire.conf
 
dovecot-dict-expire.conf:
 
connect = host=localhost dbname=postfixadmin user=postfixadmin password=xxx
# dovecot v1.1 only:
table = expires
select_field = expire_stamp
where_field = mailbox
username_field = not_used
 
 
and users home (lukas@] ls -ltra shows:
 
-rw------- 1 mail mail    0 Mar 31 10:25 dovecot-uidvalidity.49d1d387
drwx------ 4 mail mail 4096 Mar 31 10:25 ..
-rw------- 1 mail mail   36 Mar 31 11:53 subscriptions
-rw------- 1 mail mail    8 Mar 31 14:31 dovecot-uidvalidity
drwx------ 5 mail mail 4096 Apr  1 14:33 .INBOX.Trash
drwx------ 2 mail mail 4096 Apr  2 22:09 tmp
-rw------- 1 mail mail  161 Apr  2 22:09 dovecot-uidlist
drwx------ 2 mail mail 4096 Apr  3 13:42 new
drwx------ 2 mail mail 4096 Apr  3 13:42 cur
drwx------ 8 mail mail 4096 Apr 16 11:32 .
drwx------ 5 mail mail 4096 Apr 16 11:35 .INBOX.Drafts
-rw------- 1 mail mail   64 Apr 16 13:31 maildirsize
drwx------ 5 mail mail 4096 Apr 22 12:44 .INBOX.Sent
 
any idea what is causing the "didn't return uid" / "User lookup failed:" ?
 
many thanks,
Liebe Gruesse
Georg Kaefer