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 […]

Microsoft Azure Database for MySQL: Use PHP (not) to Connect and Query Data

Back on the road of blogging again. So our client who is a big European organization has Microsoft Azure Cloud services and having consultant company for support. Since we would like to run Moodle we need PHP + MySQL.  We got an Ubuntu app server. Funny isn’t is to run Linux machines in the Microsoft […]

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 […]

Moodle plugin: Aardvark theme – Anchor Offset to Adjust for Fixed Header

I have using Aardvark theme for many years (thanks Shaun). With my latest Aardvark theme deployment I had a problem that the fixed header was relative big (160 pixel) and when using hash tag links in the courses the content of the anchors was covered by the header. I needed to offset the anchors for […]

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 = […]

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 […]

Another Moodle report – List submitted files of an assignment by cohort users

My boss wanted a report to show who had submitted a certification of their debit by courses. We have approximately 120 courses. All courses have a consultant with teacher role. All the student are in separate cohorts. Each cohorts added  one-by-one to courses so one cohort to one course.  Consultants need to know who paid or […]