From nobody Thu Jan 05 10:31:52 2023
X-Original-To: ports@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 4NnjSr0vczz2p6tD
	for <ports@mlmmj.nyi.freebsd.org>; Thu,  5 Jan 2023 10:31:56 +0000 (UTC)
	(envelope-from yuri@FreeBSD.org)
Received: from shell1.rawbw.com (shell1.rawbw.com [198.144.192.42])
	by mx1.freebsd.org (Postfix) with ESMTP id 4NnjSq5d46z3KJ1;
	Thu,  5 Jan 2023 10:31:55 +0000 (UTC)
	(envelope-from yuri@FreeBSD.org)
Authentication-Results: mx1.freebsd.org;
	none
Received: from [192.168.5.3] (c-73-162-96-20.hsd1.ca.comcast.net [73.162.96.20])
	(authenticated bits=0)
	by shell1.rawbw.com (8.15.1/8.15.1) with ESMTPSA id 305AVrnc053537
	(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO);
	Thu, 5 Jan 2023 02:31:53 -0800 (PST)
	(envelope-from yuri@FreeBSD.org)
X-Authentication-Warning: shell1.rawbw.com: Host c-73-162-96-20.hsd1.ca.comcast.net [73.162.96.20] claimed to be [192.168.5.3]
Message-ID: <488ef591-44b9-d15e-84c7-4c286d3ce254@tsoft.com>
Date: Thu, 5 Jan 2023 02:31:52 -0800
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Archive: https://lists.freebsd.org/archives/freebsd-ports
List-Help: <mailto:ports+help@freebsd.org>
List-Post: <mailto:ports@freebsd.org>
List-Subscribe: <mailto:ports+subscribe@freebsd.org>
List-Unsubscribe: <mailto:ports+unsubscribe@freebsd.org>
Sender: owner-freebsd-ports@freebsd.org
X-BeenThere: freebsd-ports@freebsd.org
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:102.0) Gecko/20100101
 Thunderbird/102.5.0
Subject: Re: PortsDB: a program that imports the ports tree into an SQLite
 database
Content-Language: en-US
To: ports@freebsd.org
References: <f84e138d-46f7-9353-112f-492b1460c3c3@tsoft.com>
 <CAFDf7UKk0hfyXEZYY965-qw+_5_bNpnAt+dwe0Ejbp_sSqbEoQ@mail.gmail.com>
Cc: Nuno Teixeira <eduardo@freebsd.org>
From: Yuri <yuri@FreeBSD.org>
In-Reply-To: <CAFDf7UKk0hfyXEZYY965-qw+_5_bNpnAt+dwe0Ejbp_sSqbEoQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Rspamd-Queue-Id: 4NnjSq5d46z3KJ1
X-Spamd-Bar: ----
X-Spamd-Result: default: False [-4.00 / 15.00];
	REPLY(-4.00)[];
	ASN(0.00)[asn:7961, ipnet:198.144.192.0/19, country:US]
X-Rspamd-Pre-Result: action=no action;
	module=replies;
	Message is reply to one we originated
X-ThisMailContainsUnwantedMimeParts: N

Hi Nino,

On 1/5/23 01:50, Nuno Teixeira wrote:
>
> /etc/make.conf:
> PORTSDIR=/work/freebsd/ports/main
>
> `portsdb-import`:
> error: the PORTSDIR environment variable should point to a valid ports 
> tree
> Usage: /usr/local/bin/portsdb-import <db.sqlite> <file.sql> [{sync|async}]
>
> Any clues?


/etc/make/conf doesn't set environment variables. It sets make variables.


You should run:

$ PORTSDIR=/work/freebsd/ports/main portsdb-import


Best,

Yuri