Re: [GENERAL] ldap auth problem

[Brian Wong]

On 1/2/07, Ing. Dan Horáček <[EMAIL PROTECTED]> wrote:

 Hi,
 I've just installed postgres 8.2.0-1 for win32 and wanted to try out the
 built-in LDAP support(with Openldap and Novell eDirectory).
 The following LDAP authentication was added to "pg_hba.conf" :

 Openldap:
 host     all         all         127.0.0.1/32          ldap
 ldap://localhost/dc=dandoma,dc=cz;cn=;,dc=dandoma,dc=cz

 However when trying to connect, it gave the error.
 Look at the server log:
 2006-12-31 19:34:59 LOG:  LDAP login failed for user
"cn=postgres
dc=dandoma
dc=cz" on server "localhost": error code 34
 2006-12-31 19:34:59 FATAL:  LDAP authentication failed for user "postgres"


 eDirectory:
 pg_hba.conf:
 host     all         all         127.0.0.1/32          ldap
ldap://192.168.168.2/ou=win2000,o=plhb;cn=;,ou=win2000,o=plhb

 Server log:
 2006-12-29 13:50:18 LOG:  LDAP login failed for user
"cn=xxx
ou=win2000
o=plhb" on server "192.168.168.2": error code 32
 2006-12-29 13:50:18 FATAL:  LDAP authentication failed for user "xxx"

 The problem seems to be in conversion of comma in suffix.

 Thanks in advance.
 Dan

I have found that quoting the suffix works. The conversion does not
happen when quoting.

---------------------------(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