Re: can't access through SSL

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

2013/2/22 Maz Mohammadi <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
> 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