Archive

mundus senescit

Text Manipulation Cheat Sheet

coding macos shell regex

I recently had the "opportunity" to perform some text manipulation to get data from a huge log file into a spreadsheet. I had done this sort of work a long time ago as a developer, but had forgotten over the years. So I decided to compile a text manipulation cheat-sheet for macOS.

Continue reading...

Installing MySQL on macOS

guide macos

There are many open source packages that require the "AMP" stack comprising Apache, MySQL and PHP (hence "WAMP" for Windows-Apache-MySQL-PHP and "MAMP" for macOS-Apache-MySQL-PHP). Since macOS 10.12 Sierra already includes Apache 2.4 and PHP 5.6, here's how to add MySQL 5.7.

Continue reading...

Further ways to lockdown apps like Kodi and VLC

guide macos vm

You have have read that CheckPoint, a cyber security research company, has identified vulnerabilities that may allow an attacker to compromise your computer using malicious subtitle files downloaded by popular media players including Kodi and VLC. It's not clear if this affects macOS too, but in light of this threat, here is a summary of how I further "lockdown" any apps I'm unsure of...

Continue reading...

Setting printer defaults in macOS CUPS

guide macos peripherals

I have experienced a couple of issues printing with the Ricoh printer drivers for macOS - at one location, I simply couldn't print, and at another, I couldn't get it to print "two-sided" (despite the correct duplex settings). In both cases, I reverted to the standard macOS driver, i.e. "Generic PostScript Printer" or "Generic PCL Laser Printer". This post details the steps to set printer defaults like duplex via CUPS.

Continue reading...

Workflow Action to add cheap IDD call prefix

guide ios shortcuts

Does your service provider differentiate between standard or "premium" IDD and "budget" IDD like mine does? Typically, the standard + international call prefix will default to the premium option, but to use the the cheaper option, usually via voice-over-IP (VoIP), one has to specific a different carrier-defined prefix, e.g. 12300 (I just made this up, check with your telco). I can't find a built-in way to do this on iOS... enter the Workflow App!

Continue reading...

Using Workflow App to Track Travel Expenses

guide ios shortcuts

Apple acquired Workflow today, and Workflow is now free in the App Store! Workflow (http://workflow.is)is a powerful yet simple rule-based automation tool. One pre-built workflow is to lookup your next calendar meeting, retrieve the location if there is one, and pop up directions in Maps - all this from a single button click.

If you are new to Workflow, here is a short tutorial to use Workflow to track travel expenses.

Continue reading...

Creating a macOS Sandbox to run Kodi

guide macos

Since 2012, all apps on the Mac App Store must run in an app sandbox, which restricts access to system resources unless explicitly required. The secure sandbox isolates the app and defines access controls, protecting users from malicious code with undesired behaviour.

Here's how to setup a sandbox for an app downloaded from outside the Mac App Store.

Continue reading...