BUG #1185: Problem with last added user in group (lack of rights)

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1185: Problem with last added user in group (lack of rights)
Date: 2004-06-29 09:41:30
Message-ID: 20040629094130.B190BCF4B52@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1185
Logged by: Chris Ksiezyk

Email address: kksiezyk(at)alpha(dot)pl

PostgreSQL version: 7.4

Operating system: FreeBSD 4.8 (running on AMD Athlon) (PostgreSQL-7.4.1)

Description: Problem with last added user in group (lack of rights)

Details:

In words:
Last user added to group doesn't have right to connect to database although
group have necessary rights (in pg_hba.conf). Other users in this group can
connect to database. If we add another user to group, previous added user
(which couldn't connect) can finally connect to db.
---
Step by step:

--- DB SERVER (f.e 192.168.240.50) ---
create database a_test;
create group a_test;
create user a_test1 password '1' in group a_test;
create user a_test2 password '1' in group a_test;
create user a_test3 password '1' in group a_test;

---in pg_hba.conf---
host a_test +a_test 192.168.240.100 255.255.255.255 md5
---------------------

--- bash ---
killall -HUP postgres

--- PROD SERVER (192.168.240.100) ---
--- bash ---
command: psql -h 192.168.240.50 -d a_test -U a_test1
effect: Password: (proper behavoiur)
command: psql -h 192.168.240.50 -d a_test -U a_test2
effect: Password: (proper behavoiur)
command: psql -h 192.168.240.50 -d a_test -U a_test3
effect: psql: FATAL: no pg_hba.conf entry for host "192.168.240.100",
user "a_test3", database "a_test" (IMPROPER behavoiur!)

--- let's back to DB SERVER ----
create user a_test4 password '1' in group a_test;

--- and again on PROD SERVER ---
--- bash ---
command: psql -h 192.168.240.50 -d a_test -U a_test1
effect: Password: (proper behavoiur)
command: psql -h 192.168.240.50 -d a_test -U a_test2
effect: Password: (proper behavoiur)
command: psql -h 192.168.240.50 -d a_test -U a_test3
effect: Password: (proper behavoiur)
command: psql -h 192.168.240.50 -d a_test -U a_test4
effect: psql: FATAL: no pg_hba.conf entry for host "192.168.240.100",
user "a_test4", database "a_test" (IMPROPER behavoiur!)

That's all. I don't know if it isn't fixed in newest versions but i haven't
found anything about it.

PS. Sorry for any mistakes in this text.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lending, Rune 2004-06-29 14:10:55 VACUUM analyze verbose is skipping tables
Previous Message Chris g 2004-06-29 09:01:06 build failed using MINGW32 / MSys