Issue starting confluence after upgrade

Robert Stogsdill

Database: The database collation 'utf8_general_ci' is not supported by Confluence. You need to use 'utf8_bin'.

my.cnf

[mysqld]
datadir=/db
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
collation-server=utf8_bin
default-storage-engine=INNODB
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#table_cache = 200 mysql 5.6 will not start if enabled.
query_cache_size = 256M
sort_buffer_size = 200M
read_rnd_buffer_size = 200M
join_buffer_size = 500M
open_files_limit = 2048
table_definition_cache = 1024
transaction-isolation = READ-COMMITTED
innodb_log_file_size=2GB
max_allowed_packet = 256M
binlog_format=row
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Kiran Panduga {Appfire}

Hi @Robert Stogsdill, 

I understand that in my.cnf the collation is set to *utf8_bin*, but still you are seeing the database collation 'utf8_general_ci'

To address this issue, you need to change the collation at the Database, table and column level by following the instructions given in the below Atlassian KB article.

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

I hope this information will be helpful.

Thanks,

Kiran.