In this guide, we'll run you through installing QMetry Database, QMetry Test Management application and QMetry Reporting Tool in a 3 Tier Architecture. 

3 Tier Install 

Pre-requisites

For additional information on verifying pre-requisites refer this article. This installation installs QMetry over Apache Tomcat 9.x, MySQL v5.7.29 and Open JDK 11.0.11 in a docker container.

1. QMetry Installation is supported only on Linux  - CentOS 7 and 8, and RHEL 7 and 8. No other OS is certified for QMetry Installation.
2. Three Linux Servers are required: QMetry Database, QMetry Application, and QMetry Reporting tool. These three servers should be on the same network and able to communicate with each other. Refer QMetry Deployment Document for the requirements. All the servers should have the support of these commands: unzip, wget, curl and vim.
3. Internet access should be enabled on all 3 servers to install using docker.
4. Firewall and selinux must be disabled on the server while installing QMetry and Reports.
5. Ensure Proxy Servers are not blocking downloads from the Internet.
6. Application, DB and Report servers should be in the same network. QMetry and Report Servers should be able to communicate over 80/443 and Database Server 3306/DB Ports. Ports 8080 and 33061 should be enabled/open on Reports Server to allow connections from QMetry application server.
7. The ports 80/443 and 3306 on the respective servers should be free and should not be in use by other applications. QMetry App server should be able to communicate with the reports server on port 33061.
8. 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.

9. By default, docker is managing storage under “/var/lib/” directory on the host machine. It will also ask for storage location of QMetry application’s file related data during the installation of QMetry. Hence, make sure that both the directories have required disk space available as per usage requirement of QMetry application.

10. Get the following files from QMetry Support : QMetryApp.zip, QMetryRDS.zip, QMetryReport.zip and docker credentials required for installation. Post-installation, QMetry Application and Report tool both should be configured either on https or http.
11. 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.
12. Following Ports should be open:

Install QMetry DB

Follow the steps mentioned below.

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

• sudo su
• unzip QMetryRDS.zip
• cd QMetryRDS 
• chmod +x qmetry.sh
• sh qmetry.sh

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

Step 2. Once the script finishes executing, it will prompt to enter the following parameters:

After successful installation of QMetry DB, you will see the message "QMetry RDS Installation is complete".

Step 3. Execute the following commands. 

• docker exec -it qmetry_rds_1 bash

• mysql -uroot -p; 
• GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; 

Once the script finishes executing, check if MySQL docker is available with the name: qmetry_rds_1 - when you run the docker ps command.

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

• Username : root
• Password : <user specified password in Step#2>

Install QMetry Application

Follow the steps mentioned below.

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

• sudo su
• unzip QMetryApp.zip
• cd QMetryApp

Step 2. Execute the following command.

• chmod +x qmetry.sh
• sh qmetry.sh

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

Step 3. Next, the installation process will prompt for directory path on the host machine to store QMetry application’s file related data like attachments, license, import, export files etc. You can enter any path of the host machine to store QMetry application’s file related data. If the mentioned directory does not exist on the given path, it will get created automatically during the installation process.

Note: It is highly recommended to take periodic backup of the directory which is specified as a location to store QMetry application’s file related data to prevent any data loss in case of any disaster.

Step 4. Once the script finishes executing, it will prompt to enter the following parameters:

The installation may take a while.

After successful installation of QMetry Application, you will see the message "QMetry Application Installation is complete".

Once the installation is complete, execute the following command.

• docker ps

Step 5. 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 a 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 the 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 6. Access the QMetry application using the following address.

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

Default QMetry login credentials.

• Username: admin
• Password:<user specified password in Step#4>

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

• Username : root
• Password : <user specified password in Step#4>
• Schema : <user specified Schema in Step#4>
  

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

Step 7. 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 the Base URL as your QMetry URL.

Step 8. 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.

Install QMetry Report

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

Follow the steps mentioned below.

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

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

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

Step 2. Run the reports installer file

• chmod +x qmetry.sh
• sh qmetry.sh

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

Step 3. Once the installation initiates, it will prompt to enter the following parameters:

Wait for the script file to finish executing.

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

After successful installation of QMetry Report, you will see the message "QMetry Report Installation is complete".

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 y when prompted for a force sync.

Wait for the script to finish executing.

After waiting for about a minute, command docker ps should return the following: 

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: <user specified password in Step#3>

  • Enter Database Name: <user specified name in Step#3>

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 the 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.

Install Redis Caching Server

QMetry is providing the capability of installing the 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, kindly generate a support ticket on Support Portal for assistance.