Re: Problem in setting up multiple databases

Re: Problem in setting up multiple databases

[Yngve Svendsen]

At 13:02 05.02.2003 +0530, Sudha Mudhavalapu wrote:
>5.Added the cronjob to the file .mycron present in gnats home directory.
>ran crontab .mycron

Start off by checking that this cronjob is correctly set up (you may for 
instance have forgotten the -d argument) and that it actually runs.

Yngve Svendsen 



_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

Problem in setting up multiple databases

[Sudha Mudhavalapu]

[-- Attachment #1: Type: text/plain, Size: 1978 bytes --]

Hi,
	Mentioned below are the steps that I have followed.Please let me
know where I went wrong.If its not understandable please mail back and
example with the contents of the files and the steps followed so that I
can set up multiple databases

1.Created the base directory for the new database, say
`/home/projects/broadcom/gnats-bcm', (owned by the GNATS user)

2.Copied all files from `gnats-db/gnats-adm' to
'/home/projects/broadcom/gnats-bcm/gnats-adm', and edited them to
reflect the needs of new database. (owned by the gnats user) There is a
category named pending.

3.As the GNATS user, ran `mkcat
--directory=/home/projects/broadcom/gnats-bcm'' to
create the directories for the categories. Remove the files `current'
and `index', that exist. Run the program gen-index to create the index
file
created a 'current' file by
echo 1 > current

4.Now added a line for the new database to `/etc/gnats-db.conf', like
this:
/home/projects/broadcom/gnats-bcm:BROADCOM

5.Added the cronjob to the file .mycron present in gnats home directory.
ran crontab .mycron

7.Added aliases for the new database and ran
newaliases the contents of aliases file are...

#Aliases for broadcom gnats database
broadcom-bugs: "| /etc/smrsh/queue-pr -q -d
/home/projects/broadcom/gnats-bcm"
broadcom-query: "| /etc/smrsh/mail-query -d
/home/projects/broadcom/gnats-bcm"

8.The contents of config file present in
/home/projects/broadcom/gnats-bcm/gnats-adm are as below...
GNATS_ADDR="broadcom"
GNATS_USER="gnats"
GNATS_ADMIN="gnats-admin"
GNATS_SITE="alpine"
SUBMITTER="alpine"
DEFAULT_RELEASE="broadcom-1.0"
DEFAULT_ORGANIZATION="alpine"
NOTIFY=1
ACKNOWLEDGE=1
DEFAULT_SUBMITTER="sganesh"
KEEP_RECEIVED_HEADERS=1
BDAY_START=8
BDAY_END=17
BWEEK_START=1
BWEEK_END=5
DEBUG_MODE=1


After this I logged in to gnats new database using gnatsweb.Created a PR
nothing seemed to get created in the database for that category.

Thanks,
Sudha.

[-- Attachment #2: Wipro_Disclaimer.txt --]
[-- Type: text/plain, Size: 514 bytes --]

**************************Disclaimer************************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged' and 'confidential' and intended for use only by the individual
 or entity to which it is addressed. You are notified that any use, copying 
or dissemination of the information contained in the E-MAIL in any manner 
whatsoever is strictly prohibited.

***************************************************************************************

[-- Attachment #3: Type: text/plain, Size: 139 bytes --]

_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

Re: Problem in setting up multiple databases

[Hans-Albert Schneider]

>>>>> "Sudha" == Sudha Mudhavalapu <sudha.mudhavalapu@wipro.com> writes:

    Sudha> Created a file called .mycron in the home directory of
    Sudha> the user gnats which contains the line:

    Sudha> 0,10,20,30,40,50 * * * *
    Sudha> exec-prefix/libexec/gnats/queue-pr --run

Add --directory=/usr/local/gnats/db2

(I hope you replaced exec-prefix by the correct location.)


I'll add this hint to the FAQ.

Hans-Albert

-- 
Hans-Albert Schneider
Munich, Germany
EMail: Hans-Albert@HA-Schneider.de


_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats

Problem in setting up multiple databases

[Sudha Mudhavalapu]

[-- Attachment #1: Type: text/plain, Size: 1575 bytes --]

	I have gnats3.113.1 and gnatsweb2.9.3 setup on a Linux
machine.This works perfectly well for the database that is already
present.Now I want to sent up one more database on the same machine.I am
facing some problems in that.I use gnatsweb to manage gnats.When I
CREATE a PR I get a page throwing up saying that a mail will be sent
etc...When I say QUERY I get no PRs don't know what is the problem.
Mentioned below are the steps that I followed in setting up the new
database.

Created the base directory for the new database, say
`/usr/local/gnats/db2'

Copied all files from `gnats-db/gnats-adm' to
`/usr/local/gnats/db2/gnats-adm', and edited them to reflect the needs
of your new database. 

Edited the categories file accordingly(pending is present in that file)

Ram `mkcat --directory=/usr/local/gnats/db2' to create the directories
for the categories. Removed the files `current' and `index', that exist.


Now add a line for the new database to `gnats-db.conf', like this: 
/usr/local/gnats/db2:XXX 

Created a file called .mycron in the home directory of the user gnats
which contains the line: 

0,10,20,30,40,50 * * * * exec-prefix/libexec/gnats/queue-pr --run Then
ran 
crontab .mycron

Added the following to /etc/aliases
db2:  "|/usr/local/lib/gnats/queue-pr -d /usr/local/gnats/db2 -q"
db2: "|/usr/local/lib/gnats/mail-query -d /usr/local/gnats/db2"

Modified /etc/gnats-db.conf also added the new database to it Your help
in this regard will be very useful to me.Kindly write back to me.

Thanks and Regards,
Sudha.

[-- Attachment #2: Wipro_Disclaimer.txt --]
[-- Type: text/plain, Size: 514 bytes --]

**************************Disclaimer************************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged' and 'confidential' and intended for use only by the individual
 or entity to which it is addressed. You are notified that any use, copying 
or dissemination of the information contained in the E-MAIL in any manner 
whatsoever is strictly prohibited.

***************************************************************************************

[-- Attachment #3: Type: text/plain, Size: 139 bytes --]

_______________________________________________
Help-gnats mailing list
Help-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/help-gnats