Edb Jdbc Ssl Connection
<div><div>I want to establish simple jdbc ssl connection using edb as 11 and java 8 u271 with postgresql jdbc driver 42.2.9 (I have also tried these versions: 42.2.18 and 42.2.8).</div><div>I followed the instructions from the following link.</div><div><div><div>https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server</div></div><div><br /></div></div><div>I tested ssl connection successfully using "psql". But I cannot establish a jdbc connection. I got "FATAL: connection requires a valid client certificate" error.</div><div> </div><div>After a little googling, I want to use a different url than specified here just to consume all the possibilities. After modifiying the url with "sslcert=./test/client.crt sslkey=./test/client.key sslrootcert=./test/server.crt" I got "SSLSocket duplex close failed".</div><div> </div><div>Could you please help me with this problem?</div><div> </div><div>Thanks for you in advance.</div><div> </div><div> </div></div>
<div><div> </div><div>42.2.9 and java 8 u162 have worked.</div><div> </div></div><div> </div><div> </div><div> </div><div>31.01.2021, 08:51, "ayagmur75@yandex.com" <ayagmur75@yandex.com>:</div><blockquote><div><div>I want to establish simple jdbc ssl connection using edb as 11 and java 8 u271 with postgresql jdbc driver 42.2.9 (I have also tried these versions: 42.2.18 and 42.2.8).</div><div>I followed the instructions from the following link.</div><div><div><div><a href="https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server" rel="noopener noreferrer">https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server</a></div></div><div> </div></div><div>I tested ssl connection successfully using "psql". But I cannot establish a jdbc connection. I got "FATAL: connection requires a valid client certificate" error.</div><div> </div><div>After a little googling, I want to use a different url than specified here just to consume all the possibilities. After modifiying the url with "sslcert=./test/client.crt sslkey=./test/client.key sslrootcert=./test/server.crt" I got "SSLSocket duplex close failed".</div><div> </div><div>Could you please help me with this problem?</div><div> </div><div>Thanks for you in advance.</div><div> </div><div> </div></div></blockquote>
Please follow the instructions here
Configuring the Client (postgresql.org)
<https://jdbc.postgresql.org/documentation/head/ssl-client.html>
<https://jdbc.postgresql.org/documentation/head/ssl-client.html>
Dave Cramer
www.postgres.rocks
On Mon, 1 Feb 2021 at 01:44, <ayagmur75@yandex.com> wrote:
Show quoted text
42.2.9 and java 8 u162 have worked.
31.01.2021, 08:51, "ayagmur75@yandex.com" <ayagmur75@yandex.com>:
I want to establish simple jdbc ssl connection using edb as 11 and java 8
u271 with postgresql jdbc driver 42.2.9 (I have also tried these versions:
42.2.18 and 42.2.8).
I followed the instructions from the following link.I tested ssl connection successfully using "psql". But I cannot establish
a jdbc connection. I got "FATAL: connection requires a valid client
certificate" error.After a little googling, I want to use a different url than specified here
just to consume all the possibilities. After modifiying the url with
"sslcert=./test/client.crt sslkey=./test/client.key
sslrootcert=./test/server.crt" I got "SSLSocket duplex close failed".Could you please help me with this problem?
Thanks for you in advance.