The YubiKey is a great OpenGPG smart card compatible hardware device. I use my YubiKey to store my private GnuPG key and for authenticating SSH connections. A few applications, however, don’t work with the OpenGPG card and require a file containing the key per default; Sequel Pro is one of them.
Luckily I stumbled upon an older issue at GitHub with a neat workaround using Automator in macOS.
Together with the latest GPG Suite for macOS, the configuration is not more complex than adding a line to your
This tells your SSH application to use the GPG Agent for any authentication requests. So when you run
ssh user@host, a prompt will ask you for your smart card pin instead. Awesome!
Use Automator in macOS to create a new application and configure Automator to run a shell script containing the following lines:
source ~/.zshrc /Applications/Sequel\ Pro.app/Contents/MacOS/Sequel\ Pro
This post is mostly a reminder for my future self how to setup macOS, Sequel Pro, and a YubiKey to access MySQL databases using an SSH tunnel.
If you love software workflows as much as I do, you should check out my basics for deploying NPM packages using TypeScript, CircleCI v2, and GitHub Releases.396 words, posted on November 5
The MaxMind GeoLite2 database is basically the standard solution when you need to get the geo information for an IP address. Together with the mmdb-reader NPM package you can easily deploy your own serverless API to AWS Lambda to lookup locations for IP addresses.215 words, posted on November 3
AWS Lambda functions together with an Amazon Kinesis Stream offer a great way to process continuous information. I created an example project called Serverless Analytics to demonstrate this. You can use this as the starting point to create your very own Google Analytics clone and run it serverless and hopefully maintenance-free on Amazon.690 words, posted on August 23