On 2014-01-31 13:16, [email protected] 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 :=)
