Clever Geek Handbook

How do I set up a ColdFusion MySQL data source over SSL?

Is there a way to configure the ColdFusion datasource to connect to the MySQL server over a secure connection using SSL?

I don't see an obvious way to enable SSL connection in datasource in CF admin.

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

This is for the current configuration that is configured. We have other options, but I'm wondering if it's possible. Thank.

+2


source to share


1 answer


You will need to use the other option in the Drivers dropdown and create your own connection string. Here is an article I found on SSL for MySQL via JDBC Drivers: http://www.razorsql.com/articles/mysql_ssl_jdbc.html



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

+5


source






More articles:


All Articles