Skip site navigation (1) Skip section navigation (2)

Re: SSL Support

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: dom(at)happygiraffe(dot)net (Dominic Mitchell)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SSL Support
Date: 2004-09-21 08:17:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Am Dienstag, 21. September 2004 09:24 schrieb Dominic Mitchell:
> I am also unsure of the
> procedures for submitting patches; is it ok to just send to hackers?


>   In initialize_SSL(), we call SSL_CTX_set_verify(), but we don't pass
>   in the SSL_VERIFY_FAIL_IF_NO_PEER_CERT flag.  This means that a client
>   can present no certificate and still get access to the server.

Client-side certificates as an authentication mechanism are not intended to be 
supported.  It might be a nice feature to add, though.

>   There's nothing that gets logged to say that an SSL connection was
>   made.  This would be useful for testing.  Something like logging the
>   connection as ""?

That seems reasonable.

>   In initialize_SSL(), we call SSL_CTX_set_verify_depth(SSL_context, 1).
>   This should probably be a configurable item.  I /think/ it might be
>   stopping me from successfully verifying the server certificate is
>   signed by the CA listed in my client's root.crt file, but I'm not
>   sure.

I think verification of the server certificates is not supported either.  SSL 
only serves for encryption, not authentication or integrity checking (which 
is probably a stupid idea).

>   In open_client_SSL() again, the call to verify that the CN of the
>   certificate is the same as the hostname you've connected to is
>   commented out.  So you have no idea whether or not you've connected to
>   the right server.

This seems to match the pattern I described above.

Peter Eisentraut

In response to

  • SSL Support at 2004-09-21 07:24:52 from Dominic Mitchell


pgsql-hackers by date

Next:From: Kaare RasmussenDate: 2004-09-21 08:44:22
Subject: Re: SSL Support
Previous:From: Dominic MitchellDate: 2004-09-21 07:24:52
Subject: SSL Support

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group