Re: Multiple database

[Mike Sutton]

I avoided modifing crontab all the time by having crontab call a
script.  The script searches for directories in a specified, top-level
directory that contains all the gnats databases.  See below.

MikeS

-----------------------------------------------------------------
#!/usr/bin/sh 

#exit


GNATS_ROOT=/usr/local/gnats-3.110s
GNATS_DB_HOME=/users/gnats

list=`/usr/bin/find $GNATS_DB_HOME/* -type d -prune -name '*-db' -print`

for name in $list
do
  $GNATS_ROOT/libexec/gnats/queue-pr -d $name --run
done




On 02/08/01 16:25:28, 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 
> 2,22,42 * * * * /usr/local/libexec/gnats/queue-pr --run 
> 
> 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

-- 
Mike Sutton                      | public class
SAIC                             | software_failure : management_failure
Beavercreek, OH                  | 
Suttonm@saic.com                 | These are MY opinions, not SAIC's