Re: Cannot connect servers by SSL in V20

Thanks a lot

On Tue, Feb 14, 2023 at 1:24 PM Durumdara <durumdara(at)gmail(dot)com> wrote:

> 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
>>>>>
>>>>>
>>>>>
>>>>>