This is a multi-part message in MIME format.
------_=_NextPart_001_01C86746.0FFB68F7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I am trying to create a SSl connection to PostGres using JDBC and am not
sure if it is working. =20
I read that you must have openssl on the client machine for the
connection to take place. I have turned ssl =3D on in the config file,
created a cert and key file and placed them in the correct directory,
created a truststore and add the ?ssl=3Dtrue to the url for the client.
When I do all this I connect and get data back from the db. My
confusion is when I read that I need openssl on the client machine to
connect, since I can connect without openssl installed. I do notice
that if my truststore does not have the cert placed in it, I get an
error saying missing certificate ( something like that ), does that mean
ssl is working for the client and server?=20
I am using Postgres 8.2 and have read that I may need to compile the
Postgres src code with openssl for it to be enabled. Is this correct or
is SSL already compiled into the src code? =20
Thanks to anyone who can provide information or point me in the right
direction. I am facing a tight deadline and don't have a ton of extra
time to research this more. =20
allan
------_=_NextPart_001_01C86746.0FFB68F7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7652.24">
<TITLE>Ssl question</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">I am trying to create a SSl connection =
to PostGres using JDBC and am not sure if it is working. </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I read that you must have openssl on =
the client machine for the connection to take place. I have turned =
ssl =3D on in the config file, created a cert and key file and placed =
them in the correct directory, created a truststore and add the =
?ssl=3Dtrue to the url for the client. When I do all this I =
connect and get data back from the db. My confusion is when =
I read that I need openssl on the client machine to connect, since I can =
connect without openssl installed. I do notice that if my =
truststore does not have the cert placed in it, I get an error saying =
missing certificate ( something like that ), does that mean ssl is =
working for the client and server? </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I am using Postgres 8.2 and have read =
that I may need to compile the Postgres src code with openssl for it to =
be enabled. Is this correct or is SSL already compiled into the =
src code? </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks to anyone who can provide =
information or point me in the right direction. I am facing a =
tight deadline and don’t have a ton of extra time to research this =
more. </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">allan</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C86746.0FFB68F7--
|
