[pgpool-general: 7918] Re: Problem using password authentication
Bo Peng
pengbo at sraoss.co.jp
Wed Dec 8 18:08:32 JST 2021
Hello,
> 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
I am wondering why the "user" and "database" are blank.
Can you connect to PostgreSQL from another network?
> Jon Schewe
>
> Principal Software Systems Technologist
>
> C: +1 612.263.2718
>
> O: +1 952.545.5720
>
> jon.schewe at raytheon.com
>
> Raytheon Technologies
>
> Raytheon Intelligence & Space
>
> 5775 Wayzata Blvd. Suite 630
>
> St. Louis Park, MN 55416
>
>
> RTX.com<https://www.rtx.com/> | LinkedIn<https://www.linkedin.com/company/raytheontechnologies> | Twitter<https://twitter.com/raytheontech> | Instagram<https://www.instagram.com/raytheontechnologies>
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/
More information about the pgpool-general
mailing list