[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