Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

trouble of confluence 6.5 to connect mysql 8 on ubuntu 20.04

zhihui zheng
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 13, 2021

Hi. I have an a little bit old version of confluence 6.5 to run on my ubuntu 18.04 for a while. The database was mysql 5.X. 

 

Recently, I upgrade my ubuntu to 20.04 and also upgrade the mysql version to 8. Now it seems that I can not use my confluence now since it reporting:
MYSQL isolution level could not be read.

 

I did spend lots of time to find out that I also need to download new mysql-connector-8.xx.jar and put it to the right folder. But the problem is that even I managed to get the new mysql connector jar file and put into the right folder. I still could not have confluence 6.5 to connect to mysql (I did stop/start confluence when doing so).

 

Is there anyone can help me on this please? There are lots of my personal data on confluence. Thank you in advance. 

3 answers

0 votes
Gonchik Tsymzhitov
Community Champion
March 13, 2021

@zhihui zheng  Hm, if I were I will start upgrade of Confluence at least to 7.2 version. 

https://jira.atlassian.com/browse/CONFSERVER-52665

 

Because too risky works with unsupported 8.0 and old Confluence. 

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 13, 2021

What does the log say the database connection errors are when Confluence starts up?

0 votes
zhihui zheng
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 13, 2021

btw, isolution level is correctly configured in mysql 8:

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT @@GLOBAL.transaction_isolation, @@transaction_isolation;
+--------------------------------+-------------------------+
| @@GLOBAL.transaction_isolation | @@transaction_isolation |
+--------------------------------+-------------------------+
| READ-COMMITTED | READ-COMMITTED |
+--------------------------------+-------------------------+
1 row in set (0.00 sec)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events