Dear all,
I have postfix delivering to dovecot lda (via spamassinassin). Ihave 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: postmaster@test.info 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 | +-----------------------------+-----------+----------+ | root@test.info | 19524 | 18 | | bob@test.info | 9420 | 6 | | test@klunky.co.uk | 4662 | 4 | | bob1@test.info | 19284 | 13 | | bob2@test.info | 173906172 | 5702 | | postmaster@test.info | 10587 | 9 | | bob3@test.info | 3695 | 2 | +-----------------------------+-----------+----------+ 7 rows in set (0.00 sec)