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.
You can find plenty of frameworks and tools to provision your AWS resources. Some of them do a great job for a specific purpose, others are more generic. Nevertheless, I do prefer to use native CloudFormation templates as much as possible.605 words, posted on May 1
The more projects you work on, the more streamlined your tooling gets. Hopefully. Various services using different languages have different tooling requirements, of course. A sweet Makefile can be the entry to a unified tooling interface.263 words, posted on April 30
With AWS AppSync, it’s easy to run your own serverless GraphQL service API. Thanks to Velocity Mapping Templates, DynamoDB, and AWS Lambda your can aim for an architecture without any maintenance at all.280 words, posted on April 7