[Dovecot] Overwriting user Quota
Thomas Krause
toaster at chef-ingenieur.de
Thu May 7 12:36:41 EEST 2009
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 at y.z>, method=PLAIN, rip=a.b.c.d, lip=e.f.g.h
IMAP(x at y.z): Loading modules from directory: /usr/local/lib/dovecot/imap
IMAP(x at y.z): Module loaded:
/usr/local/lib/dovecot/imap/lib10_quota_plugin.so
IMAP(x at y.z): Module loaded:
/usr/local/lib/dovecot/imap/lib11_imap_quota_plugin.so
IMAP(x at y.z): Effective uid=101, gid=6, home=/vmail/x.z/x/
IMAP(x at y.z): Quota root: name=user backend=dict args=:proxy::quotadict
IMAP(x at y.z): dict quota: user=x at y.z, uri=proxy::quotadict, noenforcing=0
IMAP(x at y.z): Quota rule: root=user mailbox=* bytes=398458880 messages=10000
IMAP(x at y.z): Quota rule: root=user mailbox=Trash bytes=104857600 messages=0
IMAP(x at 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 at 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.
More information about the dovecot
mailing list