FreshPorts News – News and announcements regarding FreshPorts, The Place For Ports (original) (raw)
Migrating a database from one host to another
I’m moving from PostgreSQL 16 to PostgreSQL 18 at home in the basement. I’ve done the dev and dvl databases. Now it’s time for test and stage. Since they are closer (in configuration) to production, I thought I would document how I’m doing that. I’m likely to jump back and forth between test and stage […]
Migrating a database from one host to another Read More »
DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version.
Shortly after moving the jail dvl-ingress01 from Python 3.11 to Python 3.12, I started seeing these messages: The code in question ( link to source) is This should be easy enough to replace, knowing python. First, reproduce the problem With any change to fix a problem, I must first be able to reproduce the problem.
Updating a jail by replacing it – 1.0.1
This post replaces Updating a jail by replacing it 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. The host names may not be consistent within this post. It has been constructed over multiple
Updating a jail by replacing it – 1.0.1 Read More »
Where did all these vuxml entries go?
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 »
Why does this PostgreSQL \copy fail when launched by the daemon?
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 »
The new process_vuxml.pl
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 »
How FreshPorts processes vuxml entries
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 »
Clearing out the distfiles
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 »
Converting from int to bigint and from serial to identity
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 »
Updating to Perl 5.40 on FreeBSD 14.2
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