" 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 <[email protected]> > Sent: Saturday, February 15, 2025 4:41 PM > To: Aki Tuomi <[email protected]>; Ken Wright via dovecot > <[email protected]>; Timo Sirainen <[email protected]> > 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 > > > <[email protected]> wrote: > > > > > > > > > > > > > > > > > > On Sat, 2025-02-15 at 17:53 +0200, Aki Tuomi wrote: > > > > > > > > > > > > > > > > > On 15/02/2025 17:39 EET Ken Wright via dovecot > > > > > > > > > > <[email protected]> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Sat, 2025-02-15 at 08:59 +0200, Timo Sirainen wrote: > > > > > > > > > > > > > > > > > On 15. Feb 2025, at 0.06, Ken Wright via dovecot > > > > > > > > > > > > <[email protected]> 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=<[email protected]>, 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 -- [email protected] > To unsubscribe send an email to [email protected] _______________________________________________ dovecot mailing list -- [email protected] To unsubscribe send an email to [email protected]
