Page Comparison

QMetry v8.6 introduces a brand new reporting module. In this guide we will run you through installing QMetry Test Management Reports in your environment.

Pre-requisitesrequisitesr

1. QMetry Reports Installation is supported only on Linux  - Cent OS 7 and 8, and RHEL 7 and 8. No other OS is certified.

2. This installation needs to be done on a server separate from QMetry Application Server. Refer QMetry Deployment Document for server configuration details.

   Server Configs	Small Teams  < 50 Users		Medium Teams < 500 Users		Large Teams 500+ Users
   Min Max	Min	Recommended	Min	Recommended	Min	Recommended
   	Stand Alone Server
   CPU	4 Cores	4 Core	8 Core	16 Core	16 Core	24 - 32 Core
   Memory	8 GB	16 GB	16 GB	24 GB	32 GB	32 - 64 GB
   HDD (Free Space)	100 GB	250 GB	50 GB	100 GB	50 GB	500 GB

   
   

3. Server should have support of commands : unzip, curl, yum, etc.
4. Internet access should be enabled on the server to install using docker.
5. Firewall and selinux must be disabled on the server while installing QMetry Reports.
6. Ensure Proxy Servers are not blocking downloads from the Internet.
7. The Reports Server should be on the same network as the QMetry Application Server. Report server should be able to communicate with the App Server over ports 80/443 and Database port 3306.
8. Ports 80/443, 33061 and 8000 should be open and free on the server and not in use by other applications.
9. Docker install requires root user access.
10. Get the files : Spark_Report_Install.zip by reaching out to QMetry Support by sending an email at qtmprofessional@qmetrysupport.atlassian.net , if you have not received the install files.

Steps to Install QMetry Reports

Step 1 - MySQL bin logs should be enabled on the QMetry DB server

• Connect to the QMetry Application server and execute the below commands: 
  • sudo su -
  • Run command : docker ps to view the list of docker containers.
  • docker exec -it qmetry_rds_1 bash

  • Edit my.cnf file and add the following parameters (if they already exist, do not add them again)

    Code Block
    language sql theme Confluence
    server-id=1 binlog_format=row log_bin=bin.log expire_logs_days=10 max_binlog_size=100M log_bin_index=bin-log.index log_bin_trust_function_creators=1

    
    

  • vi /home/my.cnf - Type i to get into insert mode, and add the above parameters
  • Type Esc and then :wq to save the changes to the file.
• Restart QMetry Services
  • docker stop qmetry_app_1 qmetry_rds_1
  • docker start qmetry_rds_1
  • docker start qmetry_app_1

Step 2 - Connect to QMetry

...

Reports Server and Stop Existing QMetry Reports and Visual Analysis Services

Connect to your existing reports server and run the following commands.

• sudo su -
• Run command : docker ps to view existing report dockers container names and stop them using below commands
• docker stop qmetryreport8X_report_1 qmetryreport8X_discovery_1 (replace X with the actual number seen in container name)

Step 3 - Download and unzip the Reports install files 

Upload the Spark_Report_Install.zip to the /opt directory of the existing report server and unzip it.

• cd /opt
• unzip Spark_Report_Install.zip
• cd Spark_Report_Install/

Step 4 - Run the reports installer file

• chmod +x spark-install.sh
• sh spark-install.sh
• The install script prompts the following options

...

• Go to QMetry > Customization > Insight Configuration
• Enter Host : Reports Server Host Public IP/DNS
• Enter Port : 33061
• Enter Username : root
• Enter Password : qmetryreports@!Nf0#

• Enter Database Name : qtmanalytics

...