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: 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)