Skip site navigation (1) Skip section navigation (2)

Re: SSL and md5 password?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Peter Koczan <pjkoczan(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SSL and md5 password?
Date: 2008-10-29 18:54:34
Message-ID: 20081029185434.GH4331@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Scott Marlowe escribió:
> On Wed, Oct 29, 2008 at 11:07 AM, Peter Koczan <pjkoczan(at)gmail(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-10-30 02:11:00
Subject: Re: SSL and md5 password?
Previous:From: Scott MarloweDate: 2008-10-29 18:49:26
Subject: Re: SSL and md5 password?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group