Test Management

Windows IIS Detailed Install

You will need to be running windows along with the components listed below in order to run QaTraq. The checks and install instructions provided below show you how to install IIS, MySQL and PHP components.

1. IIS Install , PHP and MySQL Download and Setup

Install IIS

IIS 5.1 is part of Windows XP Professional. You can install IIS from the windows components by double clicking the control panel's add/remove programs item. Full detailed instructions can be found here:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/iiiisin2.mspx

Download MySQL, PHP and PHP modules

Check	Action	Command
	Download MySQL for windows	http://dev.mysql.com/downloads/ Choose the 'windows essential' edition with the installer
	Download PHP for windows	http://www.php.net/downloads.php Choose the PHP installer in 'windows binaries'
	Download PHP modules for windows	http://www.php.net/downloads.php Choose the PHP zip package in 'windows binaries'

Install MySQLs

Check	Action	Command
	Launch setup	Double click the 'mysql-essential-x.x-win32.msi' icon on your desktop and leave the default options during the setup process.
	Copy MySQL Library	Copy the file C:\program files\mysql\MySQL Server x.x\bin\libmySQL.dll to your system32 directory (usually c:\windows\system32)

Note that if you decide to run MySql as a service you will probably need admin privileges or you will need to ask an administrator to unblock this service for the standard windows firewall.

Install PHP

Check	Action	Command
	Launch setup	Double click the 'php-x.x.x-installer.exe' icon on your desktop and follow the assistant. Install PHP to c:\PHP and when prompted to select the Web Server it is essential that you select: IIS ISAPI module
	Extract PHP Modules	Double click the 'php-x.x.x-Win32.zip' icon on your desktop and extract the 'ext' directory (and only this directory !) in c:\php (assuming you installed php in c:\php) Edit PHP configuration Edit c:\windows\php.ini using notepad and find and modify this line : extension_dir = "./" change to extension_dir = "c:\php\ext\"
	Edit PHP configuration	Remove ";" characters at the beginning of these lines : ;extension=php_mysql.dll ;extension=php_gd2.dll ;extension=php_gettext.dll change to extension=php_mysql.dll extension=php_gd2.dll extension=php_gettext.dll Save the file and exit.

2. QaTraq Install and Setup

Check	Action	Command
	Download QaTraq	Download from here
	Extract QaTraq	copy qatraq_full_6_10_0.zip \inetpub\wwwroot\ cd \inetpub\wwwroot unzip qatraq_full_6_10_0.zip
	Create the QaTraq database	cd \Program Files\mysql\mysql server x.x \bin\mysql -uroot -p<password> -e "create database qatraq" \bin\mysql -uroot -p<password> qatraq < inetpub\wwwroot\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	\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 \inetpub\wwwroot\
	QaTraq version 5 cd qatraq\lib notepad.exe db_qatraq.php QaTraq version 6 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