dovecot - May 2009 - Overwriting user Quota

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.

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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20090511/5ba21696/attachment-0002.bin>