QMetry and Reports Installation - 2 Tier


In this guide we'll run you through installing QMetry Test Management application and QMetry Reports on your environment. 

2 Tier Install 

Server 1QMetry App and MySQL DB
Server 2QMetry Reports

Pre-requisites for QMetry Application

For additional information on verifying pre-requisites refer this article.

  1. QMetry Installation is supported only on Linux  - Cent OS 7 and 8, and RHEL 7 and 8. No other OS is certified for QMetry Installation.
  2. Two Linux Servers are required: One for QMetry Application and the other or QMetry Reporting.
  3. Refer QMetry Deployment Document for the hardware requirements.
  4. All the servers should have support of these commands: unzip, yum and curl.
  5. Internet access should be enabled on both the servers to install using docker.
  6. Firewall and selinux must be disabled on the server while installing QMetry and Reports.
  7. Ensure Proxy Servers are not blocking downloads from the Internet.
  8. Application and Report servers should be in the same network. Report Server should be able to communicate with Application Server over 80/443 and Database Server 3306/DB Port. Ports 8080 and 33061 should be enabled/open on Reports Server to allow connections from QMetry application server.
  9. Docker installation requires root user access. To install using a non-root user, follow the steps specified here before starting the install on both QMetry and Report servers.
  10. Docker is installed under /var/lib/ directory. We recommend allocating enough space here to ensure QMetry has enough space to save your data.
    • Data of QMetry database is saved under : /var/lib/docker/volumes/qmetry_mysql_data/_data
    • Data of QMetry attachments added is saved under : /var/lib/docker/volumes/qmetry_attachment/_data
  11. Get the following files from QMetry Support : QMetryApp.zip, Spark_Report_Install.zip & docker credentials required for installation.
  12. Post installation QMetry Application and QMetry Report both should be configured either on https or http.
  13. If you are planning Jira integration with QMetry and Jira is running on https, make sure your QMetry is also running over https protocol. QMetry and Jira should run on the same protocol.
  14. Following Ports should be open:
InstallationPorts that need to be enabled and should be available for use
QMetry Application80/443 & 3306
QMetry Reporting Tool80/443, 8080 & 33061

Installing QMetry Application

Hardware Requirements 

Supported OS : Linux - Cent OS 7 and 8, RHEL 7 and 8

 

Small Teams 

< 50 Users

Medium Teams

< 500 Users

Large Teams

500+ Users

 

Min

Recommended

Min

Recommended

Min

Recommended

 

Stand Alone Server

CPU

2 Cores

4 Core

8 Core

12 Core

16 Core

24 Core

Memory

8 GB

16 GB

16 GB

24 GB

24 GB

32 - 64 GB

HDD (Free Space)

100 GB

250 GB

100 GB

500 GB

100 GB

500 GB

This is the most straightforward way to get your production site up and running on a Linux server.

Step 1. Copy the QMetryApp.zip installation file received from QMetry Support to your server. Navigate to the directory where this file is kept and execute the following commands.

  • unzip QMetryApp.zip

Step 2. Execute the following commands.

  • sudo su
  • chmod +x qmetry85-install.sh
  • sh -x qmetry85-install.sh

       You will be asked for credentials. Enter docker credentials shared as a part of installation package.

The installation may take a while. Once the installation is complete, execute the following command.

  • docker ps

The docker containers installed will be shown along with their container IDs and names.


Step 3. Getting your QMetry License and Installing it.

  1. For users evaluating QMetry
    • You should have received an evaluation license valid for 30 days along with the installation.
  2. For users requiring commercial license
    • Server's domain name and mac address are required to generate your QMetry License. Follow the below steps to get your server mac address and send this information along with the domain name to QMetry Support to get your QMetry License generated. Send an email to qtmprofessional@qmetrysupport.atlassian.net to reach QMetry Support.
      • Execute the below command to get your server mac address. Then send the MAC address to QMetry Support to receive license file.
        • ifconfig (MAC address of Ethernet card e.g. eth0/eth1 )
      • Once you receive license.key from QMetry Support, you can follow the Steps to Apply License file.

Step 4. Access QMetry application using the following address.

http://<your IP Address OR Domain Name>

Default QMetry login credentials.

  • Username: admin
  • Password: qmetry@123

Note : With installation, MySQL 5.7.29 will be installed on port 3306. Below are the details

  • Username : root
  • Password : qmetry
  • Schema : qmetry

Note : This installation installs QMetry over Apache Tomcat 9.x, MySQL 5.7.29 and Open JDK 11 in a docker container.

Step 5. After the above steps are completed, log into QMetry application.

  • Go to "Admin" Profile and Edit the Profile.
  • Update Email of Admin in the Email field.
  • Enter Base URL as your QMetry URL.



Step 6. Additional Tomcat Configuration: QMetry is installed with a default configuration of minimum and maximum heap memory utilization. You can modify these settings depending on your hardware configuration. Refer Additional Configuration for more details.

Installing QMetry Reporting

If you have purchased Advanced Reporting then you will need a separate server for QMetry Reporting.

This step we'll run you through installing QMetry Test Management Reports in your environment.

Hardware Configurations Recommended

Supported OS : Linux - Cent OS 7 and 8, RHEL 7 and 8

 Server Configurations

Small Teams  < 50 Users

Medium Teams < 500 Users

Large Teams  500+ Users

Stand Alone Server

 

Min

Recommended

Min

Recommended

Min

Recommended

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

Steps to Install QMetry Reports

Step 1 - Connect to Report Server and Download the file. 

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

  • sudo su -
  • cd /opt
  • unzip Spark_Report_Install.zip
  • cd Spark_Report_Install/

Step 2 - Run the reports installer file

  • chmod +x spark-install.sh
  • sh spark-install.sh
  • The install script prompts the following options
OptionsDetailsExample
Number of CPU's to allocate

Allocate 3/4th of the available CPUs. For example if CPU has 8 cores, enter 6

To check total CPUs, run the command : lscpu

6
Memory to allocate in GB(s)

Allocate 3/4th of total memory on server. For example for 24GB, enter 18

To check total memory, run the command : free -h

18

Wait for the script file to finish executing.

Step 3 - Add reports configuration to the apps file by executing it

  • cd /var/lib/docker/volumes/spark_report_spark-apps/_data
  • sh ConfigureSyncApp.sh 

Once the script finishes executing it will prompt to enter the following parameters

OptionsDetailsExample
Enter Mysql Database Host IP / DNS Name (Qmetry)
QMetry DB Host Public IP/DNS10.10.11.100
Enter Mysql Database Port (Qmetry)
QMetry App MySQL DB Port. Enter 3306, unless QMetry DB port is different3306
Enter Mysql Database Schema (Qmetry)
QMetry App DB schema name. Enter : qmetryqmetry
Enter Mysql Database Username (Qmetry)
QMetry App DB username. Enter : rootroot
Enter Mysql Database Password (Qmetry)
QMetry App DB password. If it is unchanged from default, enter : qmetryqmetry
Enter Mysql Database Host IP / DNS Name (Reports)
Enter the static docker IP : 10.5.0.7 as the IP address of QMetry Reports server10.5.0.7
Enter Mysql Database Port (Reports)
Enter the port where reports DB is running. Enter : 3306

3306

Enter Mysql Database Schema (Reports)
Enter the database schema name of QMetry Reports DB - qtmanalytics
Enter Mysql Database Username (Reports)
Enter username of QMetry Reports DBroot
Enter Mysql Database Password (Reports)
Enter password of QMetry Reports DB - qmetryreports@!Nf0#qmetryreports@!Nf0#
Enter Port To Start SyncJob (Reports)
Reports Sync Job runs from this port - 80808080
Do you want to Run Force Sync Now ? (y/n)
Enter to sync all the QMetry data to Reports DB with the current script. Always enter y at the time of fresh reports installType : y
Enter Memory to allocate in GB(s) to Spark
Entered memory would be used by the sync job while running a full sync of data. Enter 3/4th of total memory available on server. For example, if memory on server is 24 GB, enter 1818

Note: In cases when you need to force sync to re-sync any missing data, just repeat step 3, and skip qll parameter details (by hitting enter) and just enter when prompted for a force sync.

Wait for the script to finish executing.

Wait for about 2 minutes - docker ps command should give output as follows :

Step 4 - Restart Reports Services

  • docker restart qmetry-reports qmetry-reports-db

 Step 5 - Login to QMetry with 'admin' user login, and configure the reports server URL in the configuration menu

Go to QMetry > Customization > Insight Configuration

  • Under Database Configuration tab
    • Enter Host : Reports Server Host Public IP/DNS
    • Enter Port : 33061
    • Enter Username : root
    • Enter Password : qmetryreports@!Nf0#
    • Enter Database Name : qtmanalytics

Click Test to ensure successful connection and then hit "Test & Save"

  • Under Sync Data tab, setup the Report Data Sync from your reports server to QMetry Reporting. 
    • Report Server URL : This should be set to your report server domain URL followed by port 8080 as shown below. Ensure port 8080 is open on the reports server.
    • Click on Test to ensure successful connection and then hit "Test & Save".
    • Hit "Sync Data" to start Reports Data Sync.

Note : "Sync Data" is required first time after reports installation. Time taken to sync depends on amount of data in QMetry. Sync Progress and Status can be monitored as shown in the below screenshot. QMetry custom reports remain inaccessible during a sync in progress and is recommended to be run only during off-peak hours.

Users can start using QMetry Reports when the sync is completed. QMetry remains available during this time.



Installing Redis Caching Server

QMetry is providing capability of installing Redis server. Overall performance and scalability can be improved using Redis caching. To install the Redis Server, refer to Installing Redis Caching Server.

If you are facing any issues during the installation process, write us at qtmprofessional@qmetrysupport.atlassian.net. This will automatically open a ticket with our support team and help you to follow the progress.