* Multiple Databases
@ 2001-09-19 6:39 Perry Klein
2001-09-19 6:50 ` George Nawfal
0 siblings, 1 reply; 2+ messages in thread
From: Perry Klein @ 2001-09-19 6:39 UTC (permalink / raw)
To: gnats-devel
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
^ permalink raw reply [flat|nested] 2+ messages in thread
* RE: Multiple Databases
2001-09-19 6:39 Multiple Databases Perry Klein
@ 2001-09-19 6:50 ` George Nawfal
0 siblings, 0 replies; 2+ messages in thread
From: George Nawfal @ 2001-09-19 6:50 UTC (permalink / raw)
To: Perry Klein, gnats-devel
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
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2001-09-19 6:50 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2001-09-19 6:39 Multiple Databases Perry Klein
2001-09-19 6:50 ` George Nawfal
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).