Tonight I was setting up a new FreshPorts node for development. It took me a while to remember the steps. sudo su -l postgres psql template1 < globals.sql createdb -T template0 -E SQL_ASCII freshports.org psql freshports.org create language plperl; exit; time pg_restore -j 32 -d freshports.org ~dan/dump/freshports.org.dump This takes about 45 minutes.
note to self: restoring a database Read More »
Based on the Add links to GitHub and GitLab mirrors for ports and commits request, the website has some new links arriving soon. Link to GitHub from each commit A similar link to GitLab Use the one you like. Each git web interface has it’s own followers. Also, while there, the commit hash at the
New links to GitLab and GitHub, in addition to the exist cgit.freebsd.org Read More »
The Libreoffice homepages seem wrong. dev and test do not show a homepage for arabic/libreoffice, but stage and prod do. Could this be a commit which corrected something after dev and test were corrected? I think so. I think this commit did that. Let’s check from the command line. I’m doing this in my empty
What’s up with libreoffice homepages Read More »
By “post correction”, I meant “post-correction script”, i.e. after the correction script completed. A recent commit started the process of moving the WWW from pkg-descr to Makefile. These were huge commits, about 27930 ports each. FreshPorts is dumb. It sees a commit and it refreshes all ports touched by that commit. Refreshing every port takes
homepage – post correction Read More »
Today I learned, or at best, relearned, a new make target: root@freshports:/usr/ports/sysutils/anvil # make create-manifest root@freshports:/usr/ports/sysutils/anvil # ls -lt | head total 14 drwxr-xr-x 3 root wheel 3 Sep 10 17:26 work -rw-r–r– 1 root wheel 337 Sep 10 16:06 pkg-descr -rw-r–r– 1 root wheel 182 Sep 10 16:06 distinfo -rw-r–r– 1 root wheel 1050
make create-manifest Read More »
A long-standing bug, perhaps dating back to April 2003, has been fixed. It was an optimization in a trigger: if the values in the trigger have not changed, let’s not run the trigger. Turns out, that was a bad idea. The table The ports_categories table documents the connections between a port and the categories in
missing ports_categories entries Read More »
The July 4th tweet announced “dev, test, and stage .freshports.org are now running Python 3.9”. Three days later, “Is it coincidental that dev, test, and stage are all stuck on commits from July 4?” I took notes as I explored the problem. The first clue was: 2022.07.07 00:12:03 git-delta.sh /usr/local/libexec/freshports/git-to-freshports-xml.py –repo ports –path /var/db/ingress/repos/ports –branch
Update to Python 3.9 broke commit processing Read More »
I need some help with the git processing shell script. Look at line 82 in this script please. See those hardcoded branch names? That’s my problem. Let’s reduce the shell script to a simple proof of concept. % cat ~/tmp/poc.sh #!/bin/sh git for-each-ref –format ‘%(objecttype) %(refname)’ \ | sed -n ‘s/^commit refs\/remotes\///p’ \ | while
Help needed with shell scripting Read More »
One of the known limitations of mkjail is updating of jails within jails. Unless you’re running a FreshPorts node or poudriere while you’re running mkjail, this is unlikely to affect you. For me, to avoid this stoppage, this is my plan: ssh to each jail: csshX [dev,test,stage]-ingress01 disable commit processing: sudo service freshports stop stop
Updating all the jails Read More »
Messages such as: Internal error: I was expecting a short description and found nothing for databases/postgresql indicate a cache entry which predates a change to the cache format. I could clear out the entire cache, but I want to try a targeted approach. In issue 339, some detail is provided. The common thread seems to