Postgres Pro
Downloads
Home   >   mailing lists

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

From Vitalii Tymchyshyn
Subject Re: can't access through SSL
Date
Msg-id CABWW-d16U403PogPcv+J4vNi437KZ-qPbC-jASg9tCkd9knJrg@mail.gmail.com
Whole thread Raw
In response to can't access through SSL  (Maz Mohammadi <mmohammadi@pentaho.com>)
Responses Re: can't access through SSL  (Maz Mohammadi <mmohammadi@pentaho.com>)
List pgsql-jdbc
Tree view
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:

Previous
From: Maz Mohammadi
Date:
Subject: can't access through SSL
Next
From: Kris Jurka
Date:
Subject: Re: JDBC - PreparedStatement reuse oddity when using setObject() with nulls and setTimestamp()