Re: How to test SSL cert from CA?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Francisco Reyes <lists(at)natserv(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to test SSL cert from CA?
Date: 2015-07-10 18:26:07
Message-ID: CAMkU=1xeu0nbv_R973HJSOj2Y=02ittUrboEkPou62JmhH0r9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 9, 2015 at 9:29 PM, Francisco Reyes <lists(at)natserv(dot)net> wrote:

> On 07/09/2015 03:07 PM, Vick Khera wrote:
>
>>
>> On Wed, Jul 8, 2015 at 10:17 PM, Francisco Reyes <lists(at)natserv(dot)net
>> <mailto:lists(at)natserv(dot)net>> wrote:
>>
>> openssl s_client -connect HOST:PORT -CAfile /path/to/CA.pem
>>
>
> According to this post:
> http://serverfault.com/questions/79876/connecting-to-postgresql-with-ssl-using-openssl-s-client?rq=1
>
> one can not use openssl to test ssl connection to postgresql. True?

If you think the problem might be with the certificate itself, then take
postgresql out of the loop entirely by installing that certificate to be
used by apache (for instance) instead of by postgresql. Then use s_client
against apache.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eduardo Piombino 2015-07-10 22:53:57 Disconnected but query still running
Previous Message John McKown 2015-07-10 16:40:59 Re: Bounded Zone Offset Query