Directions for setting up the Track+ bug tracking system on GlassFish. This is all boring, and I just put it up for reference. If you are looking for something fun, follow one of the links in the second paragraph instead.
I use the Track+ bug tracking system in my software engineering class. (Why not Bugzilla? Have a look at the 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 this or this instead.
I executed all these steps as root on Ubuntu 6.06 server edition.
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
cd ~/trackplus wget http://www.trackplus.com/files/download.php?file=track-320-db.zip jar xvf track-320-db.zip
cd dbase/Postgres su trackp psql -f id-table-schema.sql track psql -f track-schema.sql track psql -f ../populate.sql track exit
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
cp track-320.ear /opt/domain1/autodeploy/