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