On 13/01/2023 19:39 EET Stefano Cecconello <stefano.cecconello@staff.aruba.it> wrote:
Hi,
If i understood correctly the extra field feature ( https://doc.dovecot.org/configuration_manual/authentication/user_database_ex... ), any extra field that is passed from a SQL query will overwrite any existing settings on the dovecot.conf configuration file ( if present ) .
For example, if i want to enable a plugin ( ex: acl ) on a per user basis, i would add a column\field ( ex: “acl_enabled” = 1 ) into my auth DB , then add into the dovecot password\user queries :
… IF(acl_enabled = 0, NULL, 'acl imap_acl') AS mail_plugins …
While having in the dovecot.conf this setting : … mail_plugins = quota notify
protocol imap mail_plugins = $mail_plugins imap_quota
…
From my test, this combination will lead to having the logging users with acl_enabled=1, a mail_plugins list of acl and imap_acl only, without the quota and notify plugins . If i change the acl_value to 0, the returned mail_plugins list is empty and it will not overrive\overwrite the dovecot.conf mail_plugins configuration .
If it’s correct, there is a way to merge both settings, like having in the dovecot.conf a minimal\base subset of settings and adding any additional values via SQL queries ?
Thanks and best regards Stefano
You could try:
IF(acl_enabled = 0, NULL, 'acl imap_acl') AS mail_plugins_extra
and in config
mail_plugins = $mail_plugins $mail_plugins_extra
Aki