Dear all,
I have postfix delivering to dovecot lda (via spamassinassin). I
have configured the quota plugin, but it does not seem to respect the
details in the quota table in mysql. The query I have used looks
correct to me, and the user can connect to the database.
I wonder if someone might put me straight on the misconfiguration.
Best wishes, j.
# Relevant portions of dovecot -n:
mail_plugins: quota imap_quota
lda:
log_path:
auth_socket_path: /var/run/dovecot/auth-master
postmaster_address: [email protected]
mail_plugins: sieve quota
plugin:
quota: dict:user::proxy::quotadict
dict:
quotadict: mysql:/etc/dovecot/dovecot-dict-quota.conf
# cat /etc/dovecot/dovecot-dict-quota.conf
connect = host=localhost dbname=fred user=fred password=freddy
map {
pattern = priv/quota/storage
table = quota
username_field = username
value_field = bytes
}
map {
pattern = priv/quota/messages
table = quota
username_field = username
value_field = messages
}
# mysql table
mysql> select * from quota;
+-----------------------------+-----------+----------+
| username | bytes | messages |
+-----------------------------+-----------+----------+
| [email protected] | 19524 | 18 |
| [email protected] | 9420 | 6 |
| [email protected] | 4662 | 4 |
| [email protected] | 19284 | 13 |
| [email protected] | 173906172 | 5702 |
| [email protected] | 10587 | 9 |
| [email protected] | 3695 | 2 |
+-----------------------------+-----------+----------+
7 rows in set (0.00 sec)