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

[Bo Peng]

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/