Use ident sameuser?

From: "William C(dot) Rowden" <rowdenw(at)hurston(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Use ident sameuser?
Date: 2002-03-26 22:48:15
Message-ID: 20020326144815.A19799@hurston.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is anyone using AUTH_TYPE=ident with AUTH_ARGUMENT=sameuser in the
PostgreSQL Host-Based Access file ("pg_hba.conf")? The documentation
within that file says this:

# AUTH_ARGUMENT is required: [...]
# The special map name "sameuser" indicates an implied
# map (not in pg_ident.conf) that maps each ident
# username to the identical PostgreSQL username.

However, with PostgreSQL 7.2 (on Red Hat 7.2 Linux 2.4.7-10) the
following lines do not permit access to PostgreSQL usernames identical
to system usernames [1]:

local all ident sameuser
host all 127.0.0.1 255.255.255.255 ident sameuser

Only when an expressed map is present in "pg_ident.conf" do I get the
"sameuser" functionality, for example [2]:

admin postgres postgres

[1] The postgresql log message is 'FATAL 1: IDENT authentication
failed for user "postgres"'. The system log, though, shows
'identd[...]: reply to 127.0.0.1: 2438, 5432 : USERID : OTHER
:postgres'.

[2] The log message is, for example, 'DEBUG: connection:
host=127.0.0.1 user=postgres database=mydb'.
--
-William
This system has been running 47 days since the janitor knocked it over.
When did you last reboot Windows?

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Emberson 2002-03-26 23:26:58 lo_unlink usage
Previous Message Bruce Momjian 2002-03-26 18:18:23 Re: info request : listing active connections