Postgres Pro
Downloads
Home   >   mailing lists

Re: How to test SSL cert from CA? - Mailing list pgsql-general

From Jeff Janes
Subject Re: How to test SSL cert from CA?
Date
Msg-id CAMkU=1xeu0nbv_R973HJSOj2Y=02ittUrboEkPou62JmhH0r9A@mail.gmail.com
Whole thread Raw
In response to Re: How to test SSL cert from CA?  (Francisco Reyes <lists@natserv.net>)
List pgsql-general
Tree view
On Thu, Jul 9, 2015 at 9:29 PM, Francisco Reyes <lists@natserv.net> wrote:
On 07/09/2015 03:07 PM, Vick Khera wrote:

On Wed, Jul 8, 2015 at 10:17 PM, Francisco Reyes <lists@natserv.net
 <mailto:lists@natserv.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

pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: regexp_matches for digit
Next
From: Eduardo Piombino
Date:
Subject: Disconnected but query still running