This post talks about vuxml entries I found in the FreshPorts database table which were not in the security/vuxml files. This is another post in the new processing of vuxml series: How FreshPorts processes vuxml entries The new process_vuxml.pl Why does this PostgreSQL \copy fail when launched by the daemon? When the new code was […]
Where did all these vuxml entries go? Read More »
I have a perl script. One portion of it loads data into a PostgreSQL table. It runs as expected from the command line. It fails when launched by another script. I don’t know why. I feel the key fact is the lack of output from the psql command. Nothing. No errors. No success. To be
Why does this PostgreSQL \copy fail when launched by the daemon? Read More »
This post is a work-in-progress. This paragraph will be removed when it is completed. This post is mostly for my own benefit. It will track the redesign of process_vuxml.pl which follows on from How FreshPorts processes vuxml entries. In that previous post, defects were identified and a proposed change put forth. In this post, I’ll
The new process_vuxml.pl Read More »
One of my favorite FreeBSD features is security/vuxml – from it we get these great tools (provided by pkg): * pkg audit (what installed packages contain known vulnerabilities?) * /usr/local/etc/periodic/security/410.pkg-audit – pkg-audit for host and jails * /usr/local/etc/periodic/security/405.pkg-base-audit – same as above, but for base system I use the latter two command within my monitoring
How FreshPorts processes vuxml entries Read More »
It has been 15 months since the last blog post about clearing out distfiles. It was time again today. This is still not scripted, however, that day may come. The steps were: [7:08 pro05 dvl ~] % ssh aws-1-ingress01 [11:09 aws-1-ingress01 dvl ~] % sudo service freshports stop Stopping freshports. Waiting for PIDS: 3073. [11:09
Clearing out the distfiles Read More »
Yesterday, a Facebook memory reminded me of an old issue with FreshPorts: serial values which are about to overflow. This is where you may be thinking? serial? In this day? You might also think, why serial? Why not UUID. Keep thinking about that. Some of the tables we’re talking about were designed 20+ years ago.
Converting from int to bigint and from serial to identity Read More »
Just so you know, there is no conclusion to this story. The cause is still not known. However, I have some ideas to track it down and a follow-up blog post is underway. In short: All src commits gave errors – this was reproducible, and has been fixed When an error occurs, it’s not the
Updating to Perl 5.40 on FreeBSD 14.2 Read More »
This post is a proof-of-concept for creating a new jail instead of upgrading one in-place. I think the process is easier, given there are no packages installed in the jail. Re https://github.com/FreshPorts/freshports/issues/622 Each ingress node in a FreshPorts instance contains a FreeBSD jail. It has some shell scripts, but no installed packages. I think it
Updating a jail by replacing it Read More »
It’s time to clear old distfiles. Based on Moving distfiles to a new filesystem & deleting unused distfiles, I did the following on the aws-1-ingress01 jail. In short: fetch index list DISTFILES used by index remove DISTFILES not used by index The commands: root@freshports:/usr/ports # make fetchindex /usr/bin/env fetch -am -o /usr/ports/INDEX-14.xz https://download.FreeBSD.org/ports/index/INDEX-14.xz /usr/ports/INDEX-14.xz 1864
Time to clear out the distfiles Read More »
This morning I was created with 6 emails, all announcing FAILED: MASTER_PORT, one for each FreshPorts node. Each was sent at 5AM (1000 UTC). Something happened which upset every one of them. I have no idea why. However, I’m writing this down for future reference. This announcement came from one of the many system checks
FAILED: MASTER_PORT Read More »