Multiple Databases

Multiple Databases

[Perry Klein]

I am looking for more information on setting up multiple databases for 
gnats. gnats is currently being used at our facility for a project, but 
another project is interested in using it. The on-line documentation refers 
to the capability of multiple databases on one host, but lacks the details 
in what is needed in regards to the pr-queue, and other components. It is 
important that we keep the two projects segregated.  Each will have its own 
administrator as well.  Any additional information would be appreciated.


Thanks,

Perry Klein

RE: Multiple Databases

[George Nawfal]

Perry,

The following instructions should help you set up multiple databases:

 1- Copy/Create an empty database
 Copy an empty database into the new location. For simplicity, let's call
the
 new database "lcd" and let's copy it into this directory:
  /usr/local/share/gnats/lcd-db/

 2- Modify the config file in the new database
 Now that you've created a new database, you need to modify the config file.
 Open the file ../lcd-db/gnats-adm/config and change the following
 variables:
 Change GNATS_ADDR           to "lcd"
 Change GNATS_SITE           to "lcd"
 Change SUBMITTER            to "lcd"
 Change DEFAULT_ORGANIZATION to "lcd"

 You can keep the other variables as they are or change them if you want to.

 3- Modify gnats-db.conf file
 Add the following line to the file /etc/gnats-db.conf:
 /usr/local/share/gnats/lcd-db:lcd
 The above line inserts "lcd" in the Database combo box at login.

 4- Modify the aliases file
 Add the following lines to the file /etc/aliases - gnats section
 lcd:     "| /usr/local/libexec/gnats/queue-pr -q -d
/usr/local/share/gnats/lcd-db/"
 lcd-gnats:   lcd

 5- Modify the crontab file
 Add the following line(s) to the file /etc/crontab - gnats section
 0,10,20,30,40,50 * * * * /usr/local/libexec/gnats/queue-pr --run -d
 /usr/local/share/gnats/lcd-db

 6- Modify the .mycron file
 Open the file .mycron, located at the user gnats home directory. Then add
the following
 line to it:
 0-59 * * * * /usr/local/libexec/gnats/queue-pr --run -d
/usr/local/share/gnats/lcd-db

 7- Create an email account for lcd
 Create an email account for lcd, say lcd@foo.com if your domain name is
foo.
 Set its .qmail file to have the following line:
 | /usr/local/libexec/gnats/queue-pr -q

 8- Reload the .mycron file:
 Login as gnats users then type "crontab .mycron" in order to reload the
.mycron file
 into the memory.


George


-----Original Message-----
From: gnats-devel-owner@sources.redhat.com
[ mailto:gnats-devel-owner@sources.redhat.com]On Behalf Of Perry Klein
Sent: Wednesday, September 19, 2001 9:45 AM
To: gnats-devel@sources.redhat.com
Subject: Multiple Databases


I am looking for more information on setting up multiple databases for
gnats. gnats is currently being used at our facility for a project, but
another project is interested in using it. The on-line documentation refers
to the capability of multiple databases on one host, but lacks the details
in what is needed in regards to the pr-queue, and other components. It is
important that we keep the two projects segregated.  Each will have its own
administrator as well.  Any additional information would be appreciated.


Thanks,

Perry Klein