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
