Connecting to Postgres with SSL Mode without certificate

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
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
Devart Team
Posts: 2983
Joined: Fri 24 Jun 2011 14:17

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: 92
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
Devart Team
Posts: 2983
Joined: Fri 24 Jun 2011 14:17

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
Devart Team
Posts: 2983
Joined: Fri 24 Jun 2011 14:17

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: 92
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)?

Post Reply