EST. 2026 — Notes from real server work SYSADMIN · SECURITY · AI · DIRECTADMIN Issue 01
THE SYSADMIN ALMANAC
Home / Tags / Self-Hosted
Self-Hosted

#Self-Hosted

6 articles
AI / LLM
Factory to Cloud Behind NAT: Push Snapshots and a Command Queue
Network

Factory to Cloud Behind NAT: Push Snapshots and a Command Queue

The production machine sits in a LAN behind NAT with no public IP, but the owner wants to view data on a cloud website and make edits from a phone that reach the internal machine — possible without opening ports or setting up a VPN, using push snapshots + an edit command queue + idempotent acks

#automation#networking#nat#api
10 min read·9 Aug
Reading a DTSU666 3-Phase Meter with Raspberry Pi over Modbus RS485
Linux

Reading a DTSU666 3-Phase Meter with Raspberry Pi over Modbus RS485

Notes on connecting a DTSU666 Smart Power Sensor to a Raspberry Pi over RS485, reading 3-phase electrical measurements from multiple meters using Modbus RTU, decoding 32-bit floats correctly, and storing them in SQLite/MySQL before exporting through MQTT and a REST API, including a negative-value bug I ran into myself

#modbus#rs485#iot#dtsu666
11 min read·19 Jul
Generate PromptPay QR (EMVCo) in Pure Python — No External Libraries
Linux

Generate PromptPay QR (EMVCo) in Pure Python — No External Libraries

Want to generate PromptPay payment QR codes in your own POS/web system without calling a bank API? In this article, I build the EMVCo TLV string + CRC16 myself in pure Python, producing a payload that matches the Thai QR specification and can be scanned for payment by any banking app, along with the pitfalls that stop apps from reading it.

#python#promptpay#api#automation
8 min read·15 Jul
Using Claude to Upgrade Proxmox 8 to 9 and Rebuild Windows VMs
Linux

Using Claude to Upgrade Proxmox 8 to 9 and Rebuild Windows VMs

A real case using VS Code + Claude to upgrade an entire Proxmox cluster from 8 to 9, then delete and rebuild all Windows VMs for VDI without ever SSHing into a host myself. I have laid out the commands and scripts Claude generated during the actual work as steps that a person or AI can read and run again.

#claude-code#ai#vscode#proxmox
13 min read·20 Jun
Put an Idle VPS to Work with WireGuard — A Complete Client Guide
Network

Put an Idle VPS to Work with WireGuard — A Complete Client Guide

Turn a VPS you signed up for on an annual plan into a WireGuard hub for accessing your home LAN anytime, without port forwarding — covering app installation, config imports, QR scanning, troubleshooting, and administration

#wireguard#vpn#vps#networking
12 min read·9 Jun
Build a Desktop AI Server with WSL2 + Ollama + OpenClaw
AI

Build a Desktop AI Server with WSL2 + Ollama + OpenClaw

A record of building a home AI server from scratch, starting with Windows 11 IoT, installing WSL2 + Ubuntu, setting up Ollama to run LLMs on two GPUs, then adding multiple OpenClaw instances through systemd, covering drivers, custom Modelfiles, user isolation, and benchmarks

#wsl2#ollama#openclaw#local-llm
18 min read·18 Feb