tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/18695-secure-database-publishingCascade CMS: Discussion 2015-07-17T14:36:39Ztag:help-archives.hannonhill.com,2010-02-09:Comment/373086312015-07-06T17:51:50Z2015-07-06T17:51:50ZSecure Database Publishing<div><p>Hi,</p>
<p>SSL connection would not be supported by the Database transport
out of the box, but it may be possible by <a href="http://stackoverflow.com/questions/16523595/specify-ssl-to-be-used-for-jdbc-in-context-xml">
configuring Tomcat to use SSL</a> for database connections. The
downside; however, is this would be for all connections across the
board and not just Database Publishing.</p>
<p>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.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/373086312015-07-06T19:42:13Z2015-07-06T19:42:13ZSecure Database Publishing<div><p>Hi,</p>
<p>My apologies, I was confusing the application connection
(Tomcat) with database publishing.</p>
<p>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.</p>
<p>If this is a feature you would like to see implemented in a
future release, I highly recommend posting a suggestion on our
<a href="http://ideas.hannonhill.com/">Idea Exchange</a> for others
to vote up and have it considered for a future release.</p>
<p>In the meantime, just thinking out loud here, but you may be
able to use a custom <a href="http://www.hannonhill.com/kb/Publish-Triggers/">Publish
Trigger</a> to potentially connect to your database over SSL and
"publish" to it along side of a regular Transport.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffith