SQL iterate_query

[James]

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