[pgpool-general: 3632] pgpool auth worklflow

[Ilia Zenkevich]

Hi all.

My question is about pgpool 3.1.14
In documentation I see description about auth through enabling option
enable_pool_hba
And what is the workflow when enable_pool_hba is false ? Is this simple
proxy of auth requests to backend?

If yes, I have second question.
My configuration is:
Ubuntu 14.04 x64
pgpool 3.1.14 in master/slave (stream) mode with load balancing enabled
enable_pool_hba = false

When I trying to test connection, I get:
psql: ERROR:  MD5 authentication is unsupported in replication,
master-slave and parallel modes.
HINT:  check pg_hba.conf

I find problem description and way to solve it, when enable_pool_hba = true
But I have enable_pool_hba =false

I see that requests do not reach master/slave backends.

pgpool in debug mode gives:
2015-04-16 16:25:39 DEBUG: pid 21851: I am 21851 accept fd 6
2015-04-16 16:25:39 LOG:   pid 21851: connection received:
host=10.10.10.221 port=51043
2015-04-16 16:25:39 DEBUG: pid 21851: Protocol Major: 1234 Minor: 5679
database:  user:
2015-04-16 16:25:39 DEBUG: pid 21851: SSLRequest from client
2015-04-16 16:25:39 DEBUG: pid 21851: read_startup_packet:
application_name: psql
2015-04-16 16:25:39 DEBUG: pid 21851: Protocol Major: 3 Minor: 0 database:
test user: test
2015-04-16 16:25:39 DEBUG: pid 21851: new_connection: connecting 0 backend
2015-04-16 16:25:39 DEBUG: pid 21851: new_connection: connecting 1 backend
2015-04-16 16:25:39 DEBUG: pid 21851: pool_read_message_length: slot: 0
length: 12
2015-04-16 16:25:39 DEBUG: pid 21851: pool_read_message_length: slot: 1
length: 12
2015-04-16 16:25:39 DEBUG: pid 21851: pool_do_auth: auth kind:5

-- 
--
Best regards,
Ilia Zenkevich
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150416/0bc24510/attachment.htm>