Re: userdb lookup not possible with only userdb prefetch

8 Dec 2014


      -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sun, 7 Dec 2014, Yves Goergen wrote:
...
...
prefetch(box@****.de,2001:****:7765,<bzAOP5QJXwAgAQpgEAXJAZyOMB1qBXdl>):
userdb lookup not possible with only userdb prefetch
dovecot: auth: Error:
userdb(box@****.de,2001:****:7765,<bzAOP5QJXwAgAQpgEAXJAZyOMB1qBXdl>): user
not found from userdb prefetch
dovecot: imap: Error: Authenticated user not found from userdb, auth lookup
id=178651137 (client-pid=13711 client-id=1)
dovecot: imap-login: Internal login failure (pid=13711 id=1) (internal
failure, 1 successful auths): user=, method=PLAIN,
rip=2001:****:7765, lip=2a01:****:2, mpid=13717, TLS,
session=<bzAOP5QJXwAgAQpgEAXJAZyOMB1qBXdl>
That doesn't help me a lot. Here's parts of my configuration, dumped with
'dovecot -n':
it's a bad decision to post only "parts of" the conf mostly.
[cut]
...
...
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
[cut]
userdb {
driver = prefetch
}
once you've resolved the prefetch problem with deoren's advice, also read:
[found by searching for "prefetch"]
http://wiki2.dovecot.org/UserDatabase/Prefetch
"... the passdb returns the userdb information in extra fields with
userdb_ prefixes. For example if a userdb typically returns uid, gid and
home fields, the passdb would have to return userdb_uid, userdb_gid and
userdb_home fields."
Also note the the snippet: "If you're using LDA, you still need a valid
userdb which can be used to locate the users." This advice applies to all
services, that need to know user information without to auth' before, e.g.
the LDA or doveadm.
IMHO, you should add the fall-back SQL-userdb as shown in the Wiki page.

Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iQEVAwUBVIVb3Hz1H7kL/d9rAQKn5QgAhnbpqd6Xvewvzy6FTTzFU1eHH6rRUK7+
PEQWm8UYPm4a9wBdM1tMHCAaCp1BKSlRVEhrOKgyyk4rE8GQzbyerN8noN7E0jvl
tS5RwntMxmYr9mgo8l04dKnd4iEPVg1s9bvYbkig1xrWxkVmAP2+w7v9Aum6pBaO
yHfQsHyUNQYDtRVBtDix7h8ApvmbnAOtZRot9/6TP553ZdW0n13I165dlk1owVAq
KnkxwxOOPeg4+9J2Az3rO3eBpq1quRmW/wLVCbyg6Ru8avkihWDMzj2O72DF6nO1
PnjQI+60d4iZV42IKnRCB2Mc/2bxMG+fcOLnHfZtNk/lItypJ5sWiw==
=/AS/
-----END PGP SIGNATURE-----