[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.pgpool.net/pipermail/pgpool-general/attachments/20141024/105d5cd2/attachment.htm>
More information about the pgpool-general
mailing list