DB showing incorrect version and won't allow upgrade

DB showing incorrect version and won't allow upgrade

by Jeff Shrek -
Number of replies: 3

Attempting to upgrade from v3.1.2 to v3.3.2

Server Check shows the following with red CHECK at the end:

database   mysql(5.5.5-10.1.28-MariaDB)   version 5.5.31 is required and you are running 5.5.5.10.1.28

So the problem is that we are running MariaDB 10.1.28 and NOT running MySQL, but the database check is thinking we are still using MySQL 5.5.5.

So how do we get upgrade script to correctly recognize db?

Thanks
 


Average of ratings: -
In reply to Jeff Shrek

Re: DB showing incorrect version and won't allow upgrade

by Jeff Shrek -

So as further information, when I run SELECT VERSION() on the database it reports back as:

10.1.28-MariaDB

And this version is greater than the required version of 5.5.31-MariaDB.


So why is Moodle upgrade script reporting 5.5.5 MySQL?

Average of ratings: -
In reply to Jeff Shrek

Re: DB showing incorrect version and won't allow upgrade

by Jeff Shrek -

Okay so the problem is that my config.php file needed to be changed to reflect the change from MySQL to MariaDB.


In config.php I changed this:

$CFG->dbtype    = 'mysql';


To this:

$CFG->dbtype    = 'mariadb';


And this allowed upgrade to continue.


Another question though...

In this article: https://docs.moodle.org/26/en/MariaDB
it shows that the following line should also be added to config.php:

$CFG->dblibrary = 'native';
This is going way back to v2.6 so is this still necessary, and should I add it?

I am going to assume that YES I should!


Average of ratings: Useful (1)