Do you have an example with different quotas using mysql.
These are my config files:
dovecot-sql.conf
password_query = SELECT email AS user, password,
'/home/vmail/%d/%n' AS userdb_home,
'maildir:/home/vmail/%d/%n' AS userdb_mail,
5000 AS userdb_uid,
5000 AS userdb_gid,
CONCAT('maildir:storage=', ROUND(quota/1000) ) AS userdb_quota
FROM users WHERE email = '%u'
user_query = SELECT '/home/vmail/%d/%n' AS home,
'maildir:/home/vmail/%d/%n' AS mail, 5000 AS uid, 5000 AS gid,
CONCAT('maildir:storage=', ROUND(quota/1000) ) AS quota
FROM users WHERE email = '%u'
dovecot.conf
plugin:
quota: maildir:storage=51200:messages=1000:ignore=Trash
trash: /etc/dovecot/dovecot-trash.conf
