From nobody Sat Sep 3 16:38:47 2022 X-Original-To: questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4MKgTc19rCz4brkY for ; Sat, 3 Sep 2022 16:39:00 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: from mail-vs1-xe2c.google.com (mail-vs1-xe2c.google.com [IPv6:2607:f8b0:4864:20::e2c]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4MKgTb0RlRz3k46; Sat, 3 Sep 2022 16:38:59 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: by mail-vs1-xe2c.google.com with SMTP id j6so5038605vsr.0; Sat, 03 Sep 2022 09:38:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date; bh=4kq2eCuVdxovIhVr1orjOe2CYSdEfVwBLWLFN9Mn94c=; b=EcfKVpdh0FW6MpS8HRcJFw1Lj0p14LBzVsO3myxi+cPWhrQGoejsG5OXCXBs4ZlcTB ORLsrCEj9QellgsvH5J9sskr3oz5ynlclzJYvzMfjW0pMJM6oqn8Nwrr2pxbPqmKFzft uu3MO09/og60QcgfZZUq9sPj0VxAHH37Dpg4q0p7iSBj8zt+lT4VHVJBuM60kD5IJv8f 6Pg0nC9ToRzg8px07FAsWOQp5uTd+htrEDuMjecf1x/+tRQNIpPQQkqKrAX5gZF7n4vH yPz/VZLw9I3XQuKTc2hatztcJGBVd7BMFpVoT6aWpsQZjKEcH/sI2LRj5qpDUiThhaDG BRjg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date; bh=4kq2eCuVdxovIhVr1orjOe2CYSdEfVwBLWLFN9Mn94c=; b=yMXj86i15FSY40jyuyA0Z81oHgBvNGPOssdlV5iLKruWKr5jChWlsxQxvzU3oY5crm qVuPOolKSrZ7hmnBviz0HRCK3V/0gFEvbg1S93Ar8tUPTfu2XAbZRW1wFBnOCrrLoiaB rrsJ7rHAELQpaQQlnPx5gyWBIGWmLGDQYs6aQSsNDNdspRhEcLGtqukW6Ai8OEwft2an FtX8fSbz9EaYj1zWkID9Q9sK33uJpFKEVSZCW+8YkZey8vUsy2Us6xW36MwZ7j+AjM1R Nrt50aiOcnSbQyYVbm/byc/BPsORTkarze7roZpNJOYfjk/Rv+hHhG5hbdmRS6wmRTUF k/GA== X-Gm-Message-State: ACgBeo30PyIV/4WavyohWa8hQPDmGwTQcSBssKvx4y/rWKKSgwhMIu1N M9YNYRtJU8fHN2eKCvwalGJzlpjrflH8FYNrFmd6fl+H X-Google-Smtp-Source: AA6agR6Syb93JFP4EMZwkGmUVI2vo/Y18dNvYdakogOgRshcYieaHabFISGiKfX6+Weo6iAUAo8HB3Oft/kdS2QqLn0= X-Received: by 2002:a67:e3c7:0:b0:388:b85e:4e8b with SMTP id k7-20020a67e3c7000000b00388b85e4e8bmr12102106vsm.43.1662223138082; Sat, 03 Sep 2022 09:38:58 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org> In-Reply-To: From: paul beard Date: Sat, 3 Sep 2022 09:38:47 -0700 Message-ID: Subject: Re: pkgdb question To: Kevin Oberman Cc: Graham Perrin , questions@freebsd.org Content-Type: multipart/alternative; boundary="000000000000aed59905e7c87bae" X-Rspamd-Queue-Id: 4MKgTb0RlRz3k46 X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=EcfKVpdh; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of paulbeard@gmail.com designates 2607:f8b0:4864:20::e2c as permitted sender) smtp.mailfrom=paulbeard@gmail.com X-Spamd-Result: default: False [-3.75 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-0.998]; NEURAL_HAM_SHORT(-0.76)[-0.755]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::e2c:from]; MLMMJ_DEST(0.00)[questions@freebsd.org]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_TO(0.00)[gmail.com]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ARC_NA(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; RCPT_COUNT_THREE(0.00)[3]; FROM_HAS_DN(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; FREEMAIL_FROM(0.00)[gmail.com]; TO_DN_SOME(0.00)[]; RCVD_TLS_LAST(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim] X-ThisMailContainsUnwantedMimeParts: N --000000000000aed59905e7c87bae Content-Type: text/plain; charset="UTF-8" I managed to get what I wanted by mounting the /var /partition of my damaged disk image and running pkg query %o. I'll put that on the cron as soon as all this rebuilding is done. Finding out the many ways my backup or disaster mitigation strategies have failed has been instructive. On Sat, Sep 3, 2022 at 9:33 AM Kevin Oberman wrote: > On Sat, Sep 3, 2022 at 9:19 AM Graham Perrin > wrote: > >> On 02/09/2022 23:57, paul beard wrote: >> >> list of ports, preferably w origins, >> >> pkg prime-origins | sort >> > > Or, if you need name and origin, use sqlite3: > sqlite3 local.sqlite "select name, origin from packages" > > -- > Kevin Oberman, Part time kid herder and retired Network Engineer > E-mail: rkoberman@gmail.com > PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683 > -- Paul Beard / www.paulbeard.org/ --000000000000aed59905e7c87bae Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I managed to get what I wanted by mounting the /var /parti= tion of my damaged disk image and running pkg query %o. I'll put that o= n the cron as soon as all this rebuilding is done.=C2=A0

Finding out the many ways my backup or disaster mitigation strategies have= failed has been instructive.=C2=A0

On Sat, Sep 3, 2022 at 9:33 AM Kev= in Oberman <rkoberman@gmail.com> wrote:
=20 =20 =20
On 02/09/2022 23:57, paul beard wrote:
list of ports, preferably w origins,

pkg prime-origins | sort


Or, if you need name and origin, use sqlite3:
sqlite3 local.sqlite "select name, origin from packages"

--
Kevin Oberma= n, Part time kid herder and retired Network Engineer
E-mail: rkoberman@gmail.com
PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683


--
Paul Beard / www.paulbeard.org/
--000000000000aed59905e7c87bae--