Dovecot quota via custom column

Filip Bartmann filbar at
Sat Nov 8 16:45:15 UTC 2014

we have multiple domains connected to single user account and we want to have quota counted via this column - called account_id. Users are stored in mysql database.
iterate_query = SELECT email AS user FROM mailboxes
user_query=SELECT email, 501 AS uid, 501 AS gid, CONCAT('*:storage=',quota,'M') AS quota_rule FROM mailboxes AS m WHERE email='%u'
password_query=SELECT email AS user, pw_hash AS password, CONCAT('*:storage=',quota,'M') AS userdb_quota_rule FROM mailboxes AS e WHERE email='%u'
We have quota stored in dovecot dictionary and as usable variables we found only - 

Is there any way to do use account_id as quota username?

Filip Bartmann

More information about the dovecot mailing list