Test Management

Windows Quick Install

You will need to be running windows along with Apache, MySql and Php in order to run QaTraq. If you are already running with Apache, Mysql and Php then you can skip step 1. The checks and install instructions provided below assume you have installed the components using XAMPP and that you have an Apache web server document root set to:

C:\Program Files\xampp\htdocs

1. Download and Install XAMPP

If you are not already running Apache, Mysql and Php then download and install these components first.

Check	Action	Command
	Download and install the basic XAMPP installer packages	http://www.apachefriends.org/en/xampp-windows.html#641

2. Check System Requirements

Using the XAMPP control panel:

Check	Action	Command
	Control Panel	If the XAMPP control Panel is not already open double click the ‘XAMPP Control Panel’ icon on the desk top.
	MySql	Check MySql is 'Running', if not click the start button for Mysql
	Apache	Check Apache is 'Running', if not click the start button for Apache

Or, using a command prompt (Start -> Run: cmd) :

Check	Action	Command
	Confirm Apache is running	cd \Program Files\xampp\ apache\bin\apache.exe –v
	Confirm Php (version 4.4 or greater)	php\php.exe -v
	Confirm MySql (version 4.1 or greater)	mysql\bin\mysqladmin -u<user> -p version

3. QaTraq Install and Setup

Check	Action	Command
	Download QaTraq	Download from here
	Extract QaTraq	copy qatraq_pro_7_0_0.zip \Program Files\xampp\htdocs\. cd \Program Files\xampp\htdocs unzip qatraq_pro_7_0_0.zip
	Create the QaTraq database	cd \Program Files\xampp\ mysql\bin\mysql -uroot -p<password> -e "create database qatraq" mysql\bin\mysql -uroot -p<password> qatraq < htdocs\qatraq\DB\qatraq.sql NOTE: when specifying the password make sure that there is no space between the -p and the actual password. You may also find after a clean install of MySql that no root password is defined in which case omit the "-ppassword" string altogether.
	Configure SQL user accounts	mysql\bin\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	cd \Program Files\xampp\htdocs
	QaTraq version 5 cd qatraq\lib notepad.exe db_qatraq.php QaTraq version 7 cd qatraq\lib notepad.exe 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 notepad, setting <qatraq_password> and <reports_password> to values dependent on the passwords provided in the ‘Configure QaTraq Sql user accounts’ 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