[Dovecot] userdb prefetch not working for passdb sql

[Timo Sirainen]

On Sun, 2006-03-26 at 16:43 -0500, dovecot-ri wrote:
> The MySQL query is long and complicated, but here's what it returned when I copied and pasted it into mysql:
> 
> user         testuser at mydomain.com
> password     {SSHA}BRuPgonpb8Zd+0NaFH2G6dT47m3mT43w
> userdb_home  /var/mail/mydomain.com/testuser
> userdb_uid   vmail
> userdb_gid   vmail

It would be faster to return numeric uid/gid so Dovecot doesn't have to
look them up.

>   passdb sql {
>     args = /etc/dovecot/dovecot-sql.conf
>   }
>   passdb pam {
>     args = "*"
>   }
>   userdb passwd {
>   }
>   userdb prefetch {
>   }

Have you tried without pam/passwd? I think the "userdb passwd" makes it
forget about the userdb_* fields. I'm not sure how good idea it's in any
case to use prefetch with multiple passdbs..