Re: Cannot Connect to server with SSLmode set to required.

On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02(at)gmail(dot)com> wrote:

> 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.
>
While testing with other clients, how did you confirm that the connection
is secured? Does it show the SSL connection info?

>
> 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
>