Re: PostgreSQL 9.3.5 - Enable SSL - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: PostgreSQL 9.3.5 - Enable SSL
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53800738@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: PostgreSQL 9.3.5 - Enable SSL  (Venkata Balaji N <nag1010@gmail.com>)
Responses Re: PostgreSQL 9.3.5 - Enable SSL
List pgsql-admin
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

pgsql-admin by date:

Previous
From:
Date:
Subject: Re: PostgreSQL 9.3.5 - Enable SSL
Next
From: Matheus de Oliveira
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2