linux commands
Test OpenVPN server on it’s standard UDP port telnet is so 2020 so use nc which does UDP too -v verbose -z test daemon -u UDP Get a list of hosts with port “X” open -oG temp: output in grepable format to […]
Category: Programming
Debugging Pi from VSCode
There’s a few tutorials and references for debugging a python program on a remote (e.g. pi) computer. I had to fiddle a fair bit to get VSCode, ssh and debugpy to work. Here is how. Traps and Notes ptvsd is depreceated run […]
Access Grafana v6 without a login screen
Unlike Grafana 5, we can’t use the ‘old’ method of a proxy login to get a cookie for semi-permanent login. This post investigates options to achieve the goal of: Provide a user a “secret” URL which allows them to login to grafana […]
ESP32 Development Environment – Bleeding Edge ESP-IDF v4.1 with cmake
There’s a few options to program the esp32: Arduino IDE : good. Heaps of support and tutorials. Some key limitations for ESP32, such as sleep modes. ESP-IDF with Eclipse: messy to setup. Works okay. However, my PC is a bit slow for […]
WebApp Development for a Esp32 Arduino Sketch
AJAX or websockets will allow nicer development. I’m trying BootStrap to get a tidy interface. Bootply.com and layitout.com enable you to easily create a css/html set of file to display nice buttons and the like. Pingendo (a desktop app) was better for […]
VBA Regex
Typical Replacement Example Dim objRegExp As Object ‘ RegExp using Microsoft VBScript 5.5 Set objRegExp = CreateObject(vbscript.regexp) Dim res As String res = Some text to stuff around with objRegExp.Global = True ‘ match all instance objRegExp.IgnoreCase = True ‘ Multi-space to […]
Time Lapsing with Raspberry Pi
Time Lapse Setup TimeLapse on RPi Enable camera via raspi-config Get pi-timolo which provides a nice script set and configuration to run time lapses Follow the update instructions on that page. Install pi-timolo as a service if you like. I found that […]
Beeson Excel Function
What is it? These add-in contains various User Defined Functions. They can answer the following Where is the Sunday in London on Friday afternoon in 2020? What is the wetbulb for a given humidity? How big should my duct / compressed air […]