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: Download MySQL, PHP and PHP modules
Install MySQLs
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
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: 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' |
| 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
change to
;extension=php_gd2.dll ;extension=php_gettext.dll
extension=php_mysql.dll
Save the file and exit.
extension=php_gd2.dll extension=php_gettext.dll |
2. QaTraq Install and Setup| Check | Action | Command |
| Download QaTraq | Download from here | |
| Extract QaTraq | copy qatraq_pro_6_10_2.zip \inetpub\wwwroot\ cd \inetpub\wwwroot unzip qatraq_pro_6_10_2.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 | |