Note : This article only applies to QMetry On-Premise installations. For SaaS/Cloud customers these settings are not customizable.
...
- Execute the command : docker ps to view existing dockers running on the server.
- To go the QMetry MySQL Docker execute the command : docker exec -it <docker_name> bash, example : docker exec -it qmetry_rds_1 bash
- Login to QMetry DB, by replacing the username, password in the below commands
- mysql -u[username] -p[password] qmetry -A
- To view the currently set API limits, execute the below query
- SELECT name, value FROM productconfig WHERE name IN ('automationHourlyAPIRequestCount','dailyAPIRequestCount','hourlyAPIRequestCount');
- Turn off SQL safe updates and execute the below queries by replacing the values for the limits to be set.
- SET SQL_SAFE_UPDATES = 0;
- UPDATE productconfig SET value = <set value here> WHERE name ='automationHourlyAPIRequestCount' ;
- UPDATE productconfig SET value = <set value here> WHERE name ='dailyAPIRequestCount' ;
- UPDATE productconfig SET value = <set value here> WHERE name ='hourlyAPIRequestCount' ;
- To check the updated values run the query in Step 3 again.
- exit;
- Restart QMetry Tomcat Services
- Check the running containers using the following command:
- docker ps
- Restart both docker containers using below commands:
- docker stop qmetry_app_1 qmetry_rds_1
- docker start qmetry_rds_1
- docker start qmetry_app_1
- Check the running containers using the following command:
...