Re: Cannot connect servers by SSL in V20

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(at)gmail(dot)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(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
>>>
>>>
>>>
>>>