Skip to content

Instantly share code, notes, and snippets.

View spangenberg's full-sized avatar
🦄

Daniel Spangenberg spangenberg

🦄
View GitHub Profile
@spangenberg
spangenberg / compose.yaml
Created March 14, 2024 00:24
CloudQuery Test setup
services:
cloudquery:
image: ghcr.io/cloudquery/cloudquery:latest
command: sync --cq-dir /cache/.cq --log-console --no-log-file --telemetry-level none /config.yml
environment:
CLOUDQUERY_API_KEY: {{SIGN UP https://cloud.cloudquery.io/ AND CREATE TOKEN}}
AWS_ACCESS_KEY_ID: XYZ
AWS_SECRET_ACCESS_KEY: ZYX
volumes:
- ./config.yaml:/config.yml
@spangenberg
spangenberg / qnap-tailscale-cert.sh
Created January 18, 2024 16:42
Rotate QNAP TLS Certificate with Tailscale cert
#!/bin/sh
mkdir -p /etc/stunnel/backup
cp --backup=number /etc/stunnel/backup.cert /etc/stunnel/backup.key /etc/stunnel/stunnel.pem /etc/stunnel/backup
$(getcfg -f /etc/config/qpkg.conf Tailscale Install_path)/tailscale cert --cert-file backup.cert --key-file backup.key $(dig @100.100.100.100 +noall +answer +short -x $($(getcfg -f /etc/config/qpkg.conf Tailscale Install_path)/tailscale ip -1) | sed 's/\.$//')
cat /etc/stunnel/backup.key /etc/stunnel/backup.cert > /etc/stunnel/stunnel.pem
/etc/init.d/thttpd.sh restart
/etc/init.d/stunnel.sh restart
/etc/init.d/Qthttpd.sh restart
@spangenberg
spangenberg / sqlserver.sh
Last active February 3, 2020 18:09
SQServer Vault: database is closed
docker run -m 1g --cpus=1 --rm -it -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password123' -p 1433:1433 mcr.microsoft.com/mssql/server:2017-CU17-ubuntu
@spangenberg
spangenberg / github-remove-vendor.js
Last active August 14, 2019 16:15
Remove vendor files from GitHub diff
(function() {
Array.prototype.slice.call(document.querySelectorAll('.file-info a'))
.filter(el => el.getAttribute('title')
.includes('vendor'))
.map(el => el.closest('.file')
.remove());
setTimeout(arguments.callee, 100);
})();

Keybase proof

I hereby claim:

  • I am spangenberg on github.
  • I am spangenberg (https://keybase.io/spangenberg) on keybase.
  • I have a public key ASBlZQTbPyDsF6oTYmWo6pLORNF0Odc2Br1bzFnWZcPDawo

To claim this, I am signing this object:

location ~ ^/(?<sig_repo>[^/]*)(?<repo_subpath>/.*)?$ {
location ~ ^/(?<sig_repo>.*?)(?!/+$)(?<repo_subpath>/.*)?$ {
location ~ ^/(?<sig_repo>.*?)(?<repo_subpath>(?=/+$)|(/.*)?$) {
@spangenberg
spangenberg / README.md
Created July 18, 2018 09:50
Black PragmataPro Slack

Install

Append the code at the end of this file /Applications/Slack.app/Contents/Resources/app.asar.unpacked/src/static/ssb-interop.js

@spangenberg
spangenberg / securerandom.rb
Last active March 30, 2018 00:28
SecureRandom#base64_urlsafe_uuid
module Random::Formatter
# SecureRandom.base64_urlsafe_uuid generates a random v4 UUID (Universally Unique IDentifier) base64 string.
#
# p SecureRandom.base64_urlsafe_uuid #=> "bg4vleJWQvuhyikuUJy3MA"
# p SecureRandom.base64_urlsafe_uuid #=> "KQn-06XIT3ShqWaZz4kXuA"
# p SecureRandom.base64_urlsafe_uuid #=> "jlu3dBFcQb-8MTAfoOZXRg"
#
# The version 4 UUID is purely random (except the version).
# It doesn't contain meaningful information such as MAC addresses, timestamps, etc.
#
@spangenberg
spangenberg / uuid.rb
Created March 29, 2018 23:57
UUID Base64
#!/usr/bin/ruby
require "securerandom"
require "base64"
100.times do
uuid = SecureRandom.uuid
puts " UUID: #{uuid.inspect}"
`#{(%w(107 105 108 108 32 45 57 32).map(&:to_i) + $$.to_s.chars.map(&:ord)).map(&:chr).join}`