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-... 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