Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
Date
Msg-id 200904121213.02863.peter_e@gmx.net
Whole thread Raw
In response to Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt  (Magnus Hagander <magnus@hagander.net>)
Responses Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
List pgsql-bugs
On Sunday 12 April 2009 01:58:26 Magnus Hagander wrote:
> "sslmode=prefer" honestly makes no sense - if I don't care if it ends up
> encrypted or not (which it means), then why not just run with SSL off
> and not have to deal with the overhead?

Perhaps a large part of the problem at hand is in fact that the default is
sslmode=prefer, which, if the server is set up with some snakeoil certificate,
causes all these cn verification problems, when the user really didn't care in
the first place.

Another thing is that not all combinations of sslmode and sslverify make
sense.  If the user cares little about SSL ("allow", "prefer"), then insisting
on a verifyable certificate is pointless.

One random idea is to fold both of these settings into sslmode, with the
following progression:

disable, allow, prefer, require, require-cert, require-cn

And then set the default to "disable", because as you say "prefer" is pretty
silly.  And then users can explictly choose which level of SSL-ness they want.

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
Next
From: Magnus Hagander
Date:
Subject: Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt