[Dovecot] mail quota dovecot 1.2.15-3

J4 junk4 at klunky.co.uk
Wed Jan 12 13:14:50 EET 2011


Dear all,

    I am attempting to enforce quota with Dovecot 1.2.15-3 using LDA for
deliver.  I use smtp-source (postfix) to deliver large messages but the
quota is never noticed.  The webmail interface is Roundcube, and the
admin is performed using Postfixadmin.  I have not looked into the
postfix portion for quota, yet.  Is there something that I have missed
from the configuration?  (The contents of relevant the mysql tables are
included)

Best wishes,
J.


# 1.2.15: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.32-cgmemcap-smack x86_64 Debian squeeze/sid ext4
log_timestamp: %Y-%m-%d %H:%M:%S
ssl_listen: *:993
ssl: required
ssl_cert_file: /etc/ssl/certs/smtpd.crt
ssl_key_file: /etc/ssl/private/smtpd.key
login_dir: /var/run/dovecot/login
login_executable: /usr/lib/dovecot/imap-login
first_valid_uid: 106
mail_privileged_group: mail
mail_location: maildir:/var/vmail/%d/%u/
maildir_very_dirty_syncs: yes
mbox_write_locks: fcntl dotlock
mail_plugins: quota imap_quota
lda:
  log_path:
  auth_socket_path: /var/run/dovecot/auth-master
  postmaster_address: postmaster at test.info
  mail_plugins: sieve quota
auth default:
  mechanisms: plain login
  passdb:
    driver: pam
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-mysql.conf
  userdb:
    driver: passwd
  userdb:
    driver: static
    args: uid=5000 gid=5000 home=/var/vmail/%d/%n allow_all_users=yes
  userdb:
    driver: sql
    args: /etc/dovecot/dovecot-mysql.conf
  socket:
    type: listen
    client:
      path: /var/spool/postfix/private/auth
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail
plugin:
  quota: dict:user::proxy::quotadict
dict:
  quotadict: mysql:/etc/dovecot/dovecot-dict-quota.conf



 select * from mailbox;
+--------------------------+------------------------------------+--------------+---------------------------+----------+------------+------------------+---------------------+---------------------+--------+
| username                 | password                           |
name         | maildir                   | quota    | local_part |
domain           | created             | modified            | active |
+--------------------------+------------------------------------+--------------+---------------------------+----------+------------+------------------+---------------------+---------------------+--------+
| 11 at test.info   | $1$abc111kdddjkfsdhfjksdhfj. |  TEST   |
test.info/11/   |  1024000 | 11      | test.info | 2011-01-07 14:19:03 |
2011-01-12 11:34:32 |      1 |
+--------------------------+------------------------------------+--------------+---------------------------+----------+------------+------------------+---------------------+---------------------+--------+

select * from quota;
+-----------------------------+-----------+----------+
| username                    | bytes     | messages |
+-----------------------------+-----------+----------+
| 11 at test.info      | 173879747 |     5689 |

quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
## dovecot-dict-quota.conf
connect = host=localhost dbname=mail user=mail password=fred
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
}




More information about the dovecot mailing list