Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf

From: Daniel Buus <daniel(at)nos(dot)co>
To: pgadmin-support(at)postgresql(dot)org
Subject: Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf
Date: 2016-07-22 12:29:19
Message-ID: CABt26P+xoZjUhvMzYjH60mK4Zr4X8pOW9QOfV4QANq-XR0jzVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi there :)

I'm trying to connect to a Postgresql server (running in a Docker
container) from pgAdmin (most recent 3 stable as well as most recent 4
beta).

Connecting to the server works fine with Postico. With pgAdmin,
however, I get the error, "SSL error: sslv3 alert handshake failure
FATAL: no pg_hba.conf entry for host "172.17.0.1", user "postgres",
database "nosco", SSL off" as long as my pg_hba.conf looks like this:

local all all trust
host all,replication replication samehost md5
hostssl all,replication replication samehost md5
hostssl all all samenet md5
hostssl nosco all .nos.co md5

The error message mentions "SSL off," so I tried adding "host all all
samenet md5" to pg_hba.conf, and this allows pgAdmin 4 to connect with
SSL still required in its connection settings. pgAdmin 3, however,
will still fail to connect with SSL required, but with the
non-SSL-allowing rule in pg_hba.conf it will now successfully connect
if I explicitly disable SSL in the connection settings.

Any idea why this is?

Thanks in advance,
Daniel

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2016-07-22 15:01:10 pgAdmin 4 v1.0-beta3 released
Previous Message Marcus Crowley 2016-07-22 01:10:01 White text on white background in Edit Data JSONB column