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

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