From: Peter Koczan <pjkoczan@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: SSL and md5 password?
Date: Wed, 29 Oct 2008 22:26:30 -0500
Message-ID: <4544e0330810292026j1b8e9307j62d6a9c828c7a6b5@mail.gmail.com> (raw)
In-Reply-To: <2764.1225332660@sss.pgh.pa.us>
References: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com>
<dcc563d10810291149w520c718v2a2557f183aa604@mail.gmail.com>
<20081029185434.GH4331@alvh.no-ip.org>
<2764.1225332660@sss.pgh.pa.us>
On Wed, Oct 29, 2008 at 1:49 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> 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.
Well, psql is trying to connect with SSL off even though postgres was
built with SSL support, the server has SSL turned on, and psql
connects with SSL by default for Kerberos connections. Where I was
getting confused was that, for some reason, md5 authentication wasn't
using SSL (or at least that's what the error suggested) and the only
thing I changed was what user/auth-method I was using.
On Wed, Oct 29, 2008 at 9:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> 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.
>
> Right. So in the meantime, what Peter should do is try the problem case
> after
> export PGSSLMODE=require
> so that he can see the error message that's relevant to his desired use.
After exporting that environment variable, it works. Thanks.
Peter
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pjkoczan@gmail.com, tgl@sss.pgh.pa.us, alvherre@commandprompt.com, scott.marlowe@gmail.com
Subject: Re: SSL and md5 password?
In-Reply-To: <4544e0330810292026j1b8e9307j62d6a9c828c7a6b5@mail.gmail.com>
References: <4544e0330810291007p5b68fba2o4ee782b4d4f92878@mail.gmail.com> <dcc563d10810291149w520c718v2a2557f183aa604@mail.gmail.com> <20081029185434.GH4331@alvh.no-ip.org> <2764.1225332660@sss.pgh.pa.us> <4544e0330810292026j1b8e9307j62d6a9c828c7a6b5@mail.gmail.com>
* 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