I have no write up of the jails used by FreshPorts. The following originated in an email I sent this morning. FreshPorts runs on a FreeBSD host, hosting four jails. db – the PostgreSQL database server – the source for all content. connections via TCP/IP mx – Postfix takes incoming emails from subversion mailing list […]
The FreshPorts server died on Friday night. I drove up on Sunday morning to retrieve it. I have not yet investigated the breakage. It might be the M/B. It was suggested on IRC that replace instead of repair might be a better approach. The existing X8DTU m/b has some unresolved IPMI vulnerability issues. A newer […]
This is more for my own sanity for the next time I deploy a new FreshPorts host. There is no useful information here for anyone else. Base this upon the existing host: svn cp host_vars/foo.example.org host_vars/NEWHOST svn cp roles/postgresql-server/templates/hosts/foo.example.org roles/postgresql-server/templates/hosts/NEWHOST Edit these files: host_vars/NEWHOST roles/postgresql-server/templates/hosts/NEWHOST/pg_hba.conf.j2 roles/postgresql-server/templates/hosts/NEWHOST/postgresql.conf.j2 Create ssl certs for: NEWHOST.freshports.org NEWHOST.freshsource.org NEWHOST
I’m going to add bookmarks for ports. You can go directly to the dependencies, to the commits, to the configuration items. This will outline the sections before I start coding: #description #dependency #flavors #distinfo #packages #dependencies #config #uses #sites #commits
One of the lesser known FreshPorts features is searching pkg-plist. You want nslookup and dig but you can’t find the package which installs that. The FreshPorts search can find it for you. When a new commit occurs for a given port, FreshPorts extracts and store the pkg-plist information. This allows you to search. How does […]
A few days ago, I did the database work to ignore case when browsing to a cat/port. Tonight, I did the website side. database access First, I altered the database function (in classes/element_record.php) to use the new stored procedure: On line one, I modify the function to pass in an optional parameter which preserves the […]
This idea came to me today from swills: stupid question, would it be possible to make the urls on freshports case insensitive? so that like https://www.freshports.org/x11/libx11 would go to https://www.freshports.org/x11/libX11 After confirming this was for manually typed URLs (as opposed to generated links), I started looking into it. This is what I found. In this […]
In my recent post, my conclusion preferred Rename over Delete & Add. Now I’ve changed my mind. I looked at the code, and the database. Now I prefer Delete & Add. The database In the database, there is no way to represent the Rename action without modifying the structure of the commit_log_elements table: The change_type […]
I spent an evening working through the delete issue with git repos. A Twitter thread was the result. Sergey Kozlov came up with some code changes which changed the XML output. Now I think we have a plan. The commit I’m using for a working example was to editors/nvi2 on 27 Jul 2020 01:58:34 – […]
I want to document some of the not-visible differences between a git commit and a subversion commit when in the database. subversion git id 808224 808303 message_id 202007091812.069IC6QK044004@repo.freebsd.org a1d2d5b40fba4186daf29b2b2e9ff2dd8b7d8039 message_date 2020-07-09 18:12:06+00 2020-07-09 18:12:06+00 message_subject svn commit: r541803 – in head/devel: . py-absl-py [null] date_added 2020-07-09 18:39:53.510006+00 2020-07-09 18:59:49.863092+00 commit_date 2020-07-09 18:12:06+00 2020-07-09 18:12:06+00 committer […]