[pgpool-general: 3246] Re: Having trouble with trust mode with pgpool

[Tatsuo Ishii]

You need to allow connecting via trust auth of pg_hba.conf by user
*and* host where pgpool-II is running on. What is the IP of pgpool-II
host?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> pgpool-lb, db1 and db2 are all on separate hosts. Using streaming
> replication PostgreSQL 9.2.8.
> I have mode trust configured for this user on both DB hosts. And as the
> user I am able to connect via trust to both db hosts.
> 
> error when connecting
> dev:~ adm$ psql -U myuser -h pgpool-lb <http://pgpool.host.com/> test
> psql: ERROR:  MD5 authentication is unsupported in replication,
> master-slave and parallel modes.
> HINT:  check pg_hba.conf
> 
> pgpool.log entry
> 
> 2014-10-21 13:39:00 DEBUG: pid 7810: I am 7810 accept fd 5
> 2014-10-21 13:39:00 LOG:   pid 7810: connection received:
> host=17.203.48.103 port=58440
> 2014-10-21 13:39:00 DEBUG: pid 7810: Protocol Major: 1234 Minor: 5679
> database:  user:
> 2014-10-21 13:39:00 DEBUG: pid 7810: SSLRequest from client
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_ssl: SSL requested but SSL
> support is not available
> 2014-10-21 13:39:00 DEBUG: pid 7810: read_startup_packet: application_name:
> psql
> 2014-10-21 13:39:00 DEBUG: pid 7810: Protocol Major: 3 Minor: 0 database:
> test user: cumulusman
> 2014-10-21 13:39:00 DEBUG: pid 7810: new_connection: connecting 0 backend
> 2014-10-21 13:39:00 DEBUG: pid 7810: new_connection: connecting 1 backend
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_ssl: SSL requested but SSL
> support is not available
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_ssl: SSL requested but SSL
> support is not available
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_read_message_length: slot: 0
> length: 12
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_read_message_length: slot: 1
> length: 12
> 2014-10-21 13:39:00 DEBUG: pid 7810: pool_do_auth: auth kind:5
> 
> pg_hba.conf entry on both db hosts.
> 
> # Rule Name: trust-dev-myuser
> # Description: Allow from 17.203.48.103
> # Order: 140
> host    all     myuser      17.203.48.103 255.255.252.0     trust
> 
> pool_hba.conf entry
> 
> host    all     myuser     17.203.48.103    255.255.252.0  trust
> 
> pgpool.conf
> 
> listen_addresses = '*'
> enable_pool_hba = off
> pool_passwd = ''
> 
> Thanks in advance for any help.
> Bruce