Postgres Pro
Downloads
Home   >   mailing lists

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

Cannot Connect to server with SSLmode set to required.

From
Surya Widyanto
Date:
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.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.png

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

Regards,
Surya
Attachment

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

From
Khushboo Vashi
Date:


On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02@gmail.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.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.png

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

Regards,
Surya
Attachment

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

From
Surya Widyanto
Date:
Please look into this.

Navicat-Connection-Settings.png
This is the connection setting on Navicat for the same server We've been successfully connect with SSLmode require.

With this connection, I run the query below:
Query-Run-Navicat.png
The blue marked connection is the connection with Navicat Client with SSL enabled connection.


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


On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02@gmail.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.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.png

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

Regards,
Surya
Attachment

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

From
Surya Widyanto
Date:
Please look the picture below for more information on the SSL Connection Query:
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.vashi@enterprisedb.com> wrote:


On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02@gmail.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.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.png

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

Regards,
Surya
Attachment

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

From
Surya Widyanto
Date:
Please find below the connection we successfully made using PSQL in windows command prompt:

psql-connection-from-windows.png
The connection from PSQL is marked with blue line and check...

Regards,
Surya

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


On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02@gmail.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.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.png

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

Regards,
Surya
Attachment

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

From
Khushboo Vashi
Date:
Hi,

On Mon, Jun 17, 2024 at 7:58 PM Surya Widyanto <ayrus02@gmail.com> wrote:
Please find below the connection we successfully made using PSQL in windows command prompt:

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.vashi@enterprisedb.com> wrote:


On Mon, Jun 17, 2024 at 1:03 PM Surya Widyanto <ayrus02@gmail.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.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.png

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

Regards,
Surya
Attachment