Re: pgSql authentication problem with openLdap

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: pgSql authentication problem with openLdap
Дата
Msg-id 937d27e10904141132g42649313y2e5be5f3d0b4a71c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgSql authentication problem with openLdap  (sandiphw <sandiphw@hotmail.com>)
Список pgsql-general
On Tue, Apr 14, 2009 at 1:28 PM, sandiphw <sandiphw@hotmail.com> 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
> 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://202.18.10.1:389/dc=abc,dc=net;cn=;,dc=holtecnet,dc=com
>
> But all shows the same error in postgresql log.
>
> I must be doing some basic syntax error. Is anybody get it working?

I had cause to test LDAP auth the other day. This is the pg_hba.conf
line I used:

host all all 172.24.32.0/24 ldap
"ldap://ldap.ox.uk.enterprisedb.com/dc=enterprisedb,dc=com;uid=;,ou=People,dc=enterprisedb,dc=com"

It took me an embarrassing amount of time to get it right though - I
missed the leading comma on the suffix :-)

I see you are using 8.1.11 though - first, if you are using 8.1, it
should be 8.1.17. Second, ldap auth support was added in 8.2 which
explains the syntax error. I would grab 8.3.7 and use that.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Kynn Jones
Дата:
Сообщение: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...