Re: Connection fails on one system in a address range allowed to connect

On Tue, 2023-11-21 at 23:27 +0000, Johnson, Bruce E - (bjohnson) wrote:
> DBI connect('dbname=webdata;host=dhbpostgres.pharmacy.arizona.edu;port=5432','trav',...) failed: FATAL:  password authentication failed for user "trav"
> FATAL:  no pg_hba.conf entry for host "150.135.124.50", user "trav", database "webdata", no encryption at ./pg_test.pl line 8.
> 
> The pg_hba.conf on the server includes this which should encompass all systems in this VLAN
> 
> # external 'OldMTM' site range
> hostssl all all 150.135.124.0/25 password
> 
> Anywhere else that I should look for a cause?

"no encryption" does not match a "hostssl" entry.

Either add "sslmode=require" to the connection string, or use a "hostnossl" entry.

Yours,
Laurenz Albe