MySQL Forums :: C#, Mono, .Net :: Connector/Net, Amazon RDS, SSL

Hi there.

I'm developing an application that will be uploading data into an Amazon RDS instance (RDS is MySQL). My application will be using VB.Net & Connector/NET.

Amazon provide a single SSL certificate/pem file: mysql-ca-cert.pem which is shared by all RDS instances.


I have the following connection string:
"Server=RDS;Database=DB;Uid=ssluser;Pwd=sslpass;SSL Mode=Required;"

Somehow, even though I have not provided the SSL certificate, this does indeed connect & I can retrieve data. How can I be sure that SSL is being used? Given that I have asked that SSL is required, I would have expected an error when trying to connect here.

Also, I see from the docs that Connector/NET needs a PFX file and not a PEM file. Is it possible to use the PEM file Amazon supplies, or convert it into a PFX file (I only have a single PEM file, obviously not Amazon's secret key file)

This connection string also works:
"Server=RDS;Database=DB;Uid=ssluser;Pwd=sslpass;CertificateFile=C:\\mysql-ca-cert.pem;SSL Mode=Required;"

Can anyone shed any light on this? I am required to encrypt all data I am sending into Amazon RDS (it is sensitive information).

EDIT: Btw, the user ssluser on MySQL does NOT have Require SSL activated (yet).

Thanks,
James



Edited 2 time(s). Last edit at 03/21/2012 04:35AM by James Bhatt.