Subject: Re: Connection to database failed: FATAL: no pg_hba.conf entry
 for host
To: Chris <cglenstark@apple.com>, pgsql-sql@postgresql.org
References: <1460413886714-5898099.post@n5.nabble.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <570D7D2C.8010404@aklaver.com>
Date: Tue, 12 Apr 2016 15:56:44 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.7.2
MIME-Version: 1.0
In-Reply-To: <1460413886714-5898099.post@n5.nabble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 04/11/2016 03:31 PM, Chris wrote:
> Introduction:
>
> I am working on an application that connects to a postgres database using
> the libpq API. As a requirement the remote host uses SSL.
>
> The scenario involves two Mac computers. We also have two different users,
> each with their own account to access the database.
>
> On one computer, the application works fine and both users can connect to
> the database using SSL.
>
> On the other computer, both users fail to connect to a database and the “no
> pg_hba.cong entry for host …” error is returned from PQerrorMessage.
>
> All users can connect to the database on both computers using either psql,
> or pgAdmin.
>
> Code Syntax:
>
> Development is done on Mac with code written in Cocoa / Objectice-C, and C
> language.
>
> I am using the following include file:
>
> #include <libpq-fe.h>
>
> I create the connection string using the following format. Then
>
> NSString *connstr = [NSString stringWithFormat:@"sslmode='prefer' host='%@'
> port='%@' user='%@' password='%@' dbname='%@'", host, port, user, pass, db];
>
> const char *conninfo = [connstr cStringUsingEncoding:NSASCIIStringEncoding];
>
> PGconn *conn =  PQconnectdb (conninfo);
>
> /*
> conninfo = "sslmode='prefer' host='host.domain.com' port='' user='username'
> password='password' dbname='database'"
> */
>
> if (PQstatus(conn) != CONNECTION_OK)
> {
> 	// no pg_hba.conf entry for host error occurs
> }
>
>
> Configuration Settings:
>
> pg_hba.conf contains
>
> hostssl		all	all	0.0.0.0/0	md5
>
>
> postgresql.conf contains
>
> ssl		on		on
> ssl_cert_file	server.crt	server.crt
> ssl_key_file	server.key	server.key
>
>
> Since I able to connect to both computers using psql and pgAdmin, I suspect
> the problem is with the connection within the Application. The connection
> string in the application is correct, and I verified the user name and
> password being passed properly.

Have you verified the other parameters, in particular the port. I am 
suspicious of the port='' in the above. The error is pretty straight 
forward, the correct host name is not being found in the the pg_hba.conf 
file. That means either the host name  is not specified  correctly in 
the file or you are connecting to a different cluster(port) then you 
think are and are picking up a different pg_hba.conf.

>
>
>
> --
> View this message in context: http://postgresql.nabble.com/Connection-to-database-failed-FATAL-no-pg-hba-conf-entry-for-host-tp5898099.html
> Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql