Author name: Dan Langille

I've been playing with computers since I read an Elementary Electronics magazine way back in the 1970s. I started contributing to open source projects in 1998. After that, I gradually moved from being a software developer to being a systems administrator.

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 »

Lime wash – over field stone walls already covered in latex and/or lead-base paint

Leave a Comment / Painting, Rennovations / By /

I have a plan. To paint the basement walls, without paint, but instead a lime-based wash. photos: https://www.flickr.com/photos/dlangille/albums/72177720331055034/ The basement is 46x15ft with 9ft tall walls. or 2 * (46 + 15) * 9 = 1098 sq ft. https://www.limeworks.us/calculator/calc_limepaint.php# says I need 15 gallons of Ecologic™ LimeWash – $125.00 / 5 gallon. or $375 Lancaster Limeworks makes * https://lancasterlimeworks.com/product/plastrum-limewash/ * https://lancasterlimeworks.com/product/natural-hydraulic-lime-2/ Limeworks makes: * https://www.limeworks.us/product/ecologic-whitewash-platinum/ * https://www.limeworks.us/product/st-astier-naturally-hydraulic-lime/ Let’s see how much NHL 2.0

Lime wash – over field stone walls already covered in latex and/or lead-base paint 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 »

r730-01

Leave a Comment / DELL, hardware, R730 / By /

This post has been replaced by a newer post. This is the Dell R730 host known as r730-01. For reference, the previous post on this server is still available. This host has undergone major storage changes over the past few weeks. This post will reflect those changes This is my primary developer server in my basement. gpart zpool list zpool status zfs list dmesg sesutil show [16:57 r730-01 dvl ~] % sudo sesutil

r730-01 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 »

Scroll to Top