Re: Cannot connect jboss to mysql 8 cluster with mysqlrouter
Posted by: John Stricklen
Date: October 19, 2018 09:50AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Cannot connect jboss to mysql 8 cluster with mysqlrouter
October 19, 2018 09:50AM


Sorry, only registered users may post in this forum.

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.