Re: PostgreSQL 9.3.5 - Enable SSL

shyamkant.dhamke@wipro.com wrote:
> We have followed steps as mentioned by you. We are able to connect using PGAdmin, but now we are
> facing challenge while connecting from ASP.Net client.
> 
> My connection string is
> 
> <add key="ConnectPIAM_TRANS_DB" value="Server=10.200.201.79;Port=5555; User Id=postgres;
> Password=wipro@123;Database=PIAM_TRANS_DB;Protocol=3;SSL=true;sslMode=Require;"/>
> 
> Also attached cert file for your reference.
> 
> I am getting below error
> 
> “FATAL: 28000: connection requires a valid client certificate”

The error message means that the client did not send a valid
client certificate (i.e. one that can be verified using the server's
certificate chain).

What .NET provider are you using?
Do you have a the server parameter ssl_ca_file point to your CA certificate?
Does your provider send a client certificate?

Yours,
Laurenz Albe