Dear all,
I am attempting to enforce quota with Dovecot 1.2.15-3 using LDA fordeliver. 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@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@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@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 }