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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to