Below are the steps to be followed to upgrade your existing QMetry installation :

Step 1 : Download Required Files

• Please write to QMetry Support by sending an Email at qtmprofessional@qmetrysupport.atlassian.net,  to get the latest version of QMetry Upgrade Installer. The QMetryApp.zip contains the QMetry App and DB Upgrade.

• Download the QMetry85x.zip to your QMetry Application Server once you receive it.

Step 2 : IMPORTANT : Backup your existing QMetry Database

Take the backup of your existing “qmetry” database. You can replace username, password, location of backup file (currently default /opt). Replace x with the mysql docker name seen in the output of command : docker ps

• Syntax : docker exec qmetry85x_mysql_1 sh -c 'exec mysqldump -uroot -p<password> --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_<date>.sql
  

• For example: docker exec qmetry85x_mysql_1 sh -c 'exec mysqldump -uroot -pqmetry --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2018-01-01.sql
  
  

Verify that your database has been backed up properly and is available for later use in case of any emergency.

Step 3 : Run the QMetry Upgrade Utility

1. Go to the directory where the zip file is downloaded.

2. Check the running containers using the following command:

• docker ps

3. Copy QMetry8xx.zip file inside the docker container using the following command (replace x with the application container name seen in command above and the upgrade zip received) :

• command : docker cp QMetry8xx.zip qmetry_app_1:/opt
  
  • Note: Your current tomcat installed path in docker container would be /home/qmetry/QMetry. (For QMetry v8.5 or below, the path will be /home/qmetry/QMetry84)
    

4. Log into docker container, using the following command (replace x with the application container name seen in command : docker ps )

• command : docker exec -it qmetry_app_1 bash

5. Go to /opt directory where the QMetry85.zip file is copied using command

• cd /opt

6. Unzip the file under the /opt directory separate from your current installation path /home/qmetry/QMetry84 (replace x with the upgrade package name zip received)

Note: From QMetry v8.5 onward, the path will be /home/qmetry/QMetry

• unzip QMetry8xx.zip
  

7. Go to QMetry directory:

• cd QMetry8xx

8. Give permission to qmetry.sh file through the following command

• chmod +x qmetry.sh

• sh -x qmetry.sh

10. Utility will confirm if you want to upgrade, type Yes, and then specify the path of existing QMetry installation.

Wait for the process to complete.

11. Exit from docker container once the process is completed, use the following command:

• exit

Step 4 :Additional Tomcat and MySQL Configuration (Mandatory)

QMetry is installed with a default configuration of minimum and maximum heap memory utilization. You should modify these settings depending on your hardware configuration. Refer Additional Configuration for more details.

Step 5 : Restart QMetry and MySQL Docker Container

• Check the running containers using the following command:
  • docker ps
• Restart both docker containers using below commands:
  
  • docker stop qmetry_app_1 qmetry85_mysql_1
  • docker start qmetry85_mysql_1
  • docker start qmetry_app_1
• Note : In case you have configured Redis Caching for QMetry installed on same server OR a separate server - connect to that server and run the below commands :
  • To view existing containers : docker ps
  • Replace the container name seen in above command : docker exec -it container-name redis-cli FLUSHALL

Step 6 : Set up report configuration

At this point you should be able to login to the QMetry application. Verify your data. You should be on the latest version of QMetry.

If you have already set up the QMetry reporting server, the following settings are required to be done once. 

• Login using "Admin" User >> Go to Profile and Edit the Profile.
• Update QMetry Base URL and Report Server URL
  

Upgrade your Jira add-on as per the above compatibility matrix. In case you have not installed the Jira Integration - QMetry Enterprise add-on for integration, follow the Steps to Install and Configure the Jira Integration - QMetry Enterprise add-on, if it is not installed.