As mentioned in the comments of my previous post, some commits have been processed with an incorrect prefix. That is, some pathnames are missing the src/ part of the path. I just went looking… I found interesting stuff. 1233 rows of interesting stuff. For example: SELECT * FROM element_pathname WHERE pathname NOT LIKE ‘/ports/%’ AND […]
Wrong prefix on some pathnames Read More »
Alex wrote in to mention that FreshSource was missing some src commits. In fact, he wrote twice. I’m glad he did. I replied to his first post saying that I was seeing www commits… He pointed out that no src commits were turning up. OH! I checked my local mailing list archive (i.e. a folder
Missing src commits Read More »
Lately, I’ve been thinking and writing about how to list ports that depend upon this port. Today, another special situation arose: doing commits out of order. Case in question: this commit support for databases/php5-sqlite3 to lang/php5-extensions. The lang/php5-extensions commit was at 15:52:14. However, databases/php5-sqlite3 was not created until 15:54:29. I am not sure how to
Doing commits in the correct order Read More »
From time to time, ports/security/vuxml/vuln.xml gets a date field containing an invalid date. FreshPorts stores these entries in a table that looks like this: freshports.org=# \d vuxml Table “public.vuxml” Column | Type | Modifiers —————-+————–+—————————————————- id | integer | not null default nextval(‘vuxml_id_seq’::regclass) vid | text | not null topic | text | not null
Storing dates in date fields Read More »
The most recent project on FreshPorts is what ports are dependent upon *this* port. Tonight, two issues came to mind that I need to resolve: Ports in the DEPENDS that do not exist Refreshing other ports when a port depends upon them At present, FreshPorts refuses to process a commit if a port does not
What if the port doesn’t exist? Read More »
I have no idea what caused the server to freeze up at about 00:10 GMT on 13 Feb 2011. Everything, including ping, stopped working then. Service was restored at about 17:26 GMT. Why so long? I was occupied elsewhere. FreshPorts appears to have caught up with everything on the commit list.
An interesting discussion started earlier this week: upstream dependents. At present, FreshPorts captures and displays the information output from: make -V BUILD_DEPENDS -V RUN_DEPENDS -V LIB_DEPENDS For a given port, this tells up what that port depends upon for building, running, and libraries. The request is for this same information, but in the reverse ordering;
What ports are dependant upon this port? Read More »
A few months ago, Dmitry Marakasov asked for a new feature: a link to diff. The problem I had was figuring out the previous revision. The code always has the current revision. That is stored in the table: freshports.org=# \d commit_log_elements Table “public.commit_log_elements” Column | Type | Modifiers —————+————–+—————————————————————— id | integer | not null
Quite some time ago, FreshPorts and The FreeBSD Diary both moved from clear text passwords to password hashes. As such, you are no longer able to recover your password. You had to email me. This is extra work for everyone. Let us automate this. The first, step, is a table: create table user_password_reset( user_id int
Sending out a URL for password reset Read More »
Today I found a new issue with commit emails. They aren’t perfect. Neither is the code. The problem arose with this email: philip 2010-07-31 14:57:38 UTC FreeBSD src repository Modified files: . access mentors Log: SVN rev 210685 on 2010-07-31 14:57:38Z by philip Take cbzimmer’s commit bit into safekeeping per his request. Approved by: core
Commit email problems Read More »