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

Hi,

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

> Please find below the connection we successfully made using PSQL in
> windows command prompt:
>
> [image: psql-connection-from-windows.png]
> The connection from PSQL is marked with blue line and check...
>
>
Thanks for sharing the details, please log this issue @
https://github.com/pgadmin-org/pgadmin4/issues

Thanks,
Khushboo

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