starting service would freeze the terminal session

I noticed a problem with a newly-created freshports daemon script: starting it would sometime freeze the terminal session. The rc.d script The rc.d script was fairly straight forward: Nothing odd there, right? This first happened a week or so ago. I moved on it and decided to look into later. But wait, there’s more This

starting service would freeze the terminal session Read More »

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.30 to 5.7.31, my database backups started encountered this error: mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Read More »

Creating a new iocage jail

Every time I go to create a new iocage jail, I cannot remember out the command. Here we go, for next time: iocage create -n devgit-ingress01 –thickjail host_hostname=devgit-ingress01.int.unixathome.org ip4_addr=10.0.0.141 –release 12.1-RELEASE iocage create -n devgit-nginx01 –thickjail host_hostname=devgit-nginx01.int.unixathome.org ip4_addr=10.0.0.147 –release 12.1-RELEASE

Creating a new iocage jail Read More »

Renaming and replacing zroot filesystems using mfsBSD

I am replacing one zroot with another because of missing binaries and suspect layout. The existing zroot is an old system predating current zroot layouts. This work is being performed on a test system (that link is not safe for young eyes). In this post: FreeBSD 12.1 mfsBSD 12.1 The failed attempt I tried once,

Renaming and replacing zroot filesystems using mfsBSD Read More »

Burning a disk image to a thumbdrive on OSX

Every time I go to burn a new image to a thumbdrive I have to remember how. This post aims to fix that so I can just look it up. Case in point: mfsBSD I have downloaded mfsbsd-12.1-RELEASE-amd64.img from https://mfsbsd.vx.sk/files/images/12/amd64/ From the same URL I’ve looked in mfsbsd-12.1-RELEASE-amd64.img.sums.txt and grabbed the md5 hash. I verified

Burning a disk image to a thumbdrive on OSX Read More »

WARNING: failed precmd routine for mysql

Last night the MySQL server instance in my dbclone jail stopped working. This is the jail into which copies of all my databases eventually go for test restores and backups. This morning I tried started it: [dan@dbclone:~] $ sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql My initial search suggested removing /var/db/mysql

WARNING: failed precmd routine for mysql Read More »

Scroll to Top