Moodle installation checks for below 3 global variables values:
(1) innodb_file_format=Barracuda
(2) innodb_file_per_table = 1,
(3) innodb_large_prefix = `ON`
and installation fails in case above values not set.
Above 3 global variables are removed in MySQL 8.0 and MariaDB 10.3 (https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-103/#system-variables),
Hence Moodle 3.8.2 installation fails for MySQL 8.0 and MariaDB 10.3
from mysql client what do you get for:
mysql> show variables like 'innodb_file_per_table';
mysql> show variables like 'innodb_large_prefix';
mysql> show variables like 'innodb_file_format';
Since you know they need to be present and the values, could you not use the 'set' command?
'SoS', Ken
Hi Pranav,
could you issue the following SQL queries:
SHOW VARIABLES LIKE "%version%";
and:
SHOW TABLE STATUS FROM <your moodle DB>;
?
Could you post here the content of your config.php file, if any?
Please anonymize any sensitive content there e.g. IP addresses and credentials.
TIA,
Matteo
Hi Matteo,
Please find required detail in the file attached here.
TIA & Regards,
Pranav Soni
Hi Pranav,
now it's clearer, it's Azure Database For MySQL 8.0 which could be another business compared to MDL-61702 e.g. since it looks like - as per Moodle code - not a "plain" drop-in replacement of vanilla MySQL: look at MDL-58931 and MDL-63521, they should be part of your problem too - at least the latter.
Both issues are still open, looking for the right solution (or sponsors ).
HTH,
Matteo
