[Dovecot] Dovecot v2.0.beta3 quota using userdb

20 Feb 2010


      Hello Timo,
I'm playing around with the new Dovecot v2.0.beta3 and don't seem to be
able to get quotas working from userdb. I didn't change the SQL query
which was working for 1.2.10.
Feb 20 19:34:06 ubuntu-test dovecot: auth: sql(test,192.168.156.99):
SELECT home, mail, uid, gid, concat('*:storage=', quota_limit, 'MB') AS
quota_rule FROM users WHERE username = 'test'
...
Feb 20 19:34:06 ubuntu-test dovecot: imap(test): Quota root: name=user
backend=dict args=:proxy::dictionary
Feb 20 19:34:06 ubuntu-test dovecot: imap(test): dict quota: user=test,
uri=proxy::dictionary, noenforcing=0
...
Note there is no "Quota rule".
However it seems to work by adding "quota_rule = *:storage=1024MB"
directly to plugin.conf:
...
Feb 20 19:39:15 ubuntu-test dovecot: imap(test): Quota root: name=user
backend=dict args=:proxy::dictionary
Feb 20 19:39:15 ubuntu-test dovecot: imap(test): Quota rule: root=user
mailbox=* bytes=1073741824 messages=0
Feb 20 19:39:15 ubuntu-test dovecot: imap(test): dict quota: user=test,
uri=proxy::dictionary, noenforcing=0
...
Has there anything changed in dovecot 2.0 in this perspective?
Thanks,
e-frog

# 2.0.beta3: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.31-19-generic-pae i686 Ubuntu 9.10
auth_debug = yes
auth_socket_path = /var/run/dovecot/auth-userdb
deliver_log_format = msgid=%m: from=%f: %$
dict {
dictionary = mysql:/etc/dovecot/dovecot-dict-sql.conf
}
disable_plaintext_auth = no
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
mail_debug = yes
namespace {
hidden = no
inbox = yes
list = yes
location =
prefix =
separator = /
subscriptions = yes
type = private
}
namespace {
location = virtual:/etc/dovecot/virtual:INDEX=~/.maildir/control
prefix = virtual/
separator = /
subscriptions = no
type = private
}
passdb {
args = /etc/dovecot/dovecot-sql.conf
deny = no
driver = sql
master = no
pass = no
}
plugin {
fts = squat
fts_squat = partial=4 full=10
quota = dict:user::proxy::dictionary
sieve = ~/.dovecot.sieve
sieve_before = /etc/dovecot/sieve-global/
sieve_dir = ~/.sieve
}
postmaster_address = postmaster@ubuntu-test
protocols = imap lmtp managesieve
quota_full_tempfail = yes
service managesieve-login {
inet_listener sieve_deprecated {
port = 2000
}
}
service dict {
unix_listener dict {
mode = 0666
}
}
service auth {
unix_listener auth-userdb {
mode = 0666
}
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
}
service lmtp {
unix_listener /var/spool/postfix/lmtp-server {
group = postfix
mode = 0660
user = postfix
}
}
ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_key = </etc/ssl/private/dovecot.pem
userdb {
args = /etc/dovecot/dovecot-sql.conf
driver = sql
}
verbose_proctitle = yes