Home → How Do I... →

Secure Database Publishing

• Edit

hickeykc

06 Jul, 2015 01:59 PM

How do I configure database publishing to use ssl for a mysql database connection?

1. 1 Posted by Ryan Griffith on 06 Jul, 2015 05:51 PM

   

   Hi,

   SSL connection would not be supported by the Database transport out of the box, but it may be possible by configuring Tomcat to use SSL for database connections. The downside; however, is this would be for all connections across the board and not just Database Publishing.

   Let me do some testing to see if it is possible in general and I will be in touch as soon as I have additional information.

   Please let me know if you have any questions.

   Thanks!

   • Edit

2. 2 Posted by Ryan Griffith on 06 Jul, 2015 07:42 PM

   

   Hi,

   My apologies, I was confusing the application connection (Tomcat) with database publishing.

   Looking over the implementation of the Database Transport, there is no option for establishing a secure connection. I am speculating the database driver may not be smart enough to handle automatically switching to SSL if the selected database for the Transport forces SSL. You can certainly try and see if you receive any errors.

   If this is a feature you would like to see implemented in a future release, I highly recommend posting a suggestion on our Idea Exchange for others to vote up and have it considered for a future release.

   In the meantime, just thinking out loud here, but you may be able to use a custom Publish Trigger to potentially connect to your database over SSL and "publish" to it along side of a regular Transport.

   Please let me know if you have any questions.

   Thanks!

   • Edit

3. Tim closed this discussion on 17 Jul, 2015 02:36 PM.