Настроил dovecot 1.2.6, квоты с хранением в mysql версии 1.2.
Сами квоты работают на весь почтовый ящик пользователя.
Данные в sql заносятся.
Код: Выделить всё
mysql> select * from quota2;
+-------------------+----------+----------+
| username | bytes | messages |
+-------------------+----------+----------+
| user@dom.com | 10280850 | 2 |
+-------------------+----------+----------+
1 row in set (0.00 sec)
mysql>
Код: Выделить всё
quota_rule2 = Spam:storage=10M
quota_rule3 = Trash:storage=10M
Можно ли сделать независимые исключения, без оглядки на значение quota = dict:user::proxy::quotadict?
Спасибо.
Настройки:
dovecot.conf
Код: Выделить всё
dict {
quota = mysql:/etc/dovecot/dovecot-dict-quota.conf
quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
}
plugin {
autocreate = Drafts
autocreate2 = Sent
autocreate3 = Spam
autocreate4 = Trash
autosubscribe = Drafts
autosubscribe2 = Sent
autosubscribe3 = Spam
autosubscribe4 = Trash
quota = dict:user::proxy::quotadict
}
Код: Выделить всё
driver = mysql
connect = host=localhost dbname=xxx user=xxx password=xxx
default_pass_scheme = CRAM-MD5
user_query = SELECT 8 AS uid, 12 AS gid, CONCAT('*:storage=', quota, 'B') AS quota_rule \
FROM mailbox WHERE username = '%n@%d' AND active='1'
password_query = SELECT username as user, password FROM mailbox WHERE username = '%n@%d' AND active='1'
Код: Выделить всё
connect = host=localhost dbname=xxx user=xxx password=xxx
map {
pattern = priv/quota/storage
table = quota2
username_field = username
value_field = bytes
}
map {
pattern = priv/quota/messages
table = quota2
username_field = username
value_field = messages
}