From owner-freebsd-ports@FreeBSD.ORG Wed Aug 7 01:02:39 2013 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id E3C64AC for ; Wed, 7 Aug 2013 01:02:39 +0000 (UTC) (envelope-from mueller6724@bellsouth.net) Received: from nm4-vm1.access.bullet.mail.bf1.yahoo.com (nm4-vm1.access.bullet.mail.bf1.yahoo.com [216.109.114.112]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 84B8B2D89 for ; Wed, 7 Aug 2013 01:02:38 +0000 (UTC) Received: from [66.196.81.157] by nm4.access.bullet.mail.bf1.yahoo.com with NNFMP; 07 Aug 2013 01:00:16 -0000 Received: from [98.139.221.53] by tm3.access.bullet.mail.bf1.yahoo.com with NNFMP; 07 Aug 2013 01:00:16 -0000 Received: from [127.0.0.1] by smtp106.sbc.mail.bf1.yahoo.com with NNFMP; 07 Aug 2013 01:00:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bellsouth.net; s=s1024; t=1375837216; bh=murd+H9rtaFbQ2FDHbWlFoJUWwSrUvaRPJ9I/RiIhnw=; h=X-Yahoo-Newman-Id:Message-ID:Date:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:X-Rocket-Received:From:To:Subject; b=IKn0a2Drb/1ir8K+FyHbFfmvQG0DSHIBCeCcekp2tJ2wQ7rGKc1L0iL/pXskVo+fpyfSaIPFgr0OEQrOFQCCVKwpsBvmB8KXdOV/xktI5LDs/PEP5JjUJMRlYgh8yCeQUsTjj/6fTHaD6A+iU0bQRCh6li2oKSJak6avYW4x420= X-Yahoo-Newman-Id: 17955.77948.bm@smtp106.sbc.mail.bf1.yahoo.com Message-ID: <17955.77948.bm@smtp106.sbc.mail.bf1.yahoo.com> Date: Tue, 6 Aug 2013 18:00:16 -0700 (PDT) X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: 9QnWhCMVM1nDxTQAVekO0P204am7Z38rVs0zsjXu69lEHd6 4u8_zV.hdbUK9RwCClZaHgAQhuY6jANiI6baROLJsXpD.TOd2xl0gIe0QZOK Fbcf63.RJAEhz_2N69GwJICzDvQopT5CyHhEB3Jc7OxqtbCglRgzts8c7fwy Ej8BAxZcUkOe90X4hu7HPhUx9N1YgflbGR.qAQm0_MYlQKzVoDWsY.VJzWT2 HtdRduXwglATVTKjmuAP4zkVERMFjm8UBdi7rfVozkE2s6WXU93M_YISkXyg fPzkiKNoScVMF6PFaASue2bgkiloRWekpu8revdCmRdisGZZZI37.1_1v_MW TM5DJ4VMvDRgzX4YhvKoN3DJpbZ8WVO6Yjn1AMLznYf92CGxENsVMy7YRc3k AH8hMeOaewVlGnyiPqe1cnhiye.PMYA2JLgspWYdX6qeUwaIgx2YdtnoCcg8 DI6PekoKIuL7yCJvyDZ3eA79tiCHpAS4pG9cXHwCw8dhkGi3O4pFBV5Ong7y 4cUnC.SjH9oWhqi0KH2K9K_nXJm5zWxJwCFguxjpNdIG8yjYF6F9bm2Lst1A FzDWYO7Ig X-Yahoo-SMTP: Kz_aW1.swBBYof3zAD7.RWzXz9ZAQVDMml1VADsbgPT4Kq79LC0- X-Rocket-Received: from localhost (mueller6724@74.130.200.176 with plain) by smtp106.sbc.mail.bf1.yahoo.com with SMTP; 06 Aug 2013 18:00:15 -0700 PDT From: "Thomas Mueller" To: freebsd-ports@freebsd.org Subject: [SOLVED] libpkg, sqlite and database problems prevent building any packages 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: Wed, 07 Aug 2013 01:02:40 -0000 I solved the impasse by moving /var/db/pkg/local.sqlite to another place where it wouldn't be found, in this case /var/tmp . Then I went into $PORTSDIR/ports-mgmt/pkg and ran make deinstall install to update pkg. That produced a new, small, /var/db/pkg/local.sqlite which I renamed to local.sqlite.2 in preparation for restoring the older local.sqlite . Then, with the new pkg installed but the ghost of the old pkg remaining in local.sqlite, I ran, again, from $PORTSDIR/ports-mgmt/pkg make deinstall install to put local.sqlite in sync with the installation of updated pkg. I think the pkg database is restored now. At first, with sqlite3 not listed as a dependency of pkg, I wouldn't have realized what needed fixing. Tom