Re: pgSql authentication problem with openLdap

On Tue, Apr 14, 2009 at 1:28 PM, sandiphw <sandiphw(at)hotmail(dot)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