dev@stean.ch wrote:
Hello there,
I am working with dovecot v2.2.12, and have setup a user and domain quota by using a quota/quota_rule for user and quota2/quota2_rule for the domain.
This works fine when the limit configuration for both is stored inside dovecot configuration files. However, I would like to have the limits configurable on a user and domain base, and that data is stored inside my SQL database.
Getting the user quota out of a database with SQL works fine, as documented with "SELECT whatever AS quota_rule FROM mytable", I extended my query to return quota2_rule too, but dovecot did not really do something with that value in the end, the domain limit was set to 0, as visible through the logs and with doveadm quota get ...
Any idea or hint how I could get dovecot to read the limit for the domains out of my SQL database ?
Thanks, Stephan
Works here with 2.2.9 (Debian). Snippet from userdb SQL query:
user_query = SELECT ... '*:bytes=' || domains.quota_size || 'M:messages=' || domains.quota_files as quota_rule, '*:bytes=' || mailboxes.quota_size || 'M:messages=' || mailboxes.quota_files as quota2_rule ...
Using quota backend "fs" for both (user quota for mailbox, group quota for domain)
plugin { quota = fs:Domain quota:group:inode_per_mail quota2 = fs:Mailbox quota:user:inode_per_mail }