How to set up a ColdFusion MySQL datasource over SSL?
coldfusion, mysql, ssl
Solution
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_ssl_jdbc.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
Problem
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.