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 address@hidden 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: address@hidden
[mailto:address@hidden Behalf Of Perry Klein
Sent: Wednesday, September 19, 2001 9:45 AM
To: address@hidden
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