Nextcloud complaining about MySQL being non UTF-8

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

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


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:


Restart mysqld to apply new settings:

systemctl restart mysqld

Change database to utf8:

ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;`

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


Thanks @mrmarkuz, appreciate the time and effort.

Should I not better create a custom template?

You’re welcome.

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