Re: [Dovecot] 'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?

I've made some progress, but quota 'Limit' is still not fully functioning for me.

A couple of changes have helped:

Specifying a "%u% as username format,

/etc/dovecot/conf.d/90-quota.conf
	plugin {

•   	quota_rule = *:bytes=1073741824:messages=10000
    	quota_rule2 = Trash:storage=+10%%
    }

using 'username' rather than 'user' in 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`;

•   iterate_query = SELECT `MAILBOX_user_domain` AS username FROM `PARAMS`;

and adding to my user_query,

CREATE PROCEDURE `UserDBQuery`(
	...
	SELECT ...
	  concat('*:bytes=', quota_bytes, ':messages=10000') AS quota_rule,
	  ...

Now, at init,

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

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

and, after sending a single message to 'myuser@domain1.com', I do see that Dovecot now recognizes/calculates a quota change, and only for one domain,

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

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

But, the Limit's wrong. It's not picking up the global Limit from

/etc/dovecot/conf.d/90-quota.conf
	...

--> quota_rule = *:bytes=1073741824:messages=10000 ...

and once a message quota Value is calculated, the Limit is set == Value, resulting in an incorrrect quota %-age of 100%.

Is Limit supposed to be specified per-user?

Rich