search

Azure / Moodle

Tooling and guidance on deploying Scalable Moodle Clusters on Azure.
MIT License
153 stars 165 forks source link

The Large templates deploys MySQL 5.6.47.0 but the template claims it's 5.7 #274

Closed VFXpro closed 1 year ago

VFXpro commented 1 year ago

After deployment of this template, the Azure UI claims Azure for MySQL is v.5.6 but Moodle verification reports it as 5.6.47.0. :( This means, we can't use this template, it's simply too old. We're forced to deploy a new MySQL Flexible server as v5.7. Then reconnect everything to it. Not as user friendly. Please improve.

joaop221 commented 1 year ago

Hi there,

Currently moodle supports a named downgrade of MySQL Supported version, you just need to add the environment variable MOODLE_DATABASE_MIN_VERSION=5.6.47.0 you'll not lose any feature of moodle or mysql, this is just a work arround when using azure databases.

joaop221 commented 1 year ago

@VFXpro my bad, i need to correct the info above, this config can be found here admin/environment.xml at the moodle source code. To fix you'll need to change the required version to 5.6.47.0, and as mentioned before there is no problems to do this.

The sed command that i used:

sed -i "s/name=\"mysql\" version=\"5.7\"/name=\"mysql\" version=\"5.6.47.0\"/" /path/to/moodle/admin/environment.xml
naioja commented 1 year ago

We are now supporting Azure Flexible Server For MySQL version 5.7 and 8.0.21 https://github.com/Azure/Moodle/blob/master/azuredeploy.json#L290