PostgreSQL and OpenLdap

From: "Cristiano Panvel" <cristiano(dot)panvel(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL and OpenLdap
Date: 2007-02-11 22:54:56
Message-ID: 8e8b996b0702111454r74c30fa7p72d3be1c3059431b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Friends,

This is my first post in the list.

I am not obtaining authentication my users of PostgreSQL in OpenLdap.

1) PostgreSQL was compiled with the support to ldap in a FreeBSD System.
"option --with-ldap for configure".

2) The user also exists in the base of the OpenLdap

3) Already I also added the line of configuration in "pg_hba.conf" and
in the "pg_service.conf"

$ tail /etc/pg_service.conf
ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br

$ cat /usr/local/pgsql/data/pg_hba.conf

local all all trust

host all all 10.193.4.0/24 md5

ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br

4) To create the usuary I make thus

# su - pgsql
% createuser scott

After the made configurations, I try to effect login and is error of password.

remote# psql postgresql -h server -U scott -W
psql: FATAL: password authentication failed for user "scott"

It will be that somebody could help me, "I am making something incorrect !!!"

http://www.postgresql.org/docs/current/interactive/libpq-ldap.html

Thanks Cris.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phil Endecott 2007-02-11 23:09:43 Re: getting postgres to emulate mysql/sqlserver bit datatype
Previous Message Peter Eisentraut 2007-02-11 22:11:48 Re: getting postgres to emulate mysql/sqlserver bit datatype