Re: Cannot connect servers by SSL in V20

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(dot)joshi(at)enterprisedb(dot)com> ezt írta (időpont: 2023. febr.
13., H, 9:54):

> Hi Durumdara
>
> On Mon, Feb 13, 2023 at 2:18 PM Durumdara <durumdara(at)gmail(dot)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
> <https://github.com/pgadmin-org/pgadmin4/issues/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
>>
>>
>>
>>