[pgpool-general: 7927] Re: Problem using password authentication

[Tatsuo Ishii]

>> I'm using password authentication over SSL. This works fine with connections from the same network, but doesn't work with connections from another network. Can anyone explain why this isn't working?
>> 
>> in pgpool.conf:
>> enable_pool_hba = on
>> pool_passwd = ''
>> 
>> 
>> in pool_hba.conf:
>> # "local" is for Unix domain socket connections only
>> local   all         all                               trust
>> # IPv4 local connections:
>> host    all         all         127.0.0.1/32          trust
>> host    all         all         ::1/128               trust
>> 
>> hostssl    all         all           0.0.0.0/0          password
>> 
>> log output:
>> Dec  7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: WARNING:  unable to get password, password file descriptor is NULL
>> Dec  7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: FATAL:  client authentication failed
>> Dec  7 16:20:59 psql-01 pgpool[1085857]: 2021-12-07 16:20:59: pid 1102488: DETAIL:  no pool_hba.conf entry for host "XXX.XXX.XXX.XXX", user "", database "", SSL off

Also I suspect SSL connection between client and Pgpool-II does not succeed.
You might want to change:

hostssl    all         all           0.0.0.0/0          password

to:
hostssl    all         all           0.0.0.0/0          trust

so that you can verify whether the SSL setting is correct or not. If
after this you still get an error, there's something wrong with the
SSL setting.

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