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*
https://www.digitalocean.com/?refcode=25021cb7dbdf
2014-01-31 Benny Pedersen <me@junc.eu>:
On 2014-01-31 12:41, drum.lucas@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