It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

SSL errors with confluence and MySQL

Hi All,

I have now reached my end with the below error on Confluence:

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

I have tried appending the "useSSL=False" to my connection url on confluence.cfg.xml as per below:

1. <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=default_storage_engine%3DInnoDB&useSSL=false&amp;</property> - This caused a timeout exception

2. <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=default_storage_engine%3DInnoDB?useSSL=false</property> - This just causes confluence to crash.

I have also tried downloading and installing 3 specific certificates based on a post, which for the life of me, I cannot locate right now.

None of the above have sorted out the issue.

Below are the specs on what we are using:

- MySQL Community Server 5.7.17

- Confluence Version 6.07

Someone please help !!!

3 answers

Howdy Kogan,

Was having similar drama but found that the property tag needed to be as follows:

<property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB&amp;useSSL=false</property>

Which seemed to get confluence to not bomb out on startup

Hi Michael, where did you add this line?

@João Correia, you can add useSSL=false in your JDBC query string, through the confluence admin UI.

You need to make sure the DB server is configured for remote access for the user credentials you are using to remotely access. Enabling a user account to connect to DB server remotely resolved this issue for me.

Where is that on Confluence @Rohit Agarwal?

easy way to get there is:

1. Open Macros edit pop-up for Confiform Form Field Definition, select any DB related Input field type.

2. If you see a "Create new DB Connection". Click on that and it will lead you to the admin interface

3. add the DB Connection details on the resultant page, after signing in through the admin credentials or re-typing your password.

 

NOTE: you must have admin privileges over your confluence instance to perform Step3

Sorry where is Macros edit popup? and Confiform Form Field Definition? isn't there a way to edit this in the Confluence config files?

Edit the page where you have defined your Confiform Form Definition.

Look for the field or create a new Confiform Field Definition.

Select the input type which requires connection to DB. When you click on the edit for this Confiform Field Definition, you will then need to follow the steps I have outlined.

 

I Hope this helps.

@Joao CorreiaTo answer your first question: You can find the file confluence.cfg.xml that was mentioned in the first post under ApplicationData\Confluence.

In my case, the line looked like

<property name="hibernate.connection.url">jdbc:mysql://localhost/confluence</property>

(without the InnoDB variable, seems that's default in the mean time) and had to be changed to

<property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?useSSL=false</property>

Worked like a charm. I didn't dare to try to do something from the admin section in Confluence, as I wasn't sure how to remedy that if it went wrong and I couldn't access Confluence anymore ...

Like # people like this

I am having the same issue. has anyone figured out what needs to be done here?

https://community.atlassian.com/t5/Confluence-questions/SSL-Warning-filling-catalina-out-when-connecting-to-MySQL/qaq-p/117867

 

Found these answers if anyone is still interested. I am trying. will try to get back to this thread and update results of the suggestions on the above post

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Introducing Confluence Cloud and Jira Software Cloud Premium

Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...

725 views 8 18
Read article

Community Events

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

Events near you