Re: Edb Jdbc Ssl Connection

From: Dave Cramer <davecramer(at)postgres(dot)rocks>
To: ayagmur75(at)yandex(dot)com
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Edb Jdbc Ssl Connection
Date: 2021-02-01 13:52:58
Message-ID: CADK3HHJoFykx=ZoZKL8t1h7ezXw-w+LzVZTsAAkTJoCAMLyeCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)yandex(dot)com> wrote:

>
> 42.2.9 and java 8 u162 have worked.
>
>
>
>
> 31.01.2021, 08:51, "ayagmur75(at)yandex(dot)com" <ayagmur75(at)yandex(dot)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.
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2021-02-01 14:38:35 ransomware
Previous Message Jiří Pavlovský 2021-02-01 10:46:10 libpq and mysterious "invalid byte sequence for encoding UTF8".