| Lists: | pgsql-jdbc |
|---|
| From: | "Mark Borins" <mark(dot)borins(at)rigadev(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | JDBC connection to postgres via SSL |
| Date: | 2004-06-25 19:09:17 |
| Message-ID: | 108819057301@smtp-1.vancouver.ipapp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
I have downloaded and compiled with SSL support Postgres 7.4.3.
I have enabled SSL connections in both the pg_hba.conf and postgresql.conf.
I have been able to connect via ssl to the database from a client using
pgAdmin III without any problem.
However, from the same client my JDBC application cannot connect to the
postgres server over SSL.
What do I have to do to enable this?
I have tried putting SSL=true as a query string parameter in my connection
URL. This causes an exception about not getting a proper SSL handshake, or
something of the sort.
So my question is, what do I have to do to be able to connect to a postgres
server via SSL from JDBC?
Thank you
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Mark Borins <mark(dot)borins(at)rigadev(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC connection to postgres via SSL |
| Date: | 2004-06-25 19:44:22 |
| Message-ID: | Pine.BSO.4.56.0406251442140.5961@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
On Fri, 25 Jun 2004, Mark Borins wrote:
> I have been able to connect via ssl to the database from a client using
> pgAdmin III without any problem.
>
> However, from the same client my JDBC application cannot connect to the
> postgres server over SSL.
The libpq client doesn't need the client to recognize the server cert,
Java's default ssl connections do. See the following message on how to
import the cert into your java keystore:
http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php
Kris Jurka