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)


Reply via email to