Author: John
Using LetsEncrypt with Ubiquiti Unifi Video server
I’ve spent a lot of time scratching my head trying to get LetsEncrypt, or more accurately certbot working with Ubiquiti UniFi Video server, especially auto-renewing the certificate every month or so. I found two posts on the Ubiquiti…
Read More »SQL Tips – List of Countries (2018 revision)
Over nine years ago, I published a SQL and tab delimited list of countries sourced from Wikipedia and ISO. After numerous comments about it being out of date, here is an updated version….. The data was sourced from…
Read More »I’m still here
To answer all those messages… Yes, I am still alive! Watch this space, more posts to come very soon
Read More »Cheese fridge repairs
My cheese fridge was partially destroyed at the start of July. A car crashed into a power pole carrying both a 22kv distribution line and the 230v line for our house. They . touched . briefly It turns…
Read More »Setting up a CA SSL certificate in hMailServer
I’m a big fan of hMailServer, but the documentation for setting up SSL certificates and the certification chain is a bit lacking. The easiest way to check if hMailServer is setup correctly is to use OpenSSL. openssl.exe s_client…
Read More »1,500,000,000 the Epochening
Don’t forget that at 2:40am, 14 July 2017 (UTC) the Linux epoch will hit 1,500,000,000 (1.5 Gigaseconds). Visit https://www.john.geek.nz/epoch to watch the excitement! It hit 1,000,000,000 back in September 2001 and it won’t hit 2,000,000,000 until May 2033.
Read More »Modifying float voltage of a TP-SCPOE-1224
Adjusting the float voltage of a Tycon Systems TP-SCPOE-1224 The Tycon Systems TP-SCPOE-1224 is a Solar and Power over Ethernet powered DC UPS. You connect it up to a 12v battery, power it over ethernet, add an optional…
Read More »Power meter optical pulse detection
I’ve always planned to monitor my electricity usage. I had previously (about a year ago!) ordered some power transformers from seeedstudio and a six channel ADC for simultaneous three phase current and voltage measurement but never got around…
Read More »Wiring up the ESP8266
Before you can program the ESP8266, you need to wire it up. First things first, the ESP8266 uses a 2mm pin spacing so you can’t use a standard breadboard as these use a 0.1 inch spacing. It also…
Read More »Introducing the ESP8266
About a year ago I put up some money for the Wino-Board kickstarter project, received my Wino-Boards and did nothing with them for 12 months. They are effectively a tiny Arduino board attached to the innards of an…
Read More »