On 2014-01-31 13:16, drum.lucas@gmail.com wrote:
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'
i have in dovecot v1
# dovecot v1 format with postfixadmin quotas
user_query = SELECT concat('/home/vmail/', maildir) AS home, concat('/home/vmail/', maildir) AS maildir, 1002 AS uid, 1002 AS gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u'
quotadict is to see used quotas in postfixadmin, damm i know that but forgot it :=)