[Dovecot] Dovecot v2.0.beta3 quota using userdb
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 =
On Sat, 2010-02-20 at 20:02 +0100, e-frog wrote:
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.
I guess I broke it with the recent config changes. Or maybe earlier. I'll look into it tomorrow..
On Sat, 2010-02-20 at 20:02 +0100, e-frog wrote:
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.
Fixed: http://hg.dovecot.org/dovecot-2.0/rev/ba19f3c077a8
Looks like this has always been broken. Wonder why I never noticed it.
Symptons are the ones we described earlier but It was not working on 1.2.10 for me until I set quota_rule on password_query.
On Mon, Feb 22, 2010 at 2:12 PM, Timo Sirainen tss@iki.fi wrote:
On Sat, 2010-02-20 at 20:02 +0100, e-frog wrote:
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.
Fixed: http://hg.dovecot.org/dovecot-2.0/rev/ba19f3c077a8
Looks like this has always been broken. Wonder why I never noticed it.
[ ]'s Aledr - Alexandre "OpenSource Solutions for SmallBusiness Problems"
I guess you mean you added userdb_quota_rule on password_query, because you were using userdb prefetch.
On 22.2.2010, at 19.19, aledr wrote:
Symptons are the ones we described earlier but It was not working on 1.2.10 for me until I set quota_rule on password_query.
On Mon, Feb 22, 2010 at 2:12 PM, Timo Sirainen tss@iki.fi wrote:
On Sat, 2010-02-20 at 20:02 +0100, e-frog wrote:
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.
Fixed: http://hg.dovecot.org/dovecot-2.0/rev/ba19f3c077a8
Looks like this has always been broken. Wonder why I never noticed it.
[ ]'s Aledr - Alexandre "OpenSource Solutions for SmallBusiness Problems"
Timo Sirainen wrote:
On Sat, 2010-02-20 at 20:02 +0100, e-frog wrote:
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.
Fixed: http://hg.dovecot.org/dovecot-2.0/rev/ba19f3c077a8
Looks like this has always been broken. Wonder why I never noticed it.
Hmm. This patch doesn't seem to fix it for me. There is still no "Quota rule" in the logs as before...
On Mon, 2010-02-22 at 21:39 +0100, e-frog wrote:
Hmm. This patch doesn't seem to fix it for me. There is still no "Quota rule" in the logs as before...
This should finally fix it: http://hg.dovecot.org/dovecot-2.0/rev/ce166f70ea71
On 09.03.2010 16:00, wrote Timo Sirainen:
On Mon, 2010-02-22 at 21:39 +0100, e-frog wrote:
Hmm. This patch doesn't seem to fix it for me. There is still no "Quota rule" in the logs as before...
This should finally fix it: http://hg.dovecot.org/dovecot-2.0/rev/ce166f70ea71
Sorry, for the late reply ...
Yes, this fixes it. Thanks Timo!
participants (3)
-
aledr
-
e-frog
-
Timo Sirainen