Secure jdbc connection from swing application

[Lalit Agarwal]

Hello all,

I have a java swing application that I would like to connect to mysql database running on a linux machine. If I use the jdbc driver provided by mysql, I assume that the connection would be plain text. I have to encrypt all the data transmission in this connection. I am currently using 4.0.25 and will in near future upgrade to 5.0.x. I am a security newbie and have never worked with encryption before this.

I would like to keep using the binary downloads available from mysql.com as I have a bunch of these servers (20 at present and growing) running mysql and it is easier to maintain the upgrades from binaries.

I have tried stunnel, but after wasting a day or so, I cannot get remote connections made to the mysql database. It seems like the mysql server gets the connection, but it hangs there. If I kill the client, I do see a message that says something like "connection was reset by peer". I have tried following a couple of different ways available on the internet to get the stunnel work for me, without any success.

I would appreciate if anyone, who has succesfully cracked this mystery, willing to share their experience with me.


Thanks.