Authentication Postgres user via LDAP - Mailing list pgsql-admin

From Rafael Domiciano
Subject Authentication Postgres user via LDAP
Date
Msg-id 3a0028490909230607t3d05fc5bl28c1210eebff5a99@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello guys,

I'm configuring a new server, and I would to authenticate the users via LDAP. We already have systems doing this, like Intranet (Joomla! Framework) and Imap Mail.

So, for tests, I added the following line in the pg_hba.conf (according the Postgres Documentation):

host    all         "r.domiciano"       172.16.5.20     255.255.255.255 ldap "ldap://172.16.5.1/ou=usuarios,dc=senffnet,dc=intranet;SENFFNET\"

The user "r.domiciano" is already created in the Postgres.

When Trying to connect in the databse via psql, I'm prompted for password, and then for the error message:
psql postgres -h 172.16.5.20 -U "r.domiciano"
psql: FATAL:  autenticação do tipo LDAP falhou para usuário "r.domiciano"
psql: FATAL: LDAP authentication failed for user: "r.domiciano"

In the log I get a message saying "error code: 34"... googling a while I get that this is a invalid DN syntax. But i thing the pg_hba.conf is ok.

Has anyone get the same trouble? Helps?

Best Regards,

Rafael Domiciano

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: recovery is stuck when children are not processing SIGQUIT from previous crash
Next
From: Tom Lane
Date:
Subject: Re: recovery is stuck when children are not processing SIGQUIT from previous crash