Moodle 3.3 with MySQL SSL Connection in the Azure Cloud

Update: Microsoft Azure Database for MySQL: Use PHP (not) to Connect and Query Data article has now some new updates. Microsoft listened to my words, so I have found a documentation how to connect to Azure Database for MySQL with PHP via SSL connection. This can be found here: https://docs.microsoft.com/en-us/azure/mysql/howto-configure-ssl Of course this is not […]

Read more
Moodle – .vtt Captions do not Work with Internet Explorer

Another thing that works in every other browser but does not work in Internet Explorer. So my solution is to set the MIME type for the .vtt files. This can be done under the Site administration / Server / File types (Moodle >= 2.9). Click on “Add a new file type” button. Set Extension to […]

Read more
Another Moodle report – List of users in a course with enrolment and access info

A report was needed by my client to list participants in a course with access info, so those who did not access the course can be warned to perform the mandatory quiz before closing it. SELECT u.firstname, u.lastname, u.idnumber, c.shortname, IF(ue.status = 0, ‘Active’, ‘Suspended’) as status, e.enrol, FROM_UNIXTIME(ue.timecreated, ‘%m/%d/%Y %h:%i:%s %p’) as enrollment_date, IF(ue.timestart = […]

Read more
Moodle – Filepicker not working in 2.7.1+ on HTTPS

As a request to our client we changed to HTTPS on our server for their Moodle 2.7.1+ instance. I configured the site, but after the change the file picker stopped working. I have found that Chrome console shows the following: Failed to load resource: the server responded with a status of 404 (Not Found) https://c328740.ssl.cf1.rackcdn.com/mathjax/2.3-latest/MathJax.js?delayStartupUntil=configured Uncaught […]

Read more
How to turn off HTTPS login in Moodle database

When cloning a site for testing purposes, there could be a problem with HTTPS within the testing environment. There is a fast way to turn it off in the the database: update prefix_config set value = 0 where name = ‘loginhttps’; Then you can login without HTTPS.    

Read more