I am trying setting up at virtual domain with quota using postfix and
dovecut.
But I can't get the quota to work, every time I try sending a mail
the following queries is run on the database.
SELECT home, uid, gid FROM mail_view_tmp WHERE account = 'dummy' AND
domain = 'example.com'
SELECT current FROM mail_quota WHERE path = 'quota/storage' AND
username = '(null)'
BEGIN;INSERT INTO mail_quota (current, path, username) VALUES ('quota/
storage', 262, '(null)') ON DUPLICATE KEY UPDATE current = current +
262;COMMIT
The mail is delivered, but the quota for the user is not updated. Instead I just have an other new row for the user (null).
I am using the package dovecot-1.0.rc2p3-mysql on OpenBSD 4.0 for macppc
My configuration:
(posting the full content of alt the config files seemed unnecessary
so I cut out the important bits)
/etc/postfix/main.cf ... virtual_transport = dovecot
/etc/postfix/master.cf : ... dovecot unix - n n - - pipe flags=DRhu user=vmail argv=/usr/local/libexec/dovecot/deliver -d $ {recipient}
/etc/dovecot.conf .... protocol lda { mail_plugins = quota } .. auth default { user = root passdb sql { args = /etc/dovecot-mysql.conf } userdb static { args = uid=2000 gid=2000 home=/var/vmail/%d/%n/ } socket listen { master { path = /var/run/dovecot/auth-master mode = 0600 user = vmail group = vmail } } } dict { quota = mysql:/etc/dovecot-dict-quota.conf } plugin { quota = dict:storage=10240:messages=1000 proxy::quota }
/etc/dovecot-mysql.conf:
driver = mysql
connect = host=localhost dbname=ingoBase user=dovecot password=dovecot
default_pass_scheme = CRYPT
password_query = SELECT password FROM mail_view_dovecot WHERE account
= '%n' AND domain = '%d'
user_query = SELECT home, uid, gid FROM mail_view_tmp WHERE account =
'%n' AND domain = '%d' or account = '%u'
/etc/dovecot-dict-quota.conf connect = host=localhost dbname=ingoBase user=dovecot password=dovecot table = mail_quota select_field = current where_field = path username_field = username
Is there something wrong in my configuration or is this a bug in the
version i am using ?
Thanks in advance !
Andreas