Skip to content

Instantly share code, notes, and snippets.

brentmaxwell / EmptyGuid.sql
Created January 20, 2022 20:42 — forked from jonsagara/EmptyGuid.sql
Generating Guid.Empty in SQL Server
-- 2021-11-24: suggestion from comments:
SELECT @EmptyEmpty
-- Original
brentmaxwell / myusbgadget
Last active June 1, 2020 14:39 — forked from geekman/myusbgadget
Pi Zero multiple USB gadgets minimal example
#!/bin/bash -e
modprobe libcomposite
cd /sys/kernel/config/usb_gadget/
mkdir g && cd g
echo 0x1d6b > idVendor # Linux Foundation
echo 0x0104 > idProduct # Multifunction Composite Gadget
echo 0x0100 > bcdDevice # v1.0.0

Better SSH Authorized Keys Management

A seemingly common problem that people encounter is how to handle all of your users authorized_keys file.

People struggle over management, ensuring that users only have specific keys in the authorized_keys file or even a method for expiring keys. A centralized key management system could help provide all of this functionality with a little scripting.

One piece of functionality overlooked in OpenSSH is the AuthorizedKeysCommand configuration keyword. This configuration allows you to specify a command that will run during login to retrieve a users public key file from a remote source and perform validation just as if the authorized_keys file was local.

Here is an example directory structure for a set of users with SSH public keys that can be shared out via a web server:

brentmaxwell / gist:4e0239b214f589cc3d80824a4bef8f34
Created May 4, 2016 12:53 — forked from davidnunez/gist:1404789
list all installed packages in android adb shell
pm list packages -f