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 […]
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 »
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 »
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
replacing an existing zroot with a proper zroot Read More »
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
ZFS: adding a drive back into the zpool Read More »
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
using zfs rollback for cache clearing Read More »
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
Creating a ZFS dataset for testing iocage within a jail Read More »
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 $
What files installed by this package have been modified post-install? Read More »
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
Migrating FreshPorts from one db server to another Read More »
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
pkg: vulnxml parsing error: no element found Read More »