From owner-freebsd-vuxml@FreeBSD.ORG Fri Aug 27 14:14:45 2004 Return-Path: Delivered-To: freebsd-vuxml@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 853F616A4CE for ; Fri, 27 Aug 2004 14:14:45 +0000 (GMT) Received: from gw.celabo.org (gw.celabo.org [208.42.49.153]) by mx1.FreeBSD.org (Postfix) with ESMTP id 42CBB43D67 for ; Fri, 27 Aug 2004 14:14:45 +0000 (GMT) (envelope-from nectar@celabo.org) Received: from localhost (localhost [127.0.0.1]) by gw.celabo.org (Postfix) with ESMTP id BA3C854861; Fri, 27 Aug 2004 09:14:44 -0500 (CDT) Received: from gw.celabo.org ([127.0.0.1]) by localhost (hellblazer.celabo.org [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 70609-02; Fri, 27 Aug 2004 09:14:33 -0500 (CDT) Received: from madman.celabo.org (madman.celabo.org [10.0.1.111]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "madman.celabo.org", Issuer "celabo.org CA" (not verified)) by gw.celabo.org (Postfix) with ESMTP id BA6B65485D; Fri, 27 Aug 2004 09:14:33 -0500 (CDT) Received: by madman.celabo.org (Postfix, from userid 1001) id 5223C6D468; Fri, 27 Aug 2004 09:14:24 -0500 (CDT) Date: Fri, 27 Aug 2004 09:14:24 -0500 From: "Jacques A. Vidrine" To: Dan Langille Message-ID: <20040827141424.GF54027@madman.celabo.org> Mail-Followup-To: "Jacques A. Vidrine" , Dan Langille , freebsd-vuxml@freebsd.org References: <20040827051637.T78365@xeon.unixathome.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040827051637.T78365@xeon.unixathome.org> X-Url: http://www.celabo.org/ User-Agent: Mutt/1.5.6i cc: freebsd-vuxml@freebsd.org Subject: Re: FreshPorts - VuXML tables - DDL + data X-BeenThere: freebsd-vuxml@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Documenting security issues in VuXML List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 27 Aug 2004 14:14:45 -0000 On Fri, Aug 27, 2004 at 07:07:07AM -0400, Dan Langille wrote: > Here is the DDL I created this morning. Note that some slight changes > have been made relative to the diagram I posted last night. The diagram > is now out of date. > > The rest of this message contains a sample vuxml entry followed by the DDL > to create the tables and populate it with a single VuXML entry. It also > shows how I mark which packages are affected by a given vid (i.e. how I > populate the commit_log_ports_vuxml table). > > I have created the code to display VuXML information, but at present, the > only data loaded is for http://beta.freshports.org/ftp/tnftpd/ Good work! > NOTE: I'm assuming there can be multiple VuXML entries for a given version > of a package/port. However, there will be only one VuXML icon shown per > row of Commit History. Look at the last commit on the page for a commit > which is affected by two VuXML entries (this is achieved with a fake VuXML > entry). Yep, that's a correct assumption. > freshports.org=# select id, vid, topic from vuxml; > id | vid | topic > ----+--------------------------------------+---------------------------------------------- > 1 | c4b025bb-f05d-11d8-9837-000c41e2cdad | tnftpd -- remotely exploitable vulnerability > (1 row) [...snip...] This is all looking pretty good to me. When the beta is up, I'll be happy to keep an eye on the results for anything unusual. By the way-- a bit off-topic from the DBA stuff-- when processing the FreeBSD VuXML document, you may want to insert a validation step between fetching it and loading it into the database. This will catch problems like bad commits or truncated transfers-- cases in which you probably do not want to use the results for updating the database. See ports/security/vuxml/files/validate.sh for a simple example of using xmllint or onsgmls for validation. Cheers, -- Jacques Vidrine / nectar@celabo.org / jvidrine@verio.net / nectar@freebsd.org