Unzip all zip files in the current directory
I often have more than one zip file in a directory to unzip – usually Moodle modules or the like. e.g. To unzip all of the mods into their respective folders in one line:
ssh login with no password
It’s really inconvenient to continually enter your password when ssh’ing among internal servers. Especially if your password is long. I have set up password-less login on some of our linux servers using this excellent guide. I had already set up a private/public key pair on my mac in the .ssh folder in my /Users/ folder: It’s necessary to send your public key to the server you intend to log into. The provided command does not work because the hidden directory…
Blob problems
I have recently encountered a problem loading BLOBs from SQL server 2012. Until moving to PHP 7.x we previously used the mssql libraries. Now we are using the dblib driver in PDO the php_mssql libraries are gone for good. It appeared that, once again, files were being truncated to 60Kb (an old problem). It’s not clear why this started to break again. No new packages have been installed. Using php_mssql it was possible to: These ini_set statements don’t have any…
Randomise column in CSV using awk
In packaging our learning analytics automation system I have provided test data in CSV files on the Virtualbox machine. These CSV files contained actual student ID numbers from our College so I needed to replace them with random, non-repeating information. I have substituted these with Student(n) to represent the real students for this post. I found an excellent AWK entry on the evergreen Stack Overflow which fit my particular use case. This is very close to what I need to…