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
