db:convert-mysql-charset and MariaDB 10.3

[timm2k]

Dear devs,

I've tried to use occ db:convert-mysql-charset with MariaDB 10.3. MariaDB 10.3 doesn't know global variables like innodb_large_prefix and innodb_file_format because they were removed and deprcated since MariaDB 10.2. These settings are default and hardcoded in MariaDB 10.3.

So db:convert-mysql-charset fails to run with message
"The database is not properly setup to use the charset utf8mb4.
For more information please read the documentation at https://docs.nextcloud.com/server/13/go.php?to=admin-mysql-utf8mb4"

db:convert-mysql-charset needs to check the db server's version. MariaDB 10.3 is ready to use utf8mb4.

Steps to reproduce

1. install NC without utf8mb4 support. Use MariaDB 10.3
2. occ db:convert-mysql-charset

Expected behaviour

Database is converted to utf8mb4

Actual behaviour

convert fails

Kind regards
Timm :-)

[MorrisJobke]

cc @nickvergessen

[nextcloud-bot]

GitMate.io thinks possibly related issues are #5099 (Failed to convert DB from sqlite to MariaDB), #5912 (Recommend PostgreSQL instead of MariaDB/MySQL), #3179 (PostgreSQL => MySQL db:convert-type with calendar/contacts), #3709 (Upgrade with SSL-enabled MySQL DB fails), and #4914 (occ db:convert-type mysql -> UniqueConstraintViolationException).

[nickvergessen]

Can you please run the following query:

SELECT VERSION();