Cannot Connect to server with SSLmode set to required.

From: Surya Widyanto <ayrus02(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Cannot Connect to server with SSLmode set to required.
Date: 2024-06-17 07:33:25
Message-ID: CALVBtxyZ=zC_8L7-1hBRruuDX7vWSJ-W+-5c6DebO7cW-bStpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Support Team,

We had PostgreSQL server PostgreSQL 14.12 on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit that runs with SSL
Mode connection activated and we are enforcing ssl connection on it,

When we try to connect to the server using local installed PGAdmin4 v8.8,
we encounter this error *"Unable to connect to server:connection is bad:
sslmode value "require" invalid when SSL support is not compiled in"*

[image: image.png]

Mean while when we try to connect from the same PC/Laptop using other 3rd
party client software like Navicat, it can connect flawlessly with no
problem at all even with SSLmode set to require.

FYI, the PGAdmin4 is running on web mode on Windows 11, that we run using
this command:
[image: image.png]

Could you please take a look and help us to troubleshoot?

Regards,
Surya

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2024-06-17 08:14:03 Re: Cannot Connect to server with SSLmode set to required.
Previous Message Aditya Toshniwal 2024-06-17 04:37:29 Re: Expand/Collapse Nodes in Query Window