Install Windows Quick
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:
Or, using a command prompt (Start -> Run: cmd) :
| 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_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 | |