Nextcloud complaining about MySQL being non UTF-8

Support
,
1

as per title. I installes the rss feed app in nextcloud. When opening the app i get:

image
image.png922×86 15.8 KB

Any advise appreciated, I do not want to follow the notice just like that.

TIA

2

I tried it and it seems to work but maybe it’s better to try on a test machine first or wait for the next official Nethserver Nextcloud update.

Create /etc/my.cnf.d/nextcloud.cnf with following content:

[mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=1

Restart mysqld to apply new settings:

systemctl restart mysqld

Change database to utf8:

mysql
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;`
exit

Apply changes to Nextcloud:

sudo -u apache /opt/rh/rh-php71/root/usr/bin/php /usr/share/nextcloud/occ config:system:set mysql.utf8mb4 --type boolean --value="true"

Update database:

sudo -u apache /opt/rh/rh-php71/root/usr/bin/php /usr/share/nextcloud/occ maintenance:repair

Be careful as the default backup/restore may not work. You have to care about correct database backup, see NextCloud 15.0.7 update - mysql needs updating as well - Advice please

Source:

https://docs.nextcloud.com/server/14/admin_manual/configuration_database/mysql_4byte_support.html

3

Thanks @mrmarkuz, appreciate the time and effort.

Should I not better create a custom template?

4

You’re welcome.

It’s not necessary because /etc/my.cnf.d/nextcloud.cnf is not templated.