> 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:
> > >
> > > driver = mysql
> > > connect = host=localhost dbname=postfixadmin user=postfixadmin
> > > password=hidden
> > > userdb_default_password_scheme = ARGON2I
> > > password_query = SELECT username AS username, password FROM mailbox
> > > WHERE username = '%{user | username }' AND active= '1'
> > > user_query = SELECT maildir, 2000 AS uid, 2000 AS gid FROM mailbox
> > > WHERE username = '%{user | username }' AND active= '1'
> > > iterate_query = SELECT username AS username FROM mailbox
> >
> > 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.
Aki
_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
