This is the mail archive of the
gnats-devel@sources.redhat.com
mailing list for the GNATS project.
RE: Multiple Databases
- To: "Perry Klein" <pgk3 at psu dot edu>, <gnats-devel at sources dot redhat dot com>
- Subject: RE: Multiple Databases
- From: "George Nawfal" <george at cplane dot com>
- Date: Wed, 19 Sep 2001 09:49:48 -0400
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