FreeBSD

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 »

Copying everything off a zpool, destroying it, creating a new one, and copying everything back

1 Comment / FreeBSD, Open Source, syncoid, ZFS / By /

I have a problem with a zpool. To be clear, this really isn’t a problem. I’m not aware of any I/O throttling etc. It is just something I would like to change. zpzpoo% [18:26 r720-02 dvl ~] % zpool status data01 pool: data01 state: ONLINE status: One or more devices are configured to use a non-native block size. Expect reduced performance. action: Replace affected devices with devices that support the configured block size,

Copying everything off a zpool, destroying it, creating a new one, and copying everything back Read More »

data04: moving data01/bacula/volumes over

Leave a Comment / FreeBSD, ZFS / By /

After finally creating data04, it’s time to relocate some data. In this post: FreeBSD 14.3 The source The current zpool which is straining is data01: I plan to move data01/bacula/volumes over first, then data01/bacula/working. Let’s modify the source for better results on the move. What do we have now? [20:22 r730-01 dvl /jails/bacula-sd-03/usr/local/bacula/volumes] % zfs get compression,recordsize data01/bacula/volumes NAME PROPERTY VALUE SOURCE data01/bacula/volumes compression on inherited from data01 data01/bacula/volumes recordsize 1M local Let’s

data04: moving data01/bacula/volumes over Read More »

creating a raidz2 from 8x 4TB devices – here. we. go.

Leave a Comment / FreeBSD, ZFS / By /

It’s time. Time to create the 8x 4T raidz2 zpool. These are the devices: disks=”nda0 nda1 nda2 nda3 nda5 nda8 da12 da13″ In this post: FreeBSD 14.3 Check for existing partitions Using the list above: [18:15 r730-01 dvl ~] % gpart show | grep -E “nda0|nda1|nda2|nda3|nda5|nda8|da12|da13” => 40 7814037088 nda5 GPT (3.6T) => 34 7814037101 nda8 GPT (3.6T) Note I could not do this command because it fails at the first error: [18:05

creating a raidz2 from 8x 4TB devices – here. we. go. Read More »

Making room to creating a raidz2 from 8x 4TB devices – here. we. go.

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

It’s time. Time to create the 8x 4T raidz2 zpool. That doesn’t happen in this post, hopefully the next one. But first, I have to move some stuff around, to free up all the 4TB devices. The host has 4 devices (NVMe) and I moved in two more, 4TB SSDs. From /var/log/messages: Dec 9 00:24:29 r730-01 kernel: mrsas0: System PD created target ID: 0xc Dec 9 00:24:29 r730-01 kernel: mrsas0: System PD created

Making room to creating a raidz2 from 8x 4TB devices – here. we. go. Read More »

How to recover when booting to multiple zroots?

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

On Nov 28, I rebooted r730-01 after an update, and it didn’t come back. At all. I had inserted 2x 4TB SSDS a few days earlier. It seems they contained remnants of a zroot. The host was trying to boot from them. I couldn’t get the host to boot from the real zroot. It frustrated me. I gave up and went to sleep later. The next morning, I moved those two drives into

How to recover when booting to multiple zroots? Read More »

Scroll to Top