Re: hostnossl in pg_hba.conf demands a password

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: hostnossl in pg_hba.conf demands a password
Дата
Msg-id 5878107F-B5AB-4AEB-8B52-987AF3DB1739@gmail.com
обсуждение исходный текст
Ответ на Re: hostnossl in pg_hba.conf demands a password  (Venkata B Nagothi <nag1010@gmail.com>)
Ответы Re: hostnossl in pg_hba.conf demands a password  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
The only entries are a local connection line with md5 authentication specified and a line for local replication with a trust authentication. Both of these entries do seem to be working properly.

Sent from my iPad

On Nov 14, 2016, at 4:20 PM, Venkata B Nagothi <nag1010@gmail.com> wrote:


On Tue, Nov 15, 2016 at 8:10 AM, John Scalia <jayknowsunix@gmail.com> wrote:
I've been experimenting a bit with both 9.4.10 and 9.6.0 and both of these are exhibiting the same behavior. I've been setting up zabbix and the local agent requires a trust connection. So, if my pg_hba.conf has a line:

host         all                monitoring.          127.0.0.1/32.    trust

It works as I expected, but if I change "host" to "hostnossl" and reload, it then demands a password for the monitoring user.

The servers are configured with SSL and all other connections require "hostssl", but the zabbix agent is not configured with SSL. I'd say this behavior is a bug, but maybe I missed reading the fine manual somewhere. Has anyone else seen this or maybe the docs need updating.
 
Do you have any other entries (for 127.0.0.1) in pg_hba.conf which is generating this behaviour ?

Regards,

Venkata B N
Database Consultant

Fujitsu Australia

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

Предыдущее
От: Venkata B Nagothi
Дата:
Сообщение: Re: hostnossl in pg_hba.conf demands a password
Следующее
От: Tom Lane
Дата:
Сообщение: Re: hostnossl in pg_hba.conf demands a password