agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Chris <cglenstark@apple.com>
To: pgsql-sql@postgresql.org
Subject: Connection to database failed: FATAL:  no pg_hba.conf entry for host
Date: Mon, 11 Apr 2016 15:31:26 -0700 (MST)
Message-ID: <1460413886714-5898099.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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-tp589...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


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

view thread (6+ messages)  latest in thread

Message-ID: <1460413886714-5898099.post@n5.nabble.com>
Permalink:  ../1460413886714-5898099.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1460413886714-5898099.post@n5.nabble.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: cglenstark@apple.com
  Subject: Re: Connection to database failed: FATAL:  no pg_hba.conf entry for host
  In-Reply-To: <1460413886714-5898099.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox