[Dovecot] Getting second quota limit out of database

[dev at stean.ch]

Jiri, thanks for the hint. It works now, no idea what I did wrong
yesterday.

Quoting Jiri Bourek <bourek at thinline.cz>:

> dev at 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
> }
>