Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group