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.

Get the download file URLs from
href="http://www.trackplus.de/home/download.php">http://www.trackplus.de/home/download.php

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 usertrackp and a database track:

adduser trackp

su postgres

createuser -P trackpEnter password for new role: secretEnter it again: secretShall the new role be a superuser? (y/n) nShall the new role be allowed to create databases? (y/n) nShall the new role be allowed to create more new roles? (y/n) n

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: