Re: Client certificate authentication - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Client certificate authentication
Date
Msg-id 492165ED.6080907@hagander.net
Whole thread Raw
In response to Re: Client certificate authentication  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> Magnus Hagander escribió:
>> On 16 nov 2008, at 01.00, "Alex Hunsaker" <badalex@gmail.com> wrote:
> 
>>> My only concern is there is no way to specify the USER_CERT_FILE for
>>> libpq.  So if for example I have two users that I want to use cert
>>> authentication for I really have to have to users on the system (or i
>>> guess maybe you could fake HOME=... psql -U other_user).   Or am I
>> While not directly related to this patch, that is a very good point. We 
>> have PGSSLKEY but not PGSSLCERT. Could certainly be worth adding.
> 
> FWIW I think this was part of the patch submitted by Mark Woodward; see
> http://wiki.postgresql.org/wiki/CommitFest_2008-07, and
> http://archives.postgresql.org/message-id/20080801203157.GL4321@alvh.no-ip.org

Seems like it. I totally missed that one.

As for the patch itself - do we really want to #ifdef all parameters
out? There's no harm in accepting them for non-ssl connections (and
ignoring them), and that might make life easier on third party stuff
that fills in all parameters with their default values if they're not
specified. Like we support sslmode even if we're compiled without SSL.

And yes, sslkey and PGSSLKEY should be made the same thing, I think.

//Magnus


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Client certificate authentication
Next
From: Aidan Van Dyk
Date:
Subject: Re: Block-level CRC checks