Thread: Cannot connect servers by SSL in V20

Hi Durumdara

On Mon, Feb 13, 2023 at 2:18 PM Durumdara <durumdara@gmail.com> wrote:

Dear Developers!

Today I installed the V20. After that I can't connect to the servers.

These servers used crt/key files, and they ignore the passwords (I can use anything as pwd).

The V20 version said that certificate isn't valid.

   On which platform are you facing the issue with the certificate/keys? Can you please provide the screenshots if possible?

   Regarding passwords, we have just fixed one issue #5847. We have also changed the logic to make the connection string, I would suggest testing the nightly build tomorrow. 

When I remove the V20, rename the backup SQLite db to the old, install the V19, it works fine with the same options.

So something is wrong with this V20.

Because I have to work I can't check more things.

So I just reported the problem.

Thank you for your help!

Best regards

   dd

Hello!

OS: Win11. I copied the error from the log. 

2023-02-13 09:05:59,275: ERROR pgadmin: Could not connect to server(#17) - 'C11 - 1'.
Error: connection to server at "**********************.hu" (2*************************6), port 5432 failed: FATAL:  connection requires a valid client certificate
connection to server at "*********************.hu" (2********************6), port 5432 failed: FATAL:  no pg_hba.conf entry for host "4*************************8", user "postgres", database "postgres", SSL off

It's interesting, because the SSL options are on, I set it to prefer/require.

These options are working with V19.

Best regards

dd

Akshay Joshi <akshay.joshi@enterprisedb.com> ezt írta (időpont: 2023. febr. 13., H, 9:54):

Hi Durumdara

On Mon, Feb 13, 2023 at 2:18 PM Durumdara <durumdara@gmail.com> wrote:

Dear Developers!

Today I installed the V20. After that I can't connect to the servers.

These servers used crt/key files, and they ignore the passwords (I can use anything as pwd).

The V20 version said that certificate isn't valid.

   On which platform are you facing the issue with the certificate/keys? Can you please provide the screenshots if possible?

   Regarding passwords, we have just fixed one issue #5847. We have also changed the logic to make the connection string, I would suggest testing the nightly build tomorrow. 

When I remove the V20, rename the backup SQLite db to the old, install the V19, it works fine with the same options.

So something is wrong with this V20.

Because I have to work I can't check more things.

So I just reported the problem.

Thank you for your help!

Best regards

   dd

Hi Durumdara

We have fixed one issue yesterday it may fixed this issue as well. Can you please test on the nightly build https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2023-02-14/

On Mon, 13 Feb, 2023, 10:31 pm Durumdara, <durumdara@gmail.com> wrote:

Hello!

OS: Win11. I copied the error from the log. 

2023-02-13 09:05:59,275: ERROR pgadmin: Could not connect to server(#17) - 'C11 - 1'.
Error: connection to server at "**********************.hu" (2*************************6), port 5432 failed: FATAL:  connection requires a valid client certificate
connection to server at "*********************.hu" (2********************6), port 5432 failed: FATAL:  no pg_hba.conf entry for host "4*************************8", user "postgres", database "postgres", SSL off

It's interesting, because the SSL options are on, I set it to prefer/require.

These options are working with V19.

Best regards

dd

Akshay Joshi <akshay.joshi@enterprisedb.com> ezt írta (időpont: 2023. febr. 13., H, 9:54):

Hi Durumdara

On Mon, Feb 13, 2023 at 2:18 PM Durumdara <durumdara@gmail.com> wrote:

Dear Developers!

Today I installed the V20. After that I can't connect to the servers.

These servers used crt/key files, and they ignore the passwords (I can use anything as pwd).

The V20 version said that certificate isn't valid.

   On which platform are you facing the issue with the certificate/keys? Can you please provide the screenshots if possible?

   Regarding passwords, we have just fixed one issue #5847. We have also changed the logic to make the connection string, I would suggest testing the nightly build tomorrow. 

When I remove the V20, rename the backup SQLite db to the old, install the V19, it works fine with the same options.

So something is wrong with this V20.

Because I have to work I can't check more things.

So I just reported the problem.

Thank you for your help!

Best regards

   dd

Dear Akshay!

It seems to be working fine now.

I will check for a longer period of time.

Thank you! Regards

Akshay Joshi <akshay.joshi@enterprisedb.com> ezt írta (időpont: 2023. febr. 14., K, 4:41):

Hi Durumdara

We have fixed one issue yesterday it may fixed this issue as well. Can you please test on the nightly build https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2023-02-14/

On Mon, 13 Feb, 2023, 10:31 pm Durumdara, <durumdara@gmail.com> wrote:

Hello!

OS: Win11. I copied the error from the log. 

2023-02-13 09:05:59,275: ERROR pgadmin: Could not connect to server(#17) - 'C11 - 1'.
Error: connection to server at "**********************.hu" (2*************************6), port 5432 failed: FATAL:  connection requires a valid client certificate
connection to server at "*********************.hu" (2********************6), port 5432 failed: FATAL:  no pg_hba.conf entry for host "4*************************8", user "postgres", database "postgres", SSL off

It's interesting, because the SSL options are on, I set it to prefer/require.

These options are working with V19.

Best regards

dd

Akshay Joshi <akshay.joshi@enterprisedb.com> ezt írta (időpont: 2023. febr. 13., H, 9:54):

Hi Durumdara

On Mon, Feb 13, 2023 at 2:18 PM Durumdara <durumdara@gmail.com> wrote:

Dear Developers!

Today I installed the V20. After that I can't connect to the servers.

These servers used crt/key files, and they ignore the passwords (I can use anything as pwd).

The V20 version said that certificate isn't valid.

   On which platform are you facing the issue with the certificate/keys? Can you please provide the screenshots if possible?

   Regarding passwords, we have just fixed one issue #5847. We have also changed the logic to make the connection string, I would suggest testing the nightly build tomorrow. 

When I remove the V20, rename the backup SQLite db to the old, install the V19, it works fine with the same options.

So something is wrong with this V20.

Because I have to work I can't check more things.

So I just reported the problem.

Thank you for your help!

Best regards

   dd