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
