Connecting to Postgres with SSL Mode without certificate

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
n3xus
Posts: 2
Joined: Mon 13 Jul 2020 03:19

Connecting to Postgres with SSL Mode without certificate

Post by n3xus » Mon 13 Jul 2020 03:26

This is the connection string I'm using to connect to Postgres in C#.

Host={host};Database={db};Username={userid};Password={password};SSL Mode=Require;Trust Server Certificate=true

But I couldn't connect to this DB using Data Compare for PostgreSQL.

Is there an option to connect to Postgres using SSL without specifying certificates?

alexa

Re: Connecting to Postgres with SSL Mode without certificate

Post by alexa » Mon 13 Jul 2020 15:43

We will review this and will answer you as soon as possible.

n3xus
Posts: 2
Joined: Mon 13 Jul 2020 03:19

Re: Connecting to Postgres with SSL Mode without certificate

Post by n3xus » Wed 15 Jul 2020 05:21

Thanks @alexa

Seismic
Posts: 3
Joined: Fri 30 Oct 2020 18:38

Re: Connecting to Postgres with SSL Mode without certificate

Post by Seismic » Fri 30 Oct 2020 18:45

Is there a fix to support this? I"m using the latest version of dbForge Data Compare for PostgreSQL 3.3.6

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Connecting to Postgres with SSL Mode without certificate

Post by dzhanhira » Mon 02 Nov 2020 16:18

There will be a fix in one of the next realizes of that product.

Seismic
Posts: 3
Joined: Fri 30 Oct 2020 18:38

Re: Connecting to Postgres with SSL Mode without certificate

Post by Seismic » Wed 18 Nov 2020 17:49

Are there any updates on the fix for this issue?

alexa

Re: Connecting to Postgres with SSL Mode without certificate

Post by alexa » Thu 19 Nov 2020 12:21

Unfortunately, we still don't have an estimated date for this.

alexa

Re: Connecting to Postgres with SSL Mode without certificate

Post by alexa » Mon 01 Feb 2021 15:59

You can use SSL connection without authentication on both server and client side. If you don't want server to verify the client certificate, you need to configure PostgreSQL server without the root.crt, and if you don't want client to verify the server certificate, don't set the SslOptions.CACert property of the connection.

Seismic
Posts: 3
Joined: Fri 30 Oct 2020 18:38

Re: Connecting to Postgres with SSL Mode without certificate

Post by Seismic » Mon 15 Mar 2021 16:26

@alexa - Your suggestion doesn't work for me. In the Security tab for the Database Connection Properties, I have "Use security protocol" checked, but all the other fields empty. When I hit Test Connection, I receive:

"The server hello message uses a protocol that was not"

I'm using version 3.3.6

sergiosaw
Posts: 1
Joined: Mon 05 Jul 2021 11:29

Re: Connecting to Postgres with SSL Mode without certificate

Post by sergiosaw » Mon 05 Jul 2021 11:32

Any news on this topic, we have the same problem. When we tried to connect to a postgresql v 13.0 we have the error: "The server hello message uses a protocol that was not recognized."

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Connecting to Postgres with SSL Mode without certificate

Post by dzhanhira » Tue 06 Jul 2021 11:23

Could you please provide more information regarding to your case (server settings. etc)?

AnnaMia
Posts: 1
Joined: Thu 14 Oct 2021 19:00

Re: Connecting to Postgres with SSL Mode without certificate

Post by AnnaMia » Thu 14 Oct 2021 19:40

Is anyone attending to this issue?
I'm almost giving up!

alexa

Re: Connecting to Postgres with SSL Mode without certificate

Post by alexa » Wed 20 Oct 2021 07:43

Could you please provide us the full product name along with its version?

chadirnje
Posts: 1
Joined: Tue 26 Apr 2022 15:24

Re: Connecting to Postgres with SSL Mode without certificate

Post by chadirnje » Tue 26 Apr 2022 15:28

AnnaMia wrote: Thu 14 Oct 2021 19:40 Is anyone attending to this issue? canlı tv izle
I'm almost giving up!
Please someone help on this issue, I've been looking for a solution everywhere but I couldn't find it.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: Connecting to Postgres with SSL Mode without certificate

Post by dzhanhira » Fri 30 Sep 2022 10:08

Kindly note that there is a task for deep investigation created.

Post Reply