| 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: | Whole Thread | Raw Message | 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 |