Re: Multiple database

[George Nawfal]

Greetings everybody,

My problem with multiple databases is not finished yet.
Here's where I'm at right now:
- Modified crontab file
- Modified aliases file
- Modified gnats-db.conf file

Now, all bugs created in lcd database are sent to the original database. I read 
in
the archives about this bug but I didn't find a solution for it. Anybody has a
solution for this problem?
All help and comments are appreciated:)

Thanks - George




Yngve Svendsen wrote:

> At 09:57 08.02.2001 -0500, George Nawfal wrote:
> >Hi!!
> >
> >Well, I went with Mike's comment because I have a copy of the default 
> >database
> >and I didn't want to risk breaking a working database. However, PRs entered 
> >in
> >the new database are being lost. I don't know what's wrong with it now...
> >
> >My aliases file looks like this:
> >
> >bugs:                    "| /usr/local/libexec/gnats/queue-pr -q -d
> >/usr/local/share/gnats/gnats-db"
> >lcd:                       "| /usr/local/libexec/gnats/queue-pr -q -d
> >/usr/local/share/gnats/lcd-db"
> >cplane-gnats:     bugs
> >
> >Do I need to modify the crontab file too? What do I need to insert there?
> >
> >Any ideas to where is the problem??
>
> Yes, you need items in the crontab file for all the databases. We're
> running three databases, and this is our crontab:
>
> 0,20,40 * * * * /usr/local/libexec/gnats/queue-pr --run
> 1,21,41 * * * * /usr/local/libexec/gnats/queue-pr --run
> --directory=/usr/local/share/gnats/external
> 2,22,42 * * * * /usr/local/libexec/gnats/queue-pr --run
> --directory=/usr/local/share/gnats/helpdesk
>
> I have been planning to review the docs with regards to mutiple database
> support, but it has been quite a long time since I set up our system, and I
> have probably forgotten many of the little kinks and problems in the
> installation. Could you send me any details in the installation process
> that you think are lacking in the current documentation?
>
> By the way, you didn't recompile Gnats, did you? In any case, that
> shouldn't be necessary.
>
> Yngve Svendsen
> IS Engineer
> Clustra AS, Trondheim, Norway
> yngve.svendsen@clustra.com