Re: SSL and md5 password? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: SSL and md5 password?
Date
Msg-id 20081029185434.GH4331@alvh.no-ip.org
Whole thread Raw
In response to Re: SSL and md5 password?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: SSL and md5 password?
List pgsql-admin
Scott Marlowe escribió:
> On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <pjkoczan@gmail.com> wrote:

> > And an md5 connection...
> >
> > $ /s/postgresql/bin/psql -h dumbo.cs.wisc.edu -p 5432 -U test_md5 koczan_test
> > Password for user test_md5:
> > psql: FATAL:  no pg_hba.conf entry for host "128.105.162.36", user
> > "test_md5", database "koczan_test", SSL off
>
> According to this, you're trying to connect with SSL off, right?  I
> don't think you've got any matching lines for that in your
> pg_hba.conf.  But I could be reading that wrong.

libpq tries to connect with SSL on and then falls back to SSL off.  If
the latter fails, the error message from the first attempt has been
overwritten, and only the second one is logged.

This has been fixed by Magnus on CVS HEAD.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: SSL and md5 password?
Next
From: Tom Lane
Date:
Subject: Re: SSL and md5 password?