QMetry App Upgrade Guide for Linux (from 8.25.2.2 and above to Latest)

On the host machine, run the following command. Replace <password> with the MySQL root password and <date> with the current date. If needed, change the location of the backup file.

docker 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

docker exec qmetryapp_db sh -c 'exec mysqldump -uroot -pqmetry --triggers --routines --hexblob
--single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2021-01-
01.sql

Verify that the database backup was successfully created and is available before proceeding with the upgrade.

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

Download QMetry8290.zip to the QMetry Application Server on the host machine.

On the host machine, list the running containers:

docker ps

If the QMetry containers are not running, run the following commands:

docker start qmetryapp_db
docker start qmetry_app_1

Go to the directory that contains the QMetry8290.zip file.

Copy the upgrade file into the QMetry application container:

docker cp QMetry8290.zip qmetry_app_1:/opt

The current Tomcat installation path inside the Docker container is:

/home/qmetry/QMetry

Log in to the QMetry application container:

docker exec -it qmetry_app_1 bash

Go to the /opt directory where the upgrade file was copied:

cd /opt

Unzip the upgrade package:

unzip QMetry8290.zip

Ensure that the extracted upgrade directory is separate from the current installation path:

/home/qmetry/QMetry

Go to the extracted QMetry upgrade directory:

cd QMetry8290

Grant execute permission to the upgrade script:

chmod +x upgrade_qmetry.sh

Run the upgrade script:

sh upgrade_qmetry.sh

When the script prompts you to confirm, respond as described in the following table:

The upgrade can take some time to complete.

After the upgrade completes successfully, exit the container:

exit

On the host machine, list the running containers:

docker ps

Stop both containers, and then start the database container followed by the application container:

docker stop qmetry_app_1 qmetryapp_db
docker start qmetryapp_db
docker start qmetry_app_1

Verify that both containers are running successfully:

docker ps

Open the QMetry application in a browser.

Log in to confirm that users can sign in.

Confirm that the application works as expected.

Check key application functionality and integrations.

Confirm that QMetry displays version 8.29.0