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