Install Testitool

Prerequisites

• Apache
• PHP
• MySQL
• php_users

Story From the Field

How one person got testitool installed

#
# INSTALL.txt
# These are the installation instructions for testitool,
# or the Test Planning Tool
#
# $Id: INSTALL.txt,v 1.1.1.1 2003/06/03 14:30:12 byrnereese Exp $

1. Prerequisites

You will first need to install the following software packages 
before actually installing and setting up testitool:

   * Apache (1.3.27 recommended and supported)
   * PHP 4.3.x required
     - compiled with mcrypt support (optional)
     - compiled with mysql support (required)
   * MySQL (3.23.x recommended and supported)
   * php_users beta 1 - Another project available on 
     majordojo: 
        http://majordojo.com/php_users/

2. Create the testitool database

Before you can setup any tables, it is recommended you 
create a separate database for testitool. In all honesty, if 
you wish to import the table definitions into an existing 
database, that is ok too, I will leave up to you to decide. 
Run the following command to create the testitool 
database:

   % mysqladmin -u root -p create testitooldb

3. Setup users and permissions in MySQL

This is an optional step. For those who want the simplest 
install you may be able to skip this step. However, if you 
or your company likes to maintain tight control over db and 
table access, you will want to set that up now.

If you are integrating with Bugzilla, be sure you give the 
testitool user read only access to Bugzilla.

Remember: Any users you create, remember their login 
credentials as you will need this later when editing the 
testitool config file.

4. Setup the MySQL database

Next you need to set up the MySQL database. In the 
directory in which you unarchived the PMI tartball 
($TESTITOOL_HOME) you will find a file called 
'pmidb.mysql_schema' - this file contains the table 
definitions needed to run Testitool. To install it, simply run 
the following command:

   % mysql -u USER_NAME -p testitooldb < $TESTITOOL_HOME/schemas/mysql

You may optionally import some test data into your new 
table structure by running the following command:

   % mysql -u USER_NAME -p testitooldb < $TESTITOOL_HOME/schemas/mysql.test_data

5. Setup Apache 

Add the following lines to your Apache httpd.conf file:

    > Alias /testitool/ $TESTITOOL_HOME
    > 

    >   AddType application/x-httpd-php .php
    >   php_value include_path ".:$TESTITOOL_HOME/include"
    > 
    > 
    >   DirectoryIndex index.php index.html
    > 

6. Setup PHP 

For the most part the default PHP installation will work. 
However, testitool does require that "magic_quotes_gpc" 
parameter be set to "Off" - otherwise, when committing 
records to the database all quotes will be escape twice, which 
is honestly quite ugly, and probably not what you want. You 
may also set this value by adding the following line to 
Apache's httpd.conf:

    >   php_value magic_quotes_gpc "Off"

7. Customize testitool

The first thing you MUST do is edit the 
'$TESTITOOL/include/testitool.conf' file. Follow the instructions 
within it. It should be clear enough .

8. Append permissions.txt to permissions.inc
Located in $TESTITOOL_HOME/include is a file called 
permissions.txt. The contents of this file need to added to 
the global PHP Users permissions file located at 
$PHP_USERS_HOME/include/permissions.inc.

See PHP Users documentation for more information regarding 
the use of this file.

Once this file is installed, you may need to edit your user's 
settings online through the PHP Users management 
interfaces. Login as the administrator and grant yourself all 
Testitool permissions.

9. Restart Apache

Now restart Apache. Be sure to watch your error logs and 
what not to make sure Apache started without any problems.