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 how to install XAMPP components.
1. Apache Download, Install and Setup
XAMPP is an easy to install Apache distribution containing MySql, PHP and Perl. XAMPP is really very easy to install and to use. Download and install instructions for XAMPP can be found here:
Note that if you decide to run MySql and Apache as a service you will probably need admin privileges or you will need to ask an administrator to unblock these services for the standard windows firewall.
To check your XAMPP setup before installing QaTraq you can run the following checks. The following checks assume that you accepted the default XAMPP location of C:\Program Files\xampp\htdocs.
Download
| Check | Action | Command |
| Download the basic XAMPP installer packages | http://www.apachefriends.org/en/xampp-windows.html#641 |
Install
| Check | Action | Command |
| Extract | Double click the 'xampp-win32-1.5.1-installer.exe' icon on your desktop | |
| Language | Select the required language | |
| Directory | Select an install directory like C:\Program Files and click 'Install' | |
| Finish | When you see the completion dialogue box click 'Finish' | |
| Service | If you are not familiar with windows services then select 'No' when prompted about installing XAMPP servers as services | |
| Control Panel | When prompted to start the XAMPP control panel click 'Yes' |
Start
| Check | Action | Command |
| Control Panel | If the XAMPP control Panel is not alredy open double click the 'XAMPP Control Panel' icon on the desk top. | |
| MySql | Click the start button for Mysql | |
| Apache | Click the start button for Apache |
Note that if you decide to run MySql and Apache as a service you will probably need admin privileges or you will need to ask an administrator to unblock these services for the standard windows firewall.
Checks
To check your XAMPP setup before installing QaTraq you can run the following checks. The following checks assume that you accepted the default XAMPP location of C:\Program Files\xampp\htdocs.
| Check | Action | Command |
| To check that Apache is running enter the URL | http://localhost/ | |
| XAMPP default home page should show | XAMPP for Windows Version 1.5.1 Apache/2.2.0 PHP/5.1.1 |
|
| Click phpMyAdmin in the left menu bar (under Tools) | MySQL 5.0.18 running on localhost | |
| To check Php and Mysql processes enter the URL | http://localhost/ | |
| Click 'status' in the left menu bar (at the top of the menu bar) | MySQL database should be ACTIVATED PHP should be ACTIVATED |
|
| To check Php Infoenter the URL | http://localhost/ | |
| Click 'phpinfo()' in the left menu bar (at the top of the menu bar) | Php info page should be displayed | |
| Search for and check that the following php configuration settings are enabled | MySQL Support = enabled Session Support = enabled * GD Support = enabled |
2. QaTraq Install and Setup
| Check | Action | Command |
| Download QaTraq | Download from here | |
| Extract QaTraq | copy qatraq_pro_6_10_2.zip \Program Files\xampp\htdocs\. cd \Program Files\xampp\htdocs unzip qatraq_pro_6_10_2.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 6
cd qatraq\lib notepad.exe db_params.php
$db_data['tmt'] = array(
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.'host' => 'localhost', 'db' => 'qatraq', 'user' => 'qatraq', 'password' = '<qatraq_password>' ); $db_data['tmt_reports'] = array( 'host' => 'localhost', 'db' => 'qatraq', 'user' => 'report', 'password' = '<report_password>' ); 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 | |