itslukej

curl -s -H "user-agent: " https://bgp.tools/table.jsonl \
 | jq '{cidr: .CIDR, asn: .ASN, hits: .Hits}' \
 | clickhouse-client --user admin --password "${CH_PWD}" --database bgp --query="INSERT INTO routes FORMAT JSONEachRow"
 
 curl -s -H "user-agent: " https://bgp.tools/asns.csv \
 | csvformat -U 1 -D ',' \
 | python3 -c 'import csv,json,sys; [print(json.dumps({**row, "asn": int(row["asn"].replace("AS", ""))})) for row in csv.DictReader(sys.stdin) if (lambda asn: asn >= 0)(int(row["asn"].replace("AS", "")) if row["asn"].replace("AS", "").isdigit() else -1)]' \
 | clickhouse-client --user admin --password "${CH_PWD}" --database bgp --query="INSERT INTO asns FORMAT JSONEachRow"

clickhouse-client --user admin --password "${CH_PWD}" --database bgp --query="OPTIMIZE TABLE asns FINAL"

itslukej

log_format json escape=json
  '{'
    '"timestamp":"$time_iso8601",'
    '"request_time":"$request_time",'
    '"request_time_ms":"$msec",'
    '"upstream_cache_status":"$upstream_cache_status",'
    '"remote_addr":"$remote_addr",'
    '"cf_connecting_ip":"$http_cf_connecting_ip",'
    '"range":"$http_range",'
    '"uri":"$uri",'

itslukej

#!/usr/bin/env python3
# Download your data dump and place this file in the messages folder of your data dump.
# Then run it!

from datetime import datetime, timedelta, timezone
import dateutil.parser
import matplotlib.pyplot as plt
import matplotlib.ticker as ticker
import matplotlib.dates as mdates
import csv

itslukej

#!/usr/bin/env python3
# Download your data dump and place this file in the messages folder of your data dump.
# Then run it!

from datetime import datetime, timedelta, timezone
import dateutil.parser
import matplotlib.pyplot as plt
import matplotlib.ticker as ticker
import matplotlib.dates as mdates
import csv

itslukej

1. Get a proxmox ISO mounted

2. boot to bios, switch to uefi, boot to ISO

3. head to Install Proxmox (Debug Mode) under advanced options

4. press ctrl-d to launch a terminal

5. mount zfs, then chroot into it

itslukej

Tunneling a whole process through wireguard

Certain company blocking a certain hosting provider? No problem, just tunnel the process through a small VPS with wireguard.

Consider server A your blocked server and server B your VPS.

Step 1: Generate a keypair on server A and server B

Server A:

itslukej

# Caches movie covers, tv covers and other media
# Replace <YOUR PLEX TOKEN> with a random plex token

# docker-compose.yml
#  varnish:
#    image: "varnish:fresh"
#    network_mode: "host"
#    environment:
#      VARNISH_SIZE: 2G
#      VARNISH_HTTP_PORT: 32500

itslukej

db.aggregate([{
    $replaceRoot: {
      newRoot: {
        _id: '$_id',
        data: {
          $objectToArray: '$$ROOT'
        }
      }
    }
  },

itslukej

#!/bin/sh
/usr/lib/plexmediaserver/Plex\ Media\ Server \
	--sqlite /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db \
	"UPDATE metadata_items SET added_at = created_at WHERE added_at > strftime('%s', 'now');"

itslukej

router id x;

protocol bgp as62240 {
    local as 209808;
    source address x;
    neighbor x as 62240;

    import all;
    export filter {
        if net ~ [2a06:e881:5404::/48] then accept;