Jan 192015
Bad portrevision

mandree reported a problem with security/openvpn-auth-ldap. Looking in the database: Looking at the database, the webpage is displaying what is there: Let’s looking at that commit in the database: OK, that’s not the commit which changed the BROKEN flag. Let’s look at that commit: The the date_added fields? These commits were processed out of order. […]

Jan 032015

Today I noticed a bug with the recently added Fetch, Patch, and Extract dependencies. The are correctly displayed on the port page, but not on the dependent port page. The problem If you look at sysutils/libchk, you will see lang/ruby20 listed under Extract dependencies. However, at lang/ruby20, there is no mention of Patch, Fetch, or […]

Nov 082014

I noticed the server load was high. I saw that several instances of search by date where still running. Looking at the query in question: The analysis for this query is available at http://explain.depesz.com/s/uCT I redesigned the query to make use of explicit JOINs: The analysis for that query is at http://explain.depesz.com/s/p3wn. I’ll let readers […]

Oct 052014

New categories in the FreeBSD ports tree do not come along often, but when they do, FreshPorts is ready to pull the details in and get the category name right. def ProcessCategoryNew(): syslog.syslog(syslog.LOG_NOTICE, ‘We have a new category’) urllib.urlretrieve(“http://www.freebsd.org/cgi/cvsweb.cgi/~checkout~/www/en/ports/categories?rev=HEAD;content-type=text%2Fplain”, ‘/usr/websites/freshports.org/dynamic/caching/tmp/categories’); Touch(WWWENPortsCategoriesFlag) Touch(JOBWAITING) No. It’s not. That’s cvs. Won’t work. It will redirect to https://svnweb.freebsd.org/ports/head/en/ports/categories and […]

Oct 052014

Today, kwm mentioned that http://www.freshports.org/Mk/bsd.port.mk was out of date, showing the most recent commit as back in March. My first concern was the system had stopped recording such commits. To check on that, I looked at https://svnweb.freebsd.org/ports/head/Mk/bsd.port.mk and searched my email for the most recent commit message. Extracting the message id from that email, I […]

Jul 092014

FreshPorts processes commits via email. That is, email coming in from the mailing list are received by FreshPorts, parsed, and the resulting data loaded into the database. Today a problem arose. I received these error messages: This List-Id/Message-Id combination is not known to this script. List-Id=’SVN commit messages for the ports tree for head ‘ […]

Jun 182014

A mail error is breaking many things, including the daily reports and sanity test failures. This problem is only on production, not on dev. The error is: could not open Mail::Sender. from=’FreshPorts Sanity Daemon <FreshPorts@example.org>’ to=’kwm@example.org’ subject=’FreshPorts sanity checking’ errorcode=’-24′ errormsg=’IO::Socket::SSL- >start_SSL failed: SSL connect attempt failed with unknown error error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed’ I […]

Jun 172014

Yesterday I tweeted that FreshPorts now directs you to bugs.freebsd.org for a PR. I noticed the URL typo but I was headed to bed. Today, @FreeBSDHelp told me that links involving a category were wrong. Here’s the patch: The first half fixed the case for ports/1234 etc. The second half fixes: PR 1234, 123, and […]