From owner-freebsd-ports@FreeBSD.ORG Sun Oct 21 10:00:07 2012 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4E49FB38 for ; Sun, 21 Oct 2012 10:00:07 +0000 (UTC) (envelope-from mueller23@insightbb.com) Received: from mail.insightbb.com (smtp3.insight.synacor.com [208.47.185.25]) by mx1.freebsd.org (Postfix) with ESMTP id EF1728FC16 for ; Sun, 21 Oct 2012 10:00:06 +0000 (UTC) X_CMAE_Category: 0,0 Undefined,Undefined X-CNFS-Analysis: v=2.0 cv=ZYCfx7pA c=1 sm=0 a=Dm9TOXL4taQ+Gy1KovpL+A==:17 a=C2ajsPsEavcA:10 a=jLN7EqiLvroA:10 a=9YQ-1ebCAAAA:8 a=0D-DR49PIxUA:10 a=WF2pI21SAAAA:8 a=5IjJdNiwoh49hTR6J9gA:9 a=Dm9TOXL4taQ+Gy1KovpL+A==:117 X-CM-Score: 0 X-Scanned-by: Cloudmark Authority Engine Authentication-Results: smtp02.insight.synacor.com smtp.mail=mueller23@insightbb.com; spf=softfail; sender-id=softfail Authentication-Results: smtp02.insight.synacor.com header.from=mueller23@insightbb.com; sender-id=softfail Received-SPF: softfail (smtp02.insight.synacor.com: transitional domain insightbb.com does not designate 74.130.198.7 as permitted sender) Received: from [74.130.198.7] ([74.130.198.7:47097] helo=localhost) by mail.insightbb.com (envelope-from ) (ecelerity 2.2.3.49 r(42060/42061)) with ESMTP id 34/29-23131-A07C3805; Sun, 21 Oct 2012 05:57:30 -0400 Date: Sun, 21 Oct 2012 05:57:30 -0400 Message-ID: <34.29.23131.A07C3805@smtp02.insight.synacor.com> From: "Thomas Mueller" To: freebsd-ports@freebsd.org Subject: Re: Snag in upgrading p5-XML-SAX and p5-XML-SAX-Base X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Oct 2012 10:00:07 -0000 > No -- you only ever need to run pkg2ng once. > /usr/bin/pkg will invoke /usr/local/bin/pkg automatically if > /usr/local/bin/pkg is installed -- /usr/bin/pkg is a shim that exists to > facilitate the installation of the actual /usr/local/bin/pkg binary. > That's all normal. > Now, the real problem: not seeing the contents of the local package > database. Can you check a few things: > 1) That PKG_DBDIR isn't defined in your environment or in > /usr/local/etc/pkg.conf (or if it is, it is set to an > appropriate directory.) > 2) That /var/db/pkg/local.sqlite exists and has these permissions > and ownership: > % ls -l /var/db/pkg/local.sqlite > -rw-r--r-- 1 root wheel 4041728 Oct 14 17:52 /var/db/pkg/local.sqlite > (The size will be different depending on what packages are > installed) > 3) Try opening the local.sqlite database and investigating the > contents of one or more of the tables. Like so: > # pkg shell > SQLite version 3.7.14.1 2012-10-04 19:37:12 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select count(*) from packages ; > 47 > sqlite> .quit > If that returns zero then something has wiped your package DB. > You may be able to recover from a backup copy of local.sqlite that the > daily periodic jobs creates in /var/backups/pkgng.db -- just copy that > back to /var/db/pkg/local.sqlite and try again. > 4) If there is content in local.sqlite, then try using 'pkg info' to > query the contents. This should print out just about everything pkgng > knows about what is installed on your system: > % pkg info -fa > Cheers, > Matthew > -- > Dr Matthew J Seaman MA, D.Phil. > PGP: http://www.infracaninophile.co.uk/pgpkey Actually, I find pkg in sbin directory as opposed to bin: /usr/sbin/pkg and /usr/local/sbin/pkg . I followed your steps 1 to 4, found 638 packages, found the correct permissions, and pkg info seemed to work correctly. Now I wonder if the problem is fixed. Tom