We are trying to connect Confluence to MySQL 5.7 using SSL via a google MySQL managed instance. We have 3 files, server-ca.pem, client-cert,pem, client-key.pem. I've imported the server certificate into the trust store and created a pkcs12 file with the cert files. This file was then imported into a keystore.
I'm having trouble passing the keystore location to Confluence java via the setenv.sh file in confluence/bin. Adding useSSL=true onto the jdbc url in dbconfig.xml gives me an access denied for confluence user message on MySQL. If I allow insecure connections Confluence user is able to connect. I was able to get this to work with Jira by following this article but its not working for Confluence:
Any ideas on how to pass the keystore location variables? Here is my setenv.sh lines currently which aren't working:
We eventually found this document which shows how to setup the SSL variables in the JDBC connection. Hope it helps someone!
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events