On 15/02/2025 18:29 EET Ken Wright via dovecot <dovecot@dovecot.org> wrote: On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote: On 15/02/2025 17:39 EET Ken Wright via dovecot <dovecot@dovecot.org> wrote: On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: On 15. Feb 2025, at 0.06, Ken Wright via dovecot <dovecot@dovecot.org> wrote: These need to be converted to the new syntax. Is this correct? passdb sql { query = SELECT username AS username, domain, password FROM mailbox WHERE username = '%{user | username}' AND domain = '%{user | domain}' AND active= '1' } userdb sql { query = SELECT maildir, 2000 AS uid, 2000 AS gid FROM mailbox WHERE username = '%{user | username}' AND domain = '% {user | domain}' AND active= '1' # For using doveadm -A: iterate_query = SELECT username AS username, domain FROM mailbox Like mentioned already on some thread, returning maildir is not right, check https://doc.dovecot.org/2.4.0/core/config/mailbox/ mail_location.html and return mail_path instead. Okay, I changed maildir to mail_path, but I still can't log in. I'm sorry, but I think I need to see the fix spelled out. I'm an idiot. Ken Did you check logs for details? If there is not much, try log_debug=category=auth mail_debug=yes Aki