[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Multiple Databases
RE: Multiple Databases
Wed, 19 Sep 2001 09:49:48 -0400
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
new database "lcd" and let's copy it into this directory:
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
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:
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
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
6- Modify the .mycron file
Open the file .mycron, located at the user gnats home directory. Then add
line to it:
0-59 * * * * /usr/local/libexec/gnats/queue-pr --run -d
7- Create an email account for lcd
Create an email account for lcd, say address@hidden if your domain name is
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
into the memory.
[mailto:address@hidden Behalf Of Perry Klein
Sent: Wednesday, September 19, 2001 9:45 AM
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.