From owner-freebsd-pkg@freebsd.org Sun Sep 6 10:47:57 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4A3F79CB16D for ; Sun, 6 Sep 2015 10:47:57 +0000 (UTC) (envelope-from portscout@FreeBSD.org) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 3375F11EE for ; Sun, 6 Sep 2015 10:47:57 +0000 (UTC) (envelope-from portscout@FreeBSD.org) Received: by mailman.ysv.freebsd.org (Postfix) id 3351E9CB16C; Sun, 6 Sep 2015 10:47:57 +0000 (UTC) Delivered-To: pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 32EDF9CB16B for ; Sun, 6 Sep 2015 10:47:57 +0000 (UTC) (envelope-from portscout@FreeBSD.org) Received: from portscout.freebsd.org (portscout.freebsd.org [IPv6:2001:1900:2254:206a::50:6]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 238DD11ED for ; Sun, 6 Sep 2015 10:47:57 +0000 (UTC) (envelope-from portscout@FreeBSD.org) Received: from portscout.freebsd.org ([127.0.1.123]) by portscout.freebsd.org (8.15.2/8.15.2) with ESMTP id t86Alvhv017067 for ; Sun, 6 Sep 2015 10:47:57 GMT (envelope-from portscout@FreeBSD.org) Received: (from portscout@localhost) by portscout.freebsd.org (8.15.2/8.15.2/Submit) id t86Alvn1017066; Sun, 6 Sep 2015 10:47:57 GMT (envelope-from portscout@FreeBSD.org) Message-Id: <201509061047.t86Alvn1017066@portscout.freebsd.org> X-Authentication-Warning: portscout.freebsd.org: portscout set sender to portscout@FreeBSD.org using -f Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain MIME-Version: 1.0 Date: Sun, 6 Sep 2015 10:47:56 +0000 From: portscout@FreeBSD.org To: pkg@freebsd.org Subject: FreeBSD ports you maintain which are out of date X-Mailer: portscout/0.8.1 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 06 Sep 2015 10:47:57 -0000 Dear port maintainer, The portscout new distfile checker has detected that one or more of your ports appears to be out of date. Please take the opportunity to check each of the ports listed below, and if possible and appropriate, submit/commit an update. If any ports have already been updated, you can safely ignore the entry. You will not be e-mailed again for any of the port/version combinations below. Full details can be found at the following URL: http://portscout.freebsd.org/pkg@freebsd.org.html Port | Current version | New version ------------------------------------------------+-----------------+------------ ports-mgmt/pkg | 1.5.6 | 1.5.99.12 ------------------------------------------------+-----------------+------------ If any of the above results are invalid, please check the following page for details on how to improve portscout's detection and selection of distfiles on a per-port basis: http://portscout.freebsd.org/info/portscout-portconfig.txt Thanks. From owner-freebsd-pkg@freebsd.org Sun Sep 6 21:00:27 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4287C9CB699 for ; Sun, 6 Sep 2015 21:00:27 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 2E907ECB for ; Sun, 6 Sep 2015 21:00:27 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: by mailman.ysv.freebsd.org (Postfix) id 2E2609CB693; Sun, 6 Sep 2015 21:00:27 +0000 (UTC) Delivered-To: pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 2DC479CB692 for ; Sun, 6 Sep 2015 21:00:27 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 0839AEC2 for ; Sun, 6 Sep 2015 21:00:27 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id t86L0QDb098271 for ; Sun, 6 Sep 2015 21:00:26 GMT (envelope-from bugzilla-noreply@FreeBSD.org) Message-Id: <201509062100.t86L0QDb098271@kenobi.freebsd.org> From: bugzilla-noreply@FreeBSD.org To: pkg@FreeBSD.org Subject: Problem reports for pkg@FreeBSD.org that need special attention X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 Date: Sun, 06 Sep 2015 21:00:26 +0000 Content-Type: text/plain; charset="UTF-8" X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 06 Sep 2015 21:00:27 -0000 To view an individual PR, use: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=(Bug Id). The following is a listing of current problems submitted by FreeBSD users, which need special attention. These represent problem reports covering all versions including experimental development code and obsolete releases. Status | Bug Id | Description ------------+-----------+--------------------------------------------------- New | 193995 | [PATCH] ports-mgmt/pkg: floating point exception 1 problems total for which you should take action. From owner-freebsd-pkg@freebsd.org Mon Sep 7 08:07:29 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 04C5F9CCE8F for ; Mon, 7 Sep 2015 08:07:29 +0000 (UTC) (envelope-from marko@markoturk.info) Received: from vps.markoturk.info (vps.markoturk.info [95.154.208.14]) by mx1.freebsd.org (Postfix) with ESMTP id CA34B616 for ; Mon, 7 Sep 2015 08:07:28 +0000 (UTC) (envelope-from marko@markoturk.info) Received: by vps.markoturk.info (Postfix, from userid 1001) id EA16427390; Mon, 7 Sep 2015 09:59:15 +0200 (CEST) Date: Mon, 7 Sep 2015 09:59:15 +0200 From: Marko Turk To: freebsd-pkg@freebsd.org Subject: Pkg audit package not identified as vulnerable Message-ID: <20150907075915.GA1702@vps.markoturk.info> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="RnlQjJ0d97Da+TV1" Content-Disposition: inline User-Agent: Mutt/1.5.23 (2014-03-12) X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Sep 2015 08:07:29 -0000 --RnlQjJ0d97Da+TV1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi, I have both gstreamer1-libav and ffmpeg installed. Both are vulnerable (according to vuxml.freebsd.org) but pkg audit prints one package two times. Additionally, pkg audit -v prints only one package as vulnerable. Is this intended behavior? BR, Marko root@shkatula:~ # pkg audit gstreamer1-libav-1.4.5 is vulnerable: ffmpeg -- use after free CVE: CVE-2015-3417 WWW: https://vuxml.FreeBSD.org/freebsd/da434a78-e342-4d9a-87e2-7497e5f117ba.html gstreamer1-libav-1.4.5 is vulnerable: ffmpeg -- out-of-bounds array access CVE: CVE-2015-3395 WWW: https://vuxml.FreeBSD.org/freebsd/80c66af0-d1c5-449e-bd31-63b12525ff88.html 1 problem(s) in the installed packages found. root@shkatula:~ # pkg audit -q gstreamer1-libav-1.4.5 root@shkatula:~ # --RnlQjJ0d97Da+TV1 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJV7UPTAAoJEDcRe7P/w1sjnrMQAIuo3cWuZfS9aLtph2ZdBU+7 Bs11r+FWAwNSYnzr74E7ckAZx0jRrl7r3gjwekKsRRhIiZB3eVk0wT4toj2GY+CK VgdHQW0YpMW2Vqk19PbCysuwPVaH16t+HUrM6jOXXszvM/XR9xwA07+wPvqhmzMc pgh88QGgEXk5XM79vn6hZ1Bg+WfAwnYhRH2zAKmbGdYzh7Ot8tjEfhQoyRaYseMK 8l7SjiPAiYnLBzSan4lUTVcy5dKw57L0jJ987F9Bi/yXicMzvK+0v8l1LXJKoCGW Ve55JMwm44LZS9JRGlAKr6lRMCqY5oJ3UmJ32X0jpFX3DF/GmahTMoH+RTJ4pFmE jOgGlD3qRlwC5Y92BXnUUZLtcskJnmYnWymrf1qeCy6CrrrUwqrdf7e1TSjaIBO6 /T0v/uyeAGOrUhOt9j260U3xP/F5BjROZuL/TS7JW4jhACeKehDVx/lonJf71ye1 4mBHyWlJPZt9itMLszOwZ1dSbC1/uiGf3OlQLiBYJcXiswHIw/wBb9WMSMzpGojb bG54Mgg93BTJMfcRO8MgvgPMOR1kv44aURbbZmAb28gsbuNjOFeZ/D8CNb/F3RO5 JYFOd7/qUTdxb6ZYhSbnraMXO6HVXTh3kXp071xD9M/T+m7aFT/xKiZ43gQGsfT+ BXQDU4kXk9wC3ytYpicr =+6Nu -----END PGP SIGNATURE----- --RnlQjJ0d97Da+TV1-- From owner-freebsd-pkg@freebsd.org Mon Sep 7 09:15:41 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 5CB799CB67F for ; Mon, 7 Sep 2015 09:15:41 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: from mail-wi0-x236.google.com (mail-wi0-x236.google.com [IPv6:2a00:1450:400c:c05::236]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id E7AB01D89 for ; Mon, 7 Sep 2015 09:15:40 +0000 (UTC) (envelope-from baptiste.daroussin@gmail.com) Received: by wiclk2 with SMTP id lk2so76851773wic.1 for ; Mon, 07 Sep 2015 02:15:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; bh=0gFmP3K/hB6zjRcF0RbZTwYpTPdQYXwmcAKoLIgJJ3s=; b=n+XLtZXBc/ao2qlEBXcm4Fi5zAzBBK0dXTvj3DBh8KDdU6erx6yUGwCzZ3v/uNM9Yt 6Emt9rmKRRhN8hdfAVhED/Q3gmU/8lcS5SsYCUNlk/CPWlRpZCEHDOdkLA/XR5g2RUrL Iz49jHb+vY3nrsrRrjvawcPP+hGTs6kmFNJotIAwyjVGJYxNJJT+j933VtJoV3tzua1H bRgfbIo1ER6EbeduaM1ymM98AYH5TloHd1HsOqyk0MCShK2U0veWLqwb601k+8BWWkfQ /uzLOaLf3HlSNpYWwjP5cYVKMtXiBSWcPaTmJEkgdtMwEF8xghF0U7JJDRStaKNt2YNg hGbA== X-Received: by 10.180.83.137 with SMTP id q9mr33861299wiy.68.1441617339283; Mon, 07 Sep 2015 02:15:39 -0700 (PDT) Received: from ivaldir.etoilebsd.net ([2001:41d0:8:db4c::1]) by smtp.gmail.com with ESMTPSA id p5sm19280577wiy.17.2015.09.07.02.15.38 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 07 Sep 2015 02:15:38 -0700 (PDT) Sender: Baptiste Daroussin Date: Mon, 7 Sep 2015 11:15:36 +0200 From: Baptiste Daroussin To: Marko Turk Cc: freebsd-pkg@freebsd.org Subject: Re: Pkg audit package not identified as vulnerable Message-ID: <20150907091536.GA38185@ivaldir.etoilebsd.net> References: <20150907075915.GA1702@vps.markoturk.info> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="qDbXVdCdHGoSgWSk" Content-Disposition: inline In-Reply-To: <20150907075915.GA1702@vps.markoturk.info> User-Agent: Mutt/1.5.23 (2014-03-12) X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Sep 2015 09:15:41 -0000 --qDbXVdCdHGoSgWSk Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Sep 07, 2015 at 09:59:15AM +0200, Marko Turk wrote: > Hi, >=20 > I have both gstreamer1-libav and ffmpeg installed. Both are vulnerable > (according to vuxml.freebsd.org) but pkg audit prints one package > two times. Additionally, pkg audit -v prints only one package as > vulnerable. >=20 > Is this intended behavior? >=20 > BR, > Marko >=20 > root@shkatula:~ # pkg audit > gstreamer1-libav-1.4.5 is vulnerable: > ffmpeg -- use after free > CVE: CVE-2015-3417 > WWW: https://vuxml.FreeBSD.org/freebsd/da434a78-e342-4d9a-87e2-7497e5f117= ba.html >=20 > gstreamer1-libav-1.4.5 is vulnerable: > ffmpeg -- out-of-bounds array access > CVE: CVE-2015-3395 > WWW: https://vuxml.FreeBSD.org/freebsd/80c66af0-d1c5-449e-bd31-63b12525ff= 88.html >=20 > 1 problem(s) in the installed packages found. >=20 > root@shkatula:~ # pkg audit -q > gstreamer1-libav-1.4.5 > root@shkatula:~ # Which version of ffmpeg do you have installed? Best regards, Bapt --qDbXVdCdHGoSgWSk Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlXtVbgACgkQ8kTtMUmk6Ewu0gCgutDNfvNP74c+VeBmM5RiP6t0 QEMAoLRhmWxdujEpRfjJQevo4h5qggHs =36tv -----END PGP SIGNATURE----- --qDbXVdCdHGoSgWSk-- From owner-freebsd-pkg@freebsd.org Mon Sep 7 09:23:24 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6AC0D9CBBF9 for ; Mon, 7 Sep 2015 09:23:24 +0000 (UTC) (envelope-from marko@markoturk.info) Received: from vps.markoturk.info (vps.markoturk.info [95.154.208.14]) by mx1.freebsd.org (Postfix) with ESMTP id 5844D109D; Mon, 7 Sep 2015 09:23:23 +0000 (UTC) (envelope-from marko@markoturk.info) Received: by vps.markoturk.info (Postfix, from userid 1001) id C517427393; Mon, 7 Sep 2015 11:23:21 +0200 (CEST) Date: Mon, 7 Sep 2015 11:23:21 +0200 From: Marko Turk To: Baptiste Daroussin Cc: freebsd-pkg@freebsd.org Subject: Re: Pkg audit package not identified as vulnerable Message-ID: <20150907092321.GB1702@vps.markoturk.info> References: <20150907075915.GA1702@vps.markoturk.info> <20150907091536.GA38185@ivaldir.etoilebsd.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="mojUlQ0s9EVzWg2t" Content-Disposition: inline In-Reply-To: <20150907091536.GA38185@ivaldir.etoilebsd.net> User-Agent: Mutt/1.5.23 (2014-03-12) X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Sep 2015 09:23:24 -0000 --mojUlQ0s9EVzWg2t Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Sep 07, 2015 at 11:15:36AM +0200, Baptiste Daroussin wrote: > On Mon, Sep 07, 2015 at 09:59:15AM +0200, Marko Turk wrote: > Which version of ffmpeg do you have installed? >=20 > Best regards, > Bapt Yes, my version is newer and it's not vulnerable. Sorry for this, I wasn't looking carefully enough. BR, Marko --mojUlQ0s9EVzWg2t Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIbBAEBCAAGBQJV7VeJAAoJEDcRe7P/w1sjPtoP+PE+N/r/5MVZ6RCWLEi+ZXg5 KTSrzNOUBN6QG3MkCs7+RaR3uQ8jKeudBaKzImT/PFyETgsZpMAnBAxRfTRfSgoo I5lOBr1zO767h/Kh4zKbqWlReOSOxnO5wsiKedmfLS3nOtOzzyJZk4Y1cMUO8uLP LREHt7ksrINOPX2hSYFN986aYR/vTf8luU8ElAT6kIY/T2QvKYvcww2cIl4ENqUK egkb9gBKaqe8/hUXnTvDlhdWbuHmDG3BlXF9xK9lIMhIqWoiD4+H3t6UNB+UMq5m DOYHReqoe/c6PZwIGvm2AbvqDYdZULtgY8fShzC6XhOwt5Uzj9k8SrULHOC/ahFe EBuWiV66d93nXJdXutsJhXwPcipQgBibTWQI3YRC8ooNcpe0+EGyG/aO64lYcnTW 4bH7Qns7LxdEZwlPrYtSVj7awVmPf8UDSbHd6Xks+M1FJlV9OtidEJMOOnQpkeUb n5JAOlGXByisGCrIOA9Z/yYGM5DpLax8/ciMPXO0CTf42vvVD8vutp2LxW9ITxsr 8hzEpVoNOtq5DVlX3G8mjl87Jhv7wVBH1QiaRj7BxerdFL2AGU6dSUB/rfa35yWe Gjizr1ML0C5bhfhXCk6E9nnrt8nOnpDPWvFAFbw/kq1/jcftW4laDKcbeqa3GwPT q5MeihKrypRNCsVEFPI= =03XD -----END PGP SIGNATURE----- --mojUlQ0s9EVzWg2t-- From owner-freebsd-pkg@freebsd.org Tue Sep 8 21:52:58 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id EE4F29CD358 for ; Tue, 8 Sep 2015 21:52:58 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: from mail-io0-x233.google.com (mail-io0-x233.google.com [IPv6:2607:f8b0:4001:c06::233]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id BF9CB10E1 for ; Tue, 8 Sep 2015 21:52:58 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: by iofh134 with SMTP id h134so936648iof.0 for ; Tue, 08 Sep 2015 14:52:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=YLZv5OU1bs6Oml7lbP64rttO3PsH3u/rKaceC4DOLto=; b=0mz5oNNE5Z+1EuG/Z3vKBS5snnItAmhASibplsteB8VTfR6z0MbkxFPY0zU6ExET6e olsFzWgNy+Wpt4n5KBW+QmTaXOlQyrgr1b3hASM/TqgbQKxbvOePq7TVT55Mtf6XB7Lk UW0OWcBZ0HOxB7dFekMgWkXmEcoByxUG5w2df8yP/bK55oPdXbBC2wjnbq0asBKwY/bD zhfZHLWTTE/W2GfFuFkV/Craa1IjEguKEYA8tC+rQXXOGpBIPnjHYVtjhwfD7vO3SQB7 Jknu1b8NQ94nFjj7HD7JlrzJ9l669FvC9Q9r0nyIZyKgFd6QV3B69mFG0VyCbiDr+bMh lqPA== MIME-Version: 1.0 X-Received: by 10.107.169.102 with SMTP id s99mr6439445ioe.190.1441749178103; Tue, 08 Sep 2015 14:52:58 -0700 (PDT) Received: by 10.79.14.10 with HTTP; Tue, 8 Sep 2015 14:52:58 -0700 (PDT) Date: Tue, 8 Sep 2015 14:52:58 -0700 Message-ID: Subject: pkg list installed by date From: jungle Boogie To: freebsd-pkg@freebsd.org Content-Type: text/plain; charset=UTF-8 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Sep 2015 21:52:59 -0000 Hello, Requesting help with simple query. I want to list installed packages by their install/update timestamp. % pkg query %n-%t and % pkg query %t-%n List packages installed alphabetically. Also is the %t UTC or local time? Thanks, jb -- ------- inum: 883510009027723 sip: jungleboogie@sip2sip.info xmpp: jungle-boogie@jit.si From owner-freebsd-pkg@freebsd.org Tue Sep 8 23:50:45 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0218B9CD0BC for ; Tue, 8 Sep 2015 23:50:45 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id DB9AA1C00 for ; Tue, 8 Sep 2015 23:50:44 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.ysv.freebsd.org (Postfix) id DA73A9CD0B7; Tue, 8 Sep 2015 23:50:44 +0000 (UTC) Delivered-To: pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id DA0B79CD0B6 for ; Tue, 8 Sep 2015 23:50:44 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id C69BA1BFF for ; Tue, 8 Sep 2015 23:50:44 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id t88Noi7r005196 for ; Tue, 8 Sep 2015 23:50:44 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 176925] ports-mgmt/pkg: pkg version fails if cwd no longer exists Date: Tue, 08 Sep 2015 23:50:44 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: linimon@FreeBSD.org X-Bugzilla-Status: In Progress X-Bugzilla-Priority: Normal X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: assigned_to Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Sep 2015 23:50:45 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=176925 Mark Linimon changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|bdrewery@FreeBSD.org |pkg@FreeBSD.org --- Comment #5 from Mark Linimon --- Reassign to group alias by request. -- You are receiving this mail because: You are the assignee for the bug. From owner-freebsd-pkg@freebsd.org Wed Sep 9 07:05:12 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 13511A00404 for ; Wed, 9 Sep 2015 07:05:12 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 93C9A1171 for ; Wed, 9 Sep 2015 07:05:11 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from liminal.local (liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id t89752XO082855 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Wed, 9 Sep 2015 08:05:02 +0100 (BST) (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.10.3 smtp.infracaninophile.co.uk t89752XO082855 Authentication-Results: smtp.infracaninophile.co.uk/t89752XO082855; dkim=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6] claimed to be liminal.local Subject: Re: pkg list installed by date To: freebsd-pkg@freebsd.org References: From: Matthew Seaman Message-ID: <55EFDA12.2060702@FreeBSD.org> Date: Wed, 9 Sep 2015 08:04:50 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV" X-Virus-Scanned: clamav-milter 0.98.7 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.7 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Sep 2015 07:05:12 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 08/09/2015 22:52, jungle Boogie wrote: > Hello, >=20 > Requesting help with simple query. >=20 > I want to list installed packages by their install/update timestamp. >=20 > % pkg query %n-%t > and > % pkg query %t-%n >=20 > List packages installed alphabetically. pkg-query(8) doesn't provide any sorting capabilities. However, it is fairly trivial to pipe the output into sort(1) > Also is the %t UTC or local time? Neither. It's the unix time -- seconds since the epoch, where the epoch date is: % env TZ=3DUTC date -j -f %s 0 Thu Jan 1 00:00:00 UTC 1970 or the same time in whatever timezone you inhabit. Cheers, Matthew --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2 iQJ8BAEBCgBmBQJV79oaXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT/nIP/Aqxtl8mctqemYftp+7CtI7Q hetuO+7MRjyo/fYd8K2atm2OSNKd19dME+1b84256JFzRivVw4M8B6UfkB1zdvdU 4zqMOJuUZKC3Q5qQ7wIToeGLdg9U32LteByunOlDYtiOqd6qdsTPTadSwv+zkjx1 j+mDQIaW9F07kMXdFLwpeWphL3Tp6qtE+6n8PbC5DQETm3v24vgVlygg4rdXpvO6 dhhPNLH0gBGUnRdHL3AlSExu0cjbqeO5wCIF9wsJB+fK+lHbvvtYzy+kNVU2gqXZ B25WCPABYlU3Q+9p9T0E6xbBCllAouIICzKRpzVr35rwnR49HLDENXQqyKIlocMf ORIYI/CDFo8rGkxKtHW8CZ3E0ey9xSkt6Z80nmVAJV/TvZaRmLSOlBhGDwjQlMRm +8n3TksXFblABBmKVqqZbxkdTJakArawAA0opATjeYScIyGR+O3QMp5BuvPVmJqN WpfoXJJ9Z+NcEj0O/7XZN5G27uU21MJz1TnWA8mb8uqW9Oc9X+z9MjBD9Yc7+RCm cMJ5b4N/xnNqtBh2IXGzRGk8lw3aJLu2nOvLeQoMIfqLS7jn5je0amzdiob9Cv05 NnslgOR3TmP4lHclVdiTp93D8LEVV0TzGGW7EKMJbkrFR+Ykpa4kufnElVZE4+Aj bH8mPUbELizqBV+8xy2t =cbug -----END PGP SIGNATURE----- --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV-- From owner-freebsd-pkg@freebsd.org Wed Sep 9 18:05:10 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 8E4AFA0167D for ; Wed, 9 Sep 2015 18:05:10 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: from mail-io0-x22d.google.com (mail-io0-x22d.google.com [IPv6:2607:f8b0:4001:c06::22d]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 5EB391D88 for ; Wed, 9 Sep 2015 18:05:10 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: by iofb144 with SMTP id b144so32003504iof.1 for ; Wed, 09 Sep 2015 11:05:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:cc:content-type; bh=obi36IMqTIR/CRzeXX2K0hgfrR1KZf+Ex/moL0oJ49I=; b=oh/u1Jw/a86r61IpkyJ2P5tubSGXUtwej7Blj7ESvO9EdAInU+XTdeKuchJ5/XUm1h lhMh+vNSSSbPyzKvpDFF3WsQ9qfK5Lx3C6oO6fozO/+kb3QtQmCLcLKp2El4mnewiGfO rMYYDYCY2VZhNyGbCIceY29z+feHtB+CP2PVueFHadouEhiZFABVzy+8zCttLTf3v+zV dgMIfGl/vd9F7qeKAJNnWsr5Wrp1QmaWoFkvrSFK7AkAwFSM1RPwd03MeAiOT5iSZziJ 8m+9Pcd6+uuJ1yYQWCuQNF4oSmm21RD3qc5o/blh46f+TfYoUz2JtNd6xVvvzyzgcZSF a35g== MIME-Version: 1.0 X-Received: by 10.107.131.16 with SMTP id f16mr52808383iod.100.1441821909626; Wed, 09 Sep 2015 11:05:09 -0700 (PDT) Received: by 10.79.14.10 with HTTP; Wed, 9 Sep 2015 11:05:09 -0700 (PDT) Date: Wed, 9 Sep 2015 11:05:09 -0700 Message-ID: Subject: Re: pkg list installed by date From: jungle Boogie To: freebsd-pkg@freebsd.org Cc: jungle Boogie Content-Type: text/plain; charset=UTF-8 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Sep 2015 18:05:10 -0000 Hi Matthew, >> I want to list installed packages by their install/update timestamp. > >> % pkg query %n-%t >> and >> % pkg query %t-%n >> >> List packages installed alphabetically. > pkg-query(8) doesn't provide any sorting capabilities. However, it is > fairly trivial to pipe the output into sort(1) But pkg uses a sqlite3 database. Can't I alter the query? It somehow has a query to sort alphabetically. >> Also is the %t UTC or local time? > Neither. It's the unix time -- seconds since the epoch, where the epoch > date is: > % env TZ=UTC date -j -f %s 0 > Thu Jan 1 00:00:00 UTC 1970 > or the same time in whatever timezone you inhabit. Yes, I should have more clear but that helps. -- ------- inum: 883510009027723 sip: jungleboogie@sip2sip.info xmpp: jungle-boogie@jit.si From owner-freebsd-pkg@freebsd.org Wed Sep 9 20:46:23 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 400F6A019D1 for ; Wed, 9 Sep 2015 20:46:23 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id C471A1AC6 for ; Wed, 9 Sep 2015 20:46:22 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from liminal.local (liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id t89KkDiE045759 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Wed, 9 Sep 2015 21:46:13 +0100 (BST) (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.10.3 smtp.infracaninophile.co.uk t89KkDiE045759 Authentication-Results: smtp.infracaninophile.co.uk/t89KkDiE045759; dkim=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6] claimed to be liminal.local Subject: Re: pkg list installed by date To: freebsd-pkg@freebsd.org References: From: Matthew Seaman X-Enigmail-Draft-Status: N1110 Message-ID: <55F09A87.8040905@FreeBSD.org> Date: Wed, 9 Sep 2015 21:45:59 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E" X-Virus-Scanned: clamav-milter 0.98.7 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.7 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Sep 2015 20:46:23 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 09/09/2015 19:05, jungle Boogie wrote: > But pkg uses a sqlite3 database. Can't I alter the query? It somehow > has a query to sort alphabetically. Sure, if you want to write your own custom SQL for querying the package DB, knock yourself out. Please avoid publishing any software that relies on your own custom SQL though: the database schema does occasionally get changed and we don't guarantee that compatibility with any particular SQL queries will be maintained. Cheers, Matthew --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2 iQJ8BAEBCgBmBQJV8JqQXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATzMkP/AveiWi4xfGHFFjr7D6XVtjj zO6qaRUJB4CR+ay2k4ZeMbyr/q5JQGKvez4hQIbQImZCslBGyaHp8mlSDp7K8EYA VhI7yu68tbLMJELB+Zc8MZSNR8UXZ5qGDURcEFdh6VbHW2eYiYIy1etY5U+x3KPS AdhPFyW0PUrfTD6oXVWXpe4cm+JVyvS+NaPaLj5CvlFsodi5Vix/lO8QOMtckqBe RFpaZc5rXuxeZXBCrOnFSyp1gsRakwy7HgTrugL/BUuGxttOB7oEnqvij5v6eUOl Wd7w7xpNqjb5oEQYJ/sM63VhoktQbskYqHVNWRNAJCpsOGrq/+wC4Ij9kfEMKJkA Dz/pUy3x0p1DqDkvGtKFGN2JfpH2SSORpypZJT0JM4YmReDVcLGxjhXZ3e4DV8fI sdEA79xQqDaaw1Xbo6YPBvPT+qUStnsL+EFvfF3R/xrF4BGPyxCqeT5p+2bfNLU4 EslWX4+AvRKXENh0diQuNZXsDJuUGRoxlSUvqPj2lyG/edHIvWpC1EXKRqSkC6ER z9RzfYnBYhwVuz5DATP1Mwrig2JYO/4vodgkSQ9/bWKf8jWDHxdHB3cXsDaI5rEO D7siBX4y1O1OwEaxMd4V4QvCjYJOKB/JBtW9UWWBd85ibVAYSitEVLy0sv+l27sH pM5b5IYXJOuFsuIl3Ivb =c7S/ -----END PGP SIGNATURE----- --6UOisd3DtXQx8V3S8KjxKg2HiCFxa8m6E--