Thx, one step closer.
pgsql-jdbc@postgresql.org
From: Vitalii Tymchyshyn [mailto:tivv00@gmail.com] Sent: Friday, February 22, 2013 12:56 PMTo: Maz MohammadiCc: pgsql-jdbc@postgresql.orgSubject: Re: [JDBC] can't access through SSL
Try jdbc:postgresql://localhost:5432/testdb?ssl=true
2013/2/22 Maz Mohammadi <mmohammadi@pentaho.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 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
pgsql-jdbc by date:
Соглашаюсь с условиями обработки персональных данных