Edb Jdbc Ssl Connection

Started by Nonameabout 5 years ago3 messagesgeneral
Jump to latest
#1Noname
ayagmur75@yandex.com

<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&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;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>

#2Noname
ayagmur75@yandex.com
In reply to: Noname (#1)
Re: Edb Jdbc Ssl Connection

<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" &lt;ayagmur75@yandex.com&gt;:</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&quot; rel="noopener noreferrer">https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;/div&gt;&lt;div&gt;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>

#3Dave Cramer
pg@fastcrypt.com
In reply to: Noname (#2)
Re: Edb Jdbc Ssl Connection

Please follow the instructions here

Configuring the Client (postgresql.org)
<https://jdbc.postgresql.org/documentation/head/ssl-client.html&gt;
<https://jdbc.postgresql.org/documentation/head/ssl-client.html&gt;
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.

https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server

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.