Re: pgSql authentication problem with openLdap - Mailing list pgsql-general

From Dave Page
Subject Re: pgSql authentication problem with openLdap
Date
Msg-id 937d27e10904141132g42649313y2e5be5f3d0b4a71c@mail.gmail.com
Whole thread Raw
In response to Re: pgSql authentication problem with openLdap  (sandiphw <sandiphw@hotmail.com>)
List pgsql-general
On Tue, Apr 14, 2009 at 1:28 PM, sandiphw <sandiphw@hotmail.com> wrote:
>
> I have tried all possible variation of syntax I can imagine, like
>
> host  all  all  202.18.10.0/24
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> host  all  all  202.18.10.0/24   ldap
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> host  all  all  202.18.10.0/24
> "ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people"
> host  all  all  202.18.10.0/24
> ldap://202.18.10.1:389/dc=abc,dc=net;cn=;,dc=holtecnet,dc=com
>
> But all shows the same error in postgresql log.
>
> I must be doing some basic syntax error. Is anybody get it working?

I had cause to test LDAP auth the other day. This is the pg_hba.conf
line I used:

host all all 172.24.32.0/24 ldap
"ldap://ldap.ox.uk.enterprisedb.com/dc=enterprisedb,dc=com;uid=;,ou=People,dc=enterprisedb,dc=com"

It took me an embarrassing amount of time to get it right though - I
missed the leading comma on the suffix :-)

I see you are using 8.1.11 though - first, if you are using 8.1, it
should be 8.1.17. Second, ldap auth support was added in 8.2 which
explains the syntax error. I would grab 8.3.7 and use that.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Kynn Jones
Date:
Subject: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Next
From: Alvaro Herrera
Date:
Subject: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...