can't access through SSL - Mailing list pgsql-jdbc

From Maz Mohammadi
Subject can't access through SSL
Date
Msg-id 9F992F0A0D9BA04F914597F75435942D09576C4E84@MBX36.exg5.exghost.com
Whole thread Raw
Responses Re: can't access through SSL  (Vitalii Tymchyshyn <tivv00@gmail.com>)
List 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

pgsql-jdbc by date:

Previous
From: Maz Mohammadi
Date:
Subject: confirming security.
Next
From: Vitalii Tymchyshyn
Date:
Subject: Re: can't access through SSL