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.
Category Archives: Sys Admin
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:
VirtualBox reference configuration for Kubuntu 18.04 hosts and Kubuntu 18.04 guests
See my reference configuration for hardware selections which worked well for me when running Kubuntu 18.04 guests on Kubuntu 18.04 hosts.
After configuring your VM you might like to read about installing Kubuntu on it.
Installing Kubuntu
So basically I want to run KDE Plasma under Ubuntu and this can be called Kubuntu.
This article is a little bit cargo-clutish. I.e. “I did this and it seemed to work.” and “I don’t do this because it didn’t seem to work.”
I have a pretty heavy reliance on Salt Stack for system configuration. My salt config is all built around Ubuntu 18.04 LTS.
When I need to install a Kubuntu desktop, this is how I do it:
- install Ubuntu Server 18.04 LTS from live installer
- apt update && apt dist-upgrade && apt autoremove && reboot
- apt install kubuntu-desktop && reboot
- apt install virtualbox-guest-dkms virtualbox-guest-utils virtualbox-guest-x11 && reboot
- apt install salt-minion
- vim /etc/salt/minion_id
- vim /etc/salt/minion.d/minion.conf
- master: salt.staticmagic.net
- service salt-minion restart
- salt-call state.highstate
Note that if your Kubuntu install is a VirtualBox guest you need to start it with a normal start if you want the shared clipboard to work. If you start headless or detachable the shared clipboard will not work (in my experience).
If your Kubuntu install is not a VirtualBox guest you can skip the virtualbox-guest-* package installation above.
