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