dovecot - Jan 2014 - Dovecot2 + Quota

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?

Att;

*Lucas Possamai*

http://about.me/lucaspossamai

https://www.digitalocean.com/?refcode=25021cb7dbdf

On 2014-01-31 12:41, drum.lucas at gmail.com wrote:
> 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?
remove quota_rule

you as shown override postfixadmin with it, still not working ?

i think its explained very well on readmes in postfixadmin

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