Re: Cannot connect jboss to mysql 8 cluster with mysqlrouter
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.
Subject
Written By
Posted
September 19, 2018 12:15PM
September 21, 2018 05:31PM
Re: Cannot connect jboss to mysql 8 cluster with mysqlrouter
October 19, 2018 09:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.