SQL user_query quota_rule for *:messages=

James list at xdrv.uk
Fri May 20 13:41:47 UTC 2022


Hello,

dovecot.conf sets the system default quota for storage and message count:

plugin {
    ...
   quota_rule = *:storage=1G
   quota_rule2 = *:messages=10000
    ...
}

This quota_rule for the storage is overridden by an SQL user_query in 
dovecot-sql.conf:

user_query = "SELECT ... '*:storage=' || maxstorage || 'M'  AS 
userdb_quota_rule, ...;"

Is it possible to override the message count limit with an SQL 
user_query (and password_query)?




I tried returning userdb_quota_rule2 in the SQL but it did not work. 
"SELECT ... '*:messages=' || maxcount AS userdb_quota_rule2 ...;"


Ref:
https://doc.dovecot.org/configuration_manual/authentication/user_database_extra_fields/#authentication-user-database-extra-fields



More information about the dovecot mailing list