Re: Connection to database failed: FATAL: no pg_hba.conf entry for host - Mailing list pgsql-sql

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