I broke my FreeBSD MySQL jail; got it working again by using a snapshot

Leave a Comment / FreeBSD, mySQL, Open Source, snapshots, ZFS / By /

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

Leave a Comment / FreeBSD, Open Source, pkg / By /

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

Leave a Comment / FreeBSD, Open Source, pkg / By /

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

Leave a Comment / FreeBSD, freebsd-update, Open Source / By /

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

Leave a Comment / FreeBSD, mkjail, Open Source / By /

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

Leave a Comment / FreeBSD, mySQL, Open Source / By /

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

Leave a Comment / FreeBSD, mySQL, Open Source / By /

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 »

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail

Leave a Comment / FreeBSD, mySQL, Open Source / By /

It’s time for me to get off MySQL 8.0. It is not my database of preference, PostgreSQL is, however, I’m moving to MySQL 8.4. In this post: FreeBSD 14.3 MySQL 8.0.44 MySQL 8.4.7 The plan This is my plan, as tooted: zfs snapshot data02/jails/mysql01@mysql80 zfs clone data02/jails/mysql01@mysql80 data02/jails/mysql02 Get that mounted (it mounts automagically) modify the /etc/rc.conf entries of the new jail disable mysql_server so it doesn’t start up add a /etc/jail.conf add

Migrating a MySQL 8.0 jail to a new MySQL 8.4 jail Read More »

Migrating my hosts from Python 3.11 to Python 3.12

Leave a Comment / FreeBSD, General, pkg, poudriere / By /

This post probably won’t help you much. It is mostly just me saving stuff I may want to refer to later. Also, this post covers only the initial hosts. It is the first step. I’ll also post it to my Mastodon toot. In this post: FreeBSD 14.3 poudriere-3.4.4 the FreeBSD ports tree on head as of 2026-01-20 I’m also moving from PostgreSQL 16 client to PostgreSQL 18 client Building Python 3.12 via poudriere

Migrating my hosts from Python 3.11 to Python 3.12 Read More »

bash: line 1: /usr/local/sbin/rrsync: No such file or directory

Leave a Comment / FreeBSD, Open Source / By /

Today I got this message in the logs: The rest of the message told me it was a cronjob run by the rsyncer user on my x8dtu host. Looking at that cronjob I found: [rsyncer@x8dtu ~]$ crontab -l # use /bin/sh to run commands, overriding the default set by cron SHELL=/bin/sh # mail any output to `dan’, no matter whose crontab this is MAILTO=dan@langille.org # take a local copy of the bacula stuff

bash: line 1: /usr/local/sbin/rrsync: No such file or directory Read More »

Scroll to Top