upgrade

The following instructions list generic steps which can be used to upgrade from one version of QaTraq Professional to another version. The release notes supplied with a QaTraq Professional package will give any additional specific instructions (release notes can be found in the QaTraq package you download with the file name releaseNotes_x_x.txt).

If wish to upgrade an old version of the standard QaTraq application (now depreciated) to the latest QaTraq Professional version please follow the instructions below and then apply the license file by following the instructions found here.

1. It is recommended that you back up your existing installation of qatraq before embarking on the upgrade. Back up both the attachments directory and the database before you proceed! For example use the following command to back up the database:
   > mysqldump -u <user> -p <password> qatraq > qatraq_20060201.sql
2. All of these commands are executed from the directory ABOVE your existing qatraq installation

1. Install the new QaTraq Package
   Copy qatraq_full_6_10_1.tar.gz to directory above your existing qatraq installation, so that you have the following:
   pwd
   xxx/htdocs/
   
   > ls -ld qatraq*
   drwxrw-rw- 8 nobody nobody 5120 Dec 18 10:22 qatraq
   -rw-r--r-- 1 nobody nobody 1597440 Feb 3 07:20 qatraq_full_6_10_1.tar.gz
   Move the existing qatraq directory to a new name
   > mv qatraq qatraq_old
   Unpack the qatraq_full_6_10_1 release file
   > gunzip qatraq_full_6_10_1.tar.gz
   > tar -xvf qatraq_full_6_10_1.tar
   Alter the permissions of the new qatraq directory
   > chmod 755 qatraq
   Temporarily alter the permissions of the following files and directories
   > chmod 755 qatraq/lib
   > chmod 755 qatraq/includes
   > chmod 755 qatraq/images
   >chmod 755 qatraq/lib/db_params.inc
   
2. Configure the Database Connection
   The file specifying the database parameters (mysql user name and password) is named db_params.php. Edit this file specifying the database parameters (mysql user name and password) using a text editor:
   > vi qatraq/lib/db_params.php  
   
   Or alternatively just copy the db_params.php file from your old installation:
   
   > cp qatraq_old/lib/db_params.php   qatraq/lib/db_params.php
   
   
3. Upgrade the Database
   Make the required database changes with the commands provided below.
   Upgrading from QaTraq version 6.9 to QaTraq 6.10
   You must execute the following sql statements on the qatraq database:
   
   > mysql -u<user> -p<password > qatraq < qatraq/DB/update_69_to_610.sql
   
   Upgrading from QaTraq version 6.8 to QaTraq 6.10
   You must execute the following sql statements on the qatraq database:
   
   > mysql -u<user> -p<password> qatraq < qatraq/DB/update_68_to_610.sql
4. Restore any htaccess configuration files you might have
   Copy any old .htaccess files in to the new installation directories
   > cp ./qatraq_old/.htaccess ./qatraq/.htaccess
   > cp ./qatraq_old/lib/.htaccess ./qatraq/lib/.htaccess
   > cp ./qatraq_old/includes/.htaccess ./qatraq/includes/.htaccess
   > cp ./qatraq_old/images/.htaccess ./qatraq/images/.htaccess
5. Restore attachments
   Copy the attachments in the old qatraq directory to the new qatraq installation
   > cp qatraq_old/attachements/* qatraq/attachements
   Or you could create a link to the old directory if you don't want to recreate all the documents (however, if you do create a link don't forget to copy the documents when you finally delete the old qatraq installation)
   
   Note that the directory permissions for the attachments directory have been tightened up. Directory permissions for the attachments directory should be 766. If you find these permissions prevent you from adding attachments in qatraq then try the following...
   
   Find out which user your apache daemon runs with (e.g. wwwrun)
   > ps -ef | grep apache
   change the ownership of the attachments directory to the same as the httpd daemon user
   > chown wwrun:www qatraq/attachements
   (and yes there is a spelling mistake in the attachments directory name)
   Return the following files and directories to their default permissions
   > chmod 555 qatraq/lib
   > chmod 555 qatraq/includes
   > chmod 555 qatraq/images
   > chmod 555 qatraq/lib/db.inc
   or
   > chmod 755 qatraq/lib/db.php
   or
   > chmod 755 qatraq/lib/db_qatraq.php
6. Restore Reports
   
   If you have created your own reports copy the reports include files in the old qatraq directory to the new qatraq installation
   > cp qatraq_old/reports/<rep_name>.inc qatraq/reports
   Or you could create a link to the old directory if you don't want to recreate all the documents (however, if you do create a link don't forget to copy the reports when you finally delete the old qatraq installation)
   
   
7. Restore License File
   
   You will need to copy the old license file across to the new install of QaTraq
   > cp qatraq_old/licence/* qatraq/licence
   Or if you wish to request and install a new license file you can apply the license file by following the instructions found here.
   
   
8. Remove the old QaTraq Installation
   Either retain the old qatraq installation as a back or delete the old QaTraq installation.
   BE CAREFUL WITH THIS LAST STEP. YOU MAY WANT TO RUN WITH YOUR NEW QATRAQ INSTALLATION FOR A WHILE BEFORE YOU DELETE THE OLD ONE. Also, if you have created a link to your attachments in the old installation don't forget to copy these attachments over first!
   
   > rm -R qatraq_old