[Dovecot] domain quota in sql

Adam Szpakowski as at 3a.pl
Tue Feb 14 23:29:19 EET 2012


Hi,
I have a problem with setting up quota usage tracking for domains.
Problem is, that domain quota is always based on only one user in 
domain, the last one on whom behalf any operation was performed.
To recreate this situation, one has only to perform:
doveadm quota recalc -u USER
on a user, and the domain quota takes the value of this user quota.

Have anyone a clue what could cause this problem?

Quota tracking is set up both for users and domains.
For users quota tracking is working fine, data is saved into dbase 
without problems.
We are using dovecot 2.0.15.
Quota enforcing (rules) is NOT a part of the problem.

Important parts of config:

dict {
quota = mysql:/etc/dovecot/dovecot-dict-used-quota.conf.ext
quota2 = mysql:/etc/dovecot/dovecot-dict-used-quota-domain.conf.ext
}

plugin {
quota = dict:User quota::proxy::quota
quota2 = dict:Domain quota:%d:proxy::quota2
}

/etc/dovecot/dovecot-dict-used-quota.conf.ext
map {
   pattern = priv/quota/storage
   table = used_quota
   username_field = username
   value_field = bytes
}
map {
   pattern = priv/quota/messages
   table = used_quota
   username_field = username
   value_field = messages
}

/etc/dovecot/dovecot-dict-used-quota-domain.conf.ext
map {
   pattern = priv/quota/storage
   table = used_quota_domain
   username_field = domain
   value_field = bytes
}
map {
   pattern = priv/quota/messages
   table = used_quota_domain
   username_field = domain
   value_field = messages
}

-- 
Adam Szpakowski



More information about the dovecot mailing list