Re: can't access through SSL

Thx, one step closer.

pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>

From: Vitalii Tymchyshyn [mailto:tivv00(at)gmail(dot)com]
Sent: Friday, February 22, 2013 12:56 PM
To: Maz Mohammadi
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] can't access through SSL

Try jdbc:postgresql://localhost:5432/testdb?ssl=true

2013/2/22 Maz Mohammadi <mmohammadi(at)pentaho(dot)com<mailto:mmohammadi(at)pentaho(dot)com>>
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<http://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

--
Best regards,
Vitalii Tymchyshyn