Dan Langille @dvl@bsd.network

Migrated this morning over to MariaDB from MySQL:

https://www.illjustparkhere.com
https://news.freshports.org
https://wp.freebsddiary.org
another
and another.

The old MySQL instance has been shutdown.

Fraud. What you want me to do is fraud.

"I came across your GitHub profile and saw you're based in the US.

I'm James, from the Philippines—over 10 years in software development. Rates here are far below the US market, so I'm focused on building a long-term way to work with US clients. I'm not looking for a one-off; I'm looking for a partner.

How it works as a long-term collaboration:

- I apply to US roles using your professional profile (you're the face of the engagement).
- You attend interviews; I provide full prep, talking points, and technical backup so you're confident and prepared.
- Once a role is secured, I handle the technical delivery. You stay in the loop and in control of the relationship.
- Revenue is shared on a clear, agreed structure—transparent and fair for both of us.

The goal is to build something that scales: two or three solid contracts can turn into steady income and a real partnership. This is a legitimate arrangement—no scam, no risk to you. I'm happy to share references or jump on a short verification call before we commit to anything.

If you're open to exploring a long-term collaboration, reply to this email and we can set up a call."

I have a thing.

[13:29 zuul-mariadb01 dvl ~] % pkg info -x maria
mariadb118-client-11.8.6
mariadb118-server-11.8.6

dan.langille.org is running off that now.

The other blogs will follow shortly.

#FreeBSD #jails

Have any of you run pkgbasify on a #FreeBSD jail?

Please tell me about it. I have about 80 jails eagerly awaiting your reply.

re: https://github.com/FreeBSDFoundation/pkgbasify

MySQL always bring such joy and wonder.

https://forums.freebsd.org/threads/updated-mysql-8-0-to-8-4-cant-get-root-password-properly-set.101871/

Added this to mysqld section of /usr/local/etc/mysql/my.conf:

mysql_native_password=ON

restart, now the websites are online again.

Now to fix the password via https://dan.langille.org/2026/01/24/error-1524-hy000-plugin-mysql_native_password-is-not-loaded/

NOTE TO SELF: implement a copy of my blogs at home. ;)

I hit this problem, which I know I've written about in my blog, which is offline, because of this problem. ;)

[18:43 zuul-mysql dvl ~] % mysql -u root
ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded

[18:42 zuul-mysql dvl ~] % sudo service mysql-server onestart
Starting mysql.

2026-03-01T18:43:40.6NZ mysqld_safe Logging to '/var/db/mysql/zuul-mysql.vpn.unixathome.org.err'.
2026-03-01T18:43:40.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2026-03-01T18:43:40.427350Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2026-03-01T18:43:40.661568Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.8) starting as process 72316
2026-03-01T18:43:40.879895Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-03-01T18:43:47.920066Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-03-01T18:43:47.953917Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80023' to '80300'.
2026-03-01T18:43:49.472722Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80023' to '80300' completed.
2026-03-01T18:44:00.172869Z 4 [System] [MY-013381] [Server] Server upgrade from '80045' to '80408' started.
2026-03-01T18:44:33.117919Z 4 [System] [MY-013381] [Server] Server upgrade from '80045' to '80408' completed.
2026-03-01T18:44:45.309528Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-03-01T18:44:45.309689Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-03-01T18:44:45.351094Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '0.0.0.0' port: 33060, socket: /tmp/mysqlx.sock
2026-03-01T18:44:45.351130Z 0 [System] [MY-010931] [Server] /usr/local/libexec/mysqld: ready for connections. Version: '8.4.8' socket: '/tmp/mysql.sock' port: 3306 Source distribution.

Most of my blogs are offline pending an upgrade from MySQL 8.0 to MySQL 8.4...

here goes...

Let it be known that I updated a #FreeBSD 15.0-RELEASE host to 15.0-RELEASE-p4 via pkg-base.

It happened this week. The 15.0 images on #Azure are base-ified already.

It went smoothly. I was impressed. Then I rebooted. No. Big. Deal.

Thanks.

My idea, which I can't see why it would not work. Does it make sense?

* create an Azure VM, based on #FreeBSD 15.0
* confirm it boots, works, all fine
* snapshot that disk
* create a new disk (clone1)
* swap it out for the first disk
* yes, VM still boots.
* swap disk back to original
* yes VM still boots
* attach clone of drive from another host (clone2)
* bring in the zpool via: zpool import -fN zroot zroot_src
* attach clone1 drive to VM
* add clone1 to zpool: zpool attach zroot_src /dev/clone2p3 /dev/clone2p3
* wait for resliver
* zpool export zroot_new
* shutdown -p now VM
* detatch both clone1 & clone2 from VM
* replace OS boot disk of VM with clone2
* start VM
* nope, does not boot

Nothing used on console , perhaps it saild: IP4 boot PXE

I'll try again.

Is this a reasonable boot/system/zroot drive?

It's #FreeBSD 15.0 on Azure. I'm replacing an existing drive which the freebsd-boot partition is 173K and can't take the new boot code.

# gpart show da2
=> 40 268435376 da2 GPT (128G)
40 1024 1 freebsd-boot (512K)
1064 102400 2 efi (50M)
103464 268331952 3 freebsd-zfs (128G)

My cunning plan: copy the existing drive onto this one, swap, boot, profit.

Thank you for coming to my TED talk.

The drive above was created via:

# gpart create -s gpt da2
da2 created
# gpart add -a 4k -s 512k -t freebsd-boot da2
da2p1 added
# gpart add -a 4k -s 50M -t efi da2
da2p2 added
# gpart add -a 4k -t freebsd-zfs da2

A first attempt at using pg_upgrade for #PostgreSQL on #FreeBSD

A second post will follow soon with a cleaner approach. This was a proof-of-concept.

https://dan.langille.org/2026/02/22/upgrading-postgresql-in-place-on-freebsd/

For my next trick, I'm going to try pg_upgrade (I know all the cool kids already use it) to upgrade my pg02 host (now running #PostgreSQL 16, going to 18).

I'm going to follow http://www.unibia.com/unibianet/freebsd/upgrading-between-major-versions-postgresql-freebsd

I'll create a blog post about it because:

* their cert is dodgy
* I'm not really upgrading in place: I'll git clone, and try that way first
* I usually blog what I do

#FreeBSD