Help them meet their 2009 target: http://www.freebsdfoundation.org/donate/

All FreshPorts servers are now running PostgreSQL 8.4 (they were running 8.3). The upgrade process was rather straight forward. I documented it during the first upgrade (of my development server). I then used the same process for both the beta server and the production server. All went well.

Merry Christmas.

I was annoyed earlier tonight to find that my configuration files for security/phpmyid were overwritten by an upgrade. I started to compose an email to the maintainer only to discover I am the maintainer.

From http://bsdtalk.blogspot.com/

Interview with Dan Langille. We talk about the 2010 BSDCan and PGCon conferences. More information at http://www.bsdcan.org/2010/ and http://www.pgcon.org/2010/. We also talk briefly about FreeBSD 8.

File Info: 16Min, 8MB.

The RESTRICTED value on ports has been incorrectly recorded for some time.

The code fix:

$ cvs di port.pm
Index: port.pm
===================================================================
RCS file: /home/repositories/freshports-1/scripts/port.pm,v
retrieving revision 1.54
diff -r1.54 port.pm
168c168
<               $restricted_alt      = FreshPorts::Utilities::NULLIfEmpty($dbh, $this->{restricted_alt});
—
>               $restricted_alt      = FreshPorts::Utilities::NULLIfEmpty($dbh, $this->{restricted});

This is clearly a case of insufficient testing.

I found this bug when wondering why I could not find a package for www/linux-flashplugin9. nox pointed out that it was RESTRICTED: Redistribution not allowed

Eh? That’s not what FreshPorts was telling me. I went looking, ran a few tests, and found the error.

After making the change, I ran a script which refreshes the RESTRICTED field of every port. I then enountered these warnings:

$ perl
set-restricted-no-cdrom.pl > loading.txt
WARNING:  nonstandard use of \\ in a string literal
LINE 1: update ports set restricted = '', no_cdrom = '"no commercial...
                                                     ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING:  nonstandard use of \\ in a string literal
LINE 1: update ports set restricted = '"License doesn\\''t allow bin...
                                      ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING:  nonstandard use of \\ in a string literal
LINE 1: update ports set restricted = 'Violates djb\\''s license', n...
                                      ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING:  nonstandard use of \\ in a string literal
LINE 1: update ports set restricted = '"djb\\''s packaging license d...
                                      ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING:  nonstandard use of \\ in a string literal
LINE 1: update ports set restricted = '"Unsure of djb\\''s license"'...
                                      ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

Those fix-up scripts are pretty old. They may predate the PostgreSQL E’quoting’ mechanism. I should fix them too.

count before fix: 155
count after fix: 390

FYI, this bug has been around since Fri Jun 6 19:13:41 2008 EDT (11 months, 1 week ago).

Oops.

I have 7 drives for sale: TZ89N-AV SCSI DLT 7000 tape drive.

See my ebay sale.

The new virtual category docs was recently added.

Interestingly enough, FreshPorts has a /docs/ directory, which directly conflics with this. As such, if you were to browe to http://www.freshports.org/docs/, you’d see this:

Index of /docs

      Name                        Last modified      Size  Description
      Parent Directory                                 -
      404-for-virtual-pages.php   25-Oct-2007 12:57  8.2K  Using 404 errors to serve up virtual pages and virtual categories
      AddingNewFieldsToPortsTable 25-Oct-2007 12:57  625
      CachingStrategy             18-Jul-2006 03:54  2.6K
      VuXML.php                   18-Mar-2007 08:41   29K
      commits.xml                 21-May-2003 01:38  2.1K  sample xml file for a commit message from FreeBSD’s cvs-all mailing list
      commits_2.xml               21-May-2003 01:38  1.4K  another samle xml file
      encodings.php               25-Oct-2007 12:57  1.9K
      fp-updates.dtd              18-Oct-2007 18:44  3.8K  The data definition document for the FreshPorts/FreshSource XML
      physical_database.gif       11-Nov-2001 02:39   26K  FreshPorts/FreshSource database diagram
      sample_message.1            04-Jan-2001 17:50  2.7K  A sample email
      sample_message.1.xml        21-May-2003 01:38  1.6K  A sample email
      scripts/                    14-Feb-2007 22:22    -   Sample scripts for FreshPorts

I have fixed this problem for the BETA website, where http://beta.freshports.org/docs/ where you may view the new docs category.

I’ll fix up the production website once I get http://docs.freshports.org/ running. :)

This is news to me (thanks Pav):

$ make -V VALID_CATEGORIES
accessibility afterstep arabic archivers astro audio benchmarks biology cad chinese comms converters databases deskutils devel docs dns editors elisp emulators finance french ftp games geography german gnome gnustep graphics hamradio haskell hebrew hungarian ipv6 irc japanese java kde kld korean lang linux lisp mail math mbone misc multimedia net net-im net-mgmt net-p2p news palm parallel pear perl5 plan9 polish portuguese ports-mgmt print python ruby rubygems russian scheme science security shells spanish sysutils tcl textproc tk ukrainian vietnamese windowmaker www x11 x11-clocks x11-drivers x11-fm x11-fonts x11-servers x11-themes x11-toolkits x11-wm xfce zope

This produces a canonical list of categories. This includes virtual categories as well.

For my own notes: Creating a New Category.

Welcome to unemployment.

What was ironic about today: At lunch, I dropped off a cheque to the car dealer for the car I’d picked up two Fridays ago. At 2pm, I was fired. DOH!

Bummer.

My resume.

Thank you.

I think I’ve fixed a problem with caching of non-ports. I was looking for something to do tonight after I could not sleep. I found a old post about a this issue and figured I could fix it.

The fix is in BETA. I’ll monitor it for a while before pushing it to production.

Full diff here.