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

Please look the picture below for more information on the SSL Connection
Query:
[image: Query-Run-Navica-02t.png]
The connection from Navicat is marked with blue line and checks...

Regards,
Surya

On Mon, Jun 17, 2024 at 3:14 PM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

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