Welcome!!

This README covers the following topics:

   1. What is PRepS
   2. Why did I create it
   3. How to install it
   4. The create_prepsdb script
   5. The update_prepsdb script
   6. PRepS command line options
   7. Adding Users


1. What is PRepS

PRepS is a simple Problem Reporting System.  PRepS is designed around the
bug tracking needs of small to medium sized software projects.  However, 
PRepS may be flexible enough to be used for other types of problem or
status tracking.  For example, PRepS could be setup to track things 
that need fixing around the house.  Be creative.


2. Why did I create it

I created PRepS for a couple of reasons:
   o I needed a simple bug tracker for myself, and gnats seemed like
     it was overkill for what I needed.
   o I wanted to get some more experience working with relational 
     databases.
   o I thought it sounded like fun (for the most part, it was).

Note that PRepS is best suited to small and medium sized projects where
all of the developers are under one roof (so to speak).  If you need
to do things like support remote users sending in problems via e-mail,
I stronly suggest that you use a system like gnats.


3. How to install it

Well, first off, you will need to have GTK v1.2+ installed, as well as
PostgreSQL v7.x.  (PRepS will work with PostgreSQL v6.5.x, but you will
need to modify a few things.  Please see the HTML documentation for 
details) 

You also will need to be a PostgreSQL user with permission to create
databases, and you will either need to 'postgres' account password, or
access to someone who does have it.  See your PostgreSQL admin if this
is all greek to you.

Other than that, see the INSTALL file for detailed instructions.


4. The create_prepsdb script

This script is used to setup PRepS databases.  It sets up the tables, 
triggers, and default data.  It also installs the PL/pgSQL language
into the database (which is why you need to 'postgres' user account
password to run it).

You can create any number of databases, as long as you have enough
diskspace.  

You can have all of your projects in one database, or you could have
one database per project, or anything in between.  You should lay this
out as best fits your needs. 


5. The update_prepsdb script

This script is used to update the schema of an existing PRepS database.
If you are updating from an older version of PRepS, you MAY need to 
run this script.  In general, if the first or second number in the
preps version changes (v1.2.4 vs v1.4.0, for example), or if you are
using a development version, chances are good that you will need to 
run this script. 

See the INSTALL file for details.

6. Command line options

Besides the options that GTK understands (see the GTK documentation for
details), PRepS understands the following options.

-d database_name
   PRepS will look for a database named 'myprs' (no quotes) by default.  If
   the database that you want to access has a different name, you will need
   to supply it with -d option.

   For example, if you have a PRepS database called 'project_xyz' that you
   want to access, you will need to launch PRepS as follows:

   preps -d project_xyz

   If you do not use the -d option, PRepS will attempt to access the 'myprs'
   database.

   If PRepS fails to log in to the database, it will assume that you need to
   provide an username and password, and will thus display a login dialog.  If
   that login fails, you will get an error message explaining why.  PRepS will
   continue displaying the login dialog until you either login successfully, or
   cancel the login.  If you cancel, PRepS will exit.

-h
   Show a simple help message and exit.

-l
   Force the display of the login dialog instead of attempting to login
   to the database right away.  This can be useful if the information in
   the database configuration file is currently incorrect but valid, or
   if the user knows they will need to supply some information anyhow.

-v 
   Show version information and exit.

7. Adding Users

One special note on this.  Users must be setup on PostgreSQL and in PRepS.

Setting up new users in PRepS should be fairly self explanitory from the
user interface.

See 'man createuser' for details on setting up a PostgreSQL user.

Once the user is setup in PostgreSQL AND PRepS, they can start using the
system.

Note that the PostgreSQL user id and the ID given to PRepS should match.


enjoy!


$Id: README,v 1.6 2000/10/14 03:15:02 stuffle Exp $
