userdb lookup not possible with only userdb prefetch

[Steffen Kaiser]

-----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=<box@****.de>, 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-----