Displaying 3 results from an estimated 3 matches for "userdbquery".
Did you mean:
userdb_query
2011 Oct 19
1
'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?
...::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 at domain1.com
Quota name Type Value Limit %
User quota STORAGE 0 1048576 0
User qu...
2011 Oct 24
0
[bug] Changing dovecot 'quota' Value incorrectly overwrites Limit with same value
...' 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`(
&...
2011 Oct 28
0
Are you successfully using using SQL queries to manage Dovecot2 Quota Values & Limits?
...ser' 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 PR...