QMetry 8.25.2 Upgrade Guide

Note

Starting with QMetry 8.25.2, all QMetry components for installation and upgrades are bundled into a single zip file.

Use upgrade.sh for upgrading from an older version to 8.25.2 and above.

Pre-Upgrade: BackupYour Database

Before proceeding, back up the existing QMetry database. Adjust the username, password, and backup file location as needed (default location is /opt).

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

Replace <password> with your MySQL root password and <date> with the current date.

Example 6.

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

Steps to Upgrade MySQL

Step 1: Stop QMetry Services

Stop QMetry app and report containers by running the following commands:

systemctl stop qmetryapp
systemctl stop qmetryreports

Step 2: Transfer and Extract the Installer

# Copy QMetry_RHEL_Installer.zip to your server, then:
unzip QMetry_RHEL_Installer.zip
cd QMetry_RHEL_Installer
ls -ltr

Step 3. Run the Upgrade Script

chmod +x upgrade.sh
2 sh upgrade.sh

Step 4. Select Online Upgrade

When prompted:

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

Type Y and press Enter.

Step 5: Navigate the Upgrade Menu

You will see the following menu:

1 ========== QMetry Upgrade Menu ==========
2 1. QMetryApp DB
3 2. QMetryApp
5. Upgrade Components in Sequence
Upgrade each component one at a time in the following order:
Important: After each component finishes upgrading, the menu will reappear.
Enter the next number in the sequence above.
6. Exit
Once all components are upgraded, enter 0 to exit the upgrade menu.
4 3. QMetry Report
5 4. QMetry Redis
6 5. QMetry ActiveMQ
7 6. QMetry BDD
8 7. QMetry Automation
9 0. Exit
10 =========================================
11 Enter your choice

Step 6: Upgrade Components in Sequence

Upgrade each component one at a time in the following order:

Step/Order	Enter	Component	Notes
1	1	QMetryApp DB	Upgrades MySQL App DB to version 8.4.8
2	2	QMetryApp	Upgrades the main application container
3	4	QMetry Redis	Upgrades Redis
4	5	QMetry ActiveMQ	Upgrades ActiveMQ
5	7	QMetry Automation	Upgrades the Automation component

Important

After each component finishes upgrading, the menu will reappear. Enter the next number in the sequence above.

Step 7. Exit

Once all components are upgraded, enter 0 to exit the upgrade menu.

In this section: