> On 20/05/2022 16:41 James <list at xdrv.uk> wrote:
>
>
> 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
If you are returning that from userdb, you should not return it with `userdb_`
prefix.
Aki