Maybe a straightforward, spelled-out, concrete example of the full
config (new mail_location, new sql syntax, new way to connect to the
database server, etc..) would help all of us to navigate this extended
complexity ?
Also, would be nice to clarify the ambiguity on the fields (user vs
username, domain or user, etc..) with something much more specific
On 2025-02-16 07:31, Doug via dovecot wrote:
" Access denied for user.. 'dovecot'@'localhost' "
Is a mysql error. mysql isn't allowing the user dovecot to open the
database to run your SQL query. Until you can open the database, you
aren't even retrieving the account password. That is where you should
concentrate your efforts. I don't use mysql for authentication so I
can't really tell you how to configure dovecot or mysql to make it
work.
-----Original Message-----
From: Ken Wright via dovecot <dovecot@dovecot.org>
Sent: Saturday, February 15, 2025 4:41 PM
To: Aki Tuomi <aki.tu...@open-xchange.com>; Ken Wright via dovecot
<dovecot@dovecot.org>; Timo Sirainen <t...@sirainen.com>
Subject: Re: Userdb lookup problems
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=<wiz...@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
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
