Hi
I've now got Dovecot 1.0.1 authenticating with PostgreSQL for the IMAP
service, but deliver doesn't seem to work the same.
I'm using the "prefetch" passdb, but deliver doesn't seem to
recognise it.
Here's the log for a deliver attempt:
dovecot: Jul 01 16:51:35 Info: auth(default): master in: USER 1
andy.shellam at mailnetwork.co.uk service=deliver
dovecot: Jul 01 16:51:35 Error: auth(default):
prefetch(andy.shellam at mailnetwork.co.uk): passdb didn't return userdb
entries
dovecot: Jul 01 16:51:35 Info: auth(default): master out: NOTFOUND 1
And here's the log for an IMAP login attempt straight after:
dovecot: Jul 01 16:51:46 Info: auth(default): client in: AUTH 1
PLAIN service=IMAP lip=84.45.66.158 rip=82.165.38.62
resp=AGFuZHkuc2hlbGxhbUBtYWlsbmV0d29yay5jby51awBhYzI5Y2U4NHN5ZA=dovecot: Jul 01
16:51:46 Info: auth(default):
sql(andy.shellam at mailnetwork.co.uk,82.165.38.62): query: SELECT
<user_field> as user, <password_field> as password,
<home_directory> AS
userdb_home, <mail_directory> AS userdb_mail, <chroot_directory> AS
userdb_chroot, <uid_field> AS userdb_uid, <gid_field> AS userdb_gid
FROM
<user_table> WHERE <user_field> = 'andy.shellam at
mailnetwork.co.uk'
dovecot: Jul 01 16:51:46 Info: auth(default): client out: OK 1
user=andy.shellam at mailnetwork.co.uk
dovecot: Jul 01 16:51:46 Info: auth(default): master in: REQUEST 1
24949 1
dovecot: Jul 01 16:51:46 Info: auth(default):
prefetch(andy.shellam at mailnetwork.co.uk,82.165.38.62): success
dovecot: Jul 01 16:51:46 Info: auth(default): master out: USER 1
andy.shellam at mailnetwork.co.uk home=<home_directory>
mail=maildir:<mail_directory> chroot=<chroot_directory>
uid=<uid>
gid=<gid>
dovecot: Jul 01 16:51:46 Info: imap-login: Login:
user=<andy.shellam at mailnetwork.co.uk>, method=PLAIN, rip=82.165.38.62,
lip=84.45.66.158
This works if I use separate userdb and passdb queries. Does deliver
not support the prefetch authentication method?
Thanks,
Andy.