QMetry Upgrade Guide for RHEL8, RHEL9 and Podman (from v8.16.0.1 and above)

Note

This document is intended for customers running QMetry containers on RHEL 8 or RHEL 9 using Podman. It outlines the steps to upgrade QMetry from an older version to the latest release.

The guide provides detailed instructions for backing up the QMetry database, upgrading the application, updating containers, and integrating Jira.

System Requirements and Pre-requisites

Before upgrading, ensure the following:

  • MySQL version for both QMetry Reports and QMetry Application is 8.0.40.

  • Internet connection is enabled on the server.

Upgrading QMetry for RHEL 8 and RHEL 9 using Podman

To upgrade QMetry to the latest release, perform the following steps:

Step 1: Important: Backing up the Existing QMetry Database

To backup your existing QMetry database, perform the following steps:

  1. Create a backup of the "qmetry" database. By default, the backup is saved in the /opt directory.

  2. Run the following command to update 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 7. 
    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_2021-01-01.sql


  3. Verify that the database is backed up and is available.

Step 2: Downloading the Upgrade Files

Download the required files by following these steps:

  • Get the latest version of QMetry Upgrade Installer from the Support Portal.

  • Download QMetry82411.zip to the QMetry Application Server on the host machine.

Step 3: Running Upgrade Script

To run the upgrade script, perform the following steps:

  1. List the running containers with the following command:

    podman ps

    If podman is not running, use the following command to start it:

    podman start qmetryapp_db
    podman start qmetry_app_1

    Note

    Replace the container names with the correct application names as specified in the previous command.

  2. Go to the directory where the QMetry82411.zip file is downloaded and copy the file inside the app container using the following command:

    podman cp QMetry82411.zip qmetry_app_1:/op

    Note

    Your current Tomcat installed path in the container is /home/qmetry/QMetry.

  3. Log in to the container using the following command:

    podman exec -it qmetry_app_1 bash
  4. Go to the /opt directory where the QMetry82411.zipfile is copied using the command:

    cd /opt
  5. Extract the file to the /opt directory, keeping it separate from the current installation path: /home/qmetry/QMetry.

    unzip QMetry82411.zip
  6. Go to the QMetry directory:

    cd QMetry82411
  7. Grant execution permissions to the upgrade script:

    chmod +x upgrade_qmetry.sh
  8. Run the following command to execute the upgrade script:

    ./upgrade_qmetry.sh
  9. Confirm to upgrade:

    Note

    The process may take some time to complete. Kindly be patient and allow it to finish properly.

    Table 14. Online Installation

    Options

    Allowed Values

    Default Value

    Description

    Do you want to make an online installation? (Y/N)

    Y,y,N,n

    Y

    Enter Y to begin the online upgrade.



  10. After the process completes, use the following command to exit the container:

Step 4: Verifying QMetry Container Status

List the running containers using the following command:

podman ps

Restart both containers using the following commands:

systemctl stop qmetryapp
systemctl stop qmetrydb
systemctl start qmetrydb 

Wait for around 10 seconds, then execute the following command:

systemctl start qmetryapp

Installing or Upgrading 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.

Table 15. Installing or Upgrading QMetry Jira Add-on

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



🔗 If the QMetry Jira Integration app is not installed, follow the Install andConfigure QMetry's Jira Integration App

Publication date: