MAC OS X – Renaming Multiply Filenames to Lowercase in a Directory

You will need the Terminal for this operation. Open Terminal and navigate to the directory using the cd command where you want to change the case of the files. Then run the following command: for FILE in `ls -A1 *`; do FILENAME=`echo ${FILE} | sed ‘s/ /\\ /g’`; echo mv ${FILENAME} `echo ${FILENAME} | tr […]

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
MAC OS X – SSH LC_CTYPE Warning

Using terminal ssh to my Linux servers I have always got the following error: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory Commenting the following line from /etc/ssh_config file on my Mac was the solution for me: #   SendEnv LANG LC_* Note: do not forget to use sudo when editing […]

Read more
MAC OS X – Copy and Paste as Text

Well, well. I have my new Mac workstation and let me say there are many differences to Windows. But let me say it is much more better. While I was writing my letter I would like to copy a text from one of my website admin page and it pasted the style also. So I […]

Read more
Another Annoying Outlook Web App Feature

Hope that someone at MS realize that it is time to set up an UX team. This is my favorite OWA feature for today: I’ve got a mail with an attachment that can not show in browser. Under that there is a Download button. Clicking on that you get an error telling you that you have […]

Read more
MySQL Out of Resources Error

Checking my automated backup I realized that one of my database dump is empty. I chechked the database and it was ok. I tried a manual dump and I got this: mysqldump: Couldn’t execute ‘Lock tables on `tablename`’: Out of resources when opening file ‘./databasename/tablename###.MYD’ After some googling I found a solution. I have the following […]

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