I was getting messages like this from sanoid: I was sure it was related to my recent zfs clone when I was I broke my FreeBSD MySQL jail; got it working again by using a snapshot This is the raw set of commands I ran, presented without commentary.
Show us your refcompressratio
Following from a recent toot, I’ve decide to expose some very personal data. aws-1 gw01 nagios03 r730-01 r730-03 tallboy x8dtu zuul
Show us your refcompressratio Read More »
Upgrading a jail by replacing it
This new post replaces one on another blog: https://news.freshports.org/2025/09/13/updating-a-jail-by-replacing-it-1-0-1/ I’m placing it over here because: I’m changing how I do it I couldn’t find it when I went searching – I was only looking here In this post: Old jail – FreeBSD 14.3 Host has been updated to 15.0 That old jail is in a jail already updated to 15.0 mkjail-0.0.8 The problem FreshPorts has three mail jails on each node: ingress01 –
Upgrading a jail by replacing it Read More »
I broke my FreeBSD MySQL jail; got it working again by using a snapshot
I was upgrading a host the other day. The mysql02 (that’s the hostname) jail broke. I suspect I did something like upgrading the package while the server was in use. I noticed LibreNMS wasn’t running: *** /var/log/librenms/librenms-service.log *** Feb 10 18:37:30 besser librenms[23957]: MainThread(CRITICAL):ERROR: Could not connect to MySQL database! (2003, “Can’t connect to MySQL server on ‘mysql02.int.unixathome.org’ ([Errno 61] Connection refused)”) Feb 10 18:37:30 besser librenms[23957]: (2003, “Can’t connect to MySQL server
I broke my FreeBSD MySQL jail; got it working again by using a snapshot Read More »
Poudriere symlinks for repos
I have some repos which are specific to certain tasks. Every time I upgrade major version (as I just did from FreeBSD 14.3 to FreeBSD 15.0), I need to remember to go in and add in those symlinks. I forget just about every time. I get errors like this: # pkg upgrade -f Updating local repository catalogue… pkg: Repository local has a wrong packagesite, need to re-create database pkg: Failed to fetch https://fedex.int.unixathome.org/packages/FreeBSD:15:amd64-mysql84//meta.conf:
Poudriere symlinks for repos Read More »
FreeBSD 15.0 – after upgrade, installing my own packages
I build my own FreeBSD packages using poudriere. The chicken-and-egg situation: I can’t build FreeBSD 15.0 packages until I’m on FreeBSD 15.0 – and upgrading to FreeBSD 15 involves a step of upgrading all your packages before the final steps of the upgrade. What do I do? I disable my repos and enable the FreeBSD repos. If you’re using your own repos, you should already know how to do this. In this post:
FreeBSD 15.0 – after upgrade, installing my own packages Read More »
Upgrading a FreeBSD 14.3 host to FreeBSD 15.0
Today, I again mused about FreeBSD 15.0 and pkgbase. It’s freezing outside, and I’m going for an Indian dinner in about 2 hours. Let’s see if I can break r730-01 with my upgrade attempt. In this post: FreeBSD 14.3 (starting point) FreeBSD 15.0 (target) The docs I’m starting with official docs: FreeBSD 15.0-RELEASE Installation Instructions That directs me to Upgrading from Previous Releases of FreeBSD And then the binary update via Upgrading Using
Upgrading a FreeBSD 14.3 host to FreeBSD 15.0 Read More »
Updating my poudriere jail after updating the host to FreeBSD 15.0
This post is related to Upgrading a FreeBSD 14.3 host to FreeBSD 15.0 which I wrote and ran earlier this evening. I’m now back from my Indian dinner and watching the Superbowl (0:15 left in the 2nd half). I was updating r730-01 and got to the point of where I need to updated the packages on the host. I couldn’t do that. I hope my own FreeBSD pkg repo. What I did before
Updating my poudriere jail after updating the host to FreeBSD 15.0 Read More »
Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – 2nd attempt
Yesterday, I ran my first attempt at Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – it went better than I expected. However, I spent more time with MySQL than either the data transfer or the MySQL upgrade itself. Today, that should go faster because I already know the fix and have saved the password updates. Today, I’m going to try again, and hopefully this time will be the last
Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail – 2nd attempt Read More »
ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded
Earlier today, I copied the mysq01 jail to a new mysql02. That’s all part of my migrating from 8.0 to MySQL 8.4 jail adventure. In this post: FreeBSD 14.3 MySQL 8.4.7 I hit a problem. I couldn’t log in. The password procedure has changed. [18:58 mysql02 dvl ~] % mysql -u root -p Enter password: ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded I found and used Fixing mysql_native_password is not loaded in
ERROR 1524 (HY000): Plugin ‘mysql_native_password’ is not loaded Read More »