Displaying 3 results from an estimated 3 matches for "mailbox_user_domain".
2011 Oct 19
1
'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?
...'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 at domain1.com | 1073741824 | 0 | 0 |
| 2 | myuser at domain2.com | 1000000000 | 0 | 0 |
+----+------------------...
2011 Oct 24
0
[bug] Changing dovecot 'quota' Value incorrectly overwrites Limit with same value
...vecot/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('*:byt...
2011 Oct 28
0
Are you successfully using using SQL queries to manage Dovecot2 Quota Values & Limits?
...serdb-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 ...
>> ?...