[Dovecot] Dovecot2 + Quota

[drum.lucas at gmail.com]

dovecot-sql.conf:
driver = mysql
connect = host=localhost dbname=mail user=mail password=xxxxxxxxxxxx
default_pass_scheme = MD5

user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'
as mail, 150 AS uid, 12 AS gid, CONCAT('dirsize:storage=', ROUND(
mailbox.quota / 1024 ) ) AS quota FROM mailbox WHERE username = '%u' AND
active = '1'

password_query = SELECT username as user, password, '/var/vmail/%d/%n' as
userdb_home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 150 as userdb_uid,
12 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

90-quota.conf:
## Quota backends
plugin {
  quota = dict:User quota::proxy::sqlquota
}
dict {
  sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}

Postixadmin config.inc.php:

$CONF['maxquota'] = '0';
$CONF['quota'] = 'YES';
$CONF['quota_multiplier'] = '1024000';


I need quota peer user.

Att;

*Lucas Possamai*

http://about.me/lucaspossamai

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


2014-01-31 Benny Pedersen <me at junc.eu>:

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