Monday-Wednesday. Can’t remember. Working, hiding from COVID, doing the thing. RMB was a close-contact to her later-found-COVID-positive niece, who’d been working at their house, so we’re all avoiding people.

I did a RAT with a negative result; I haven’t had any symptoms.

Thursday

• The Aussie Broadband integration for Home Assistant was released as part of core. It’s based around my pyaussiebb package, but the HA part was done by Brett Adams, who’s much more patient than I am.

Friday

Upgraded to the new version of Home Assistant. Woo, ABB data. Boo, it broke because we didn’t test with VOIP services. The PR’s already been done.

On 2022-01-15 04:14:45 UTC, the Hunga Tonga–Hunga Haʻapai Volcano erupted, with a truly epic amount of force.

From Wikipedia:

On 15 January, the volcano violently erupted again, about seven times more powerfully than the eruption on 20 December 2021. There were numerous reports of loud booms across Tonga and other countries, such as Fiji and as far away as New Zealand and Australia. A boom was heard in Alaska seven hours after eruption. The eruption set off a massive atmospheric shockwave travelling at about 300 m (1,000 ft) per second. Near the eruption, the explosion damaged property, including shattered windows.

[Read More]

I wanted some boxes to sit in my Billy bookcases and hold my DVD collections on their end, making it easy to pull out and see if I wanted, but otherwise less noticeable.

Materials

• I used a 4’x8’ plywood sheet (12mm non-structural) - you could do this with a 1200x600 piece.
• Wood Glue
• Nails (having a nailgun makes this fast to build)

Making the box

Cutting Things Up

• Cut 3x200mm wide pieces, along the width of the sheet. ie, you want pieces 1200x200, not 2400x200. 😆
  • If you’re using a big sheet, measure each time - remembering the kerf will take a little bit.
  • Small sheet? just cut it in thirds.
• Stack two of the slices up, clamp them together so they’re all aligned and cut two pieces 710mm long for the sides.
• Mark the other piece to match the length of the sides, then deduct two thicknesses of board off that length and then cut there - that’s your bottom.
  • The “ends” overlap the bottom, so they grip it from the sides (and the nails help).
• Since it’s the same width, the offcut can be cut down to make the “short” sides to the height you need - it should be 200mm, but match it up since we’re not robots.

Assembly

• Lie the bottom piece with a long edge facing up, then glue + nail a “short” piece to one end, to make an L shape.
  • The reason I don’t do it with the bottom laying flat is it’s really hard to get the alignment right, the nails in and the glue from dripping on the bench.
  • To help hold the pieces upright, you can just attach clamps on the non-working end at bench-level, which is enough to provide support.
• Glue + nail a “long” side on top of that, starting in the corner of the L and working out.
• Glue + nail the extra “short” end.
• Glue + nail the other “long” side.

At this point the box structure’s done!

I finally got around to making a Splunk App for Queensland Covid Contact Tracing, parsing the Queensland Health webpage which lists exposure sites in Queensland.

… and then they gave up.

Mumble mumble. I’m double-and-a-booster vaccinated (Pfizer x3), but that doesn’t mean I’m completely immune, and it’s getting wild.

Sigh. I guess it had to come to town eventually in a big way - I guess?

Stay safe, folks.

Original thread on the unifi forums

lbd exited with code 256 and restarted by inittab, 141,020 times one one AP in 48 hours

This process has crashed more than a few times lately…

Model UAP-AC-IW, firmware Version 5.43.43.12741

The common response from @UI-Glenn was “disable band steering” - which I had done. Any chance of an actual fix soon?

I logged a support case for this, which led to me upgrading the firmware on the Unifi controller (self hosted, on a Ubuntu 20.04.3 VM)

Here’s a scam email, just so you can find it if you’re searching for it.

• From: some random @gmail.com address.
• Subject: “Payment processed successfully”
• Source: gmail DKIM pass, so a hacked account.

Payment ID : 947GR924DR815
Payment Due Date : Oct 25, 2021
 

Norton



Dear Customer ,

Thank you for subscribing our services again and renewing your annual subscription.

As part of your automatic payment, your account has been charged with $419.94

This deduction will reflect in your statement as NTC-TB charge within 1-2 business days.

So if you have any concern with this direct-debit charge or you didn't authorize the charge, please feel free to connect with us at +1 888 - 721 - 7167



Description
Devices Covered
Expiration Date
Amount
Advanced Life-lock Security
05
Oct 24, 2022
$419.94





Your membership will automatically continue as long as you choose to remain a member.

Anytime you wish to cancel the services kindly visit "The Account Section Page" and follow the instructions to cancel the services.



Thank you 

Life-lock Security Dept.
Help care # +1 888 - 721 - 7167

This is a system generated mail. Please do not reply to this mail ID.

Go to https://www.plex.tv/claim/ and it’ll present you with a claim code, which expires in four minutes 🤔

If you get a weird error like

sqlite prepare error -> SqliteFailure(Error { code: Unknown, extended_code: 1 }, Some("near \"ON\": syntax error"))

or

syntax error near ON

While trying to use UPSERT ... ON CONFLICT(yyyy)…

It could because you’re running Ubuntu Bionic or another similarly old version - your SQLite version’s before 3.24.0

From the SQLite documentation for ON CONFLICT:

The phrase “ON CONFLICT” is also part of UPSERT, which is an extension to INSERT added in version 3.24.0 (2018-06-04)

[Read More]

I’m running an old i7 2012-ish Macbook as a docker host since it still works and it’s pretty capable for the job.

The screen kept staying on while just sitting at the text login screen, which was a bit of a worry for the lifetime of the LCD.

I have finally figured out how to fix it! Woo! 🎉🥳🎉

Edit /etc/defaults/grub and update the GRUB_CMDLINE_LINUX_DEFAULT entry to have the following two entries:

While trying to update the HTTPS/TLS certificate on my Brother MFD, I got the following error:

I’m using a Let’s Encrypt-generated certificate and had packaged the full chain.

The fix I found was to just use the end cert. I generated it using this command, on a box where I generate my cert for this printer with certbot:

sudo openssl pkcs12 -export -out ~/brother.pfx \
    -inkey /etc/letsencrypt/live/brother.example.com/privkey.pem \
    -in /etc/letsencrypt/live/brother.example.com/cert.pem

One day I’ll automate the upload, but they randomize the login form, use CSRF and have a few other protections that make it surprisingly complicated. Woo, security?