<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Michael,<br class=""><div><br class=""></div><div><blockquote type="cite" class=""><div class=""><div class="">Is there any reason Dovecot shows the 'user' variable (ie: <a href="mailto:user@domain.tld" class="">user@domain.tld</a>) being obtained in the password query and not the (more logical) user query?<br class=""></div></div></blockquote></div><div class=""><br class=""></div>maybe prefetching is configured:<div class=""><br class=""><div class=""><a href="https://wiki.dovecot.org/AuthDatabase/SQL" class="">https://wiki.dovecot.org/AuthDatabase/SQL</a></div></div><div class=""><br class=""></div><div class="">Prefetching<br class=""><br class="">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.</div><div class=""><br class=""></div><div class=""><a href="https://wiki.dovecot.org/UserDatabase/Prefetch" class="">https://wiki.dovecot.org/UserDatabase/Prefetch</a></div><div class=""><br class=""></div><div class="">Best regards</div><div class="">Gerald</div></body></html>