[Auth] "ident" method and LDAP user accounts - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject [Auth] "ident" method and LDAP user accounts
Date
Msg-id 20050302144313.GA1531@generic-nic.net
Whole thread Raw
Responses Re: [Auth] "ident" method and LDAP user accounts  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [Auth] "ident" method and LDAP user accounts  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-general
I manage a Debian/Linux machine which runs PostgreSQL 7.4.7.

All the user accounts, including mine, are in a LDAP database. Thanks
to NSS (Name Service Switch) all applications have access to the LDAP
accounts (getpwuid(3) and getpwnam(3) use LDAP). But not PostgreSQL.

When I connect locally (Linux as SO_PEERCRED so the ident daemon is
not used) with the "ident" method, I get rejected.

If I create an ident map to map the numeric UID to my name, it works:

# MAPNAME     IDENT-USERNAME    PG-USERNAME
ldapuser      1000              bortzmeyer

It is of course very inconvenient to duplicate my LDAP database into
pg_ident.conf. Is there a better way?

pgsql-general by date:

Previous
From: Bernt Andreas Drange
Date:
Subject: Re: [ADMIN] Database Name
Next
From: "Alexandru Coseru"
Date:
Subject: Error: "catalog is missing 8 attribute(s) for relid 16683"