[Dovecot] Dovecot2 + Quota

[Robert Schetterer]

Am 31.01.2014 12:41, schrieb drum.lucas at gmail.com:
> Hello!
> 
> I need to configure Quota on Roundcubemail with Dovecot2.
> 
> So, I did:
> 
> 90-quota.conf:
> 
>   # SQL backend:
>   quota = dict:User quota::proxy::sqlquota
>   quota_rule = *:storage=20M:messages=1000
> }
> dict {
>   sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
> 
> }
> 
> OK, works! but, My webmail shows me 20M of quota. But on my Postfixadmin I
> configured 200M.
> 
> How can I fix this?

what about use something like this in

dovecot-sql.conf.ext

user_query = SELECT concat('/usr/local/virtual/', maildir) AS home, \


concat('*:bytes=', mailbox.quota) AS quota_rule, \

#when saving to Trash mailbox the user gets additional 50MB
"Trash:storage=+50240" AS quota_rule2, \
#when saving to Sent mailbox the user gets additional 50MB
"Sent:storage=+50240" AS quota_rule3, \
#when saving to Drafts mailbox the user gets additional 50MB
"Drafts:storage=+50240" AS quota_rule4, \
#when saving to Templates mailbox the user gets additional 50MB
"Templates:storage=+50240" AS quota_rule5, \
#when saving to Junk mailbox the user gets additional 50MB
"Junk:storage=+50240" AS quota_rule6, \
#when saving to Archives mailbox the user gets additional 50MB
"Archives:storage=+50240" AS quota_rule7, \

quota rules are not needed to configured here

but something like

concat('*:bytes=', mailbox.quota) AS quota_rule

fits with dovecot, postfixadmin, squirrelmail at my site

> 
> Att;
> 
> *Lucas Possamai*
> 
> http://about.me/lucaspossamai
> 
> https://www.digitalocean.com/?refcode=25021cb7dbdf
> 



Best Regards
MfG Robert Schetterer

-- 
[*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstraße 15, 81669 München

Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer
Aufsichtsratsvorsitzender: Florian Kirstein