Are you able to reproduce this issue with the current release of Openfire?
What’s the first logging from openfire regarding this and what’s mysql server logging at this time?
The JDBC connection string is SSL encrypted by default. I can connect successfully by adding usessl = false
What’s Openfire’s reported error though when attempting the SSL client connection? I assume it is failing to verify the CA or port 10086 does not service SSL connections?!?