QMetry Online Upgrade Guide for RHEL8 and RHEL 9 using Podman
Note
If you're upgrading to QTM v8.20.0.2, update the Automation API to its latest version.
For more information, refer Install Automation API Feature (RHEL8 and Podman ).
This document is intended for customers running QMetry containers on RHEL 8 or RHEL 9 using Podman. It outlines the steps to upgrade from an older version of QMetry to the latest release. In addition to upgrading QMetry, it also includes the upgrade of Apache Tomcat to version 11.0.5.
The guide provides detailed instructions for backing up the QMetry database, upgrading the application, updating containers, and configuring SSL and Jira integration.
System Requirements and Pre-requisites
Before upgrading, ensure the following:
MySQL version for both QMetry Reports and QMetry Application is 8.0.40.
Internet connectivity is enabled on the server.
QMetry Upgrade Process for RHEL 8 and RHEL 9 using Podman
To upgrade the existing QMetry installation, perform the following steps:
Step 1: Important: Backup the Existing QMetry Database
To backup your existing QMetry database, perform the following steps:
Take a backup of the "qmetry" database. The backup is saved in /opt by default.
Run the following command to replace the username, password, and backup file location.
podman exec qmetryapp_db sh -c 'exec mysqldump -uroot -p<password> --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_<date>.sql
Example 16.podman exec qmetryapp_db sh -c 'exec mysqldump -uroot -pqmetry --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2023-01-01.sql
Verify that the database is backed up and is available.
Step 2: Download the Upgrade Files
Download the required files by following these steps:
Get the latest version of QMetry Upgrade Installer from the QMetry Support Portal.
Download
RHELQMetryAppTomcatUpgrade.zipto the QMetry Application Server on the host machine.
Step 3: Run Upgrade Script
To run QMetry Upgrade, perform the following steps:
To list the running containers, run the following command:
podman ps
If podman is not running, run the following command:
podman start qmetryapp_db podman start qmetry_app_1
Note
Make sure to replace the container names with the appropriate application names as specified in the previous command.
Go to the directory where the RHELQMetryAppTomcatUpgrade.zip file is located and unzip the file RHELQMetryAppTomcatUpgrade.zip on the host machine.
unzip RHELQMetryAppTomcatUpgrade.zip
Go to the extracted QMetry directory.
cd RHELQMetryAppTomcatUpgrade
Run the following command to grant execution permissions to the upgrade script.
chmod +x upgrade.sh
If your QMetry Version is below 8.9.0.3
To validate the name of your existing container and license volume, perform the following steps:
Run the following command to check the Podman volumes' names
podman volume ls
Podman volume name should be qmetry_license.
Run the following command to check the Podman containers' names
podman ps
The Podman container name should be qmetry_app_1.
If the names differ, update the upgrade.sh file with the correct values with these steps:
Open upgrade.sh in edit mode.
Run the following command:
vi upgrade.sh
Update the file with the correct volume and container names.
Press i to change the file mode to insert.
Update the variables according to the existing volume and container name.
exist_license_volume → Value from podman volume ls for license exist_qmetry_container → Value from podman ps for qmetry
Press Esc, and then type:wq to save the changes.
Run the upgrade script:
sh upgrade.sh
The process may take some time to complete. Kindly be patient and allow it to finish properly.
Step 4: Verify QMetry Container Status
List the running containers.
podman ps
Step 5: Login into QMetry
Open the QMetry application in your browser and verify it by logging in.
Step 6: Install or Upgrade QMetry Jira Add-on
Download the correct Jira add-on version that matches your QMetry version. Refer to the table below to find the compatible Jira add-on version based on your QMetry version.
QMetry Version | Jira-addon Version Required |
8.24.x | 2.3.9_jira9 (Jira Version 9x), 2.3.9 (Jira Version 10x) |
8.23.0 | 2.3.7_jira9 (Jira Version 9x), 2.3.7 (Jira Version 10x) |
8.22.1 | 2.3.5 |
8.21.0 | 2.3.3 |
For more information on QMetry Jira Integration, refer to the Steps to Install and Configure the QMetry Jira Integration app .
Reconfiguring SSL After Upgrading QMetry to the Latest Version
If you have configured SSL (https) in Tomcat inside the container, you must configure it in the new container.
If you encounter any issues during the upgrade, please submit a support ticket on the Support Portal.