avatar

Snapdragon Tech Blog

Musings of a systems administrator and open source developer

2023

Using Yubikey with OpenSSH in PIV Mode (2023 Edition)

2022

Monitoring a Django Application with Prometheus

2021

Repair Badly Damaged Borg Repository
Automatic Configuration of IMAP/SMTP-based Email Services

2020

Block Google Forms Spam using Rspamd Multimaps
Direct FIDO2/U2F Support in OpenSSH 8.2 on macOS

2019

Upgrade a Ceph Cluster from Mimic to Nautilus using Ceph-Ansible
Reject Viruses from Logged-in Users in Rspamd
Fully Unroot Custom Android ROMs to run Banking Apps
Using a Yubikey to Secure SSH on macOS (Minimalist Version)
Recognize Emails with Spoofed Sender

2018

Hosting Service for BorgBackup Repos – Free 100GB for Beta Testers
Local and remote backups for macOS and Linux using BorgBackup

2017

Update all macOS Apps with a Single Command
Find sites vulnerable to WordPress Content Injection Vulnerability
Optimize Spamassassin Detection Rate

2016

Use Piwik for more Reliable Visitor Statistics (avoid referral spam and ad blockers)
Cheaply retrieve data from Amazon AWS Glacier
Yahoo: Email not accepted for policy reasons
Download Uber ride history to Python Pandas
New Release of invoice2data
Unit testing for Jupyter (iPython) notebooks

2015

Shell Function to Remove all Metadata from PDF
Incremental FTP backups
Extend Pandas DataFrame with custom functions and attributes
Regex to find phone numbers in every format
Python clipboard access
Extract structured data from PDF invoices
Upodder – command line podcast client

2014

Scalable Docker Monitoring with Fluentd, Elasticsearch and Kibana 4
Linksnappy Command Line Downloader (Python)
md2pdf – Command line Markdown to PDF converter with support for CSS stylesheets and custom fonts, Python
SSLv3 no longer supported
Online iPython Notebook Viewer
Access Docker container attributes in Ansible
Use Mac OSX Password Generator from Terminal
Beware of header filtering, when sending to iCloud
Advanced monit: Keep track of daemons, websites, RAIDs and partitons
Defragment Mac OSX from Recovery Mode
Improved phising filter and DKIM signing
Use Java script Bookmarklet to save website data as CSV
Import single WordPress site into WordPress MU Installation
Quantego – Stochastic optimization
Using Hinton diagrams to visualize stock market correlations
High-performance SSH: Install HPN-SSH on OSX with keychain integration
Lazy admin’s guide to automated updates (Part 2: Python pip)
Lazy admin’s guide to automated updates (Part 1: Debian Linux)
Shanghai PM2.5 update
Pleasant places to live in China, Germany and Austria
Introducing: (A)SPEL web stack

2013

Case study: Howard Johnson Hotel – how NOT to sell your Wifi
Buggy Mac OSX 10.9 Mavericks update
XKeyscore capabilities (5 years ago)
Attack from below – Oracle vs the rest
China GPS offset problem
Setting Postfix to encrypt all traffic when talking to other mailservers
Scheduled server maintenance
M/Monit preparing new monitoring tool
Download from Uploaded.to (and others) via command line on Linux or Mac OSX
OwnCloud Update

2012

Happy New Year 2013!
OwnCloud 4.5 released
Scan image via SSH
XBian – Raspberry Pi-based distro for running XBMC
Raspberry Pi for CCTV using motion
Discontinued: DaviCal
Using Raspberry Pi for CCTV with Zoneminder
Access your Raspberry-Pi through any Browser with VNC
Use Raspberry Pi to Print From Your iPad or iPhone
Raspberry Pi as Budget BitTorrent Server
UPC Vienna Wifi-Passwords easily broken with GPUs
Data Retention Coming to Austria
Easily Resize PDF on Mac OSX and Linux
Secure backups in an untrusted cloud with duplicity

2011

Recent Updates
Apple iOS 5
New nameservers
Contacts and Calendar
Leaving Lighty for Apache
Moving to Singapore
Roundcube Webmail Updated
Email Arrival Times
Upgrade to Debian 6.0 “Squeeze”
Email-Privacy and the Law
Filesystem Hierarchy Standard (FHS)

2010

IPv6
Hard Drive Failure
Network Maintenance in Denver
Email-Tutorials and Clients
Network Maintenance