Re: Multiple database

[George Nawfal]

Greetings,

The problem I encountered while setting up multiple databases is now resolved, 
and as
requested, here are the steps to setup another database onto your existing gnats
database:

1- Copy/create a blank database into a 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
      Modify GNATS_ADDR to "lcd"

3- Modify gnats-db.conf file
      Add the following line to the file /etc/gnats-db.conf:
       /usr/local/share/gnats/lcd-db:lcd

4- Modify the aliases file
      Add the following line to the file /etc/aliases
      lcd:           "| /usr/local/libexec/gnats/queue-pr --run -d
/usr/local/share/gnats/lcd-db"

5- Modify the crontab file
      Add the following line to the file /etc/crontab
       0,10,20,30,40,50  *  *  *  *  /usr/local/libexec/gnats/queue-pr --run -d
/usr/local/share/gnats/lcd-db

6- Create an email account for lcd.
      Set its .qmail file to have the following line:
      | /usr/local/libexec/gnats/queue-pr -q

7- Modify the '.mycron' file
      Open the file .mycron located at gnats user home directory. Add the 
following
line to it:
        0-59  *  *  *  *  /usr/local/libexec/gnats/queue-pr --run -d
/usr/local/share/gnats/lcd-db


Those are the steps I performed to get the second database to work.
Comments/corrections are more than welcome.

George