From: Alvaro Herrera <alvherre@commandprompt.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: SSL and md5 password?
Date: Wed, 29 Oct 2008 15:54:34 -0300
Message-ID: <20081029185434.GH4331@alvh.no-ip.org> (raw)
In-Reply-To: <dcc563d10810291149w520c718v2a2557f183aa604@mail.gmail.com>
References: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com>
<dcc563d10810291149w520c718v2a2557f183aa604@mail.gmail.com>
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
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-admin@postgresql.org
Cc: alvherre@commandprompt.com, scott.marlowe@gmail.com, pjkoczan@gmail.com
Subject: Re: SSL and md5 password?
In-Reply-To: <20081029185434.GH4331@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox