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

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(dot)klaver(at)aklaver(dot)com