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.tuomi@open-xchange.com>; Ken Wright via dovecot <dovecot@dovecot.org>; Timo Sirainen <timo@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=<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
dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org
dovecot mailing list -- dovecot@dovecot.org To unsubscribe send an email to dovecot-leave@dovecot.org