Re: can't access through SSL

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