On Sat, 2025-02-15 at 20:24 +0200, Aki Tuomi wrote:
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
These two lines in /var/log/mail.log seem to be pertinent:
2025-02-15T16:33:29.976767-05:00 grace dovecot: auth: Error: mysql(localhost): Connect failed to database (): Access denied for user 'dovecot'@'localhost' (using password: NO) - waiting for 1 seconds before retry 2025-02-15T16:33:36.560826-05:00 grace dovecot: imap-login: Login aborted: Connection closed (auth failed, 1 attempts in 7 secs) (auth_failed): user=<wizard@koalatyworks.com>, method=PLAIN, rip=192.168.1.1, lip=192.168.1.10, TLS, session=<V2HRCjUu2ObAqAEB>
I don't understand why access is denied. I don't understand why it didn't use the password. Help!
Ken