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:

<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mycnf.PNG" style="width: 999px;"><img src="https://us.v-cdn.net/6038660/uploads/images/28487iD690A546D04E7998/mycnf.PNG" role="button" title="mycnf.PNG" alt="mycnf.PNG"></span>

and my database is also set to the correct collation:

<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mysql.PNG" style="width: 999px;"><img src="https://us.v-cdn.net/6038660/uploads/images/28488iC78F9FF7AA03C739/mysql.PNG" role="button" title="mysql.PNG" alt="mysql.PNG"></span>

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

<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="error.PNG" style="width: 789px;"><img src="https://us.v-cdn.net/6038660/uploads/images/28490iB2C6B2E839FE5BA4/error.PNG" role="button" title="error.PNG" alt="error.PNG"></span>

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