Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Note : This article only applies to QMetry On-Premise installations. For SaaS/Cloud customers these settings are not customizable. 

...

  1. 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
  2. Login to QMetry DB, by replacing the username, password in the below commands
    • mysql -u[username] -p[password] qmetry -A
  3. To view the currently set API limits, execute the below query
    • SELECT name, value FROM productconfig WHERE name IN ('automationHourlyAPIRequestCount','dailyAPIRequestCount','hourlyAPIRequestCount');
  4. 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; 
  5. 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

...