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.
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.
Some time ago, I posted about starting Apache automatically when macOS 10.12 Sierra starts, using the
launchctl command to add Apache to the
launchdLaunch Daemon/Agent Manager. For those familiar with Windows, this is akin to managing Windows Services.
Following up on my posts, Compiling Wine 1.9 from scratch on macOS with Retina mode and Creating a wine.app bundle manually, here's my script to automatically download and compile pre-requisite libraries, then download and compile Wine 2.9 32-bit, build the .app bundle, and even include a registry tweak to enable Retina Mode.
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...
I recently downloaded an update to VLC, an open-source media player. The VLC download page, displayed it's SHA-256 checksum - here's how to quickly validate your download by comparing the checksum using the built-in macOS tools.
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.
So I got a new MacBook for work and I didn't realize upon next reboot, the enterprise profile had mandated FileVault encrypt the start up disk, and Apple had recommended an upgrade to macOS Sierra at the same time! You can imagine triggering both simultaneously upon reboot didn't go well at all!
Remember the time I waxed lyrical about using Google Sheets to track my stock portfolio? Well, it's going to be a "standard feature" of spreadsheets soon, with the introduction of the capability to retrieve stock data with today's update of Numbers on iOS (3.1) and macOS (4.1).
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.
Wine 1.9.22 development (dated Oct 28, 2016) has been released! See the release notes for changes. Alas, I encountered errors trying to compile it "on top" of the Wine 1.9.21 installation, following the steps from my post Compiling Wine from scratch. I spent a whole day searching for the problem, and resolved it as below.
So a couple of days ago, I documented how I compiled Wine 1.9.21 with Retina Mode from scratch on macOS Sierra. After that I though I might as well figure out how to bundle all these files into a
.appbundle, which Finder presents as if it were a single file.
Here is my list of free, macOS apps that I have installed and use often. Many are also open source! When I first got my Mac I searched the internet for lists of useful apps but found most outdated. I decided to compile this list as part of a cleanup and "audit" of what's useful IMHO.
Recently I realized that the latest macOS Sierra 10.12 upgrade also updated Apache and PHP to newer revisions (2.4.23 and 5.6.24 respectively), but reverted to the default configurations. My previous post on Enabling Apache and PHP on OS X 10.11 needed a slight change too.
I've been a long time iOS 1Password user, but recently started looking at alternatives. I discovered KeePass, KeeWeb and MiniKeePass, all open source.
I recently discovered an alternative to remote control my Windows 7/10 desktop PC, instead of using Microsoft Remote Desktop. This method requires a computer with a modern NVIDIA graphics card with GameStream and works with iOS and macOS using a client called Moonlight!