Hi,

I'm setting up SQL quota usage in Dovecot2.

I've created a MAILBOX parameter table, 'PARAMS', that contains unique <user>@<domain> pairs, with quota data.

mysql> select * from PARAMS;
	+----+------------------------+------------+-------------+------------+
	| ai | MAILBOX_user_domain    | quota      | quota_bytes | quota_msgs |
	+----+------------------------+------------+-------------+------------+
	|  1 |  myuser@domain1.com    | 1073741824 |           0 |          0 |
	|  2 |  myuser@domain2.com    | 1000000000 |           0 |          0 |
	+----+------------------------+------------+-------------+------------+
	2 rows in set (0.00 sec)

I've specified dict usage for quota,

/etc/dovecot/dovecot.conf
	!include conf.d/*.conf
	protocols = imap lmtp
	dict { quota  = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext }

created the maps,

/etc/dovecot/dovecot-dict-sql.conf.ext
	connect = host=/var/run/mysql/mysql.sock dbname=my_db user=my_user

password=my_pass map { pattern = priv/quota/storage table = PARAMS username_field = MAILBOX_user_domain value_field = quota_bytes } map { pattern = priv/quota/messages table = PARAMS username_field = MAILBOX_user_domain value_field = quota_msgs }

assigned the global values and backend,

/etc/dovecot/conf.d/90-quota.conf
	plugin {
		quota = dict:User Quota::proxy::quota
		quota_rule = *:storage=1GB:messages=10000
		quota_rule2 = Trash:storage=+10%%
	}

and specified the user iteration query

/etc/dovecot/sql/virtmail-userdb-sql.cf
	driver = mysql
	connect = host=/var/run/mysql/mysql.sock dbname=my_db user=my_user

password=my_pass user_query = CALL UserDBQuery('%n','%d'); iterate_query = SELECT MAILBOX_user_domain AS user FROM PARAMS;

Verifying operation with with doveadm, I get a result from a !error query,

doveadm quota get -u myuser@domain1.com
	Quota name	Type		Value	Limit	%
	User quota	STORAGE		0 		1048576	0
	User quota	MESSAGE		0		10000	0
doveadm quota get -u myuser@domain2.com
	Quota name	Type		Value	Limit	%
	User quota	STORAGE		0 		1048576	0
	User quota	MESSAGE		0		10000	0

But notice that there's no specificity by *domain*. Despite being provided the full <user>@<domain>, matched to the map,

username_field = MAILBOX_user_domain

the Dovecot dict query seems to ignore the <domain> part, and simply matches on the first of the tow identical <user> parts.

Specifying "-A" doesn't help,

doveadm quota get -A
	Username			Quota name	Type		Value	Limit	%
	myuser@domain1.com	User quota	STORAGE		0 		1048576	0
	myuser@domain1.com	User quota	MESSAGE		0		10000	0
	myuser@domain2.com	User quota	STORAGE		0 		1048576	0
	myuser@domain2.com	User quota	MESSAGE		0		10000	0

What needs to be done to get domain-specificity in the 'doveadm quota get' query?

Is my configuration off, or incomplete, or is this a bug?

Thanks,

Rich