Track+ On GlassFish

style="float:left; padding-right: 1em;" />I use the href="http://www.trackplus.de/">Track+ bug tracking system in my href="http://www.horstmann.com/sjsu/cs160/gs.html">software engineering
class. (Why not Bugzilla? Have a look at the href="http://www.bugzilla.org/docs/2.22/html/installation.html">installation
instructions...) Track+ is open source and free for small groups and
academic institutions. Definitely recommended as a solid system that is
easy to install and maintain.

Here are the setup directions for GlassFish. I used build v2-b09, but
it probably doesn't matter very much since Track+ doesn't use anything
except Tomcat. This is all boring, and I just put it up for reference. If
you want something fun, try href="http://www.cs.mdx.ac.uk/research/PhDArea/saeed/">this or href="http://www.nextthing.org/archives/2005/08/07/fun-with-http-headers">this
instead.

I executed all these steps as root on Ubuntu 6.06 server edition.

1. Get the download file URLs from href="http://www.trackplus.de/home/download.php">http://www.trackplus.de/home/download.php
2. I use PostgreSQL 8.10. (Instructions for other databases are
   available in the Track+ documentation.) I lamely let PostgreSQL defer to
   the Linux user management. If you don't do that, hopefully you'll know
   how to modify these instructions.
   First, make a new database user
   trackp and a database track:

   adduser trackp
   
   su postgres
   
   createuser -P trackp
   Enter password for new role: secret
   Enter it again: secret
   Shall the new role be a superuser? (y/n) n
   Shall the new role be allowed to create databases? (y/n) n
   Shall the new role be allowed to create more new roles? (y/n) n
   
   createdb --owner=trackp track "Track+ Database"
   
   exit

3. Download the database setup script

   mkdir ~/trackplus<br />cd ~/trackplus
   wget http://www.trackplus.com/files/download.php?file=track-320-db.zip
   jar xvf track-320-db.zip

4. Unfortunately, one of the initialization scripts uses GROUP
   as a column name even though it is href="http://developer.mimer.com/validator/sql-reserved-words.tml">reserved
   in SQL 92. As suggested href="http://www.trackplus.com/forum/posts/list/95.page">here,
   change GROUP to THEGROUP (4x) in track-schema.sql.
   Also add a line with the word BEGIN at the start of
   ../populate.sql. Now run the scripts:

   cd dbase/Postgres
   su trackp
   psql -f id-table-schema.sql track
   psql -f track-schema.sql track
   psql -f ../populate.sql track
   exit

5. Download the EAR file and update the Torque.properties file
   inside. Just follow the comments. Set the database password, comment out
   the MySQL lines and uncomment the PostgreSQL lines.

   wget http://www.trackplus.com/files/download.php?file=track-320.ear
   jar xvf track-320.ear track.war
   jar xvf track.war WEB-INF/Torque.properties
   vi WEB-INF/Torque.properties
   jar uvf track.war WEB-INF/Torque.properties
   jar uvf track-320.ear track.war

6. Deploy by copying to the autodeploy directory.cp track-320.ear /opt/domain1/autodeploy/
7. Point your browser to
   http://servername:8080/track.

   src="http://weblogs.java.net/blog/cayhorstmann/archive/trackplus.png" />