This page contains information on how to set the Keystone web-based problem tracking system on UN*X. For more information, please refer to the Stonekeep Consulting and Keystone documentation.

Relevant or useful links.

• Apache Web Site
• PHP Web Site
• MySQL Web Site
• PostgreSQL Web Site
• Stonekeep Consulting and Keystone documentation

OS			Any UN*X OS (including Linux, Digital UNIX, etc.)
Apache			Apache HTTPd 1.3.x
PHP Apache module	PHP 3.x.x
Kestone			Keystone 0.5x or latest version
MySQL			MySQL 3.22.x
or 
PostgreSQL		PostgreSQL 6.4.x

Keystone is an excellent tool to keep track of a variety of problems and issues, both in administration/support and development. It allows the public to submit problem reports (slips) via a web interface or e-mail. The slips are later reviewed and worked on by the assigned technicians and/or developers.

Putting it all together.

Here are step-by-step instructions:

1. Install Apache 1.3.x or later.
   On Linux, it is beneficial to install software in RPM format. RPM packages for Apache and other common applications can be downloaded from RedHat or its mirrors.

2. Install MySQL. If using MySQL RPMs (which can be downloaded from the MySQL web site), make sure to install the MySQL development RPM along with the main RPMs (this contains header files and libraries needed for PHP3 compile). The RPM installation will also create a data directory and a default database.

3. Install PHP3. This can be statically compiled into Apache or installed as a dynamically loadable module.

   PHP3 needs to be compiled either with MySQL or PostgreSQL support, depending on the choice of a database.
   To add MySQL support, use

   		--with-mysql=/usr
   	

   option with configure. If you are buiding your own PHP3 RPM package, add that option to the PHP3 spec file.

   Edit Apache's httpd.conf file to uncomment all php3 entries.
   Edit Apache's srm.conf file to uncomment/add the following entry:

   		AddType application/x-httpd-php3 .php3
   	

4. Install Keystone: download the archive and extract its contents under your DocumentRoot or anywhere else where it would be accessible via your web server.

5. Create your Keystone database. If using MySQL, do:

   		mysqladmin create keystone
   	

   Then use the SQL scripts that came with Keystone to create Keystone-specific tables, etc.:

   		cd keystone
   		for i in struct/*.mysql
   		do
   		mysql keystone < $i
   		done
   	

6. Edit the Keystone configuration file: to go the conf subdirectory, copy keystone.conf.default to keystone.conf and edit as necessary.

   MySQL does not allow nobody or empty user to log into the database. Using root for sys_dbuser works fine.

7. Access the Keystone directory on your server using a web browser and choose index.php3 file. Log in with default username admin and password abc123.