SSL connection to MySQL server?

Openfire Openfire Support
1

I am currently running an OpenFire server with MySQL running on the same machine, but am considering moving the database to one of our enterprise MySQL hosts. Our organization’s MySQL service requires an SSL encrypted connection, but I cannot find anything specific in the documentation about configuring the JDBC driver to connect to the DB server with SSL enabled.

Please note that this is entirely separate from the issue of encrypting the Jabber sessions; we have that worked out just fine. This is just about encrypting the connection between OpenFire and MySQL.

Does anybody have any experience with this? Windows-specific experience is even better!

Thanks,

Paul

ask.png1263×552 24.3 KB

2

Never tried it, but here is some info - Looks like you just have to add some parameters to the JDBC connection string (and I’m assuming you need a current-ish JDBC driver)

http://www.razorsql.com/articles/mysql_ssl_jdbc.html