Re: Connection not allowed because of an error 'Not in pg_hba.conf' - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Connection not allowed because of an error 'Not in pg_hba.conf'
Date
Msg-id 103d7895-72a6-98ce-87b3-f23307408244@aklaver.com
Whole thread Raw
In response to Connection not allowed because of an error 'Not in pg_hba.conf'  ("Johnson, Bruce E - (bjohnson)" <Johnson@pharmacy.arizona.edu>)
List pgsql-general
On 9/18/23 12:45, Johnson, Bruce E - (bjohnson) wrote:
> I am doing some testing trying to migrate some websites from using 
> Oracle to Postgres. (Using Perl DBI and DBD::Pg as the connecting 
> mechanism)
> 
> (Server Environment Postgres 15 running on Ubuntu 22.04, client Rocky 
> Linux using the supplied PostgreSQL DBI and DBD::Pg packages)
> 
> The error I am getting on the client is:
> 
>   password authentication failed for user "trav"
> 
> connection to server at "dhbpostgres.pharmacy.arizona.edu" 
> (10.128.206.109), port 5432 failed: FATAL:  no pg_hba.conf entry for 
> host "10.128.206.109", user "trav", database "webdata", no encryption
> 
> 
> But I do have an entry that should allow it:
> 
> #Internal server mgmt range
> 
> hostsslallall10.128.206.0/23 password

I guessing you want that to be:

10.128.206.109/32

or

10.128.206.0/24


> -- 
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
> 
> Institutions do not have opinions, merely customs
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: "Johnson, Bruce E - (bjohnson)"
Date:
Subject: Connection not allowed because of an error 'Not in pg_hba.conf'
Next
From: Tom Lane
Date:
Subject: Re: Connection not allowed because of an error 'Not in pg_hba.conf'