mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227)

Leave a Comment / mySQL, Open Source / By / March 14, 2023

This article is a copy/paste/modify of mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. See also Creating read-only PostgreSQL database users for pg_dump and pg_dumpall. I’m linking this because I use both articles on a regular basis. The error After a recent …

mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227) Read More »

Is your jail not getting an IPv6 address soon enough? Blame DAD.

Leave a Comment / FreeBSD, Jails, Open Source / By / March 11, 2023

I have jails with both IP4 and IPv6 addresses. Lately, I’ve been noticing this in /var/log/messages: And this in console messages: Looking in the jail, it had IPv6 addresses. What gives? In this post: FreeBDS 13.1 The jail example I had a jail, similar to this: After the jail started, I could see both IP …

Is your jail not getting an IPv6 address soon enough? Blame DAD. Read More »

Home Assistant Let’s Encrypt Add-on – how to get the newly obtained cert used?

Leave a Comment / homeassistant, Open Source / By / March 1, 2023

I have the Let’s Encrypt Add-on configured for my Home Assistant logon. I got it to renew. I see the cert is stored at /data/letsencrypt/live/hass.example.org/fullchain.pem. But I don’t see directory in my terminal session for Home Assistant. It’s as if I should just give up and use an Nginx proxy instead. At least I know …

Home Assistant Let’s Encrypt Add-on – how to get the newly obtained cert used? Read More »

Home Assistant running natively on FreeBSD via bhyve

3 Comments / bhyve, homeassistant / By / March 1, 2023

This is is mostly written after-the-fact without good notes. Much of what I’m writing is pulled from a tweet and from things I did as I later copied this VM from one host to another. In this post: FreeBSD 13.1 vm-bhyve-1.5. edk2-bhyve-g202202_1 qemu-7.2.0 Much of what I’m doing is based up David Reid’s blog post: …

Home Assistant running natively on FreeBSD via bhyve Read More »

Moving ZFS filesystems/datasets from one ZFS zpool to another

Leave a Comment / FreeBSD, Open Source, syncoid, ZFS / By / February 25, 2023

Now that I’ve filled up data01, I bought some more SSDs and created another zpool. Today, on this snow-is-anticipated Saturday winter morning, I’m going to move some ZFS filesystems/datasets around. Side note: I like the term dataset better than filesystem. man zfs talks about datasets, which can be a file system, a volume, a snapshot, …

Moving ZFS filesystems/datasets from one ZFS zpool to another Read More »

Wrong recordsize on zfs send | zfs recv filesystems

Leave a Comment / FreeBSD, Open Source, syncoid, ZFS / By / February 23, 2023

Over the past few days, I’ve posted a lot about transferring jails from two hosts into one host. One of the steps involves using zfs send | zfs recv to send the files from one host to another. I’m using syncoide for that transfer. A new fileystem’s recordsize defaults to 128K. In my case, that …

Wrong recordsize on zfs send | zfs recv filesystems Read More »

Scroll to Top