[pgpool-general: 7927] Re: Problem using password authentication
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Dec 10 08:41:06 JST 2021
>> 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
More information about the pgpool-general
mailing list