28 Oct
2019
28 Oct
'19
11:10 a.m.
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-iterat...
...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