pgjdbc is not working with PKCS8 certificates with password

From: just madhu <justvmadhu(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pgjdbc is not working with PKCS8 certificates with password
Date: 2024-02-07 09:47:06
Message-ID: CALwjh=QQUdwfNq6dakWC-DOSSN2jABYsKXgAzL4gzFd0K1mqmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi ,

postgresql-42.7.1.jar

Trying to use establish a connection using PKCS8 certificate created with
password.

*openssl pkcs8 -topk8 -inform PEM -in client.key -outform DER -out
client.pk8 -passout pass:foobar*

I set the properties as below:
*...*

*sslProperties.setProperty("sslkey",
"client.pk8");sslProperties.setProperty("sslpassword","foobar");*
*...*

*Connection connection = DriverManager.getConnection(jdbcUrl,
sslProperties);*
*....*
*This is failing with the error:*

*org.postgresql.util.PSQLException: SSL error: Connection reset at
org.postgresql.ssl.MakeSSL.convert(MakeSSL.java:43) at
org.postgresql.core.v3.ConnectionFactoryImpl.enableSSL(ConnectionFactoryImpl.java:584)
at
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:168)*
*...*

Regards,
Madhu

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message just madhu 2024-02-07 11:42:06 Re: pgjdbc is not working with PKCS8 certificates with password
Previous Message Alexander Korotkov 2024-02-07 09:28:32 Re: v17 Possible Union All Bug

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2024-02-07 09:51:18 Re: Why is subscription/t/031_column_list.pl failing so much?
Previous Message jian he 2024-02-07 09:44:24 Re: cataloguing NOT NULL constraints