Re: pgjdbc is not working with PKCS8 certificates with password
| От | just madhu |
|---|---|
| Тема | Re: pgjdbc is not working with PKCS8 certificates with password |
| Дата | |
| Msg-id | CALwjh=SbLe7QvVsnMVmZ-4GCEPQen9HuQg0ZZYFmRkHV+OPufw@mail.gmail.com обсуждение исходный текст |
| Ответ на | pgjdbc is not working with PKCS8 certificates with password (just madhu <justvmadhu@gmail.com>) |
| Ответы |
Re: pgjdbc is not working with PKCS8 certificates with password
Re: pgjdbc is not working with PKCS8 certificates with password |
| Список | pgsql-bugs |
On further investigation,
With certificate generated as below. JDBC connection is successful.
openssl pkcs8 -topk8 -inform PEM -in client.key -outform DER -out client.pk8 -passout pass:foobar -v1 PBE-MD5-DESBut a connection from pgAdmin (connection failed: \SSLCerts\pk8_pass\client_pass_PBE.pk8": no start line) and psql(psql: error: could not load private key file "client_pass_PBE.pk8": unsupported) is failing
Is there a common way in which certificate with passwords can be created for both libpq and jdbc ?
On Wed, Feb 7, 2024 at 3:17 PM just madhu <justvmadhu@gmail.com> wrote:
Hi ,postgresql-42.7.1.jarTrying 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:foobarI 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
В списке pgsql-bugs по дате отправления: