[PORTS] Port Bug Report: ident authority map problem (fwd)

Can someone comment on this?

Forwarded message:

From owner-pgsql-ports@hub.org Thu Mar 26 15:25:15 1998
Date: Thu, 26 Mar 1998 15:12:29 -0500 (EST)
From: Unprivileged user <nobody@hub.org>
Message-Id: <199803262012.PAA11300@hub.org>
To: pgsql-ports@postgreSQL.org
Reply-to: john edstrom <edstrom@slugo.hmsc.orst.edu>
Subject: [PORTS] Port Bug Report: ident authority map problem
Sender: owner-pgsql-ports@hub.org
Precedence: bulk

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : john edstrom
Your email address : edstrom@slugo.hmsc.orst.edu

Category : runtime: back-end
Severity : serious

Summary: ident authority map problem

System Configuration
--------------------
Operating System : linux 2.0.32 ELF

PostgreSQL version : 6.3.1

Compiler used : cc -v => gcc version egcs-2.90.23 980102 (egcs-1.0.1 release)

Hardware:
---------
Linux Poopsie.hmsc.orst.edu 2.0.32 #26 Wed Mar 18 17:11:39 PST 1998 i586 unknown

Versions of other tools:
------------------------
GNU Make version 3.76.1
flex version 2.5.4

--------------------------------------------------------------------------

Problem Description:
--------------------
postgres gets confused reading hba.conf. The last line
pg_hba.conf appears not to be read properly. Specifications
above the last line appear to be understood correctly.

--------------------------------------------------------------------------

Test Case:
----------
Here is how I do it.

3 lines in pg_hba.con

host edstrom 127.0.0.1 255.255.255.255 ident test
host all 127.0.0.1 255.255.255.255 ident pgsql
host tstdb 127.0.0.1 255.255.255.255 ident tst

4 lines in pg_ident.conf
tst edstrom edstrom
pgsql postgres postgres
test edstrom edstrom
test postgres postgres

Postgres and edstrom are unix accounts, tstdb is a valid
postgres user but not a unix account.

Around line 729 (verify_against_open_usermap()) in
src/backend/libpq/hba.c I put:

sprintf(PQerrormsg,"pg_ident: [%s] [%s] [%s] [%s] [%s] [%s]\n",
file_map, usermap_name,
file_pguser, pguser,
file_iuser, ident_username
);
fputs(PQerrormsg, stderr);
pqdebug("%s", PQerrormsg);

using psql from the command line user edstrom tries to
connect to tstdb ("psql tstdb") and is rejected. The error
log says:

->pg_ident: [tst] [pgsql] [edstrom] [edstrom] [edstrom] [edstrom]

pg_ident: [pgsql] [pgsql] [postgres] [edstrom] [postgres] [edstrom]
pg_ident: [test] [pgsql] [edstrom] [edstrom] [edstrom] [edstrom]
pg_ident: [test] [pgsql] [postgres] [edstrom] [postgres] [edstrom]
pg_ident: [] [pgsql] [] [edstrom] [] [edstrom]
pg_ident: [] [pgsql] [] [edstrom] [] [edstrom]
User authentication failed

The arrow shows where it should have succeeded. For some
It isn't cycling through usermap_name properly.

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)