[pgpool-general: 3245] Having trouble with trust mode with pgpool

Bruce Skelton sfcowpalace at gmail.com
Sat Oct 25 05:59:00 JST 2014


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141024/105d5cd2/attachment.html>


More information about the pgpool-general mailing list