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 /

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 upgrade of MySQL server from 5.7.40 to 8.0.32, my database backups started encountered this error: The search Searching, […]

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 /

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 addresses on the specified NIC: [besser dan ~] % ifconfig igb0 igb0: flags=8963 metric 0 mtu 1500 options=4a500b9

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 /

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 how to run that. I see files in /ssl and they have today’s date. openssl is not installed

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

Replacing postfix with dma

Leave a Comment / ansible, dma, FreeBSD, Mail, Open Source, Postfix / By /

I like Postfix. I’ve been a fan of it for over 20 years. I deployed it on every host for outgoing email. Lately, I’ve taken to using dma (DragonFly Mail Agent) as my preferred mail handler on jails and hosts which don’t need to deal with incoming mail, only outgoing mail. After first getting serious with it about 6 months ago, I decided to remove it from all internal hosts during the consolidation

Replacing postfix with dma Read More »

Home Assistant running natively on FreeBSD via bhyve

6 Comments / bhyve, homeassistant / By /

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 on FreeBSD. I recommend reading his blog post and using updated values, perhaps from my 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 /

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, or a bookmark. However, usually when I talk about a filesystem, it might be dataset. It’s a fine

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

Dan makes another zpool

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

I spent my lunch, and most of my mortgage payment, on 4 x 4TB Blue 4TB SSD 3D NAND (WDS400T2B0A). In this post: FreeBSd 13.1 smartctl output partition creation zpool creation In they go This is them, being inserted into the system: I am concerned by that 150.000MB/s transfers smartctl Let’s look at the smartctl output, just in cases there are returns. What speed can that drive do? I was concerned about that

Dan makes another zpool Read More »

booting without mrsas driver – lots of errors

Leave a Comment / FreeBSD, ZFS / By /

Today I noticed that all the drives in the R730 host had 150MB/s speeds mentioned in the boot messages. They are all SSDs on an SAS bus. They should be at 600.000MB/s. The HBA in question is a AVAGO MegaRAID SAS FreeBSD (aka PERC H730P Mini). It can use either the mfi driver (default) or the mrsas driver (by setting hw.mfi.mrsas_enable=”1″ in /boot/loader.conf This is an SSD in a PCIe slot: This is

booting without mrsas driver – lots of errors Read More »

Wrong recordsize on zfs send | zfs recv filesystems

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

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 is usually OK, except for some specific datasets. For example: * video * backups * distfiles (tarballs) Here

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

Maybe I need another zpool

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

I might need to create another zpool. Or perhaps move a drives/zpool from one host to another. In this post: FreeBSD 13.1 Background I am combining two hosts (slocum and r720-01) into one new host (r730-01). I have been moving jails from those hosts. I have an ansible playbook for creating new entries in /etc/jail.conf.d/. I thought I had the space calculations done right. Now I think I’m wrong.I’m already at 73% on

Maybe I need another zpool Read More »

Scroll to Top