User / Pass SQL queries

[Gerald Galster]

Hi Michael,

> Is there any reason Dovecot shows the 'user' variable (ie: user at domain.tld) being obtained in the password query and not the (more logical) user query?


maybe prefetching is configured:

https://wiki.dovecot.org/AuthDatabase/SQL <https://wiki.dovecot.org/AuthDatabase/SQL>

Prefetching

If you want to avoid doing two SQL queries when logging in with IMAP/POP3, you can make the password_query return all the necessary userdb fields and use prefetch userdb to use those fields. If you're using Dovecot's deliver you'll still need to have the user_query working.

https://wiki.dovecot.org/UserDatabase/Prefetch <https://wiki.dovecot.org/UserDatabase/Prefetch>

Best regards
Gerald
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20190829/f1f55795/attachment-0001.html>