Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-16 Thread sandiphw
Thanks you all for your helps. Finally I have updated to 8.3.7 version and and able to get it worked with openldap with the following directives as you suggested: host all all 202.18.10.0/24 ldap ldap://202.18.10.1:389/ou=People,dc=example,dc=com;uid=;,ou=People,dc=example,dc=com"; -- View

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-14 Thread Dave Page
On Tue, Apr 14, 2009 at 1:28 PM, sandiphw wrote: > > I have tried all possible variation of syntax I can imagine, like > > host  all  all  202.18.10.0/24 > ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people > host  all  all  202.18.10.0/24   ldap > ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people > ho

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-14 Thread Scott Mead
On Tue, Apr 14, 2009 at 8:28 AM, sandiphw wrote: > > I have tried all possible variation of syntax I can imagine, like > > host all all 202.18.10.0/24 > ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people > host all all 202.18.10.0/24 ldap > ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people > h

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-14 Thread Raymond O'Donnell
On 14/04/2009 13:28, sandiphw wrote: > host all all 202.18.10.0/24 > "ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people"; I don't know anything about LDAP, I'm only scanning the PG docs, but this version is missing the "ldap" method. It should be: host all all 202.18.10.0/24 ldap "ldap:

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-14 Thread sandiphw
I have tried all possible variation of syntax I can imagine, like host all all 202.18.10.0/24 ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people host all all 202.18.10.0/24 ldap ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people host all all 202.18.10.0/24 "ldap://202.18.10.1:389/dc

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-13 Thread Raymond O'Donnell
On 13/04/2009 13:49, sandiphw wrote: > invalid entry in the file pg_hba.conf at line 82, token "ldap://202.. > " > fatal: missing of erroneous pg_hba.conf file Have you got double-quotes around the entry in ph_hba.conf? According to the docs, it's a good idea to do that. http://www.postg

Re: [GENERAL] pgSql authentication problem with openLdap

2009-04-13 Thread sandiphw
Sorry, forget to mention the log message of pgsql: invalid entry in the file pg_hba.conf at line 82, token "ldap://202.. " fatal: missing of erroneous pg_hba.conf file -- View this message in context: http://www.nabble.com/pgSql-authentication-problem-with-openLdap-tp23021809p23021943.h

[GENERAL] pgSql authentication problem with openLdap

2009-04-13 Thread sandiphw
We have installed postgresql 8.1.11 in CentOS, also installed openLdap 2.3.27. I have tried a lot to authenticate the user against ldap but couldn't succeed. Can anyone pl help me out? I have added the following entry in pg_hba.conf host all all 202.18.10.0/24 ldap://202.18.10.1:389/dc=abc,