Talkback for article: 285, March2003

Accessing PostgreSQL through JDBC via a Java SSL tunnel

Back to: http://cgi.linuxfocus.org/English/March2003/article285.shtml

From: Steve [ date: 2003-06-12 ]
Nice job! Your article is well structured and highly informative. Any software requiring secure network communications can benefit from the relay client and server.
From: Kamalendu Majumdar <kamal(at)library.iitkgp.ernet.in> [ date: 2003-11-17 ]
Dear Sir
I am kamalendu Assistant Librarian
Indian Institute of Technology
Kharagpur .

Your article is informative and helpfull.
Thank you for the article.
Now I want some help from you.

I want to install DSpace ( a free digital Library softarre from MIT)
along with Apache
in an environment with RedHat Lunix 8.0
Can you spend some of your specious time

Thank you
With regards




From: christoph bach <christoph.bach(at)swissonline.ch> [ date: 2004-01-12 ]
Congratulation, very well done! Articles of this kind are lovely!!!
From: Takatoshi Yanase <cosmos(at)sys-audit.com> [ date: 2004-06-04 ]
I tried Accessing PostgresSQL throgh Java SSL tunnel using samples of keytool and Java class, but I only got a message as below. Could you give me some advice. I am developing an applet of a database application, and I need SSL connection for it.

Starting relayapp ...
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: No trusted certificate found


Creation of the keystores are as below.

keytool -genkey -alias serverprivate -keystore kan2store -keyalg rsa -keysize 2048

keytool -export -alias serverprivate -keystore kan2store -file server.cer -rfc

keytool -import -alias trustservercert -file server.cer -keystore clienttrustkanstore


keytool -genkey -alias clientprivate -keystore kanclstore -keyalg rsa -keysize 2048

keytool -export -alias clientprivate -keystore kanclstore -file client.cer -rfc

keytool -import -alias trustclientcert -file client.cer -keystore servertrustkanstore
From: Takatoshi Yanase [ date: 2004-06-12 ]
The problem has just been solved. I placed the clienttrustkanstore and the servertrustkanstore at the reverse site. After putting them at the correct site
I got SSL connection. I really appreciate you and your articles, thank you.



From: sridhar <sridhar_rreddy(at)yahoo.com> [ date: 2005-01-11 ]
Hello sir,
while I was trying to install JDBC driver reading your article everything went well until a change was to be made in the pg_hba.conf file where you have given a statement with 5 parametres [ host,all,127.0.0.1,255.255.255.255,password ].
At this point the error I'm receiving from the pgsql sever is
-->A connection error has occurred: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "::1", user "sridhar", database "sridhar", SSL off.
And one more doubt , should I set a JDBC classpath excluding the jar file in the jdk calsspath.
Could you please help me in this situation.
Thank you.
From: Vincent <vrich12-dev(at)yahoo.fr> [ date: 2006-03-14 ]
Excellent! This article is the best I found about mutual authentication for SSL communication.
Very clear, concise, and soo helpfull!
Thanks for it! :)

From: Momar Diop <thiouboulene(at)yahoo.fr> [ date: 2006-06-13 ]
your article is the best but i don't known how to use this
help me!

8 talkbacks




Due to the increased amount of web spam we have deciced to removed the talkback posting possibility. You can read old talkbacks but you can no longer post new ones.

Back to http://cgi.linuxfocus.org/English/March2003/article285.shtml

Please contact webmaster(at)linuxfocus.org if you have any questions with regards to this talkback

lftalkback version 3.10