From mboxrd@z Thu Jan 1 00:00:00 1970 From: "George Nawfal" To: "Perry Klein" , Subject: RE: Multiple Databases Date: Wed, 19 Sep 2001 06:50:00 -0000 Message-id: References: <4.2.2.20010919094403.00a96740@email.psu.edu> X-SW-Source: 2001-q3/msg00121.html 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