On 25/10/2019 00:00, Daniel Miller via dovecot wrote:
So, given that the complete address is used as the username I now use:
iterate_query = SELECT username FROM mailbox
https://doc.dovecot.org/configuration_manual/authentication/sql/#user-iteration
...says that iterate_query has two variants. You have complete
addresses in a database column "username" so you need the first. The
addresses must be return in a column named "user", hence add "AS user"
to label your column. Try:
iterate_query = SELECT username AS user FROM mailbox
