[Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

[Robert Schetterer]

Am 01.02.2014 10:20, schrieb mayu:
> Thanks Benny for your reply . 
> 
> Postfixadmin is reflecting the used quota/assigned quota . Here used quota
> means the message send by each user .Mysql quota2 table is storing the used
> quota and   messages count  (send msg+the welcome message from postfix
> admin).The message count is not adding the inbox mails coming from different
> user .
> 
> I am trying to achieve below stmts:
> 
> 1.When I enter the quota value for each mail box in postfixadmin ,that quota
> value should reflect in squirrel mail .With this every user is aware of its
> quota value . Is it possible ??
> 
> Thanks in advance !!!
> 
> 
> 
> 
> 
> 
> 
> 
> 
> --
> View this message in context: http://dovecot.2317879.n4.nabble.com/Postfixadmin-MySQL-Dovecot-2-and-quota-tp44217p46531.html
> Sent from the Dovecot mailing list archive at Nabble.com.
> 

from former mail to list

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


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