From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
cc: buildfarm-members@postgresql.org, buildfarm-admins@postgresql.org
Subject: Re: Moving to HTTPS
In-reply-to: <a04ba257-712f-b47e-54bd-a2ee1087f014@2ndQuadrant.com>
References: <89d566b4-58fb-c1e9-97ef-46d4d915b86c@dunslane.net>
 <20170107215523.GA294152@tornado.leadboat.com>
 <96080bc2-086f-c47f-6cee-b7f00a9bcd38@2ndQuadrant.com>
 <3104.1483834327@sss.pgh.pa.us>
 <a04ba257-712f-b47e-54bd-a2ee1087f014@2ndQuadrant.com>
Comments: In-reply-to Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
	message dated "Sat, 07 Jan 2017 21:37:12 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <7216.1484469582.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 15 Jan 2017 03:39:42 -0500
Message-ID: <7217.1484469582@sss.pgh.pa.us>
Precedence: bulk
Sender: buildfarm-members-owner@postgresql.org

Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> On 01/07/2017 07:12 PM, Tom Lane wrote:
>> Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
>>> Yeah, you're right. Or perhaps even more simply we could do:
>>> perl -MLWP::Simple -e 'print qq{BAD\n} unless head(q{https://www.postgr=
esql.org});'

>> Hmm, so that reports BAD on all four of my buildfarm critters :-(.

> Ugh. I was afraid of something like that. We might need to look at=20
> providing a proxy or something.

After further fooling with this, it seems the root cause is that you
need Perl (specifically Net::SSLeay) to be linked to OpenSSL 0.9.8
or later.  Since we require at least 0.9.8 for PG itself, this does
not seem like an unreasonably heavy lift.

I found that some of the involved modules, particularly IO::Socket::SSL
and LWP::Protocol::https, fail a few of their regression tests even
with 0.9.8.  But if you tell cpan to ignore that and install them
anyway, it seems like things work; at least, the simple test proposed
above now works on all four of my buildfarm critters.  It will be
interesting to see whether that equates to "buildfarm script can talk
to https server".  Do we have any more-thorough test case available?

BTW, if anyone else is like me and has a more modern openssl installed
in a non-default location on an old machine, the secret sauce for getting
Net::SSLeay to use that is to set environment variable OPENSSL_PREFIX
to the openssl install prefix path before building Net::SSLeay.

			regards, tom lane


--=20
Sent via buildfarm-members mailing list (buildfarm-members@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/buildfarm-members