Re: can't access through SSL

Поиск
Список
Период
Сортировка
От Maz Mohammadi
Тема Re: can't access through SSL
Дата
Msg-id 9F992F0A0D9BA04F914597F75435942D09576C4F82@MBX36.exg5.exghost.com
обсуждение исходный текст
Ответ на Re: can't access through SSL  (Vitalii Tymchyshyn <tivv00@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения

Thx,  one step closer.

 

pgsql-jdbc@postgresql.org

 

 

From: Vitalii Tymchyshyn [mailto:tivv00@gmail.com]
Sent: Friday, February 22, 2013 12:56 PM
To: Maz Mohammadi
Cc: pgsql-jdbc@postgresql.org
Subject: 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: JDBC - PreparedStatement reuse oddity when using setObject() with nulls and setTimestamp()
Следующее
От: Maz Mohammadi
Дата:
Сообщение: Re: can't access through SSL