| Table of Contents |
|---|
In this guide, we'll run you through the installation of QMetry Database, QMetry Test Management application and QMetry Reporting tool on a server without an internet connection. This document contains detailed steps regarding how to download QMetry application’s docker image and Report application’s docker image from the docker repository and how to move them to another machine for installation.
This installation installs QMetry Test Management Application over Apache Tomcat 9.x and Open JDK 11.0.11 in a docker container.
...
- CentOS, RHEL-7 and RHEL-8
- Docker Version 20.10.4
- Docker Compose Version 1.22.0
- Yum-tools
2. Make sure that the docker service has been configured on both QMetry, QMetry DB and Report servers to start automatically on reboot of servers.
3. Three Linux Servers are required: QMetry Database, QMetry Application, and QMetry Reporting tool. These three servers should be on the same network and should be able to communicate with each other. Refer QMetry Deployment Document for the hardware requirements.
4. All the servers should have the support of these commands: unzip, wget, curl, vim and docker.
5. The Internet-enabled machine on which the docker images are downloaded should support the docker command.
6. QMetry and Report Servers should be able to communicate over 80/443 Ports 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. 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.
8. 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.
...
Installation | Ports that need to be enabled |
QMetry Database Server | 3306 |
QMetry Application | 80/443 |
QMetry Reporting Tool | 80/443, 8080, & 33061 |
Download Docker Images of QMetry and Report
Follow these steps on the Internet-enabled machine on which the docker images of QMetry and Report are to be downloaded.
Step 1. Execute the following command. Next, it will ask for docker's credentials. Enter the required credentials. Please contact QMetry Support, if you do not have the credentials.
- docker login
After entering docker credentials, it will show the success message as shown below.
...
- docker pull qmetry/qmetry:qmetry-reports-db
- docker save -o /opt/qtm/qmetryreportdb.tar qmetry/qmetry:qmetry-reports-db
- docker images
Step 7. Transfer the qmetrydb.tar file to QMetry DB server, qmetryapp.tar file to the QMetry application server, qmetryreport.tar and qmetryreportdb.tar files to the Report server.
Install QMetry DB
Follow the steps mentioned below.
Step 1. Download and place QMetryRDS.zip file on QMetry DB server in the same directory of qmetrydb.tar file.
Step 2. On DB server, navigate to the directory where .tar file has been placed and execute the following command.
...
- Username : root
- Password : <user specified password in Step#4>
Install QMetry Application
Follow the steps mentioned below.
Step 1. Download and place QMetryApp.zip file on QMetry application server in the same directory of qmetryapp.tar file.
Step 2. On QMetry application server, navigate to the directory where .tar file has been placed and execute the following command.
...
- sudo docker images
Step 3. Execute following command to unzip the QMetryApp.zip file.
- unzip QMetryApp.zip
- cd QMetryApp
- sudo su
- sh +x qmetry.sh
Step 4. 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.
Options | Comments/Example |
|---|---|
| Please enter QMetry application directory | /opt/qmetryapp |
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 9. 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 Reports
Follow the steps mentioned below.
Step 1. Download and place QMetryReport.zip file on Report server in the same directory of qmetryreport.tar and qmetryreportdb.tar files.
Step 2. On Report server, navigate to the directory where .tar file has been placed and execute the following command.
- sudo docker load -i qmetryreportdb.tar
- sudo docker load -i qmetryreport.tar
Execute the following command to check whether the docker images have been restored correctly or not.
- sudo docker images
Step 3.Execute following command to unzip the QMetryReport.zip file.
- unzip QMetryReport.zip
- cd QMetryReport
- sudo su
- sh +x qmetry.sh
Step 4. Users are required to enter value of required configuration parameters.
Options | Details | Default Value | Example |
Enter Report Database Password (root user) | Enter password for QMetry Reports Database. | - | QMetryreports@!Nf0# |
Enter Report Database Schema | Enter Database schema name for QMetry Reports Database. | qtmanalytics | qtmanalytics |
Enter 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 | 4 | 6 |
Enter Memory to allocate in GB(s) | Entered memory would be used by the sync job while running full sync of data. Enter 3/4th of total memory available on the server. For example, if the memory on the server is 24 GB, enter 18 | 4 | 18 |
...
Options | Details | Example |
Enter Mysql Database Host IP / DNS Name (Qmetry) | Enter Database Host Public IP/DNS of QMetry application. | 10.10.11.100 |
Enter Mysql Database Port (Qmetry) | Enter Database Port of QMetry application. If it is unchanged, use "3306" as Database port. | 3306 |
Enter Mysql Database Schema (Qmetry) | Enter Database schema name of QMetry application. | qmetry |
Enter Mysql Database Username (Qmetry) | Enter Database username of QMetry application. If it is unchanged, use "root" as username. | root |
Enter Mysql Database Password (Qmetry) | Enter Database password of QMetry application. | QMetry@123 |
Enter Mysql Database Host IP / DNS Name (Reports) | Enter Database Host Public IP/DNS of QMetry Report. If it is unchanged, enter 'qmetry-reports-db' as Database Host. | qmetry-reports-db |
Enter Mysql Database Port (Reports) | Enter Database Port of QMetry Report Database. If it is unchanged, enter "3306" as Database Port. | 3306 |
Enter Mysql Database Schema (Reports) | Enter Database schema name of QMetry Reports Database. | qtmanalytics |
Enter Mysql Database Username (Reports) | Enter Database username of QMetry Reports Database. If it is unchanged, use "root" as username. | root |
Enter Mysql Database Password (Reports) | Enter Database password of QMetry Reports Database. | QMetryreports@!Nf0# |
Enter Port To Start SyncJob (Reports) | Reports Sync Job runs from this port - 8080 | 8080 |
Do you want to Run Force Sync Now? (y/n) | Enter y to sync all the QMetry data to Reports Database with the current script. → Always enter y at the time of fresh reports install | Y |
Enter Memory to allocate in GB(s) to Spark | Entered memory would be used by the sync job while running full sync of data. Enter 3/4th of total memory available on the server. For example, if the memory on the server is 24 GB, enter 18 | 18 |
After successful installation of QMetry Report, you will see the message "QMetry Report Installation is complete".
Wait for about 2 minutes - docker ps command should give output as shown below.
...
Note: "Sync Data" is required the first time after reports installation. Time taken to sync depends on the amount of data in QMetry. Sync Progress and Status can be monitored as shown in the below screenshot. QMetry custom reports remain inaccessible during sync and It 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.
