Timo Sirainen wrote:
On Tue, 2009-01-20 at 23:38 +0200, Ivars Strazdiņš wrote:
$ sudo /usr/sbin/dovecot --exec-mail ext /usr/lib/dovecot/expire-tool --test
Error: userdb(us...@mail.example) didn't return a home directory
..
userdb:
driver: sql
args: /etc/dovecot/dovecot-mysql.conf
What is the user_query in dovecot-mysql.conf? Does it return a field
called "home"? If it does, set auth_debug=yes and show the logs when
running the command?
Although I don't see why 1.1.6 wouldn't have given this error also..
r...@mail:/etc/dovecot# cat dovecot-mysql.conf | grep quer
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 1000 AS uid, 1000 AS gid FROM mailbox WHERE
username = '%u'
r...@mail:/etc/dovecot#
But I think I found the reason yet still do not know why this had happen...
Expire table had records with strangely looking timestamp record for
those two users. I deleted them and expire-tool errors vanished.
If this will ever happen again I let you know and show these timestamps.
BR,
Ivars
