Re: Beginner's Question: No pg_hba.conf entry for host...SSL Off

Hi Kris-

Thanks for the reply!

A one-liner in your attached link fixed my problem!! Thank you very much!!
:o) I had to import my Postgres server.crt certificate into Java's system
truststore.

Again, thanks for your help, I'm up and running again!
-Jeanna

----- Original Message -----
From: "Kris Jurka" <books(at)ejurka(dot)com>
To: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Tuesday, September 26, 2006 2:23 PM
Subject: Re: [JDBC] Beginner's Question: No pg_hba.conf entry for host...SSL
Off

>
>
> On Tue, 26 Sep 2006, Jeanna Geier wrote:
>
>> Hello- Sorry to re-post this, but I'm sort of stuck on this one and
>> can't move forward until I get it resolved.... I've been googling some
>> more and looking on some Java sites and trying out some different things
>> with no luck. If anyone could offer me some assistance on this one, I
>> would be greatly appreciative.
>
> It's a little unclear how much if any of this problem was solved
> on -hackers and -admin.
>
>> I've tried the following with the 'prop.setProperty("ssl","true)
>> parameter - added:
>>
>
> You definitely need this to get a SSL connection.
>
>> However, when I do that, it's throwing an exception from: connection =
>> DriverManager.getConnection(url, prop);
>> and I'm getting an error message that says: "The connection attempt
>> failed."
>>
>
> Have you read the documentation here:
>
> http://jdbc.postgresql.org/documentation/81/ssl-client.html
>
> Java validates the server certificate by default which is different than
> the behavior of libpq.
>
> Kris Jurka
>
>