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@mailnetwork.co.uk service=deliver dovecot: Jul 01 16:51:35 Error: auth(default): prefetch(andy.shellam@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@mailnetwork.co.uk,82.165.38.62): query: SELECT as user, as password, AS userdb_home, AS userdb_mail, AS userdb_chroot, AS userdb_uid, AS userdb_gid FROM WHERE = 'andy.shellam@mailnetwork.co.uk' dovecot: Jul 01 16:51:46 Info: auth(default): client out: OK 1
user=andy.shellam@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@mailnetwork.co.uk,82.165.38.62): success dovecot: Jul 01 16:51:46 Info: auth(default): master out: USER 1
andy.shellam@mailnetwork.co.uk home=
mail=maildir: chroot= uid=<uid> gid=<gid> dovecot: Jul 01 16:51:46 Info: imap-login: Login: user=andy.shellam@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.