This article about Wikimedia’s CDN popped up on lobste.rs today.
Category Archives: Sys Admin
What it takes to run Stack Overflow
Today What it takes to run Stack Overflow popped up on r/programming. It’s an old article (2013) but still interesting. It referenced Performance is a Feature and made the bold-font claim that “the cost of inefficient code can be higher than you think.”
Linux File Timestamps Explained: atime, mtime, and ctime
Today I discovered an article explaining Linux file system timestamps: Linux File Timestamps Explained: atime, mtime, and ctime; and a good thing too, because I always thought ‘ctime’ was ‘create time’, but not so! Turns out that ‘ctime’ is ‘change time’, similar to ‘mtime’ but apparently cannot be set from userspace. My investigations were prompted by my investigations info how `borg create` identified changed files.
The unrealized potential of federation
Today I read The unrealized potential of federation.
Backing up data like the adult I supposedly am
This great article Backing up data like the adult I supposedly am popped up on Lobste.rs today. I think I’m gonna get myself an rsync.net account.
// 2022-09-18 jj5 – UPDATE: I have had an rsync.net account for some time now, works great. <3
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:
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.
How to generate an SSL private key for use with MySQL/MariaDB and PDO
To generate an SSL private key for use with MySQL/MariaDB and PDO:
openssl genrsa -out client-key.pem 4096
Shadow IT
Today I was reading about Shadow IT over on Wikipedia.
NetBeans red line
There is a feature of NetBeans where it puts a red line as the right margin in the code editor. By default this margin is at 80 characters but I prefer it at 99 characters. To change the setting in NetBeans see Tools -> Options -> Editor -> Formatting -> All Languages -> Tabs And Indents -> Right Margin. For example: