pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael.Haertel@t-systems.com
To: achill@matrix.gatewaynet.com
To: pgsql-admin@postgresql.org
Subject: Re: LDAP authentication fails with more than one entry returned
Date: Thu, 17 Aug 2017 15:07:19 +0000
Message-ID: <3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

As far as I understand you need to give the fully qualified DN to a user if you do simple binding. But in the pg_hba.conf I can only define a prefix that doesn’t change: “uid=”.

But because all the users come from different trees the suffix depends on the sub-tree where the user has been added to. This part of the DN can’t be configured statically in the pg_hba.conf.

Look at the DN for my example users in my play-instance of openLDAP:

uid=mhaertel,cn=ftth,ou=Teams,dc=organization_gismobile,dc=ldap_db1,dc=mydomain,dc=com

The part “cn=ftth,ou=Teams,dc=organization_gismobile” only is valid for a small subset of users and therefore I can’t define a full DN for the binding.

Regards,

Michael

Von: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von Achilleas Mantzios
Gesendet: Donnerstag, 17. August 2017 16:40
An: pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] LDAP authentication failes with more than one entry returned

On 17/08/2017 16:58, Michael.Haertel@t-systems.com<mailto:Michael.Haertel@t-systems.com> wrote:
Hello list,

I configured postgreSQL to only allow users that are administered in LDAP to connect to one particular database on my PostgreSQL host. This works fine as long as only one entry is returned for the combination of “ldapbasedn” and “ldapsearchattribute”.

Why don't you go the simple bind mode route? Just specify ldapprefix, ldapsuffix to construct your bind DN, this should by definition be unique.



I currently match the LDAP attribute UID against the login name. Problem is that the users exist several times in the specified (sub-) directory tree. Everything works if the user only exists once within the specified “ldapbasedn”.

How to deal with that problem?

I think it is common practice to have several sub-trees, one per organizational unit for example. Within that OU there are several sub-trees that define privileges for SAMBA shares, database connections or other purposes. Because I need to search for the users across several OUs, I can’t give the path to only one sub-tree.

I am currently on windows so I can’t test the ldapurl feature.

Would it be possible to use the ldapurl directive to allow an ldapsearch across different 1st level trees but only look for users within one particular sub-tree in each of the 1st level trees?

Thank you very much for your comments,

Michael Härtel



--

Achilleas Mantzios

IT DEV Lead

IT DEPT

Dynacom Tankers Mgmt


view thread (4+ messages)  latest in thread

Message-ID: <3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com>
Permalink:  ../3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com/
Also on:    postgresql.org/message-id/3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Michael.Haertel@t-systems.com, achill@matrix.gatewaynet.com
  Subject: Re: LDAP authentication fails with more than one entry returned
  In-Reply-To: <3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com>
  References: <3d5bf42743be4b789f4e70010a9259d8@HE101867.emea1.cds.t-internal.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox