> On Sep 3, 2025, at 20:25, Zhang Huangbin <[email protected]> wrote:
>
> I'm migrating from Dovecot 2.3 to 2.4 on Debian 13, only one issue remains:
> How can i override global mail_driver, mail_path, mail_index_path parameters
> with a SQL userdb?
>
> mail_driver = maildir
> mail_path = ~/Maildir
> mail_index_path = ~/Maildir
>
> userdb sql {
> query = SELECT ...,
> LOWER(mailbox.mailboxformat) AS mail_driver, \
> CONCAT("~/", mailbox.mailboxfolder) AS mail_path, \
> CONCAT(LOWER(mailbox.mailboxformat), ":~/", mailbox.mailboxfolder)
> AS mail, \
> CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule \
> FROM mailbox,domain \
> WHERE ...
> }
ok, find the answer in Settings Variables[1] and Passwd-file[2] page. Here's
the working setting:
mail_driver = %{userdb:mail_driver | default("maildir") | lower}
mail_path = %{userdb:mail_path | default("~/Maildir")}
userdb returns `mail_driver` and `mail_path`.
[1] https://doc.dovecot.org/2.4.1/core/settings/variables.html
[2] https://doc.dovecot.org/2.4.1/core/config/auth/databases/passwd_file.html
_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]
