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

e-frog e-frog at gmx.de
Sat Feb 20 21:02:41 EET 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 at 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


More information about the dovecot mailing list