can't access through SSL

From: Maz Mohammadi <mmohammadi(at)pentaho(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: can't access through SSL
Date: 2013-02-22 17:43:13
Message-ID: 9F992F0A0D9BA04F914597F75435942D09576C4E84@MBX36.exg5.exghost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Hello all,

I'm trying to access a postgres database through a java application (tomcat). This is the only entry I have in pg_hba.conf

# TYPE DATABASE USER ADDRESS METHOD
hostssl all all 127.0.0.1/32 cert

and put the certicate (from /var/lib/postre...../coord/server.crt) in the cacerts under $JAVA_HOME/.......

This is my jdbc URL....
jdbc:postgresql://localhost:5432/testdb&ssl=true

But When I try to create a datasource on tomcat, I get the following error...
"Connection attempt failed: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "progres-xc", database "testdb&ssl=true", SSL off"

Any help is greatly appreciated.

-maz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vitalii Tymchyshyn 2013-02-22 17:56:01 Re: can't access through SSL
Previous Message Jeff Janes 2013-02-22 17:27:18 Re: autoanalyze criteria

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vitalii Tymchyshyn 2013-02-22 17:56:01 Re: can't access through SSL
Previous Message Maz Mohammadi 2013-02-22 16:13:54 Re: confirming security.