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-requisitesr
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 |
Edit my.cnf file and add the following parameters (if they already exist, do not add them again)
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 |
Connect to your existing reports server and run the following commands.
Upload the Spark_Report_Install.zip to the /opt directory of the existing report server and unzip it.
Options | Details | Example |
---|---|---|
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.
Once the script finishes executing it will prompt to enter the following parameters
Options | Details | Example |
---|---|---|
qmetry-host | QMetry DB Host Public IP/DNS | 10.10.11.100 |
qmetry-port | QMetry App MySQL DB Port. Enter 3306, unless QMetry DB port is different | 3306 |
qmetry-schema | QMetry App DB schema name. Enter : qmetry | qmetry |
qmetry-username | QMetry App DB username. Enter : root | root |
qmetry-password | QMetry App DB password. If it is unchanged from default, enter : qmetry | qmetry |
Reports-host | Enter the static docker IP : 10.5.0.7 as the IP address of QMetry Reports server | 10.5.0.7 |
Reports-port | Enter the port where reports DB is running. Enter : 3306 | 3306 |
Reports-schema | Enter the database schema name of QMetry Reports DB - | qtmanalytics |
Reports-username | Enter username of QMetry Reports DB | root |
Reports-password | Enter password of QMetry Reports DB - qmetryreports@!Nf0# | qmetryreports@!Nf0# |
server-port | Reports Sync Job runs from this port - recommended : 8000 | 8000 |
forceSync | Enter y to sync all the QMetry data to Reports DB with the current script. Always enter y at the time of fresh reports install | Type : 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 18 | 18 |
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.
Enter Database Name : qtmanalytics
Test to ensure successful connection and then hit "Test and Save"
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.