Linux Detailed Install

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. Although these components usually come pre-installed with most Linux distros, we provide install, setup and check steps in the sections below to help you ensure that you are running with the right versions before installing QaTraq.

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!

If you don't have Apache installed or you are having problems getting Apache running correctly the following should help.

Download	http://httpd.apache.org/download.cgi
Install	http://httpd.apache.org/docs/
Setup	The following setup and configuration parameters are critical to QaTraq. Below you will find examples of configuration directives for both Apache 1.3 and Apache 2.x. Apache can seem like a small maze when it comes to configuration so we suggest you only make changes if you know what you are doing. For example we suggest that you don't make any changes to Php directives until you have installed Php. Installation of Php will automatically make changes to the necessary Apache configuration files. So it is worth waiting until you have completed the php install before modifying the httpd.conf file php parameters. Apache 1.3 example: /etc/httpd/conf/httpd.conf LoadModule php4_module modules/libphp4.so DirectoryIndex index.php AddType application/x-httpd-php .php DocumentRoot "/srv/www/htdocs/qatraq" <Directory "/srv/www/htdocs"> Options None AllowOverride None Order allow,deny </Directory> Apache 2.x example:/etc/apache2/sysconfig.d/loadmodule.conf LoadModule php4_module /usr/lib/apache2-prefork/libphp4.so /etc/apache2/conf.d/php4.conf DirectoryIndex index.php AddType application/x-httpd-php .php /etc/apache2/httpd.conf /etc/apache2/default-server.conf DocumentRoot "/srv/www/htdocs/qatraq" <Directory "/srv/www/htdocs"> Options None AllowOverride None Order allow,deny </Directory> DocumentRoot and Directory directives are dependent on your installation and set up.If you make changes to the Apache configuration files you will need to restart the daemon with: /etc/init.d/apache2 restart

Check	Action	Command
	For Apache 1.3 confirm that command shows 'Server version: Apache/1.3.xx' or greater	/usr/sbin/httpd -v
or	For Apache 2.x confirm that command shows 'Server version: Apache/2.0.xx' or greater	/usr/sbin/httpd2 -v
	Confirm Apache Daemon is running and that process list shows httpd process (e.g. '/usr/sbin/httpd..')	ps -ef \| grep httpd
or	Confirm Apache Daemon is running and that process list shows httpd process (e.g. '/usr/sbin/apache..')	ps -ef \| grep apache
	Confirm Apache Daemon status and that status shows 'httpd (pid xxx xxx) is running'	/etc/init.d/httpd status
or	Confirm Apache Daemon status and that status shows 'Checking for httpd2: running	/etc/init.d/apache2 status

Again If you don't have Php installed or you are having problems the following should help.

Download	http://www.php.net/downloads.php
Install	http://www.php.net/manual/en/install.php
Setup	You will need to make sure the following setup and configuration parameters are configured for QaTraq to run. Whilst we only cover Php4 configuration here you should have no problems running Php5 with the following config. Php 4.x: /etc/apache2/php.ini and /etc/httpd/php.ini engine = On short_open_tag = On display_errors = Off file_uploads = On upload_max_filesize = 2M mysql.allow_persistent = On mysql.max_persistent = -1 mysql.max_links = -1 session.save_handler = files session.use_cookies = 1 session.name = PHPSESSID Again, if you make changes to the Php configuration files you will need to restart the Apache daemon with: /etc/init.d/httpd restart or /etc/init.d/apache2 restart

Check	Action	Command
	Php version shows 'PHP 4.4.2' or greater	php -v
	Php / Apache running	cd /srv/www/htdocs vi info.php
	Create the following file, called info.php, with a text editor in the htdocs directory	<?php phpinfo(); ?>
	From your browser the Php info page should be displayed (see the troubleshooting guide if you have problems with this step).	http://localhost/info.php
	From the info.php page (see above) check the Php configuration and directives * Session Support may not be enabled by default in php5! See Troubleshooting for more info.	MySQL Support = enabled Session Support = enabled * GD Support = enabled

We recommend using MySQL version 4 on Linux/Unix platforms. Although it is possible to run with MySQL version 5 you may find some of the default configuration settings will need changing (possibly meaning a recompile of the source). Check the Troubleshooting section first if you plan to use MySQL5. If you don't have MySql installed or you are having problems the following should help.

Download	http://dev.mysql.com/downloads/mysql/4.1.html
Install	http://dev.mysql.com/doc/refman/4.1/en/installing.html
Setup	You will need to make sure the following setup and configuration parameters are configured for QaTraq to run. MySQL 4: /etc/my.cnf and /var/lib/mysql/my.cnf You should not need to change any MySQL settings (we provide these details just for the sake of completeness) If you do make changes to the Mysql configuration files you will need to restart the daemon with /etc/init.d/mysql restart

Check

Action

Command

Download QaTraq

Download from here

Extract QaTraq

cp qatraq_pro_6_10_2.tar.gz /srv/www/htdocs/.
cd /srv/www/htdocs/
gunzip qatraq_pro_6_10_2.tar.gz
tar -xvof qatraq_pro_6_10_2.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

Configure db_params.php include file for QaTraq version 6

cd ../lib
vi db_params.php

$db_data['tmt'] = array(
'host' => 'localhost',
'db' => 'qatraq',
'user' => 'qatraq',
'password' = '<qatraq_password>'
);

$db_data['tmt_reports'] = array(
'host' => 'localhost',
'db' => 'qatraq',
'user' => 'report',
'password' = '<report_password>'
);

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

1. Apache Download, Install and Setup

2. Php Download, Install and Setup

3. MySQL Download, Install and Setup

4. QaTraq Install and Setup