[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