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

[Rick Macdonald]

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

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...