To find out the # of minutes since a datetime in a sqlite table (example column jobend), do the below:
select jobend, cast(((julianday(current_timestamp)-julianday(jobend))*1440) as int) as mins_passed from job
Downloading envoy for linux
Looking to download the envoy proxy?
Try here – but note it needs glibc 2.18, so no Centos 7.
View TLS peerchain in Python 3
A quick hack based mainly on someone else’s work:
https://github.com/jamespo/commandmisc/blob/master/scripts/peerchain
Stop emacs paste from indenting, eg in python-mode
Put this in your .emacs:(add-hook 'python-mode-hook '(lambda ()
(electric-indent-local-mode -1))
unbound-control not working?
Add the remote-control section at the bottom of your conf file
Access your UTM VM over ssh
Go to Network Section for the Guest & create a new Port Forward from guest port 22 to host port 22022 (or whatever port you have free)
Save & start up the VM
Open terminal and ssh to your local forwarded port
Beautiful heatsink for the Raspberry Pi
Web Page Navigation with a Rapoo mouse on Mac
Install Karabiner, enable the mouse device & import these rules: https://ke-complex-modifications.pqrs.org/#mouse_button
Migrating from SmartThings to Zigbee2MQTT with Home Assistant
Sadly, Samsung seem to be winding down their SmartThings Zigbee/ZWave home automation setup and it has always been quite painful using devices that weren’t officially supported. I’ve recently migrated my non-SmartThings native devices to Zigbee2MQTT, here’s how I did it:
- Purchase a SBC, in my case an OrangePi 4 running Armbian/Ubuntu – but a Raspberry Pi 4 is more mainstream. Set it up on your home network (perhaps you already have this running Home Assistant).
- Buy a supported zigbee adaptor. I strongly recommend the electrolama zzh adaptor (this requires firmware flashing post purchase, but this is straightforward).
- Install the adaptor, ideally via a USB extension cable.
- Install zigbee2mqtt.
- The version of node installed wasn’t recent enough; I downloaded a newer version.
- As the name suggests, you’ll have to set up an MQTT server, typically mosquitto to receive the status messages.
- Configure zigbee2mqtt / Home Assistant integration.
- Add your zigbee devices.
- Reconfigure your Home Assistant Automations etc if necessary.
Memory Upgrades from Mr Memory
Very pleased with my recent order from Mr Memory. The DIMM they sent me didn’t work but the return & replacement process was free & efficient.