Connection to database failed: FATAL: no pg_hba.conf entry for host

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.



--
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.