From owner-freebsd-stable@FreeBSD.ORG  Mon Mar  3 12:14:33 2014
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@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 ESMTPS id 7E0BCD61
 for <freebsd-stable@freebsd.org>; Mon,  3 Mar 2014 12:14:33 +0000 (UTC)
Received: from server1.xenet.de (server1out.xenet.de [213.221.94.200])
 by mx1.freebsd.org (Postfix) with ESMTP id DF9EC141
 for <freebsd-stable@freebsd.org>; Mon,  3 Mar 2014 12:14:31 +0000 (UTC)
Received: from [10.0.0.50] (intern.xenet.de [213.221.94.50])
 (authenticated bits=0)
 by server1.xenet.de (8.12.5/8.12.5) with ESMTP id s23CDlvT071027
 for <freebsd-stable@freebsd.org>; Mon, 3 Mar 2014 13:13:50 +0100 (CET)
 (envelope-from meyser@xenet.de)
Message-ID: <5314721D.3010403@xenet.de>
Date: Mon, 03 Mar 2014 13:14:21 +0100
From: Matthias Meyser <meyser@xenet.de>
Organization: XeNET GmbH, Clausthal-Zellerfeld
User-Agent: Mozilla/5.0 (Windows NT 5.1;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: freebsd-stable@freebsd.org
Subject: Re: Re: pkg
References: <53144507.1060306@xenet.de> <53144AEA.10608@infracaninophile.co.uk>
In-Reply-To: <53144AEA.10608@infracaninophile.co.uk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.38
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.17
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable/>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 03 Mar 2014 12:14:33 -0000

Hi

Am 03.03.2014 10:27, schrieb Matthew Seaman:
> On 03/03/14 09:01, Matthias Meyser wrote:
>
> Given you've no internet connectivity then this is probably what you
> need: create a /usr/local/etc/pkg/repos/FreeBSD.conf containing
> something like:
>
> FreeBSD: {
>    enabled: no
> }
>
> That just switches off the default /etc/pkg/FreeBSD.conf

This makes no difference.
Same error.

I think defined repos are of no Interest here as I try to install
a local packages. The error means tha the sig for the local package
is missing.

As of "man pkg" putting 'SIGNATURE_TYPE: "none"' in /usr/local/etc/pkg.conf 
disables signature checking. An other way is to "setenv SIGNATURE_TYPE none".

The later works the first not. I think this is a Bug.

>> pkg-static: sqlite: no such table: main.packages
>>
>> Now I am lost.
>
> pkg will automatically create the sqlite database schema it needs if it
> doesn't already exist.  I guess that somehow you've got a half-formed
> schema -- enough to stop it automatically re-creating the whole thing,
> but not enough to be usable.

Ok that did it. After removing local.sqlite and "setenv SIGNATURE_TYPE none"
"pkg add pkg-1.2.6.txz" worked as expected and after that I was able to
"pkg add bind99-9.9.5_1.txz".

Thanks!
    Matthias