Re: Login with LDAP authentication takes 5 seconds

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Login with LDAP authentication takes 5 seconds
Дата
Msg-id CAMkU=1x+Epx+L_qU27MJ3-iMRCUkNnQaPEOjGggRxSzLry6gQQ@mail.gmail.com
обсуждение исходный текст
Ответ на Login with LDAP authentication takes 5 seconds  (Andreas Schmid <user462411@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, May 28, 2018 at 10:26 AM, Andreas Schmid <user462411@gmail.com> wrote:
Hi,

I configured my PostgreSQL 10 DB on Debian 9.2 with LDAP authentication (simple bind mode). While this basically works, it has the strange effect that the first login with psql takes around 5 seconds. When I reconnect within 60 seconds, the login completes immediately.

The LDAP server is behind a firewall. So for a test, in pg_hba.conf I put the LDAP servers IP address instead of its DNS name (for parameter ldapserver). Like that, all logins complete immediately. But in general I prefer specifying the DNS name rather than the IP.

When I checked on the DB machine with the following commands
host my.ldap.server.org
both always returned the host name and IP address of the LDAP server immediately.

Out of curiosity, what if you use "ping" rather than "dig" or "host"?

Cheers,

Jeff

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

Предыдущее
От: C GG
Дата:
Сообщение: Re: LDAP authentication slow
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Pgagent is not reading pgpass file either in Windows or Linux.