Dear List, I cannot overwrite the default quota. In dovecot.conf I have
plugin { quota = maildir:User quota quota = dict:user::proxy::quotadict quota_rule = *:storage=380M:messages=10000 quota_rule2 = Trash:storage=100M }
To overwrite, I put in dovecot-sql.conf
user_query = SELECT CONCAT('/vmail/', maildir) AS home,
CONCAT('maildir:/vmail/', maildir) as mail,
CONCAT('*:bytes=', quota) AS quota_rule
FROM mailbox WHERE username = '%u' AND active = '1'
Debugging dovecot:
imap-login: Login: user=x@y.z, method=PLAIN, rip=a.b.c.d, lip=e.f.g.h IMAP(x@y.z): Loading modules from directory: /usr/local/lib/dovecot/imap IMAP(x@y.z): Module loaded: /usr/local/lib/dovecot/imap/lib10_quota_plugin.so IMAP(x@y.z): Module loaded: /usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so IMAP(x@y.z): Effective uid=101, gid=6, home=/vmail/x.z/x/ IMAP(x@y.z): Quota root: name=user backend=dict args=:proxy::quotadict IMAP(x@y.z): dict quota: user=x@y.z, uri=proxy::quotadict, noenforcing=0 IMAP(x@y.z): Quota rule: root=user mailbox=* bytes=398458880 messages=10000 IMAP(x@y.z): Quota rule: root=user mailbox=Trash bytes=104857600 messages=0 IMAP(x@y.z): Namespace: type=private, prefix=INBOX., sep=., inbox=yes, hidden=no, list=yes , subscriptions=yes
mysql> select CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox where username="x@y.z" and active=1; +-------------------+ | quota_rule | +-------------------+ | *:bytes=800000000 | +-------------------+ 1 row in set (0.00 sec)
What is my mistake? I'm using dovecot 1.1.11
Best regards, Thomas.
On Thu, 2009-05-07 at 11:36 +0200, Thomas Krause wrote:
user_query = SELECT CONCAT('/vmail/', maildir) AS home,
CONCAT('maildir:/vmail/', maildir) as mail,
CONCAT('*:bytes=', quota) AS quota_rule
FROM mailbox WHERE username = '%u' AND active = '1'
Looks correct. My guess is that user_query is never even executed. Set auth_debug=yes and look at the logs what it does.
participants (2)
-
Thomas Krause
-
Timo Sirainen