FreeBSD

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

Leave a Comment / Backups, FreeBSD, mySQL, Open Source / By /

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 privilege(s) for this operation’ when trying to dump tablespaces The search Searching, I found a Kanyakonil post which […]

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

Leave a Comment / FreeBSD, iocage, Jails, Open Source / By /

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

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

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, and failed, with with old zroot_old and new zroot_new mounted. zroot_new became unusable and I started again. This

Renaming and replacing zroot filesystems using mfsBSD Read More »

replacing an existing zroot with a proper zroot

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

I wrote this post late one night while pondering how to solve this problem. I may have solved it with much less effort. I want to copy a zroot from old drives to new drives. The new drives are in a test box of mine. Once the new drives are configured, I will replace the existing mirror with them. Not shown here, I have already installed FreeBSD 12.1 on the new drives. I

replacing an existing zroot with a proper zroot Read More »

ZFS: adding a drive back into the zpool

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

Today I was updating some servers. One of them was rebooted three times. On the third time, one of the drives went missing. This is how I tracked down which drive, and which slot in the server, and fixed it. I’m writing it mostly so I can remember how to flash the light on the drive. There is also an off-by-one issue to avoid. In this post: FreeBSD 12.1 sesutil ZFS Supermicro 846

ZFS: adding a drive back into the zpool Read More »

using zfs rollback for cache clearing

2 Comments / iocage, Jails, ZFS / By /

I’m in the final stages of the FreshPorts packages project. One of the last tasks is clearing the packages cache from disk when new package information is loaded into the database. See also: Clearing the packages cache ZFS when you’re not doing ZFS Several of the configuration items have been learned from putting my poudriere instance into a jail. In this post: FreeBSD 12.1 py37-iocage-1.2_5 If I was to do this cache clearing

using zfs rollback for cache clearing Read More »

Creating a ZFS dataset for testing iocage within a jail

Leave a Comment / FreeBSD, iocage, Jails, Open Source / By /

Be warned, this failed. I’m stalled and I have not completed this. I’m going to do jails within a jail. I already do that with poudriere in a jail but here I want to test an older version of iocage before upgrading my current jail hosts to a newer version. In this post: FreeBSD 12.1 py36-iocage-1.2_3 py36-iocage-1.2_4 This post includes my errors and mistakes. Perhaps you should proceed carefully and read it all

Creating a ZFS dataset for testing iocage within a jail Read More »

What files installed by this package have been modified post-install?

Leave a Comment / FreeBSD, pkg / By /

You’ve seen it. A package gets installed. Some shell scripts are included. They get modified. It happens. But how do you know what has changed? I know there is a tool in pkg for this. I know there is a periodic script which uses it. Let’s go looking. In this post: FreeBSD 12.1 periodic $ cd /usr/local/etc/periodic/ $ find . | grep checksum ./security/460.pkg-checksum There it is! Looking inside, I found pkg check.

What files installed by this package have been modified post-install? Read More »

Migrating FreshPorts from one db server to another

Leave a Comment / FreeBSD, FreshPorts, iocage, Jails, Open Source / By /

FreshPorts runs on a FreeBSD server which hosts multiple jails. Two of these jails run PostgreSQL server. When upgrading from one version of PostgreSQL to another, we run pg_dump in the new jail, and load the backup into that database server. I’m writing this blog post to keep track of this procedure so I do not have to remember it each time. take website offline sudo mv mv offline.conf.disabled offline.conf && \ sudo

Migrating FreshPorts from one db server to another Read More »

pkg: vulnxml parsing error: no element found

Leave a Comment / FreeBSD, Open Source / By /

Today I found this annoying situation on FreeBSD 12.1 in a FreeBSD 12.0 jail (neither of which are directly relevant to the problem at hand). [dan@serpico:~] $ sudo pkg audit -F vulnxml file up-to-date pkg: vulnxml parsing error: no element found pkg: cannot process vulnxml After a bit if thinking, I figured the vulnxml file was corrupt. I guessed it might be in /var/db/pkg: [dan@serpico:/var/db/pkg] $ ls -l total 5226 -rw-r–r– 1 root

pkg: vulnxml parsing error: no element found Read More »

Scroll to Top