cant install confluence due to wrong coallation, but its all set up correctly

[Patrick Einatz]

i'm trying to install confluence on my server, where jira is already running with no issues. i downloaded and installed the package to my ubuntu 16.04. server and also installed the  mysql-connector-java-5.1.46 

i changed my "my.cnf" as recommended:

and my database is also set to the correct collation:

but when i'm trying to install or rather connect confluence to my database i get this error:

please help!

[Shankar Asam {Appfire}]

Hi, 

Could you please run this command on MySQL prompt and provide us the results;

mysql> show variables like '%collation%';

thanks

[Patrick Einatz]

wow, you sir nailed it.... so how can i adjust my collation_connection value... thank you so far.

[Patrick Einatz]

ok, i managed to set this on my own.... but i still get the same error :-(

any ideas? do i have to do the whole installation process again ?

[Shankar Asam {Appfire}]

Hi Patrick,

There are other areas that you need to take a look at for collation and character set in MySQL. 

As per atlassian's document below, collation in MySQL can be complicated because you can have a separate collation set at:

1. The database level
2. The table level
3. The column level

https://confluence.atlassian.com/confkb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-670958160.html

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

The above links might helpful.

Good luck.

[Patrick Einatz]

ok, after adding this to the "/etc/mysql/my.cnf" file

init-connect='SET NAMES utf8'
init_connect='SET collation_connection = utf8_unicode_ci' 
skip-character-set-client-handshake

i rebootet mysql and launched following command once again and then it worked

ALTER DATABASE yourDB CHARACTER SET utf8 COLLATE utf8_bin

thank you very much for your help Shankar Asam


best regards

[Shankar Asam {Appfire}]

you are welcome :)