How to set up a ColdFusion MySQL datasource over SSL?

Question

Is there a way to set up a ColdFusion data source to connect to a MySQL server over a secure connection using SSL?

I don't see any obvious option to enable a SSL connection on the data source in CF administrator.

The only option I can think of is to use the "connection string" field.

This is for a current configuration that is set up. We have other options, but I am curious as to if this is possible. Thanks.

Answer 1

You would need to use the "other" option in the Drivers dropdown and build your own connection string. Here's an article I found on SSL for MySQL through JDBC drivers: http://www.razorsql.com/articles/mysql%5Fssl%5Fjdbc.html

UPDATE: Here is another article with information on connecting via SSL and updating the keystore with certificate data. There is also some good content in the comments of the page: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html