Mar 082021

One of the many useful features on FreshPorts is: what port[s] install[s] this file? That’s the pkg-plist search option. pkg-plist is a file which “lists all the files installed by the port”. However not all ports have a pkg-plist file because the list is compiled automatically. That is why the configure_plist table was created to […]

Feb 242021

This is a cheat sheet for FreshPorts behind-the-scenes administration. If you want one for users, please start with suggested content. Ingress Actions – Take a commit from the repo and insert it into the database. Will fail if commit is already there. REPO is one of src, ports, doc. Hash is the git commit […]

Feb 102021

By request FreeBSD 14 is being added to the list of build packages. Looking at the main freebsd pkg mirror, we can see FreeBSD:14 is listed. These are the items in question: FreeBSD:14:i386 FreeBSD:14:amd64 FreeBSD:14:aarch64 FreeBSD:14:armv6 FreeBSD:14:armv7 FreeBSD:14:mips FreeBSD:14:mips64 FreeBSD:14:powerpc64 The SQL is: But why type all this, code it. Which produces: [dan@pg02:~/bin] $ sh […]

Feb 062021

EDIT: update, I think I have solved this via help on IRC. See solution. I need help configuring Postfix. I am overwhelmed by the options available and I need to stay on track by working on the rest of the git changes. I have changed references to the FreshPorts domain. I’m using instead. Background […]

Jan 312021

In this post I’ll talk about how the code intially took the easy way out and how recent changes have tightened that up. In short, the code would raise N messages when just a single notification is sufficient. Today the full vuxml database was reloaded into FreshPorts. This affects approximately 3454 ports and the marking […]

Jan 072021

This documents the git specific code which I need to package and deploy. /usr/local/libexec/freshports This is installed by freshports-scripts-git, and I have the directory symlinked to ~/scripts on for convenience. In this directory, we have the following symlinks to other directories: Ignoring lines 2 and 4 which are not relevant, we have this list […]

Jan 012021

This post documents the database upgrade process. Issues encountered during initial attempts There are permission issues on the database. Not everything is owned by the postgres super-user. In fact, many of them are owned by dan – this database is 20+ years old. To easily resolve the ownership issue, I take the database dump (named […]