Authentication Postgres user via LDAP

From: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Authentication Postgres user via LDAP
Date: 2009-09-23 13:07:47
Message-ID: 3a0028490909230607t3d05fc5bl28c1210eebff5a99@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-23 14:04:21 Re: recovery is stuck when children are not processing SIGQUIT from previous crash
Previous Message Peter Eisentraut 2009-09-23 11:21:31 recovery is stuck when children are not processing SIGQUIT from previous crash