[Dovecot] Dovecot2 + Quota

[Benny Pedersen]

On 2014-01-31 13:16, drum.lucas at 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 :=)