Re: Cannot connect jboss to mysql 8 cluster with mysqlrouter

[John Stricklen]

Thank you so much for your reply. I finally solved this problem with help from our MySQL DBA. The issue was that the DB user had the X509 flag set as a requirement on the login. This required that we set a system property in the JBOSS environment (javax.net.ssl.KeyStore) to point to our .jks file that contains the certificate for the client machine, the CA cert, and the CA root cert. I am still not clear on which certificate it is using, but the connection works now.

Unfortunately we are having the same type of issue connecting from a Cold Fusion server but we can't figure out how to set up the ssl to work. And, the driver is not compatible to the old MySQL instance so the new configuration breaks the old datasources.