Re: PostgreSQL 9.3.5 - Enable SSL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Venkata B N,

 

Thanks for response. I have attached files for your reference. Yes we have made entry in pg_hba.conf file.

 

Please help. Thanks in advance.

 

Regards

Shyamkant

 

From: Venkata Balaji N [mailto:nag1010@xxxxxxxxx]
Sent: 24 February, 2016 2:29 AM
To: Shyamkant Dhamke (BAS) <shyamkant.dhamke@xxxxxxxxx>; pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: [ADMIN] PostgreSQL 9.3.5 - Enable SSL

 

 

On Wed, Feb 24, 2016 at 3:04 AM, <shyamkant.dhamke@xxxxxxxxx> wrote:

Many Thanks Venkata B N,

 

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”

 

Did you make an hostssl entry in pg_hba.conf for the host from where pgAdmin-III is connecting ?

 

Can you get us the ssl* parameters configured in postgresql.conf file ?

 

Regards,

Venkata B N

 

Fujitsu Australia

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com

Attachment: pg_hba.conf
Description: pg_hba.conf

Attachment: postgresql.conf
Description: postgresql.conf

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux