d...@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
}
