You will need to be running a linux distro (e.g. SuSE 9.3) or Unix release (e.g. Solaris 10) along with the following components in order to run QaTraq (these components usually come pre-installed with most Linux distros). If you are going to be installing on Solaris please contact us first as there are some points we can advise you on.
Please note that Apache processes and script names can differ between different unix and linux distributions. Some examples of these differences can be found below:
Init Script
App Location
Deamon Name
Document Root
Suse 9*
/etc/init.d/apache2
/usr/sbin/httpd2
httpd2
/srv/www/htdocs/
RedHat 8
/etc/init.d/apache
/usr/sbin/httpd
httpd
/var/www/htdocs
Gentoo
/etc/init.d/apache2
/usr/sbin/apache2
httpd2
/var/www/localhost/htdocs
Others
/usr/local/apache/htdocs/
* - used in this document
We have stuck to the defaults present in Suse 9 for the purpose of this install document. If you are running a different distribution you may find you need to refer to a different set of Apache defaults given in the list above. Unfortunately It’s never quite as simple as it could be with Linux!
1. Check System Requirements
Check
Action
Command
Confirm Apache (version 1.3 or greater)
/usr/sbin/httpd2 –v
Confirm Php (version 4.4 or greater)
php -v
Confirm MySql (version 4.1 or greater)
mysqladmin -u<user> -p version
Note: In order to avoid errors that are currently being reported with Php 5.3 we recommend using Php and Mysql versions: Php 5.2 / Mysql 5.1
cp qatraq_pro_7_0_0.tar.gz /srv/www/htdocs/.
cd /srv/www/htdocs/
gunzip qatraq_pro_7_0_0.tar.gz
tar –xvof qatraq_pro_7_0_0.tar
cd /srv/www/htdocs/qatraq
Create the QaTraq database
mysql -uroot -p<password> -e "create database qatraq"
cd DB
mysql -uroot -p<password> qatraq < qatraq.sql
Configure SQL user accounts
mysql -uroot –p<password>
mysql> grant usage on qatraq.* to qatraq@localhost identified by '<qatraq_password>';
mysql> grant all on qatraq.* to qatraq@localhost identified by '<qatraq_password>';
mysql> grant usage on qatraq.* to report@localhost identified by '<report_password>';
mysql> grant select on qatraq.* to report@localhost identified by '<report_password>';
mysql> \q
Where <qatraq_password> and <report_password> are passwords of your choice
Edit db_params.php using Vi (or any other text editor), setting <qatraq_password> and <report_password> to values dependent on the passwords provided in the ‘Configure QaTraq Sql user accounts’ section above.
Note that the reports user should have been set up with only SELECT privileges for the database so that users of QaTraq running reports don't have privileges which allow them to write to or modify the database.
Log in to the QaTraq
http://localhost/qatraq/index.php
user name: admin
password: admin
Change default QaTraq user accounts
For security reasons please change the password on the admin account (user: admin, password: admin) and delete the test1 account
St. Mary's Court, The Broadway,
Old Amersham, Buckinghamshire.
HP7 0UT United Kingdom
Telephone: +44 (0)1494 582037