Re: Cannot connect servers by SSL in V20

Dear Akshay!

It seems to be working fine now.
I will check for a longer period of time.
Thank you! Regards

Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)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(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
>>>>
>>>>
>>>>
>>>>