Date: Mon, 11 Apr 2016 15:31:26 -0700 (MST)
From: Chris <cglenstark@apple.com>
To: pgsql-sql@postgresql.org
Message-ID: <1460413886714-5898099.post@n5.nabble.com>
Subject: Connection to database failed: FATAL:  no pg_hba.conf entry for
 host
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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 =E2=
=80=9Cno
pg_hba.cong entry for host =E2=80=A6=E2=80=9D error is returned from PQerro=
rMessage.=20

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

I am using the following include file:

#include <libpq-fe.h>

I create the connection string using the following format. Then=20

NSString *connstr =3D [NSString stringWithFormat:@"sslmode=3D'prefer' host=
=3D'%@'
port=3D'%@' user=3D'%@' password=3D'%@' dbname=3D'%@'", host, port, user, p=
ass, db];

const char *conninfo =3D [connstr cStringUsingEncoding:NSASCIIStringEncodin=
g];

PGconn *conn =3D  PQconnectdb (conninfo);

/*
conninfo =3D "sslmode=3D'prefer' host=3D'host.domain.com' port=3D'' user=3D=
'username'
password=3D'password' dbname=3D'database'"
*/

if (PQstatus(conn) !=3D 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=20
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.=20


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


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