BugDB

Notes

This tarball contains mostly PHP3 code which implements a simple, MySQL based bug tracking system. As it is, it is non-trivial to install, but should serve nicely as a basis if you intended to build your own.

The BugDB is designed to interoperate with ClearCase and my extension pack and should be installed on a machine that has both - and a web server with PHP3 and MySQL support of course.

Note that the MySQL database can reside on a different machine. In fact, you can install this package on multiple web servers, but they all need to point to the same MySQL database if data is to be shared.

The tarball contains 4 parts:

bugdb/bin

Utility scripts and programs. smartwrap is a compiled Linux binary in this tarball, sources are available. On your server, you can place them wherever you want as long as you fix the references to them elsewhere in the code. text2html will need to be customized to point to your cgi-bin directory and to insert your domain name, if needed. This little script is at the heart of web-enabling cleartool describe output.

bugdb/cgi-bin

These scripts provide various interfaces for running web-based manpages, cleartool annotate, cleartool describe etc...

bugdb/schema

The table definitions in this directory can simply be piped into mysql and will create the tables required for running the BugDB.

bugdb/htdocs

This is the meat. One file in particular will absolutely need to be customized: bugdb/htdocs/common.inc. You may need to tweak a lot of values to make your BugDB come out right.

I will be happy to help anyone set this up, but please note that an actual work order will motivate me immensely to do anything beyond answering basic questions.