RE: user logged into second database sees PR from standard/normal in query results

[Jeff Kyser]

-----Original Message-----
From: bug-gnats-admin@gnu.org [mailto:bug-gnats-admin@gnu.org]On Behalf
Of Rick Macdonald
Sent: Friday, October 26, 2001 12:13 AM
To: Jeff Kyser
Cc: bug-gnats@gnu.org
Subject: Re: user logged into second database sees PR from
standard/normal in query results

Pretty strange. How about posting you gnats mail alias entries and your
cron jobs.


Hey Rick/all,

Thanks for the feedback.

Here are my (2) crontab entries:

*/2 * * * * /usr/local/libexec/gnats/gnats-pr --run
*/2 * * * *
/usr/local/libexec/gnats/gnats-pr --directory=/usr/local/share/gnats/ktrails
-db --run

I should have mentioned I'm using FreeBSD 4.4 and
I'm also using postfix mail.

My config entries are as follows:

(/usr/local/share/gnats/gnats-db/gnats-adm/config:)

GNATS_ADDR="bugs"
GNATS_USER="gnats"
GNATS_ADMIN="gnats-admin"
GNATS_SITE="dogbark"
SUBMITTER="dogbark"
DEFAULT_ORGANIZATION="dogbark"

(/usr/local/share/gnats/ktrails-db/gnats-adm/config:)

GNATS_ADDR="kbugs"
GNATS_USER="gnats"
GNATS_ADMIN="gnats-admin"
GNATS_SITE="ktrails"
SUBMITTER="ktrails"
DEFAULT_ORGANIZATION="ktrails"

My gnats mail alias entries are as follows (from
/usr/local/etc/postfix/aliases):

bugs:          bug-q, bug-log
bug-log:       /usr/local/share/gnats/gnats-db/gnats-adm/bugs.log
bug-q:         "| /usr/local/libexec/gnats/queue-pr -q"
dogbark-gnats: bugs
kbugs:         kbug-q, kbug-log
kbug-log:      /usr/local/share/gnats/ktrails-db/gnats-adm/bugs.log
kbug-q:        "| /usr/local/libexec/gnats/queue-pr -d
/usr/local/share/gnats/ktrails-db -q"
ktrails-gnats: bugs

Oh, crud. That's a mistake. Nothing like submitting to a public
forum to discover one's cut-n-paste errors :-( That last line
should be:

ktrails-gnats: kbugs

I've added a separate PR to each database now, and each user only
sees his PR #3. The ktrails user still sees standard PRs #1 and #2,
but I guess fixing the ktrails-gnats alias fixes subsequent submits.

Sorry, and thanks for taking the time out to respond.

regards,

-jeff

On Thu, 25 Oct 2001, Jeff Kyser wrote:

> Hello,
>
> Please forgive if this is not the proper forum for asking a question
> regarding the setup of multiple gnats databases. I have
> checked the documentation and what I could find in the mailing
> lists.
>
> I'm running gnats 3.113.1
>
> I've set up two gnats databases, and successfully added PRs to
> each database using gnatsweb 2.9.1.
>
> (the main one [standard/normal] is in the default location:
>
>       /usr/local/share/gnats/gnats-db
>
> and the second one [ktrails] is at:
>
>       /usr/local/share/gnats/ktrails-db)
>
> When I do a query on the standard/normal database, I only
> see the two PRs that have been submitted to it. (correct)
>
> But when I log into my alternate database, and issue a query,
> even logged in as a user that does not have access to the
> standard/normal database, I see the PRs from the alternate
> database AND the standard/normal database.
>
> I have done the following to confirm that this is a problem
> with my gnats setup and not with gnatsweb:
>
> % telnet 127.0.0.1 1529       # telnet to the gnatsd server
> chdb standard         # change to the standard/normal database
> user jeff <passwd>    # log into the database
> sql2                          # issue the 'default' query
> < i get the two items in the standard database >
>
> % chdb ktrails                # log into the ktrails database
> user ktrails <passwd> # User 'ktrails' doesn't have an account in
'standard'
> sql2                          # issue the 'default' query
> < ktrails gets the two items in the 'standard' database +
>    the two items in the 'ktrails' database'>
>
> Would anyone have any suggestions as to what I might look into to
> correct this problem?
>
> TIA,
>
> -jeff
>
>
> _______________________________________________
> Bug-gnats mailing list
> Bug-gnats@gnu.org
> http://mail.gnu.org/mailman/listinfo/bug-gnats
>

...RickM...


_______________________________________________
Bug-gnats mailing list
Bug-gnats@gnu.org
http://mail.gnu.org/mailman/listinfo/bug-gnats