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

Reply via email to