[Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

[mayu]

Hi ,

I have a same problem what Matt has faced but the soln u provided to Matt
was not helpful for me  .

I am using Postfixadmin ,Dovecot ,Squirrel ,postfix and check_quota plugin
for showing quota value .

The mysql table is fetching the data stored in postfixadmin ,But squirrel in
not fetching the quota value .If I add this line: 
>  quota_rule = *:storage=1G 
>in conf.d/90-quota.conf file, it works, I mean squirrelmail gets and 
>shows information (but not the one stored in db of course). 




Daniel Parthey wrote
> Hi Matt,
> 
> sounds like the quota is correctly updated in MySQL, but your roundcube
> isn't able to fetch quota information via IMAP.
> 
> Can you reproduce this via telnet or another IMAP client (e.g. Thunderbird
> with Quota Display Extension)?
> 
> Can you be so kind and post your whole dovecot config (doveconf -n)?
> 
> Are there any error messages in your dovecot logs regarding quota?
> 
> I think that quota_rule, quota_rule2, quota_rule3 etc. are applied in
> sequence, so if you only need one quota_rule, then it should be named
> quota_rule.
> 
> Regards
> Daniel
> 
> 
> 
> Matt <

> dovecot@

> > schrieb:
>>Hi all,
>>
>>I'm setting up a new email server based on the softwares list below:
>>
>>  * Postfix
>>  * Dovecot 2.0.9
>>  * MySQL
>>  * Postfixadmin 2.3.6
>>
>>My current problem is I'm unsure whether quota feature is well
>>configured or not.
>>In order to test and validate, I use Roundcubemail GUI which provides
>>percentage of the space used by the mailbox (quota should be applied
>>per
>>mailbox).
>>
>>Here, my dovecot configuration:
>>dovecot.conf:
>>dict {
>>  quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
>>}
>>
>>dovecot-dict-quota.conf:
>>connect = host=localhost dbname=postfix user=postfix password=postfix
>>map {
>>    pattern = priv/quota/storage
>>    table = quota2
>>    username_field = username
>>    value_field = bytes
>>}
>>map {
>>    pattern = priv/quota/messages
>>    table = quota2
>>    username_field = username
>>    value_field = messages
>>}
>>
>>dovecot-sql.conf.ext:
>>driver = mysql
>>connect = host=localhost dbname=postfix user=postfix password=postfix
>>default_pass_scheme = PLAIN-MD5
>>password_query = SELECT username AS user, password, \
>>    CONCAT('*:storage=', CAST(quota AS CHAR), 'b') AS quota_rule \
>>    FROM mailbox WHERE username = '%u' AND active='1'
>>user_query = SELECT maildir, 89 AS uid, 12 AS gid, \
>>    concat('dict:storage=',floor(quota/1000),'::proxy::quotadict') AS
>>quota, \
>>    CONCAT('*:storage=', CAST(quota AS CHAR), 'b') AS quota_rule \
>>    FROM mailbox WHERE username = '%u' AND active='1'
>>
>>conf.d/90-quota.conf:
>>plugin {
>>  quota = dict:user::proxy::quotadict
>>  quota_rule2 = Trash:storage=+10%%
>>}
>>
>>conf.d/20-imap.conf:
>>protocol imap {
>>  mail_plugins = $mail_plugins imap_quota
>>}
>>
>>When I check postfixadmin GUI, I can see that quota in realtime in
>>quota2 table, no problem.
>>
>>But Roundcubemail cannot get this information and shows a unknown
>>quota.
>>If I add this line:
>>  quota_rule = *:storage=1G
>>in conf.d/90-quota.conf file, it works, I mean roundcubemail gets and
>>shows information (but not the one stored in db of course).
>>
>>I think I'm close to the right configuration but I need your help to
>>complete this setup.
>>
>>Thank you in advance for your help.
>>
>>Best,
>>Matt





--
View this message in context: http://dovecot.2317879.n4.nabble.com/Postfixadmin-MySQL-Dovecot-2-and-quota-tp44217p46523.html
Sent from the Dovecot mailing list archive at Nabble.com.