watch catting together HTML head/foot and MySQL information_schema.processlist

This came up back on August 9th 2020 in #lobsters on freenode. They were doing a system upgrade and providing a report by using `watch` to `cat` together a HTML header and footer with `mysql -e ‘select * from information_schema.processlist’` to provide a status report. Thought that was a neat hack.

Bridge sniffer

I’ve been having trouble getting my Pioneer FreedomBox to work and I found myself wanting a network protocol analyser so I could see what was going on.

I got myself two of these Simplecom USB 3.0 to Gigabit RJ45 Ethernet LAN Adapters and attached them to my MacBook Pro, like this:

network sniffing setup

Then I spun up a Kubuntu system in a VMWare Fusion virtual machine and created a bridge like this (thanks to my mate Raz for the instructions):

   ifconfig eth0 up
   ifconfig eth1 up
   brctl addbr br0
   brctl addif br0 eth0
   brctl addif br0 eth1
   ifconfig br0 up

Then I was able to run WireShark to monitor traffic across the br0 bridge which helped me to diagnose the issues I was facing.

…and in the end I got my FreedomBox operational, so got to be happy about that! :)

The problem I was having was that my FreedomBox would work okay for a few minutes and then lose network connectivity. I confirmed this with my WireShark logs. You could see the DHCP and MDNS working at first and then see things stop working after some time.

The problem turned out to be related to the fact that I was running an old version of the FreedomBox software. The reason my software was out of date was that I had downloaded a “nightly build” which was well out of date. I think maybe the nightly builds are no longer maintained. After I upgraded to a stable build my networking problems went away.

Resetting a WASD Code keyboard

I have a CODE V3 104-Key Mechanical Keyboard with Cherry MX Green switches which I love. But unfortunately it has been my experience that they can be a bit finicky. I had to return one to WASD once because keys started producing “gibberish” if pressed the keys too hard. I know! Crazy!

Anyway I had a similar problem today. My Pause key, when pressed, would simultaneous ‘mute’ my audio *and* turn it either ‘up’ or ‘down’ (with a preference for ‘up’). Friggin weird. Anyway I was able to fix the issue by doing a keyboard reset.

To do a keyboard reset: unplug the keyboard, set SW4 to the “on” position, plug it back in. Wait until the solid green lights emit and then unplug, set SW4 back to the “off” position and then plug the keyboard back in and test. Easy peasy. :)