Re: Unable to connect with password protected ssl key file

Hi Merkel,

Can you please share the exact steps to reproduce and screenshot?

I am getting the following error message on psql (command-line tool for
PostgreSQL) for verify-full option:

psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist
Either provide the file or change sslmode to disable server certificate
verification.

Can you please try your error message through psql
----
Steps
1.go into PostgreSQL binary path and execute this command

export PGSSLMODE=verify-full
2. no connect with psql
[root(at)localhost bin]# ./psql -U postgres -h localhost -p 5432 -d postgres
psql.bin: root certificate file "/root/.postgresql/root.crt" does not exist
Either provide the file or change sslmode to disable server certificate
verification.

If you are getting the same error message through psql then it is not an
issue with pgadmin4.

On Wed, May 11, 2022 at 4:23 PM Merkel, Christian <
Christian(dot)Merkel(at)allegion(dot)com> wrote:

> Hello,
>
>
>
> the pgadmin 6.8 software does support SSL mode Verify-Full on connect.
>
> But how is it possible to use a password protected client certificate key
> file to connect? (without password works)
>
>
>
> There is no prompt shown on connect nor could I find any other way to
> provide the password for the key.
>
> The whole application gets stuck in “connecting” to server for forever, so
> it’s also kind of a bug here(?)
>
>
>
> Best regards,
>
> Christian Merkel
>
>
>

--
Fahar Abbas
pgAdmin4 team
EnterpriseDB Corporation
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com