Upgrade Jira7 to Jira8 : The database setup is not supporting utf8mb4

[Arnaud Guignant]

Hello,

I've upgrade our Jira 7.0 to Jira 8.2.2 as we have change our MySQL server to MySQL 5.7.
The upgrade works fine, but when I go to Jira with my browser, I've got the following message :

"The database setup is not supporting utf8mb4"

I've tried differents thinks, I've change the collation of my database jira with this kb : 

https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-744326173.html?_ga=2.156935803.1781786784.1562070999-664805077.1548173504

I've tried to change my dbconfig.xml with config.sh.
I've resolved the bug with & (replace by &) on the dbconfig.xml as we are on ubuntu.
My dbconfig.xml was made using this kb :

https://confluence.atlassian.com/jirakb/startup-check-changing-your-mysql-connection-url-for-jira-874744240.html

I've made a lot of research, but all the solutions I've tested have failed.

So I want to know if someone has an idea or a think I can try.

Thank you in advance

Best regards

[Mirek · Accepted solution]

Hi,

Did you check also those KB articels?

https://confluence.atlassian.com/jirakb/emojis-and-special-characters-for-jira-with-mysql-952604493.html

https://confluence.atlassian.com/fishkb/migrate-mysql-database-to-utf8mb4-character-encoding-962356253.html

[Arnaud Guignant]

Hi Mirek,

Thanks for your answer.

I've made a change on my my.cnf, based on one of the KB :

On [mysqld]

character-set-server = utf8mb4
init-connect = 'SET NAMES utf8mb4
collation-server = utf8mb4_unicode_ci

On [mysql]

default-character-set = utf8mb4

It works, thank you very much !

Regards