Skip to content

Instantly share code, notes, and snippets.

View sneak's full-sized avatar

Jeffrey Paul sneak

View GitHub Profile
{
allowUnsupportedSystem = true;
allowUnfree = true;
fonts = pkgs: with pkgs; {
enableFontDir = true;
fonts = [
ibm-plex
noto-fonts
noto-fonts-cjk
@sneak
sneak / cleanup-mm.sh
Created December 8, 2022 13:14
mattermost message retention crontab
#!/bin/bash
CID="$(docker ps | grep srv-captain--mm-postgres | awk '{print $1}')"
CMD="
delete from posts where createat < extract(epoch from (now() - interval '1 months'))::int8 * 1000;
delete from reactions where postid not in (select id from posts);
delete from fileinfo where postid not in (select id from posts);
"
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Label</key>
<string>berlin.sneak.runit</string>
<key>ProgramArguments</key>
<array>
<string>/nix/store/z19ahyrb7fgzsmysxiz81q7q55m6sza2-runit-2.1.2/bin/runsvdir</string>
@sneak
sneak / webkittime.go
Created September 22, 2020 00:19
webkit time conversion
package main
import (
"fmt"
"time"
)
func main() {
//2020-09-21 22:49:02
const wk int64 = 13245202142853170
@sneak
sneak / grub.conf
Last active April 18, 2020 13:46
/boot/efi/EFI/grub/grub.conf
set timeout=1
set default=0
insmod part_gpt
insmod fat
insmod efi_gop
insmod efi_uga
insmod cryptodisk
insmod luks
insmod zfs
#!/bin/bash
dracut \
-v \
--no-compress \
--force \
--show-modules \
--kernel-cmdline "root=zfs:AUTO rootfstype=zfs" \
/boot/5.4.28-gentoo/initrd.dracut 5.4.28-gentoo-x86_64
# ifupdown has been replaced by netplan(5) on this system. See
# /etc/netplan for current configuration.
# To re-enable ifupdown on this system, you can run:
# sudo apt install ifupdown
#auto wlx801f02ee7727
#iface wlx801f02ee7727 inet dhcp
# wpa-ssid "eeqj.de"
# wpa-psk "REDACTED"
#!/usr/bin/env python3
from email import message_from_file
import json
import os
import requests
import sys
import syslog
@sneak
sneak / gist:e2d7fb6879ec901f9aaa5745701ccfeb
Created March 4, 2020 23:02
fingerprint format for weechat from tls ircd
torsocks ./openssl s_client -connect whatever.onion:6697 | tee /tmp/out
# ... wait a sec, then ^C
cat /tmp/out | openssl x509 -sha512 -fingerprint -noout | tr -d ':' | tr 'A-Z' 'a-z' | cut -d = -f 2
Script started on Wed Feb 26 01:18:46 2020
command: bash -c make run
rsync -avP ./disktest.sh root@fsn1.datavibe.net:/root/disktest.sh
sending incremental file list
disktest.sh
700 23% 0.00kB/s 0:00:00 2,977 100% 2.17MB/s 0:00:00 (xfr#1, to-chk=0/1)
sent 1,003 bytes received 65 bytes 712.00 bytes/sec
total size is 2,977 speedup is 2.79
ssh root@fsn1.datavibe.net "bash /root/disktest.sh 2>&1"