Install Project Management Interface

Prerequisites

• Apache
• PHP
• MySQL
• php_users
• Mail::Sendmail

Installation

Prerequisites

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

• Apache (1.3.26 recommended and supported)
• PHP 4.2.2 (required)
• MySQL (3.23.x recommended and supported)
• phpusers (alpha6) - Another project available on majordojo: http://majordojo.com/phpusers/
• Mail::Sendmail Perl module

To use the CPAN module, invoke the CPAN shell:

 % perl -MCPAN -e shell

After it has been configured, install Mail::Sendmail - this enables reminders and project change notifications:

 % cpan> install Mail::Sendmail

To read the README for any module, before or after installing:

 % cpan> readme MODULE

Create the PMI database

Before you can setup any tables, it is recommended you create a separate database for the PMI. 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 PMI database

% mysqladmin -u root -p create pmidb

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.

In addition, make sure the user that will be used by the PMI to access the PMI db also has access to the php_user tables. If you are integrating with Bugzilla, be sure you give the PMI user has read only access to Bugzilla.

Remember: Remember the login credentials of any users you create, as you will need this later when editing the PMI config file.

Setup the MySQL database

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

% mysql -u USERNAME -p pmidb < $PMIHOME/schemas/mysql

This table definition does come with a basic data set so that when you use the PMI for the first time it is not totally devoid of information.

Setup Apache

In the $PMIHOME/conf directory is a file called 'pmihttpd.conf' - if you wish you can include this file directly into your httpd.conf (be sure to customize it for your environment).

When you customize it make sure that:

• your phpincludepath directive enables PHP to find the pmi.inc, pmi.conf, directory.inc, users.inc (from php_users), and what ever else your web server needs to be able to find

Customize the PMI

The first thing you MUST do is edit the '$PMI_HOME/pmi.conf' file. Follow the instructions within it. It should be clear enough <knock on wood>.

To make future upgrades easier, let me suggest that you make your changes to a copy of the pmi.conf file and that your order the search paths in your php_include_path directive such that the copy will be found first.

Edit your crontab

There is a perl script in $PMIHOME/bin that needs to be executed frequently in order to enable support of the category/project watch list feature which notifies users via email of changes to items they have selected to receive updates for. The best way to do this is just add the contents of $PMIHOME/cron/crontab to your crontab.

Restart Apache

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