From nobody Sat May 29 13:40:37 2021 X-Original-To: freebsd-database@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 43E76DBEDAF for ; Sat, 29 May 2021 13:41:22 +0000 (UTC) (envelope-from dan@langille.org) Received: from wout3-smtp.messagingengine.com (wout3-smtp.messagingengine.com [64.147.123.19]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4FsjPs3mT5z3C9p; Sat, 29 May 2021 13:41:21 +0000 (UTC) (envelope-from dan@langille.org) Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id BBF4DC14; Sat, 29 May 2021 09:41:19 -0400 (EDT) Received: from imap36 ([10.202.2.86]) by compute6.internal (MEProxy); Sat, 29 May 2021 09:41:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=langille.org; h= mime-version:message-id:in-reply-to:references:date:from:to:cc :subject:content-type; s=fm1; bh=bl2E7bmpLYnHvJC9CHRPfbF+nVINWZu OHU130XEL5Kk=; b=flZGk+W35ZhvaNSbPqSQJR6VMZ9Dw0uKzZjaC1Kn8BZsBgz 3gnhW+kjahxRrFCR0LGS9gpD7NiHXx6mlhiClQ1gMdlQ+lXvfZA6muAuP28An1h2 h6LOJxyaJrCdlg3gYXVzZbEgxeoX35+bODZ73sYREcOZFsCL4V8ulrc+cV7hosbM UrYkV8dG9XLbTOQf4RdPGRo5L1k4J+iQYYO4bg8kTs1yttsqABWJgNOxDnJ7V5nf QATz0DzwgWa1Altfe4KkrdEgTCD3iPbWusxVQhWwgUmnlWivy+UMIWXQVqqXRPO4 izJncBuHY2XCfCVNK1NJoOYlFZSASRZXkUxrWsA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=bl2E7b mpLYnHvJC9CHRPfbF+nVINWZuOHU130XEL5Kk=; b=l04/1XBD1TcGwtOiwQyA9a 19323LwTWK/LOreIEzj/6qNXZP20Mr48dQQAPIES/GK1nEMzBODav8ZfWoweqe/6 7j+4er3abtxS2Xcfuu33u9gAjQM6/AkQ1KjDXf8vizMQp3AiVZDhX6EfL5+knvS/ 3BSR+TG9xzV/uGeapPF3OXs2akJJ+jsHoHr8kIvO7DqHxaNRxd+/ZTfMvMncfTo4 KlhNnuv4T6QH0ROhFzLgcwd/R5ifgpXmmSNnnvZJCp4JbaLIoRE24CjQ10RzTIQ2 O/eE/DJB+DgjQJm4SZljAMm3EgnruEEWC3bDGdbOCLiF2lvy4qtwUgFke7sOcIlg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdekledgieekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesrgdtreerreertdenucfhrhhomhepfdffrghn ucfnrghnghhilhhlvgdfuceouggrnheslhgrnhhgihhllhgvrdhorhhgqeenucggtffrrg htthgvrhhnpeejveeuhedvieffjedvhfdvkeffgeegleeiveffffetkeekffekteelteev hfekgeenucffohhmrghinhepfhhrvggvsghsugdrohhrghdpsggrtghulhgrrdhorhhgne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepuggrnhes lhgrnhhgihhllhgvrdhorhhg X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id 048D610E0089; Sat, 29 May 2021 09:41:18 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-468-gdb53729b73-fm-20210517.001-gdb53729b List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org Mime-Version: 1.0 Message-Id: In-Reply-To: <192b6704-d8f5-f780-9916-3f310015c0f3@delphij.net> References: <956930fc-5209-4ec2-95fa-19fd44a26672@www.fastmail.com> <192b6704-d8f5-f780-9916-3f310015c0f3@delphij.net> Date: Sat, 29 May 2021 09:40:37 -0400 From: "Dan Langille" To: d@delphij.net, "Xin Li" , "Jochen Neumeister" Cc: "Xin Li" Subject: Re: Content-Type: multipart/alternative; boundary=82cb4b7b5f76456283aa159fc2a965b9 X-Rspamd-Queue-Id: 4FsjPs3mT5z3C9p X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=langille.org header.s=fm1 header.b=flZGk+W3; dkim=pass header.d=messagingengine.com header.s=fm2 header.b=l04/1XBD; dmarc=pass (policy=none) header.from=langille.org; spf=pass (mx1.freebsd.org: domain of dan@langille.org designates 64.147.123.19 as permitted sender) smtp.mailfrom=dan@langille.org X-Spamd-Result: default: False [-2.54 / 15.00]; XM_UA_NO_VERSION(0.01)[]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+ip4:64.147.123.19]; RCVD_COUNT_THREE(0.00)[4]; DKIM_TRACE(0.00)[langille.org:+,messagingengine.com:+]; DMARC_POLICY_ALLOW(-0.50)[langille.org,none]; NEURAL_HAM_SHORT(-1.00)[-1.000]; RCVD_IN_DNSWL_LOW(-0.10)[64.147.123.19:from]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; ASN(0.00)[asn:11403, ipnet:64.147.123.0/24, country:US]; RCVD_TLS_LAST(0.00)[]; ARC_NA(0.00)[]; SUBJECT_ENDS_SPACES(0.50)[]; R_DKIM_ALLOW(-0.20)[langille.org:s=fm1,messagingengine.com:s=fm2]; FREEFALL_USER(0.00)[dan]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[4]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; MANY_INVISIBLE_PARTS(0.05)[1]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RWL_MAILSPIKE_VERYGOOD(0.00)[64.147.123.19:from]; MAILMAN_DEST(0.00)[freebsd-database]; MID_RHS_WWW(0.50)[] X-ThisMailContainsUnwantedMimeParts: Y --82cb4b7b5f76456283aa159fc2a965b9 Content-Type: text/plain On Sun, May 16, 2021, at 5:55 AM, Xin Li via freebsd-database wrote: > > > On 5/2/21 10:44 AM, Dan Langille wrote: > > On Sat, May 1, 2021, at 10:02 PM, Curtis Villamizar wrote: > >> The ports collection still has MySQL server versions 5.7.33 and > >> 8.0.23. > >> > >> The VuXML database has had an entry for mysql since April 20 that > >> affects mysql57-server < 5.7.34 and mysql80-server < 8.0.24. It > >> sounds rather severe: > >> > >> This Critical Patch Update contains 49 new security patches for > >> Oracle MySQL. 10 of these vulnerabilities may be remotely > >> exploitable without authentication, i.e., may be exploited over a > >> network without requiring user credentials. The highest CVSS v3.1 > >> Base Score of vulnerabilities affecting Oracle MySQL is 9.8. > >> > >> See http://vuxml.freebsd.org/freebsd/56ba4513-a1be-11eb-9072-d4c9ef517024.html > >> > >> Any idea when the port will be updated? > >> > >> It might be good to update this promptly just in case someone wants to > >> run some sort of serious mysql application in production. > > > > MySQL is not an easy port to maintain. I have tried. > > > > Some months ago, under similar circumstances, I tried to patch the port to help the > > maintainer. I failed. It was not as simple as bumping the PORTVERSION, > > running `make makesum`, followed by a `poudriere testport`. > > > > That's when I decided to leave it to the port maintainer who knows what > > they are doing and is familiar with the port. I am sure they would appreciate > > help though. If someone CAN provide patches, that is always helpful > > I've took some time to update the mysql80-server port to 8.0.25. > > Note that I have only build-tested it and have not tested it with real > data, yet (will do tomorrow-ish when I have some time). This drops LLVM > 9 dependency for most 13.x users. If you have a spare system, > especially if you have a set up with replication, please do give it some > tests and let us know if it works for you. No replication in use, but I updated my MySQL 8.0 instance May 20 and it has been working fine since. It is used for Bacula Regression testing: https://regress.bacula.org/index.php?project=Bacula-9.6&date=2021-05-29 Thank you. -- Dan Langille dan@langille.org From nobody Mon Feb 21 01:59:18 2022 X-Original-To: freebsd-database@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 92D8219D6CD7 for ; Mon, 21 Feb 2022 01:59:40 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-ej1-x636.google.com (mail-ej1-x636.google.com [IPv6:2a00:1450:4864:20::636]) (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 4K258W5mNSz4jPp for ; Mon, 21 Feb 2022 01:59:39 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: by mail-ej1-x636.google.com with SMTP id a23so29113572eju.3 for ; Sun, 20 Feb 2022 17:59:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=tzf167veg2x6wUcpviAqEPgFXigfQix9rb58rvD78mA=; b=oANMa4bqhcpV6xdodhGzD2tabCpBfKLI0L1Od294i1dASt+suTLF9QZcG1Eeu0Om92 SLd20Gk0eEBdcuCCE7WcQn8LUYu8jAKJ4HsjVXUAIvw45esviXfqvN467yscevVtz0Rx CugWbJcxh5vbDKxwVjHSOgNcEODJYJTlffho8/EAsoh01UlYqyh4J12WiEPncJag3zTU IFIetocRbOHlnJwRekafvlYjfQxF8+p5y6PrwuXgnyCfjbnwFea+f+BpHxtN2RjZ0Bfh /LSh5uil5KYnISO3JHpHdrhNfkf/SIdtAM9zaXjnk1Q2N7MtNuhPlPoykMl+k1Jw80IM VetQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=tzf167veg2x6wUcpviAqEPgFXigfQix9rb58rvD78mA=; b=0FCxExqC8L3M1fOhga1Q6oZ8QG4Sx+C55hAjI1qoNYZGAFooZPSqesyFLIiPCfmr9f OvZLSbj3BwGVlvI8Gbd4ShwhmU5h/vuMuNJW8a80Ui/y0Jbt/UwfKa6YEQ62mbXpe01D Lf1dHyiP/24aJYvRsZWypjCZzQYbrNnvyV+oPCy6IUrHGkwEI+adpN3wTXAIcIg2FFU7 2JDJp1zdhqhIAht2Hnq/MZO2/xdKI6iP+fQWSkmeFnCSZLmbic+Z2JXDvIe1bninPnEC GkyYwg6AaT5cvEwH8lwFKj3IBIgEfSnhe8Kg8FEzjkEZe7uccvXf0o3WP5GduKtGAf0W ibKA== X-Gm-Message-State: AOAM53034ITkN9HbyEApgarTucUwO9tEiFThumSjfX3ZFGCWuxQspP7K AjqFk6d/nVIxE+9mj1vmvz3hK7WGIfg35EfXgGmzqEfoXUc= X-Google-Smtp-Source: ABdhPJxdlRDA7TOzHmiWdXcpyvy3KNzgr+nQ1YMA2V6lBAloL/9UwhW/ZJ638fAp3XuahrRp1XeXbfOKoc2/3ZJ4Gwc= X-Received: by 2002:a17:906:35ca:b0:6ce:d3b5:38f5 with SMTP id p10-20020a17090635ca00b006ced3b538f5mr14108097ejb.276.1645408778754; Sun, 20 Feb 2022 17:59:38 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 From: Archimedes Gaviola Date: Mon, 21 Feb 2022 09:59:18 +0800 Message-ID: Subject: Berkeley DB 1.85 source install To: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="000000000000c49b2805d87d95ec" X-Rspamd-Queue-Id: 4K258W5mNSz4jPp X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=oANMa4bq; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of archimedesgaviola@gmail.com designates 2a00:1450:4864:20::636 as permitted sender) smtp.mailfrom=archimedesgaviola@gmail.com X-Spamd-Result: default: False [-4.00 / 15.00]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36:c]; FREEMAIL_FROM(0.00)[gmail.com]; TO_DN_NONE(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::636:from]; MLMMJ_DEST(0.00)[freebsd-database]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] X-ThisMailContainsUnwantedMimeParts: N --000000000000c49b2805d87d95ec Content-Type: text/plain; charset="UTF-8" (re-posted as this might be the proper channel to ask) Hi, With 13.0-RELEASE, I would like to compile and install the Berkeley DB 1.85 source from /usr/src/lib/libc/db however only in its parent directory /usr/src/lib/libc I could perform the "make" command. Is there a way to compile specific to the db only? If it's possible then what are the "make" parameters I should include to invoke? freebsd@fbsd13:/usr/src/lib/libc/db % ls -lah total 56 drwxr-xr-x 10 root wheel 512B Jan 28 01:36 . drwxr-xr-x 43 root wheel 1.0K Apr 9 2021 .. -rw-r--r-- 1 root wheel 416B Apr 9 2021 Makefile.inc -rw-r--r-- 1 root wheel 1.2K Apr 9 2021 README -rw-r--r-- 1 root wheel 380B Apr 9 2021 Symbol.map drwxr-xr-x 2 root wheel 512B Apr 9 2021 btree -rw-r--r-- 1 root wheel 3.4K Apr 9 2021 changelog drwxr-xr-x 2 root wheel 512B Apr 9 2021 db drwxr-xr-x 2 root wheel 512B Apr 9 2021 docs drwxr-xr-x 2 root wheel 512B Jan 27 23:38 hash drwxr-xr-x 2 root wheel 512B Apr 9 2021 man drwxr-xr-x 2 root wheel 512B Apr 9 2021 mpool drwxr-xr-x 2 root wheel 512B Apr 9 2021 recno drwxr-xr-x 4 root wheel 512B Apr 9 2021 test Thanks, Archimedes --000000000000c49b2805d87d95ec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
(re-posted as this might be the proper channel to ask)

<= /div>
Hi,

With 13.0-RELEASE, I would like to= =20 compile and install the Berkeley DB 1.85 source from=20 /usr/src/lib/libc/db however only in its parent directory=20 /usr/src/lib/libc I could perform the "make" command. Is there a = way to=20 compile specific to the db only? If it's possible then what are the=20 "make" parameters I should include to invoke?=C2=A0

freebsd@fbsd13:/usr/src/lib/libc/db % ls -lah
total 56
dr= wxr-xr-x =C2=A010 root =C2=A0wheel =C2=A0 512B Jan 28 01:36 .
drwxr-xr-x= =C2=A043 root =C2=A0wheel =C2=A0 1.0K Apr =C2=A09 =C2=A02021 ..
-rw-r--= r-- =C2=A0 1 root =C2=A0wheel =C2=A0 416B Apr =C2=A09 =C2=A02021 Makefile.i= nc
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 1.2K Apr =C2=A09 =C2=A020= 21 README
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 380B Apr =C2=A09 = =C2=A02021 Symbol.map
drwxr-xr-x =C2=A0 2 root =C2=A0wheel =C2=A0 512B A= pr =C2=A09 =C2=A02021 btree
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 = 3.4K Apr =C2=A09 =C2=A02021 changelog
drwxr-xr-x =C2=A0 2 root =C2=A0whe= el =C2=A0 512B Apr =C2=A09 =C2=A02021 db
drwxr-xr-x =C2=A0 2 root =C2=A0= wheel =C2=A0 512B Apr =C2=A09 =C2=A02021 docs
drwxr-xr-x =C2=A0 2 root = =C2=A0wheel =C2=A0 512B Jan 27 23:38 hash
drwxr-xr-x =C2=A0 2 root =C2= =A0wheel =C2=A0 512B Apr =C2=A09 =C2=A02021 man
drwxr-xr-x =C2=A0 2 root= =C2=A0wheel =C2=A0 512B Apr =C2=A09 =C2=A02021 mpool
drwxr-xr-x =C2=A0 = 2 root =C2=A0wheel =C2=A0 512B Apr =C2=A09 =C2=A02021 recno
drwxr-x= r-x =C2=A0 4 root =C2=A0wheel =C2=A0 512B Apr =C2=A09 =C2=A02021 test
=

Thanks,
Archimedes
--000000000000c49b2805d87d95ec-- From nobody Sun Mar 13 18:16:06 2022 X-Original-To: freebsd-database@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 310311A00AAC for ; Sun, 13 Mar 2022 18:16:09 +0000 (UTC) (envelope-from delphij@delphij.net) Received: from anubis.delphij.net (anubis.delphij.net [64.62.153.212]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "anubis.delphij.net", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4KGnt00k5lz4WMy for ; Sun, 13 Mar 2022 18:16:08 +0000 (UTC) (envelope-from delphij@delphij.net) Received: from [IPV6:2001:470:48ca:5:40a9:560c:6def:74a2] (unknown [IPv6:2001:470:48ca:5:40a9:560c:6def:74a2]) by anubis.delphij.net (Postfix) with ESMTPSA id F031539E58; Sun, 13 Mar 2022 11:16:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=delphij.net; s=m7e2; t=1647195367; x=1647209767; bh=cmqzcyMAuZz2sHQsPzrLF9dnRWO6pWC6z6IAJzBZTD4=; h=Date:Reply-To:To:References:From:Subject:In-Reply-To; b=PdhbLgwZ8BrW0o/5Zs12JwyDQ8p+htrO9jV5OOR+NYzNZ5oHqHxySvF8ToGbIFIje f+JHLWaEi3WOdjmIgaXQ1aqrZb4y0cUsflfurnDZtNiAHsBFMdS8nGACRL9Kek8KwD kmK5bhAlRA7ZQJIaRXrn4D6cvXClG9pNHB9UtnJefee1l482BOX63ow2fOWHHD/4Gu b5j+xvaFw+w3/uWeRmoAmqBq2ReYt3w5ZCUJ6Okvg9JJ4/9jwUqfn3xBSNnDTHSXGf 6VFLQfS1St2tlL0xfBxOSucDwBEF9yr3IQ4puRN0ZubQT8bI2m96+B6yJbDXsRuFYL SMb/g2v+qlSsQ== Message-ID: Date: Sun, 13 Mar 2022 11:16:06 -0700 List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 Reply-To: d@delphij.net Content-Language: en-US To: Archimedes Gaviola , freebsd-database@freebsd.org References: From: Xin Li Organization: The FreeBSD Project Subject: Re: Berkeley DB 1.85 source install In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 4KGnt00k5lz4WMy X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=delphij.net header.s=m7e2 header.b=PdhbLgwZ; dmarc=pass (policy=reject) header.from=delphij.net; spf=pass (mx1.freebsd.org: domain of delphij@delphij.net designates 64.62.153.212 as permitted sender) smtp.mailfrom=delphij@delphij.net X-Spamd-Result: default: False [-3.11 / 15.00]; HAS_REPLYTO(0.00)[d@delphij.net]; RCVD_VIA_SMTP_AUTH(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; HAS_ORG_HEADER(0.00)[]; DKIM_TRACE(0.00)[delphij.net:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[delphij.net,reject]; NEURAL_HAM_SHORT(-0.11)[-0.115]; FREEMAIL_TO(0.00)[gmail.com,freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:6939, ipnet:64.62.128.0/18, country:US]; MID_RHS_MATCH_FROM(0.00)[]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[delphij.net:s=m7e2]; FREEFALL_USER(0.00)[delphij]; FROM_HAS_DN(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; TAGGED_RCPT(0.00)[]; REPLYTO_DOM_EQ_FROM_DOM(0.00)[]; MIME_GOOD(-0.10)[text/plain]; TO_MATCH_ENVRCPT_SOME(0.00)[]; MLMMJ_DEST(0.00)[freebsd-database]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] X-ThisMailContainsUnwantedMimeParts: N Hi, On 2/20/22 17:59, Archimedes Gaviola wrote: > (re-posted as this might be the proper channel to ask) > > Hi, > > With 13.0-RELEASE, I would like to compile and install the Berkeley DB > 1.85 source from /usr/src/lib/libc/db however only in its parent > directory /usr/src/lib/libc I could perform the "make" command. Is there > a way to compile specific to the db only? If it's possible then what are > the "make" parameters I should include to invoke? No, unless write the build glues. /usr/src/lib/libc/db was a trimmed down and customized version of Berkeley DB 1.86, and it's not intended for standard alone use (and therefore, it's unlikely that we would accept changes to add build glues for it to build it as a standard alone library). If you need Berkeley DB 1.85 (or 1.86), you should be able to find the original tarball on the Internet and start from there. Cheers, From nobody Mon Mar 14 11:31:03 2022 X-Original-To: freebsd-database@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 3CF0C1A288FD for ; Mon, 14 Mar 2022 11:31:15 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-ej1-x62c.google.com (mail-ej1-x62c.google.com [IPv6:2a00:1450:4864:20::62c]) (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 4KHDrK4ph0z4lYY for ; Mon, 14 Mar 2022 11:31:13 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: by mail-ej1-x62c.google.com with SMTP id kt27so33274353ejb.0 for ; Mon, 14 Mar 2022 04:31:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=P/7jLZWXf/Ldyzb9Ap4RnuzF3fS3Qr5r3pOWv2QWPn0=; b=KyuB4XjEDVZ006YsI9RnE/0AwnFdkgV/iGnoDee1JUFGhwR+49cs6cYuOAZXkyulDf 3R7gqu6b/0Ru5UnMmCtCzWcrcnohkQMCOtxmI3aFgWj/f4uMSWu2QSQQlu6cxwc++p7j 8PSpT68Lz+INl9dKJCsnN7jSY7AE8XRjdA9pNLjR6BwYIgcyrr59iAXxLvpdMWJyh754 PyE1T6xzb/thOw3GNy53SMjQo9b2LzSn2tzc0CcLNk17tl0vxZV0MjCSHCvqlMp3+7aG 93dAObbqE7qh0sdV+CCFF+mKY/E9S9lSn8XyuF7p0do346E7anNVsmaanSOzGwVyFc8n JnNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=P/7jLZWXf/Ldyzb9Ap4RnuzF3fS3Qr5r3pOWv2QWPn0=; b=DTGPXwefIT+wweQpNUKZeWyIIoZc/nNeoLPujEEKlkz+snSxr/+WJjJW15iTdx4cpR dBj/D1kdd3GMcIGM9WPteBIS3bdHgQn7y/xPxsHe+gb76LwwU+HJQkguAAl7gYK4btPN IQonEdHMe+ZpfL/0/52ocE43ugFnvCJE9vqw6NG2/CmZ3gruVOT2Q1Nc5odqBmrg2iJv yHTykd7euwm3dWfcqU0xTtyIvbXFDRR/R4/osJpBHkfw/gRmPbCJHsbIUMV5zkG4Ah5/ Syxlbbgl0Hz30WZLvRfmoDwftOfCM9SKmkkLGkIlFZRTLo6Mb6DszDV/RQewgw5iQ+1I VuqA== X-Gm-Message-State: AOAM532Z3hF/SGb2oFHjAtuHp7bZ8zGLp9JChv/KQy01HcpOFOH0yua8 +bbWKkOe8iedAZjb3ZEAv/bZE4FnD3Ndn5YxkuIC2weBAjQ= X-Google-Smtp-Source: ABdhPJymRcWXzagg7zEZ8qNrDsVhLkTS2/KsVfDQBEeB3L+Tij1B86s9hw5cRZdshz2c1MnSCp01OzbnKe/BpCSFaA0= X-Received: by 2002:a17:906:4fc4:b0:6da:b4c6:fadb with SMTP id i4-20020a1709064fc400b006dab4c6fadbmr19261656ejw.282.1647257472436; Mon, 14 Mar 2022 04:31:12 -0700 (PDT) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Archimedes Gaviola Date: Mon, 14 Mar 2022 19:31:03 +0800 Message-ID: Subject: Re: Berkeley DB 1.85 source install To: d@delphij.net Cc: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="0000000000007f8e0c05da2c0461" X-Rspamd-Queue-Id: 4KHDrK4ph0z4lYY X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=KyuB4XjE; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of archimedesgaviola@gmail.com designates 2a00:1450:4864:20::62c as permitted sender) smtp.mailfrom=archimedesgaviola@gmail.com X-Spamd-Result: default: False [-4.00 / 15.00]; FREEMAIL_FROM(0.00)[gmail.com]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36]; TO_DN_NONE(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; FROM_HAS_DN(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::62c:from]; MLMMJ_DEST(0.00)[freebsd-database]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] X-ThisMailContainsUnwantedMimeParts: N --0000000000007f8e0c05da2c0461 Content-Type: text/plain; charset="UTF-8" On Mon, Mar 14, 2022 at 2:16 AM Xin Li wrote: > Hi, > > On 2/20/22 17:59, Archimedes Gaviola wrote: > > (re-posted as this might be the proper channel to ask) > > > > Hi, > > > > With 13.0-RELEASE, I would like to compile and install the Berkeley DB > > 1.85 source from /usr/src/lib/libc/db however only in its parent > > directory /usr/src/lib/libc I could perform the "make" command. Is there > > a way to compile specific to the db only? If it's possible then what are > > the "make" parameters I should include to invoke? > > No, unless write the build glues. /usr/src/lib/libc/db was a trimmed > down and customized version of Berkeley DB 1.86, and it's not intended > for standard alone use (and therefore, it's unlikely that we would > accept changes to add build glues for it to build it as a standard alone > library). > > If you need Berkeley DB 1.85 (or 1.86), you should be able to find the > original tarball on the Internet and start from there. > > Cheers, > Hi Xin Li, Thanks for your response and feedback. The challenge I encountered with the original Berkeley DB 1.85 or 1.86 sources is the need for porting as I've tried compiling, it requires fixing the source code' errors in order to work in 13.0-RELEASE or 14.0-CURRENT. That's why I wonder how the project is still able to compile the old 1.86 sources in the base system though you've said that it's been trimmed down and customized. Thanks, Archimedes --0000000000007f8e0c05da2c0461 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Mar 14, 2022 at 2:16 AM Xin L= i <delphij@delphij.net> wr= ote:
Hi,

On 2/20/22 17:59, Archimedes Gaviola wrote:
> (re-posted as this might be the proper channel to ask)
>
> Hi,
>
> With 13.0-RELEASE, I would like to compile and install the Berkeley DB=
> 1.85 source from /usr/src/lib/libc/db however only in its parent
> directory /usr/src/lib/libc I could perform the "make" comma= nd. Is there
> a way to compile specific to the db only? If it's possible then wh= at are
> the "make" parameters I should include to invoke?

No, unless write the build glues.=C2=A0 /usr/src/lib/libc/db was a trimmed =
down and customized version of Berkeley DB 1.86, and it's not intended =
for standard alone use (and therefore, it's unlikely that we would
accept changes to add build glues for it to build it as a standard alone library).

If you need Berkeley DB 1.85 (or 1.86), you should be able to find the
original tarball on the Internet and start from there.

Cheers,


Hi Xin Li,
=

Thanks for your response and feedback. The challenge I = encountered with the original Berkeley DB 1.85 or 1.86 sources is the need = for porting as I've tried compiling, it requires fixing the source code= ' errors in order to work in 13.0-RELEASE or 14.0-CURRENT. That's w= hy I wonder how the project is still able to compile the old 1.86 sources i= n the base system though you've said that it's been trimmed down an= d customized.

Thanks,
Archimedes =C2=A0 =
--0000000000007f8e0c05da2c0461-- From nobody Tue Aug 9 18:29:30 2022 X-Original-To: freebsd-database@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 4M2M6v759Zz4YnPs for ; Tue, 9 Aug 2022 18:29:43 +0000 (UTC) (envelope-from thelirius182@gmail.com) Received: from mail-vk1-xa29.google.com (mail-vk1-xa29.google.com [IPv6:2607:f8b0:4864:20::a29]) (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 4M2M6v109Nz3S9P for ; Tue, 9 Aug 2022 18:29:43 +0000 (UTC) (envelope-from thelirius182@gmail.com) Received: by mail-vk1-xa29.google.com with SMTP id t64so279978vkb.12 for ; Tue, 09 Aug 2022 11:29:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc; bh=lTdLh7lXdVxXFRAM5xWC90LBUVMQ1U6wUecHHX+X1q0=; b=oXHT9ZCug1IDXAbvpKJ06Y/DPU5XNb2atQa4YI4xw686nISh/xUidEkfXAgcnenklq oyb4fiF5p9gIw6aVEb38A8VUXEgulH12SQJ5E8YBt9DWuMgA5QBCu8zuDR2e5MPw3yNW 9AxcX1B0egocF9jzEyN5JlPLUVfrYN0ua+NZODnDsjfFp12YIlSBaWQKSWcoqMVQQvz9 o09JIwC2At2S5Th1rGDPGjPmZN76HtSxQ6RKCPcpwIaQhrU+tZEbWgnQ4UdUepEsV95T bUo25QLX5rscko0EO+yTFoOXNmSQDRbjnlrNyQ/t0KZ2PuCOi0k/tuVxhdXWCv0JXjRb +LzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc; bh=lTdLh7lXdVxXFRAM5xWC90LBUVMQ1U6wUecHHX+X1q0=; b=2pDiak0qYXnNvaw7KhBtTnbUo6LB04SIlDje1mVLc8czG+b1+zu8HXeiwQbqgjI3NU wvGCUtpHWMW9Tukyrh04Kqiw7wSPtCA5OQxpq9no2eJrhY6a66QeZf+vaLytLqIhHV5l xHCJ3ziYoOXJmbp8qa+hktVTsIpW5NNdd9JMyOa7wc8nmweT9QxgC5npw4M/eFYqS8Sd T0NXwVBdKIXXgnuBg2xNQiwYWBPaxCJ0Ybjtr7tbpRsfQdcGyCXxN7EkqcevQ0pKoznZ MKUSc3Esg3P79UqTCHJWZ/eLm1/+MnaoZQebAKs9ENuQqYemnF8ODufqgTVrDZkXkFXY hapA== X-Gm-Message-State: ACgBeo2QQ1HQnKkuJch8Jm2x3QL1u92Y+RyrjhT5ObWR+a/X2M0khSVC rt9h0cWHmvzC3GpRJkLUau2oxxPqNJJcXUZHjvVpu2MxBwY= X-Google-Smtp-Source: AA6agR67nvSr0KOUV7m72ru954+N5/g/LC06PQtfDMP9v8FieVNR0rnLxvMQB0Nz39esKV9fKvQ3w8sVX0HEzTTBX14= X-Received: by 2002:a05:6122:da8:b0:376:c611:9cdf with SMTP id bc40-20020a0561220da800b00376c6119cdfmr10375841vkb.36.1660069781988; Tue, 09 Aug 2022 11:29:41 -0700 (PDT) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 From: "Thiago D. Silva" Date: Tue, 9 Aug 2022 15:29:30 -0300 Message-ID: Subject: Qlogic clom8214 1/10gbe controller driver To: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="000000000000a8677e05e5d31d2f" X-Rspamd-Queue-Id: 4M2M6v109Nz3S9P X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=oXHT9ZCu; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of thelirius182@gmail.com designates 2607:f8b0:4864:20::a29 as permitted sender) smtp.mailfrom=thelirius182@gmail.com X-Spamd-Result: default: False [-3.92 / 15.00]; NEURAL_HAM_LONG(-1.00)[-0.997]; NEURAL_HAM_SHORT(-1.00)[-0.996]; NEURAL_HAM_MEDIUM(-0.93)[-0.931]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; ARC_NA(0.00)[]; MLMMJ_DEST(0.00)[freebsd-database@freebsd.org]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::a29:from]; FROM_EQ_ENVFROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MID_RHS_MATCH_FROMTLD(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; FREEMAIL_FROM(0.00)[gmail.com]; FROM_HAS_DN(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; TO_DN_NONE(0.00)[]; RCVD_TLS_LAST(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim] X-ThisMailContainsUnwantedMimeParts: N --000000000000a8677e05e5d31d2f Content-Type: text/plain; charset="UTF-8" hello, could anyone tell me which drive to use on this Qlogic clom8214 1/10gbe controller? if anyone knows I'll be grateful -- Att, Thiago D. Silva --000000000000a8677e05e5d31d2f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
hello, could anyone tell me which drive to use on this Qlo= gic clom8214 1/10gbe controller?

if anyone knows I'll be gratefu= l

--

Att,<= /div>

Thiago D. Silva


--000000000000a8677e05e5d31d2f-- From nobody Tue Nov 15 13:15:16 2022 X-Original-To: freebsd-database@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 4NBRWj2Slpz4dDBV; Tue, 15 Nov 2022 13:16:01 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-yw1-x1129.google.com (mail-yw1-x1129.google.com [IPv6:2607:f8b0:4864:20::1129]) (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 4NBRWh4HwMz3Fj7; Tue, 15 Nov 2022 13:16:00 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=OKukWuWs; spf=pass (mx1.freebsd.org: domain of archimedes.gaviola@gmail.com designates 2607:f8b0:4864:20::1129 as permitted sender) smtp.mailfrom=archimedes.gaviola@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-376596ae449so136531767b3.5; Tue, 15 Nov 2022 05:16:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Jgd+ITlt1FlAXL2MAbv+SZ5W0HL+/gbUgpmsYzXBx5M=; b=OKukWuWsHp6MpIt8MuKOa6HjgcylR2TiyUva/Pt0RhOMyg5NPOT+MLKwOy7NMlZj9O Jvupdy82oDyLNg4xzAwks3RbY3SgvXukWdIhjQyEwjZpbETQP5/3ws7tqRYaqav9GCJO p8LhLOkXdeFYGKh7MSNkwLSaPBxxaLcyt4Yc+Zo+SJ4X+lpMsRBFDJgDT2+eRke0Y8s0 cqgl4xASROiRHsOBDY6E37ZyRhqPEyeR4p2mA0mD1leRooZBD0as2xkfgHm4XZHuop3p CzDvWgANdAMeH7+FRYDisQuzDTN/eFXYz9RxH+OhlJipmgSkfBMhEtoUAYjmirG9bg6/ vALQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Jgd+ITlt1FlAXL2MAbv+SZ5W0HL+/gbUgpmsYzXBx5M=; b=CrobqMMPnRJsA2Oq5z2u9R7tWy04IZYcZdC6MlfWpW+1yfHBuIOrN0yqZ+6q0oobQ8 SXohUR+Sv0TIn09X/Qft5fZixXLpxAyY3QT+3kBTaA18sOvZjdWBPRcmZgpi63yOSQrv p8IY7ZAr4P3wSYkHcQXvzZVFtZf9HUuYiuLnMvkPqVxr9c2ydmWxH1ETLB4EM/BgVB0N w5Ik8GGV5Scz+Mvc4YLfkSAiOefc1u3g47U6a2jbY3wBxVJg6cD9SeAuwzMU9W6muKzz tEm5//8avhXpzVoIT2lkHVhBTkn1GvFpH+hDVLUzHQIkFIEhcWK1Zb0huCiS7AKHFqV0 nAGQ== X-Gm-Message-State: ANoB5pkJpfVZ0Sips6DDaKhT0eM+BoMQbehEWZAA1RNNPBVBj0EVz6wJ b6K9y3JTt9TWbo0g/CiCG7TXW0Erz/NIaSD1LqumQHsDs+k= X-Google-Smtp-Source: AA0mqf7T3GiH9mTxF37fZtAPpYAIZYls9UCxH8Nu6s0frqHxWV0FntvriVJPBE68rLqIiZhK0ST9ZnZUhLDytZziN2k= X-Received: by 2002:a81:a186:0:b0:373:643b:eac0 with SMTP id y128-20020a81a186000000b00373643beac0mr17310939ywg.352.1668518158116; Tue, 15 Nov 2022 05:15:58 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 From: Archimedes Gaviola Date: Tue, 15 Nov 2022 21:15:16 +0800 Message-ID: Subject: Include SQLite3 source upon buildworld To: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Content-Type: multipart/alternative; boundary="0000000000001da97105ed82281a" X-Spamd-Result: default: False [-0.63 / 15.00]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_SPAM_SHORT(0.37)[0.369]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::1129:from]; MLMMJ_DEST(0.00)[freebsd-database@freebsd.org,freebsd-questions@freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; ARC_NA(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; RCPT_COUNT_TWO(0.00)[2]; DKIM_TRACE(0.00)[gmail.com:+]; MID_RHS_MATCH_FROMTLD(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FROM_HAS_DN(0.00)[]; TAGGED_FROM(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_ALL(0.00)[]; TO_DN_NONE(0.00)[]; RCVD_TLS_LAST(0.00)[]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4NBRWh4HwMz3Fj7 X-Spamd-Bar: / X-ThisMailContainsUnwantedMimeParts: N --0000000000001da97105ed82281a Content-Type: text/plain; charset="UTF-8" Hi, There's an SQLite3 source located in the /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so that I can run the binary after compiling? freebsd@generic:/usr/src/contrib/sqlite3 % pwd /usr/src/contrib/sqlite3 freebsd@generic:/usr/src/contrib/sqlite3 % ls -lah total 11364 drwxr-xr-x 3 root wheel 1.0K Oct 27 00:06 . drwxr-xr-x 88 root wheel 2.0K Oct 27 00:06 .. -rw-r--r-- 1 root wheel 15K Oct 27 00:06 INSTALL -rw-r--r-- 1 root wheel 729B Oct 27 00:06 Makefile.am -rw-r--r-- 1 root wheel 547B Oct 27 00:06 Makefile.fallback -rw-r--r-- 1 root wheel 37K Oct 27 00:06 Makefile.in -rw-r--r-- 1 root wheel 28K Oct 27 00:06 Makefile.msc -rw-r--r-- 1 root wheel 3.5K Oct 27 00:06 README.txt -rw-r--r-- 1 root wheel 7.1K Oct 27 00:06 Replace.cs -rw-r--r-- 1 root wheel 365K Oct 27 00:06 aclocal.m4 -rwxr-xr-x 1 root wheel 7.2K Oct 27 00:06 compile -rwxr-xr-x 1 root wheel 48K Oct 27 00:06 config.guess -rwxr-xr-x 1 root wheel 35K Oct 27 00:06 config.sub -rwxr-xr-x 1 root wheel 485K Oct 27 00:06 configure -rw-r--r-- 1 root wheel 8.5K Oct 27 00:06 configure.ac -rwxr-xr-x 1 root wheel 23K Oct 27 00:06 depcomp -rwxr-xr-x 1 root wheel 15K Oct 27 00:06 install-sh -rwxr-xr-x 1 root wheel 320K Oct 27 00:06 ltmain.sh -rwxr-xr-x 1 root wheel 6.7K Oct 27 00:06 missing -rw-r--r-- 1 root wheel 717K Oct 27 00:06 shell.c -rw-r--r-- 1 root wheel 8.7K Oct 27 00:06 sqlite3.1 -rw-r--r-- 1 root wheel 8.2M Oct 27 00:06 sqlite3.c -rw-r--r-- 1 root wheel 599K Oct 27 00:06 sqlite3.h -rw-r--r-- 1 root wheel 267B Oct 27 00:06 sqlite3.pc.in -rw-r--r-- 1 root wheel 1.9K Oct 27 00:06 sqlite3.rc -rw-r--r-- 1 root wheel 36K Oct 27 00:06 sqlite3ext.h -rw-r--r-- 1 root wheel 78B Oct 27 00:06 sqlite3rc.h drwxr-xr-x 6 root wheel 512B Oct 27 00:06 tea Thanks and best regards, Archimedes --0000000000001da97105ed82281a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

There's an SQLite3 s= ource located in the=20 /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so= that I can run the binary after compiling?

=
freebsd@generic:/usr/src/contrib/sqlite3 % pwd
/usr/src/contrib/sql= ite3

freebsd@generic:/usr/src/contrib/sqlite3 % ls= -lah
total 11364
drwxr-xr-x =C2=A0 3 root =C2=A0wheel =C2=A0 1.0K Oc= t 27 00:06 .
drwxr-xr-x =C2=A088 root =C2=A0wheel =C2=A0 2.0K Oct 27 00:= 06 ..
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A015K Oct 27 00:06= INSTALL
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 729B Oct 27 00:06 M= akefile.am
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 547B Oct 27 00:06= Makefile.fallback
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A037K= Oct 27 00:06 Makefile.in
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 = =C2=A028K Oct 27 00:06 Makefile.msc
-rw-r--r-- =C2=A0 1 root =C2=A0wheel= =C2=A0 3.5K Oct 27 00:06 README.txt
-rw-r--r-- =C2=A0 1 root =C2=A0whee= l =C2=A0 7.1K Oct 27 00:06 Replace.cs
-rw-r--r-- =C2=A0 1 root =C2=A0whe= el =C2=A0 365K Oct 27 00:06 aclocal.m4
-rwxr-xr-x =C2=A0 1 root =C2=A0wh= eel =C2=A0 7.2K Oct 27 00:06 compile
-rwxr-xr-x =C2=A0 1 root =C2=A0whee= l =C2=A0 =C2=A048K Oct 27 00:06 config.guess
-rwxr-xr-x =C2=A0 1 root = =C2=A0wheel =C2=A0 =C2=A035K Oct 27 00:06 config.sub
-rwxr-xr-x =C2=A0 1= root =C2=A0wheel =C2=A0 485K Oct 27 00:06 configure
-rw-r--r-- =C2=A0 1= root =C2=A0wheel =C2=A0 8.5K Oct 27 00:06 = configure.ac
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A023K O= ct 27 00:06 depcomp
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A015= K Oct 27 00:06 install-sh
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 32= 0K Oct 27 00:06 ltmain.sh
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 6.= 7K Oct 27 00:06 missing
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 717K= Oct 27 00:06 shell.c
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 8.7K O= ct 27 00:06 sqlite3.1
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 8.2M O= ct 27 00:06 sqlite3.c
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 599K O= ct 27 00:06 sqlite3.h
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 267B O= ct 27 00:06 sqlite3.pc.in
-rw-r--r-= - =C2=A0 1 root =C2=A0wheel =C2=A0 1.9K Oct 27 00:06 sqlite3.rc
-rw-r--r= -- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A036K Oct 27 00:06 sqlite3ext.h
= -rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A078B Oct 27 00:06 sqlite3r= c.h
drwxr-xr-x =C2=A0 6 root =C2=A0wheel =C2=A0 512B Oct 27 00:06 tea

Thanks and best regards,
Archimedes
--0000000000001da97105ed82281a-- From nobody Tue Nov 15 17:47:52 2022 X-Original-To: freebsd-database@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 4NBYYg6LRQz4hLc6; Tue, 15 Nov 2022 17:48:07 +0000 (UTC) (envelope-from delphij@gmail.com) Received: from mail-ej1-x62d.google.com (mail-ej1-x62d.google.com [IPv6:2a00:1450:4864:20::62d]) (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 4NBYYf4zm9z44jP; Tue, 15 Nov 2022 17:48:06 +0000 (UTC) (envelope-from delphij@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=XaPFH1Es; spf=pass (mx1.freebsd.org: domain of delphij@gmail.com designates 2a00:1450:4864:20::62d as permitted sender) smtp.mailfrom=delphij@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-ej1-x62d.google.com with SMTP id k2so37969559ejr.2; Tue, 15 Nov 2022 09:48:06 -0800 (PST) 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:message-id:reply-to; bh=SHNxXpAhbp78Mipu0TXAtQIwy7wOwzOAjX+xgIqmhI8=; b=XaPFH1EsOZl7JaKs4M1AUQyjrRY06+L9mstri0DYNjU5XyHYk1793mfp/pPA/0dPfJ 5Oh4QBOkbNxdrRSx/+AFIXGQUxycGMqxU4H9sC2Q1hsIsQTBLqWPrZ1jxuxFUkH2JLTy Aqnbm46/YoY/RVRrZ/h347//Hpfr/UteVjiYt2cs+ExYka+8XIWJQwBmVryc6Avh0wyS DwywA8cX3ReU9RgnOkFzCc/tIH5HNW33Bl7Lwih+JED0DiMBPH7wDzYzubX3tmUNBBtA qSGLqg+MMID4uMrN5izad6tXevRPtJsKZWR1uhIZ3fK1che79jGqfIYvOpi7Gb7H8MQM LZwQ== 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:message-id :reply-to; bh=SHNxXpAhbp78Mipu0TXAtQIwy7wOwzOAjX+xgIqmhI8=; b=UP1ZZBj9vpKqIg7kHDtWl22QIRty4jr6PpYOnLOP8Gh17ljcbnZt9PWDk/4Vr8Laig Bah8h8GTPQNctXNoDqGvMwLZf4p5mjqM1wvu2uqMdY0CYP5XTb/daMVgJiAT553xGSZS 2YGPqTktSh1bkzs4FB7OtPmIusJrrs3mRmd/Acc0PsuOkyMS8G4gb4KKFgJKAA/euL0X 2DrxMR1qryi7FyLmYS1gaZ+K/ysoL9sgJXXTUeuKWWeMkplVkrk4Bmze3qoobLQhhU3s u43kWds+D3uLbXf+uAfdvskNaqMTaujxfDdvoPwJUE8GgljuuYHywcXtXJ3MJIztC7jY M3AA== X-Gm-Message-State: ANoB5pk2Ph4T8n6xuGbX843EGlXbdNNuT3Fb8fYN5uDZx00hUbIcvLDd iwlCDBT2TmCN21X3MsTzaD62YXbo+KuYw8T3RXFcvih1 X-Google-Smtp-Source: AA0mqf7TH+9vHschThjfSymGa26vL4j40O/f+383q0ogQSC9LtzWsXpI4WI6wLEi+jMsQYaVyfvsw49Do33goCvrfR0= X-Received: by 2002:a17:906:7e4e:b0:7a8:3ecb:bd62 with SMTP id z14-20020a1709067e4e00b007a83ecbbd62mr15054852ejr.721.1668534484658; Tue, 15 Nov 2022 09:48:04 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Xin LI Date: Tue, 15 Nov 2022 09:47:52 -0800 Message-ID: Subject: Re: Include SQLite3 source upon buildworld To: Archimedes Gaviola Cc: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Content-Type: multipart/alternative; boundary="00000000000040f09b05ed85f534" X-Spamd-Result: default: False [-2.80 / 15.00]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.80)[-0.799]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36:c]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; FREEFALL_USER(0.00)[delphij]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[3]; TO_DN_SOME(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; TAGGED_RCPT(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::62d:from]; ARC_NA(0.00)[]; RCVD_TLS_LAST(0.00)[]; MLMMJ_DEST(0.00)[freebsd-database@freebsd.org,freebsd-questions@freebsd.org]; DKIM_TRACE(0.00)[gmail.com:+]; MID_RHS_MATCH_FROMTLD(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FREEMAIL_TO(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FROM_EQ_ENVFROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4NBYYf4zm9z44jP X-Spamd-Bar: -- X-ThisMailContainsUnwantedMimeParts: N --00000000000040f09b05ed85f534 Content-Type: text/plain; charset="UTF-8" On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola < archimedes.gaviola@gmail.com> wrote: > Hi, > > There's an SQLite3 source located in the /usr/src/contrib/sqlite3. Is > there a way to include this upon buildworld so that I can run the binary > after compiling? > Yes and no. Yes -- you can always compile shell.c source and link against the library; the code is there, just the BSD make build glues are missing. No -- the omission is intentional: the library is meant to be used by the base system as a "private library", which gives us the flexibility to not give a stable API/ABI promise and to only build with options that the base system needed (to reduce attack surface), so that when we make an update, it will be a "wholesale" update and user applications are not broken, even if sqlite3 update have introduced one. Users who want sqlite3 should really install it from ports (databases/sqlite3) or package. --00000000000040f09b05ed85f534 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, Nov 15, 2022 at 5:16 AM Arc= himedes Gaviola <archime= des.gaviola@gmail.com> wrote:
Hi,

The= re's an SQLite3 source located in the=20 /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so= that I can run the binary after compiling?
Yes and no.

Yes -- you can always compile shell.c source and lin= k against the library; the code is there, just the BSD make build glues are= missing.

No -- the omission is intentional: the library is meant to= be used by the base system as a "private library", which gives u= s the flexibility to not give a stable API/ABI promise and to only build wi= th options that the base system needed (to reduce attack surface), so that = when we make an update, it will be a "wholesale" update and user = applications are not broken, even if sqlite3 update have introduced one.=C2= =A0 Users who want sqlite3 should really install it from ports (databases/s= qlite3) or package.
--00000000000040f09b05ed85f534-- From nobody Wed Nov 16 02:06:41 2022 X-Original-To: freebsd-database@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 4NBmdl26TNz4hCLj for ; Wed, 16 Nov 2022 02:07:23 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-yw1-x1136.google.com (mail-yw1-x1136.google.com [IPv6:2607:f8b0:4864:20::1136]) (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 4NBmdl1S6qz3tX2 for ; Wed, 16 Nov 2022 02:07:23 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-yw1-x1136.google.com with SMTP id 00721157ae682-36cbcda2157so154556767b3.11 for ; Tue, 15 Nov 2022 18:07:23 -0800 (PST) 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:message-id:reply-to; bh=7DFg05bmHu2R705rMVnDP2SnCI/Bv6ksb7ZhkddTlvA=; b=Ux1tmDH0Q7xoXPzWMMVpu08ygIkOQoKbK22pVVzVUJGpOgjdh/kLVLENzTS3ta0TST gWgxdmYGpqObskYfbhckjMC6scm68TQG2xj7BDDMuewe1x7zjhdMwnxhfWbyOjCm42w2 Ztc03AR2o3XdWQmBEpfD8nAbfZV0PyZKDIm5DwtlhLQA/zDKt5Fds+Tz981xvo7+gAC8 L/nUXzVDlptn0ERjKSUrMLIbaxTpXxfkKkhqLJleXYB4zGsTNs9wWVHc2G7L42PzjpXR UG/zd6wSLDlGjOQi6GLa7PqmP15/OItD6DH/+D85kFH13o2j/MQLgivgtf7F7M/HMVN4 kEWw== 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:message-id :reply-to; bh=7DFg05bmHu2R705rMVnDP2SnCI/Bv6ksb7ZhkddTlvA=; b=da5MZM1h2HO+az9PXb5sqG4fQGgjVGetTrmg0n9fK7wU6hrtXOYOMezGYyvT2NGoWy ZMflc3p0iXFOSprJN2GpOAvaFFU5Lrvqy1ccjXnWne3ALVgfDo+uZdaS9yfp0LSvgIS/ 5AXjKFbpvISetnwM6WaxMlCsQM+z1gfLQ6FeCxq9ZJASmQZo0JuBxds7+XgH9jxZMY3+ uHBnKWwZmTe2jr+8/nbrw+1dqoF2Oa41VfWXHTJNQteNEyYq50JksfLKCgw12IkHD61u QYG2+QkiAoL6b70HYuy3GEC9PHTIAAEBiQthfQRNyyfvigLQhHcqMq0IFa8t4J/GM3S3 K7wA== X-Gm-Message-State: ANoB5pnJrQ0yn78SQe/w8qoblC+Nrrysalbx8Idekj3/cvk1pFBBSica ZyXYyWUb+PBIFSIPX514GKxX8VqwuDWfg4pNblWZPX8o X-Google-Smtp-Source: AA0mqf5B8UjQQvyx7/qsJLLd4QQ2oSTk+LuUpIpf4wIrVAAChhMhhoyd7tCjvHOkj2fOiGshcRGVnKYyUDT8rOWqhTc= X-Received: by 2002:a81:9911:0:b0:369:b8a9:8fc6 with SMTP id q17-20020a819911000000b00369b8a98fc6mr21075501ywg.53.1668564442530; Tue, 15 Nov 2022 18:07:22 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Archimedes Gaviola Date: Wed, 16 Nov 2022 10:06:41 +0800 Message-ID: Subject: Re: Include SQLite3 source upon buildworld To: Xin LI Cc: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="000000000000e1c76f05ed8cee9e" X-Rspamd-Queue-Id: 4NBmdl1S6qz3tX2 X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; TAGGED_FROM(0.00)[] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N --000000000000e1c76f05ed8cee9e Content-Type: text/plain; charset="UTF-8" On Wed, Nov 16, 2022 at 1:48 AM Xin LI wrote: > > > On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola < > archimedes.gaviola@gmail.com> wrote: > >> Hi, >> >> There's an SQLite3 source located in the /usr/src/contrib/sqlite3. Is >> there a way to include this upon buildworld so that I can run the binary >> after compiling? >> > Hi Xin Li, > Yes and no. > > Yes -- you can always compile shell.c source and link against the library; > the code is there, just the BSD make build glues are missing. > Okay, nice! I'm so glad that it can be done. My goal is to make SQLite3 be part of the base system in a customized FreeBSD build to make it embedded. I am checking the version and it's updated 3.93.3 as I'm using the 14.0-CURRENT. I need to figure-out this BSD make and glues you've mentioned to make this happen. No -- the omission is intentional: the library is meant to be used by the > base system as a "private library", which gives us the flexibility to not > give a stable API/ABI promise and to only build with options that the base > system needed (to reduce attack surface), so that when we make an update, > it will be a "wholesale" update and user applications are not broken, even > if sqlite3 update have introduced one. Users who want sqlite3 should > really install it from ports (databases/sqlite3) or package. > Oh I see, now I know its purpose. Currently, I have my system installed with SQLite3 via package install 'pkg install sqlite3' and it works very well but because this time I want something embeddable. It so happened that I was checking the source and surprisingly found sqlite3. Anyway, let me explore and try. Thanks and best regards, Archimedes --000000000000e1c76f05ed8cee9e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Wed, Nov 16, 2022 at 1:48 AM Xin L= I <delphij@gmail.com> wrote:=


On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola <archimedes.gaviola@gmail.com= > wrote:
=
Hi,

There's an SQLite3 s= ource located in the=20 /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so= that I can run the binary after compiling?
<= /div>

Hi Xin Li,
=C2= =A0
Yes and no.

Yes -- you can always com= pile shell.c source and link against the library; the code is there, just t= he BSD make build glues are missing.
Okay, nice! I'm so glad that it can be done. My goal is to = make SQLite3 be part of the base system in a customized FreeBSD build to ma= ke it embedded. I am checking the version and it's updated 3.93.3 as I&= #39;m using the 14.0-CURRENT. I need to figure-out this BSD make and glues = you've mentioned to make this happen.

No -- the omission= is intentional: the library is meant to be used by the base system as a &q= uot;private library", which gives us the flexibility to not give a sta= ble API/ABI promise and to only build with options that the base system nee= ded (to reduce attack surface), so that when we make an update, it will be = a "wholesale" update and user applications are not broken, even i= f sqlite3 update have introduced one.=C2=A0 Users who want sqlite3 should r= eally install it from ports (databases/sqlite3) or package.

Oh I see, now I know its purpose. Curren= tly, I have my system installed with SQLite3 via package install 'pkg i= nstall sqlite3' and it works very well but because this time I want som= ething embeddable. It so happened that I was checking the source and surpri= singly found sqlite3. Anyway, let me explore and try.

<= div>Thanks and best regards,
Archimedes=C2=A0
--000000000000e1c76f05ed8cee9e-- From nobody Sat Nov 26 09:24:15 2022 X-Original-To: freebsd-database@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 4NK5s81GCRz4hydj for ; Sat, 26 Nov 2022 09:24:12 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-yb1-xb35.google.com (mail-yb1-xb35.google.com [IPv6:2607:f8b0:4864:20::b35]) (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 4NK5s72pbLz4QZY for ; Sat, 26 Nov 2022 09:24:11 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b="D30CzKk/"; spf=pass (mx1.freebsd.org: domain of archimedes.gaviola@gmail.com designates 2607:f8b0:4864:20::b35 as permitted sender) smtp.mailfrom=archimedes.gaviola@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-yb1-xb35.google.com with SMTP id 205so7641243ybf.6 for ; Sat, 26 Nov 2022 01:24:11 -0800 (PST) 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:message-id:reply-to; bh=2+YE9fg78aYNFsoWLiSsxKe12PFbV+WgR7SNU+XLqa4=; b=D30CzKk/oEdIQDvlKi+f2rWHTyx4Uv4IQqExGmthETBLvFAv34RPzJCqxoda0pNGb+ dQq3U1lpB81sdQAZxFsDsTRdFTPBYjYsN1Louwvf3M9NERqa7I8VITTHLyEb81RfhN2H KRG/TgUBtWrBKhpCYpjSYlvCn5H5r0IocFSBdrRNnnyIZ10MVKs43D/nbAPB3rz1/PAR ium0SuUt/qbAP4xwN+wJPXTKop66LCG5FXcFPrLNJjylYEnEee6mI9OyzwX6Wmuf2UHq w0vDFjnLXXEUiNNGByo5w5w/qATTc7tqUFgUaWOxYVFkF/A4aCKqYVBJFAxKTk1KgtQl jn1w== 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:message-id :reply-to; bh=2+YE9fg78aYNFsoWLiSsxKe12PFbV+WgR7SNU+XLqa4=; b=B5MrmkCDObp9BdTCduzbAUN4HwNwRHdKuu2ez9qRdupgbcLUc7fb2ZXphpbns1plIP 4AhNYJU3nL2g/9pKENwmcJ+t6dMKgMIOQ0F+dxcRISncQuvEuLdbYttmsPG5xKQ+hc6M BgKFFFx4S3xRZOn+lf4l+7bbAUA0ibmdk0jM1HrI3iYuCSur3eyNJlg6xjUXIDoW7J1I Jv0Un5pwFg+mYp3GvPt/JkP0al+poQzwMLPlvxKj4TdbjQqFA3FW1KWRPtH8jm+RRGSS 5AHQjHvaJ7REfMUnNEKb9XLxbC/jcFiz4nL7KslS+jgFh8FQH2pUC9YOlZAsL/e8oVgG 5GKw== X-Gm-Message-State: ANoB5pkaD8W/83q1VWC16Sum6eYgUPYLVMcX0k7j6Wjdho6yNfGDncBA woryXOgrgllOvaxIcEy/3gs2/qjq0F3K2DSGI+Ss25pfnss= X-Google-Smtp-Source: AA0mqf4U9nlGFtLxxdHKfgpbREXPPM3sfGxbfa/su41Q+J8vlr81epV9Q0428qtn5ZhrKSyqoCslgHx7gNmef5MNJRo= X-Received: by 2002:a5b:54f:0:b0:6e5:92af:572e with SMTP id r15-20020a5b054f000000b006e592af572emr37818408ybp.227.1669454650028; Sat, 26 Nov 2022 01:24:10 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Archimedes Gaviola Date: Sat, 26 Nov 2022 17:24:15 +0800 Message-ID: Subject: Re: Include SQLite3 source upon buildworld To: Xin LI Cc: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="0000000000006234a705ee5c33c4" X-Spamd-Result: default: False [-3.88 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.88)[-0.875]; 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]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; MLMMJ_DEST(0.00)[freebsd-database@freebsd.org]; ARC_NA(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::b35:from]; TO_MATCH_ENVRCPT_SOME(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; TAGGED_FROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; DKIM_TRACE(0.00)[gmail.com:+]; MID_RHS_MATCH_FROMTLD(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; RCVD_COUNT_TWO(0.00)[2]; RCPT_COUNT_TWO(0.00)[2]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_TO(0.00)[gmail.com]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_TLS_LAST(0.00)[] X-Rspamd-Queue-Id: 4NK5s72pbLz4QZY X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --0000000000006234a705ee5c33c4 Content-Type: text/plain; charset="UTF-8" On Wed, Nov 16, 2022 at 10:06 AM Archimedes Gaviola < archimedes.gaviola@gmail.com> wrote: > > > On Wed, Nov 16, 2022 at 1:48 AM Xin LI wrote: > >> >> >> On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola < >> archimedes.gaviola@gmail.com> wrote: >> >>> Hi, >>> >>> There's an SQLite3 source located in the /usr/src/contrib/sqlite3. Is >>> there a way to include this upon buildworld so that I can run the binary >>> after compiling? >>> >> > Hi Xin Li, > > >> Yes and no. >> >> Yes -- you can always compile shell.c source and link against the >> library; the code is there, just the BSD make build glues are missing. >> > > Okay, nice! I'm so glad that it can be done. My goal is to make SQLite3 be > part of the base system in a customized FreeBSD build to make it embedded. > I am checking the version and it's updated 3.93.3 as I'm using the > 14.0-CURRENT. I need to figure-out this BSD make and glues you've mentioned > to make this happen. > > No -- the omission is intentional: the library is meant to be used by the >> base system as a "private library", which gives us the flexibility to not >> give a stable API/ABI promise and to only build with options that the base >> system needed (to reduce attack surface), so that when we make an update, >> it will be a "wholesale" update and user applications are not broken, even >> if sqlite3 update have introduced one. Users who want sqlite3 should >> really install it from ports (databases/sqlite3) or package. >> > > Oh I see, now I know its purpose. Currently, I have my system installed > with SQLite3 via package install 'pkg install sqlite3' and it works very > well but because this time I want something embeddable. It so happened that > I was checking the source and surprisingly found sqlite3. Anyway, let me > explore and try. > > Thanks and best regards, > Archimedes > Hi Xin LI, I added the new sqlite3 folder in the /usr/src/usr.bin/sqlite3 with the Makefile file as content and then reference the /usr/src/contrib/sqlite3 directory as source. root@generic:/usr/src/usr.bin/sqlite3 # ls -la total 16 drwxr-xr-x 2 root wheel 512 Nov 26 12:46 . drwxr-xr-x 279 root wheel 5120 Nov 26 12:46 .. -rw-r--r-- 1 root wheel 295 Nov 26 16:50 Makefile root@generic:/usr/src/usr.bin/sqlite3 # cat Makefile # $FreeBSD$ .include SQLITE= ${SRCTOP}/contrib/sqlite3 .PATH: ${SQLITE} PROG= sqlite3 MK_MAN=no SRCS= sqlite3.c INCS= shell.c sqlite3.h WARNS?= 3 CFLAGS+= -I${SQLITE} \ -DSQLITE_THREADSAFE=0 \ -DSQLITE_OMIT_LOAD_EXTENSION .include and perform the 'make' command. However, I encountered this error -> ld: error: undefined symbol: main as referenced to the crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) file. root@generic:/usr/src/usr.bin/sqlite3 # make cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -MD -MF.depend.sqlite3.o -MTsqlite3.o -std=gnu99 -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=unused-but-set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef -Wno-address-of-packed-member -Qunused-arguments -c /usr/src/contrib/sqlite3/sqlite3.c -o sqlite3.o cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -std=gnu99 -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=unused-but-set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef -Wno-address-of-packed-member -Qunused-arguments -Wl,-zrelro -pie -o sqlite3.full sqlite3.o -L/usr/obj/usr/src/arm64.aarch64/lib/libthr -lpthread ld: error: undefined symbol: main >>> referenced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) >>> /usr/lib/Scrt1.o:(__start) cc: error: linker command failed with exit code 1 (use -v to see invocation) *** Error code 1 Stop. make: stopped in /usr/src/usr.bin/sqlite3 Not sure if I missed something or if something goes wrong with my Makefile content construction. I basically followed from here https://www.sqlite.org/howtocompile.html and then proved the source to compile successfully. root@generic:/usr/src/contrib/sqlite3 # pwd /usr/src/contrib/sqlite3 root@generic:/usr/src/contrib/sqlite3 # ls -lah total 11364 drwxr-xr-x 3 root wheel 1.0K Oct 27 08:06 . drwxr-xr-x 89 root wheel 2.0K Nov 26 13:01 .. -rw-r--r-- 1 root wheel 15K Oct 27 08:06 INSTALL -rw-r--r-- 1 root wheel 729B Oct 27 08:06 Makefile.am -rw-r--r-- 1 root wheel 547B Oct 27 08:06 Makefile.fallback -rw-r--r-- 1 root wheel 37K Oct 27 08:06 Makefile.in -rw-r--r-- 1 root wheel 28K Oct 27 08:06 Makefile.msc -rw-r--r-- 1 root wheel 3.5K Oct 27 08:06 README.txt -rw-r--r-- 1 root wheel 7.1K Oct 27 08:06 Replace.cs -rw-r--r-- 1 root wheel 365K Oct 27 08:06 aclocal.m4 -rwxr-xr-x 1 root wheel 7.2K Oct 27 08:06 compile -rwxr-xr-x 1 root wheel 48K Oct 27 08:06 config.guess -rwxr-xr-x 1 root wheel 35K Oct 27 08:06 config.sub -rwxr-xr-x 1 root wheel 485K Oct 27 08:06 configure -rw-r--r-- 1 root wheel 8.5K Oct 27 08:06 configure.ac -rwxr-xr-x 1 root wheel 23K Oct 27 08:06 depcomp -rwxr-xr-x 1 root wheel 15K Oct 27 08:06 install-sh -rwxr-xr-x 1 root wheel 320K Oct 27 08:06 ltmain.sh -rwxr-xr-x 1 root wheel 6.7K Oct 27 08:06 missing -rw-r--r-- 1 root wheel 717K Oct 27 08:06 shell.c -rw-r--r-- 1 root wheel 8.7K Oct 27 08:06 sqlite3.1 -rw-r--r-- 1 root wheel 8.2M Oct 27 08:06 sqlite3.c -rw-r--r-- 1 root wheel 599K Oct 27 08:06 sqlite3.h -rw-r--r-- 1 root wheel 267B Oct 27 08:06 sqlite3.pc.in -rw-r--r-- 1 root wheel 1.9K Oct 27 08:06 sqlite3.rc -rw-r--r-- 1 root wheel 36K Oct 27 08:06 sqlite3ext.h -rw-r--r-- 1 root wheel 78B Oct 27 08:06 sqlite3rc.h drwxr-xr-x 6 root wheel 512B Oct 27 08:06 tea root@generic:/usr/src/contrib/sqlite3 # cc -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite3.c -o sqlite3 I've manually invoked the first compilation command inside the sqlite3 source directory and it works just fine as seen below. root@generic:/usr/src/contrib/sqlite3 # cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -MD -MF.depend.sqlite3.o -MTsqlite3.o -std=gnu99 -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=unused-but-set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef -Wno-address-of-packed-member -Qunused-arguments -c /usr/src/contrib/sqlite3/sqlite3.c -o sqlite3.o The second compilation command below seems to break even when compiled manually. cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -std=gnu99 -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=unused-but-set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef -Wno-address-of-packed-member -Qunused-arguments -Wl,-zrelro -pie -o sqlite3.full sqlite3.o -L/usr/obj/usr/src/arm64.aarch64/lib/libthr -lpthread ld: error: undefined symbol: main >>> referenced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) >>> /usr/lib/Scrt1.o:(__start) cc: error: linker command failed with exit code 1 (use -v to see invocation) *** Error code 1 Stop. make: stopped in /usr/src/usr.bin/sqlite3 Just want to solicit if you have an idea of this particular problem or you might have encountered this problem before? Thanks and best regards, Archimedes > > --0000000000006234a705ee5c33c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Wed, Nov 16, 2022 at 10:06 AM Arch= imedes Gaviola <archimed= es.gaviola@gmail.com> wrote:


On Wed, Nov 16, 2= 022 at 1:48 AM Xin LI <delphij@gmail.com> wrote:


On Tue, Nov 15, 2022 at 5:16 AM Arch= imedes Gaviola <archimedes.gaviola@gmail.com> wrote:
Hi,

There's an SQLite3 source located in the=20 /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so= that I can run the binary after compiling?
<= /div>

Hi Xin Li,
=C2= =A0
Yes and no.

Yes -- you can always com= pile shell.c source and link against the library; the code is there, just t= he BSD make build glues are missing.
Okay, nice! I'm so glad that it can be done. My goal is to = make SQLite3 be part of the base system in a customized FreeBSD build to ma= ke it embedded. I am checking the version and it's updated 3.93.3 as I&= #39;m using the 14.0-CURRENT. I need to figure-out this BSD make and glues = you've mentioned to make this happen.

No -- the omission= is intentional: the library is meant to be used by the base system as a &q= uot;private library", which gives us the flexibility to not give a sta= ble API/ABI promise and to only build with options that the base system nee= ded (to reduce attack surface), so that when we make an update, it will be = a "wholesale" update and user applications are not broken, even i= f sqlite3 update have introduced one.=C2=A0 Users who want sqlite3 should r= eally install it from ports (databases/sqlite3) or package.

Oh I see, now I know its purpose. Curren= tly, I have my system installed with SQLite3 via package install 'pkg i= nstall sqlite3' and it works very well but because this time I want som= ething embeddable. It so happened that I was checking the source and surpri= singly found sqlite3. Anyway, let me explore and try.

<= div>Thanks and best regards,
Archimedes

Hi Xin LI,

I added the ne= w sqlite3 folder in the /usr/src/usr.bin/sqlite3 with the Makefile file as content and then reference the /usr/src/contrib/= sqlite3 directory as source.

root@generic:/usr= /src/usr.bin/sqlite3 # ls -la
total 16
drwxr-xr-x =C2=A0 =C2=A02 root= =C2=A0wheel =C2=A0 512 Nov 26 12:46 .
drwxr-xr-x =C2=A0279 root =C2=A0w= heel =C2=A05120 Nov 26 12:46 ..
-rw-r--r-- =C2=A0 =C2=A01 root =C2=A0whe= el =C2=A0 295 Nov 26 16:50 Makefile

root@generic:/usr/src/usr.bin/sq= lite3 # cat Makefile
# $FreeBSD$

.include <src.opts.mk>

SQLITE=3D ${SRCTOP}/contrib/sqlite3<= br>.PATH: =C2=A0${SQLITE}

PROG=3D sqlite3
MK_MAN=3Dno
SRCS=3D = sqlite3.c
INCS=3D shell.c sqlite3.h

WARNS?=3D 3
CFLAGS+=3D =C2= =A0 =C2=A0 =C2=A0 =C2=A0-I${SQLITE} \
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 -DSQLITE_THREADSAFE=3D0 \
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 -DSQLITE_OMIT_LOAD_EXTENSION

.includ= e <bsd.prog.mk>

=
and perform the 'make' command. However, I encountered t= his=20 error -> ld: error: undefined symbol: main as referenced to the crt1_c.c= :72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) file.

<= div>root@generic:/usr/src/usr.bin/sqlite3 # make
cc =C2=A0-O2 -pipe -fno= -common -I/usr/src/contrib/sqlite3 =C2=A0-DSQLITE_THREADSAFE=3D1 =C2=A0-DSQ= LITE_OMIT_LOAD_EXTENSION =C2=A0 -fPIE -g -gz=3Dzlib -MD =C2=A0-MF.depend.sq= lite3.o -MTsqlite3.o -std=3Dgnu99 -Wno-format-zero-length -fstack-protector= -strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-param= eter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitia= lized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-co= nst-variable -Wno-error=3Dunused-but-set-variable -Wno-tautological-compare= -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum= -conversion -Wno-unused-local-typedef -Wno-address-of-packed-member =C2=A0-= Qunused-arguments =C2=A0 =C2=A0-c /usr/src/contrib/sqlite3/sqlite3.c -o sql= ite3.o
cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THRE= ADSAFE=3D1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=3Dzlib -std=3Dgnu99 -W= no-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wa= ll -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-p= rototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-b= ody -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=3Dunused-but= -set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-= equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typede= f -Wno-address-of-packed-member -Qunused-arguments =C2=A0-Wl,-zrelro -pie = =C2=A0 -o sqlite3.full sqlite3.o =C2=A0-L/usr/obj/usr/src/arm64.aarch64/lib= /libthr -lpthread
ld: error: undefined symbol: main
>>> refe= renced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72)
>>>= ; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /usr/lib/Scrt1.o:(__star= t)
cc: error: linker command failed with exit code 1 (use -v to see invo= cation)
*** Error code 1

Stop.
make: stopped in /usr/src/usr.b= in/sqlite3

Not sure if I missed something or if so= mething goes wrong with my Makefile content construction. I basically follo= wed from here https://= www.sqlite.org/howtocompile.html and then proved the source to compile = successfully.

root@generic:/usr/src/contrib/sqlite= 3 # pwd
/usr/src/contrib/sqlite3
root@generic:/usr/src/contrib/sqlite= 3 # ls -lah
total 11364
drwxr-xr-x =C2=A0 3 root =C2=A0wheel =C2=A0 1= .0K Oct 27 08:06 .
drwxr-xr-x =C2=A089 root =C2=A0wheel =C2=A0 2.0K Nov = 26 13:01 ..
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A015K Oct 27= 08:06 INSTALL
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 729B Oct 27 0= 8:06 Makefile.am
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 547B Oct 27= 08:06 Makefile.fallback
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2= =A037K Oct 27 08:06 Makefile.in
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2= =A0 =C2=A028K Oct 27 08:06 Makefile.msc
-rw-r--r-- =C2=A0 1 root =C2=A0w= heel =C2=A0 3.5K Oct 27 08:06 README.txt
-rw-r--r-- =C2=A0 1 root =C2=A0= wheel =C2=A0 7.1K Oct 27 08:06 Replace.cs
-rw-r--r-- =C2=A0 1 root =C2= =A0wheel =C2=A0 365K Oct 27 08:06 aclocal.m4
-rwxr-xr-x =C2=A0 1 root = =C2=A0wheel =C2=A0 7.2K Oct 27 08:06 compile
-rwxr-xr-x =C2=A0 1 root = =C2=A0wheel =C2=A0 =C2=A048K Oct 27 08:06 config.guess
-rwxr-xr-x =C2=A0= 1 root =C2=A0wheel =C2=A0 =C2=A035K Oct 27 08:06 config.sub
-rwxr-xr-x = =C2=A0 1 root =C2=A0wheel =C2=A0 485K Oct 27 08:06 configure
-rw-r--r-- = =C2=A0 1 root =C2=A0wheel =C2=A0 8.5K Oct 27 08:06 configure.ac
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2= =A023K Oct 27 08:06 depcomp
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 = =C2=A015K Oct 27 08:06 install-sh
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel = =C2=A0 320K Oct 27 08:06 ltmain.sh
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel = =C2=A0 6.7K Oct 27 08:06 missing
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 717K Oct 27 08:06 shell.c
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 8.7K Oct 27 08:06 sqlite3.1
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 8.2M Oct 27 08:06 sqlite3.c
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 599K Oct 27 08:06 sqlite3.h
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 267B Oct 27 08:06 sqlite3.pc.in=
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 1.9K Oct 27 08:06 sqlite3.r= c
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A036K Oct 27 08:06 sql= ite3ext.h
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A078B Oct 27 0= 8:06 sqlite3rc.h
drwxr-xr-x =C2=A0 6 root =C2=A0wheel =C2=A0 512B Oct 27= 08:06 tea

root@generic:/usr/src/contrib/sqlit= e3 # cc -DSQLITE_THREADSAFE=3D0 -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite= 3.c -o sqlite3

I've manually invoked the first= compilation command inside the sqlite3 source directory and it works just = fine as seen below.

root@generic:/usr/src/cont= rib/sqlite3 # cc =C2=A0-O2 -pipe -fno-common =C2=A0 -I/usr/src/contrib/sqli= te3 =C2=A0-DSQLITE_THREADSAFE=3D0 =C2=A0-DSQLITE_OMIT_LOAD_EXTENSION -fPIE = -g -gz=3Dzlib -MD =C2=A0-MF.depend.sqlite3.o -MTsqlite3.o -std=3Dgnu99 -Wno= -format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wall= -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-pro= totypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-bod= y -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=3Dunused-but-s= et-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-eq= uality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef = -Wno-address-of-packed-member =C2=A0-Qunused-arguments -c /usr/src/contrib/= sqlite3/sqlite3.c -o sqlite3.o

The second compilat= ion command below seems to break even when compiled manually.
cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3=20 -DSQLITE_THREADSAFE=3D1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=3Dzlib=20 -std=3Dgnu99 -Wno-format-zero-length -fstack-protector-strong=20 -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter=20 -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith=20 -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body=20 -Wno-string-plus-int -Wno-unused-const-variable=20 -Wno-error=3Dunused-but-set-variable -Wno-tautological-compare=20 -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function=20 -Wno-enum-conversion -Wno-unused-local-typedef=20 -Wno-address-of-packed-member -Qunused-arguments =C2=A0-Wl,-zrelro -pie =C2= =A0 -o=20 sqlite3.full sqlite3.o =C2=A0-L/usr/obj/usr/src/arm64.aarch64/lib/libthr=20 -lpthread
ld: error: undefined symbol: main
>>> referenced b= y crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72)
>>> =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /usr/lib/Scrt1.o:(__start)
cc= : error: linker command failed with exit code 1 (use -v to see invocation)<= br>*** Error code 1

Stop.
make: stopped in /usr/src/usr.bin/sqlit= e3

Just want to solicit if you have an idea o= f this particular problem or you might have encountered this problem before= ?

Thanks and best regards,
Archimedes





=C2=A0
=C2=A0
<= /div>
--0000000000006234a705ee5c33c4-- From nobody Sat Nov 26 16:26:40 2022 X-Original-To: freebsd-database@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 4NKHDg4mdfz4hVrH for ; Sat, 26 Nov 2022 16:26:43 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Received: from mail-yw1-x112b.google.com (mail-yw1-x112b.google.com [IPv6:2607:f8b0:4864:20::112b]) (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 4NKHDf39Rlz40Jx for ; Sat, 26 Nov 2022 16:26:42 +0000 (UTC) (envelope-from archimedes.gaviola@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=WJVC75u+; spf=pass (mx1.freebsd.org: domain of archimedes.gaviola@gmail.com designates 2607:f8b0:4864:20::112b as permitted sender) smtp.mailfrom=archimedes.gaviola@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-36cbcda2157so67159407b3.11 for ; Sat, 26 Nov 2022 08:26:42 -0800 (PST) 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:message-id:reply-to; bh=yPKUhG1KaG4fQpsa6W3Iw8mgLE6HdWfPnW4Ar51vTUU=; b=WJVC75u+BixzbsbieEXy7xFL8jfbnlXf+Je0v4OAJBNUawksQQ56R7qNJqB5RHbmz5 0qb++KHJzSucbNCTi1w5E+WvrwLwbpa0IaBqQoYidwQ4tNysuTHDg3URnL6QLF528s4O f/pa4e1LZk2EZftQfl0FJeGzeOIxo0EBXBfdpI5BW9p+Hu1jKnlazUXKTxuywROurydM 37/sb+gJCwRY2Ekq/n8w2kzgVRJEsLvMXuN832WoYSW24vqe2ATsq9G8yBalges9kHSH ER8QfeA0rGNiX3If15oy4pwN3Akea4uTNBnxAa/Lz8hV+DHg3kIH3dzkO87c8VuhhIHh rrDg== 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:message-id :reply-to; bh=yPKUhG1KaG4fQpsa6W3Iw8mgLE6HdWfPnW4Ar51vTUU=; b=D8gFS7LFmooYhCr9NHJFv2qO3eELSD0WGtk9J9tFMgCpIYxn7Gdffnqdp2DKpV1BoL Gkyc9UNZmFbnh28uzmEcWqLDMeBaHmnMiBoYJ0rpEPSJYDv7JgVRa3dLzBnNjyFVCtRj vcyJ+KnKORPpXblbnJ/bmiYVf83m/3nGn2w4Xt+BVkqhQTA39CjDNQ90lK3MiaElFwNQ JOinWxXlv0Rj3Wz6AeGWFDK5ix5Ww4JBwwFmdjZtEtaWZzYajm42xXvUzHqn66iSQMMt YfXkRMStF1Z3YZaJsCt4TxzMQo/nuxTttvyoPfGLEFWn6PoaCD+9Ud/tuaP0oflQmVeu uW1A== X-Gm-Message-State: ANoB5pl9In72RqFjf6Siq2sfO/Eb6Y5bYQ6woxGuwfpX3nrWpjHrZhfC IAxFXeV2CbQK3hLEUwcTC88MuZd+3S7MjFqOHb8= X-Google-Smtp-Source: AA0mqf7nRrZLmyZFnzyS7QA1Gof7WkQ265Zz4AuOgQxIPJpP5zxD5RsUKAY2tBQNFh1aCVMZf2v4RGa67dSwqfzqeDs= X-Received: by 2002:a0d:d481:0:b0:3a5:9a11:db48 with SMTP id w123-20020a0dd481000000b003a59a11db48mr24435644ywd.138.1669479995011; Sat, 26 Nov 2022 08:26:35 -0800 (PST) List-Id: Database use and development under FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-database List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-database@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Archimedes Gaviola Date: Sun, 27 Nov 2022 00:26:40 +0800 Message-ID: Subject: Re: Include SQLite3 source upon buildworld To: Xin LI Cc: freebsd-database@freebsd.org Content-Type: multipart/alternative; boundary="0000000000000ff9f905ee621a92" X-Spamd-Result: default: False [-3.98 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.98)[-0.979]; 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]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; FROM_HAS_DN(0.00)[]; ARC_NA(0.00)[]; TO_DN_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::112b:from]; TO_MATCH_ENVRCPT_SOME(0.00)[]; TAGGED_FROM(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; DKIM_TRACE(0.00)[gmail.com:+]; MID_RHS_MATCH_FROMTLD(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; MLMMJ_DEST(0.00)[freebsd-database@freebsd.org]; RCPT_COUNT_TWO(0.00)[2]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_TO(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_TLS_LAST(0.00)[]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4NKHDf39Rlz40Jx X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --0000000000000ff9f905ee621a92 Content-Type: text/plain; charset="UTF-8" On Sat, Nov 26, 2022 at 5:24 PM Archimedes Gaviola < archimedes.gaviola@gmail.com> wrote: > > > On Wed, Nov 16, 2022 at 10:06 AM Archimedes Gaviola < > archimedes.gaviola@gmail.com> wrote: > >> >> >> On Wed, Nov 16, 2022 at 1:48 AM Xin LI wrote: >> >>> >>> >>> On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola < >>> archimedes.gaviola@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> There's an SQLite3 source located in the /usr/src/contrib/sqlite3. Is >>>> there a way to include this upon buildworld so that I can run the binary >>>> after compiling? >>>> >>> >> Hi Xin Li, >> >> >>> Yes and no. >>> >>> Yes -- you can always compile shell.c source and link against the >>> library; the code is there, just the BSD make build glues are missing. >>> >> >> Okay, nice! I'm so glad that it can be done. My goal is to make SQLite3 >> be part of the base system in a customized FreeBSD build to make it >> embedded. I am checking the version and it's updated 3.93.3 as I'm using >> the 14.0-CURRENT. I need to figure-out this BSD make and glues you've >> mentioned to make this happen. >> >> No -- the omission is intentional: the library is meant to be used by the >>> base system as a "private library", which gives us the flexibility to not >>> give a stable API/ABI promise and to only build with options that the base >>> system needed (to reduce attack surface), so that when we make an update, >>> it will be a "wholesale" update and user applications are not broken, even >>> if sqlite3 update have introduced one. Users who want sqlite3 should >>> really install it from ports (databases/sqlite3) or package. >>> >> >> Oh I see, now I know its purpose. Currently, I have my system installed >> with SQLite3 via package install 'pkg install sqlite3' and it works very >> well but because this time I want something embeddable. It so happened that >> I was checking the source and surprisingly found sqlite3. Anyway, let me >> explore and try. >> >> Thanks and best regards, >> Archimedes >> > > Hi Xin LI, > > I added the new sqlite3 folder in the /usr/src/usr.bin/sqlite3 with the > Makefile file as content and then reference the /usr/src/contrib/sqlite3 > directory as source. > > root@generic:/usr/src/usr.bin/sqlite3 # ls -la > total 16 > drwxr-xr-x 2 root wheel 512 Nov 26 12:46 . > drwxr-xr-x 279 root wheel 5120 Nov 26 12:46 .. > -rw-r--r-- 1 root wheel 295 Nov 26 16:50 Makefile > > root@generic:/usr/src/usr.bin/sqlite3 # cat Makefile > # $FreeBSD$ > > .include > > SQLITE= ${SRCTOP}/contrib/sqlite3 > .PATH: ${SQLITE} > > PROG= sqlite3 > MK_MAN=no > SRCS= sqlite3.c > INCS= shell.c sqlite3.h > > WARNS?= 3 > CFLAGS+= -I${SQLITE} \ > -DSQLITE_THREADSAFE=0 \ > -DSQLITE_OMIT_LOAD_EXTENSION > > .include > > and perform the 'make' command. However, I encountered this error -> ld: > error: undefined symbol: main as referenced to the crt1_c.c:72 > (/usr/src/lib/csu/aarch64/crt1_c.c:72) file. > > root@generic:/usr/src/usr.bin/sqlite3 # make > cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 > -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib > -MD -MF.depend.sqlite3.o -MTsqlite3.o -std=gnu99 -Wno-format-zero-length > -fstack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W > -Wno-unused-parameter -Wstrict-prototypes -Wmissing-prototypes > -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body > -Wno-string-plus-int -Wno-unused-const-variable > -Wno-error=unused-but-set-variable -Wno-tautological-compare > -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function > -Wno-enum-conversion -Wno-unused-local-typedef > -Wno-address-of-packed-member -Qunused-arguments -c > /usr/src/contrib/sqlite3/sqlite3.c -o sqlite3.o > cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=1 > -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -std=gnu99 > -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror > -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes > -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign > -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable > -Wno-error=unused-but-set-variable -Wno-tautological-compare > -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function > -Wno-enum-conversion -Wno-unused-local-typedef > -Wno-address-of-packed-member -Qunused-arguments -Wl,-zrelro -pie -o > sqlite3.full sqlite3.o -L/usr/obj/usr/src/arm64.aarch64/lib/libthr > -lpthread > ld: error: undefined symbol: main > >>> referenced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) > >>> /usr/lib/Scrt1.o:(__start) > cc: error: linker command failed with exit code 1 (use -v to see > invocation) > *** Error code 1 > > Stop. > make: stopped in /usr/src/usr.bin/sqlite3 > > Not sure if I missed something or if something goes wrong with my Makefile > content construction. I basically followed from here > https://www.sqlite.org/howtocompile.html and then proved the source to > compile successfully. > > root@generic:/usr/src/contrib/sqlite3 # pwd > /usr/src/contrib/sqlite3 > root@generic:/usr/src/contrib/sqlite3 # ls -lah > total 11364 > drwxr-xr-x 3 root wheel 1.0K Oct 27 08:06 . > drwxr-xr-x 89 root wheel 2.0K Nov 26 13:01 .. > -rw-r--r-- 1 root wheel 15K Oct 27 08:06 INSTALL > -rw-r--r-- 1 root wheel 729B Oct 27 08:06 Makefile.am > -rw-r--r-- 1 root wheel 547B Oct 27 08:06 Makefile.fallback > -rw-r--r-- 1 root wheel 37K Oct 27 08:06 Makefile.in > -rw-r--r-- 1 root wheel 28K Oct 27 08:06 Makefile.msc > -rw-r--r-- 1 root wheel 3.5K Oct 27 08:06 README.txt > -rw-r--r-- 1 root wheel 7.1K Oct 27 08:06 Replace.cs > -rw-r--r-- 1 root wheel 365K Oct 27 08:06 aclocal.m4 > -rwxr-xr-x 1 root wheel 7.2K Oct 27 08:06 compile > -rwxr-xr-x 1 root wheel 48K Oct 27 08:06 config.guess > -rwxr-xr-x 1 root wheel 35K Oct 27 08:06 config.sub > -rwxr-xr-x 1 root wheel 485K Oct 27 08:06 configure > -rw-r--r-- 1 root wheel 8.5K Oct 27 08:06 configure.ac > -rwxr-xr-x 1 root wheel 23K Oct 27 08:06 depcomp > -rwxr-xr-x 1 root wheel 15K Oct 27 08:06 install-sh > -rwxr-xr-x 1 root wheel 320K Oct 27 08:06 ltmain.sh > -rwxr-xr-x 1 root wheel 6.7K Oct 27 08:06 missing > -rw-r--r-- 1 root wheel 717K Oct 27 08:06 shell.c > -rw-r--r-- 1 root wheel 8.7K Oct 27 08:06 sqlite3.1 > -rw-r--r-- 1 root wheel 8.2M Oct 27 08:06 sqlite3.c > -rw-r--r-- 1 root wheel 599K Oct 27 08:06 sqlite3.h > -rw-r--r-- 1 root wheel 267B Oct 27 08:06 sqlite3.pc.in > -rw-r--r-- 1 root wheel 1.9K Oct 27 08:06 sqlite3.rc > -rw-r--r-- 1 root wheel 36K Oct 27 08:06 sqlite3ext.h > -rw-r--r-- 1 root wheel 78B Oct 27 08:06 sqlite3rc.h > drwxr-xr-x 6 root wheel 512B Oct 27 08:06 tea > > root@generic:/usr/src/contrib/sqlite3 # cc -DSQLITE_THREADSAFE=0 > -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite3.c -o sqlite3 > > I've manually invoked the first compilation command inside the sqlite3 > source directory and it works just fine as seen below. > > root@generic:/usr/src/contrib/sqlite3 # cc -O2 -pipe -fno-common > -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=0 > -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -MD -MF.depend.sqlite3.o > -MTsqlite3.o -std=gnu99 -Wno-format-zero-length -fstack-protector-strong > -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter > -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized > -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int > -Wno-unused-const-variable -Wno-error=unused-but-set-variable > -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-equality > -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typedef > -Wno-address-of-packed-member -Qunused-arguments -c > /usr/src/contrib/sqlite3/sqlite3.c -o sqlite3.o > > The second compilation command below seems to break even when compiled > manually. > > cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THREADSAFE=1 > -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=zlib -std=gnu99 > -Wno-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror > -Wall -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes > -Wmissing-prototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign > -Wno-empty-body -Wno-string-plus-int -Wno-unused-const-variable > -Wno-error=unused-but-set-variable -Wno-tautological-compare > -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function > -Wno-enum-conversion -Wno-unused-local-typedef > -Wno-address-of-packed-member -Qunused-arguments -Wl,-zrelro -pie -o > sqlite3.full sqlite3.o -L/usr/obj/usr/src/arm64.aarch64/lib/libthr > -lpthread > ld: error: undefined symbol: main > >>> referenced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) > >>> /usr/lib/Scrt1.o:(__start) > cc: error: linker command failed with exit code 1 (use -v to see > invocation) > *** Error code 1 > > Stop. > make: stopped in /usr/src/usr.bin/sqlite3 > > Just want to solicit if you have an idea of this particular problem or you > might have encountered this problem before? > > Thanks and best regards, > Archimedes > Hi Xin Li, Kindly ignore my query as it has been resolved as I've posted recently here https://lists.freebsd.org/archives/freebsd-current/2022-November/002905.html . Thanks and best regards, Archimedes > > > > > > > > >> >> > --0000000000000ff9f905ee621a92 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Sat, Nov 26, 2022 at 5:24 PM Archi= medes Gaviola <archimede= s.gaviola@gmail.com> wrote:


On Wed, Nov 16, 20= 22 at 10:06 AM Archimedes Gaviola <archimedes.gaviola@gmail.com> wrote:
<= div dir=3D"ltr">

On Wed, Nov 16, 2022 at 1:48 AM Xin LI <delphij@gmail.com> wrote:=


On Tue, Nov 15, 2022 at 5:16 AM Archimedes Gaviola <archimedes.gaviola@gmail.com= > wrote:
=
Hi,

There's an SQLite3 s= ource located in the=20 /usr/src/contrib/sqlite3. Is there a way to include this upon buildworld so= that I can run the binary after compiling?
<= /div>

Hi Xin Li,
=C2= =A0
Yes and no.

Yes -- you can always com= pile shell.c source and link against the library; the code is there, just t= he BSD make build glues are missing.
Okay, nice! I'm so glad that it can be done. My goal is to = make SQLite3 be part of the base system in a customized FreeBSD build to ma= ke it embedded. I am checking the version and it's updated 3.93.3 as I&= #39;m using the 14.0-CURRENT. I need to figure-out this BSD make and glues = you've mentioned to make this happen.

No -- the omission= is intentional: the library is meant to be used by the base system as a &q= uot;private library", which gives us the flexibility to not give a sta= ble API/ABI promise and to only build with options that the base system nee= ded (to reduce attack surface), so that when we make an update, it will be = a "wholesale" update and user applications are not broken, even i= f sqlite3 update have introduced one.=C2=A0 Users who want sqlite3 should r= eally install it from ports (databases/sqlite3) or package.

Oh I see, now I know its purpose. Curren= tly, I have my system installed with SQLite3 via package install 'pkg i= nstall sqlite3' and it works very well but because this time I want som= ething embeddable. It so happened that I was checking the source and surpri= singly found sqlite3. Anyway, let me explore and try.

<= div>Thanks and best regards,
Archimedes

Hi Xin LI,

I added the ne= w sqlite3 folder in the /usr/src/usr.bin/sqlite3 with the Makefile file as content and then reference the /usr/src/contrib/= sqlite3 directory as source.

root@generic:/usr= /src/usr.bin/sqlite3 # ls -la
total 16
drwxr-xr-x =C2=A0 =C2=A02 root= =C2=A0wheel =C2=A0 512 Nov 26 12:46 .
drwxr-xr-x =C2=A0279 root =C2=A0w= heel =C2=A05120 Nov 26 12:46 ..
-rw-r--r-- =C2=A0 =C2=A01 root =C2=A0whe= el =C2=A0 295 Nov 26 16:50 Makefile

root@generic:/usr/src/usr.bin/sq= lite3 # cat Makefile
# $FreeBSD$

.include <src.opts.mk>

SQLITE=3D ${SRCTOP= }/contrib/sqlite3
.PATH: =C2=A0${SQLITE}

PROG=3D sqlite3
MK_MA= N=3Dno
SRCS=3D sqlite3.c
INCS=3D shell.c sqlite3.h

WARNS?=3D 3=
CFLAGS+=3D =C2=A0 =C2=A0 =C2=A0 =C2=A0-I${SQLITE} \
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 -DSQLITE_THREADSAFE=3D0 \
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 -DSQLITE_OMIT_LOAD_EXT= ENSION

.include <bsd.prog.mk>

and perform the 'make= ' command. However, I encountered this=20 error -> ld: error: undefined symbol: main as referenced to the crt1_c.c= :72 (/usr/src/lib/csu/aarch64/crt1_c.c:72) file.

<= div>root@generic:/usr/src/usr.bin/sqlite3 # make
cc =C2=A0-O2 -pipe -fno= -common -I/usr/src/contrib/sqlite3 =C2=A0-DSQLITE_THREADSAFE=3D1 =C2=A0-DSQ= LITE_OMIT_LOAD_EXTENSION =C2=A0 -fPIE -g -gz=3Dzlib -MD =C2=A0-MF.depend.sq= lite3.o -MTsqlite3.o -std=3Dgnu99 -Wno-format-zero-length -fstack-protector= -strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-param= eter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith -Wno-uninitia= lized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -Wno-unused-co= nst-variable -Wno-error=3Dunused-but-set-variable -Wno-tautological-compare= -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function -Wno-enum= -conversion -Wno-unused-local-typedef -Wno-address-of-packed-member =C2=A0-= Qunused-arguments =C2=A0 =C2=A0-c /usr/src/contrib/sqlite3/sqlite3.c -o sql= ite3.o
cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3 -DSQLITE_THRE= ADSAFE=3D1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=3Dzlib -std=3Dgnu99 -W= no-format-zero-length -fstack-protector-strong -Wsystem-headers -Werror -Wa= ll -Wno-format-y2k -W -Wno-unused-parameter -Wstrict-prototypes -Wmissing-p= rototypes -Wpointer-arith -Wno-uninitialized -Wno-pointer-sign -Wno-empty-b= ody -Wno-string-plus-int -Wno-unused-const-variable -Wno-error=3Dunused-but= -set-variable -Wno-tautological-compare -Wno-unused-value -Wno-parentheses-= equality -Wno-unused-function -Wno-enum-conversion -Wno-unused-local-typede= f -Wno-address-of-packed-member -Qunused-arguments =C2=A0-Wl,-zrelro -pie = =C2=A0 -o sqlite3.full sqlite3.o =C2=A0-L/usr/obj/usr/src/arm64.aarch64/lib= /libthr -lpthread
ld: error: undefined symbol: main
>>> refe= renced by crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72)
>>>= ; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /usr/lib/Scrt1.o:(__star= t)
cc: error: linker command failed with exit code 1 (use -v to see invo= cation)
*** Error code 1

Stop.
make: stopped in /usr/src/usr.b= in/sqlite3

Not sure if I missed something or if so= mething goes wrong with my Makefile content construction. I basically follo= wed from here https://www.sqlite.org/howtocompile.html and then proved th= e source to compile successfully.

root@generic:/us= r/src/contrib/sqlite3 # pwd
/usr/src/contrib/sqlite3
root@generic:/us= r/src/contrib/sqlite3 # ls -lah
total 11364
drwxr-xr-x =C2=A0 3 root = =C2=A0wheel =C2=A0 1.0K Oct 27 08:06 .
drwxr-xr-x =C2=A089 root =C2=A0wh= eel =C2=A0 2.0K Nov 26 13:01 ..
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2= =A0 =C2=A015K Oct 27 08:06 INSTALL
-rw-r--r-- =C2=A0 1 root =C2=A0wheel = =C2=A0 729B Oct 27 08:06 Makefile.am
-rw-r--r-- =C2=A0 1 root =C2=A0whee= l =C2=A0 547B Oct 27 08:06 Makefile.fallback
-rw-r--r-- =C2=A0 1 root = =C2=A0wheel =C2=A0 =C2=A037K Oct 27 08:06 Makefile.in
-rw-r--r-- =C2=A0 = 1 root =C2=A0wheel =C2=A0 =C2=A028K Oct 27 08:06 Makefile.msc
-rw-r--r--= =C2=A0 1 root =C2=A0wheel =C2=A0 3.5K Oct 27 08:06 README.txt
-rw-r--r-= - =C2=A0 1 root =C2=A0wheel =C2=A0 7.1K Oct 27 08:06 Replace.cs
-rw-r--r= -- =C2=A0 1 root =C2=A0wheel =C2=A0 365K Oct 27 08:06 aclocal.m4
-rwxr-x= r-x =C2=A0 1 root =C2=A0wheel =C2=A0 7.2K Oct 27 08:06 compile
-rwxr-xr-= x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A048K Oct 27 08:06 config.guess
-= rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A035K Oct 27 08:06 config.su= b
-rwxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 485K Oct 27 08:06 configur= e
-rw-r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 8.5K Oct 27 08:06 configure.ac
-rwxr-xr-x = =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A023K Oct 27 08:06 depcomp
-rwxr-xr= -x =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A015K Oct 27 08:06 install-sh
-r= wxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 320K Oct 27 08:06 ltmain.sh
-r= wxr-xr-x =C2=A0 1 root =C2=A0wheel =C2=A0 6.7K Oct 27 08:06 missing
-rw-= r--r-- =C2=A0 1 root =C2=A0wheel =C2=A0 717K Oct 27 08:06 shell.c
-rw-r-= -r-- =C2=A0 1 root =C2=A0wheel =C2=A0 8.7K Oct 27 08:06 sqlite3.1
-rw-r-= -r-- =C2=A0 1 root =C2=A0wheel =C2=A0 8.2M Oct 27 08:06 sqlite3.c
-rw-r-= -r-- =C2=A0 1 root =C2=A0wheel =C2=A0 599K Oct 27 08:06 sqlite3.h
-rw-r-= -r-- =C2=A0 1 root =C2=A0wheel =C2=A0 267B Oct 27 08:06 sqlite3.pc.in
-rw-r--r-- =C2=A0 1 ro= ot =C2=A0wheel =C2=A0 1.9K Oct 27 08:06 sqlite3.rc
-rw-r--r-- =C2=A0 1 r= oot =C2=A0wheel =C2=A0 =C2=A036K Oct 27 08:06 sqlite3ext.h
-rw-r--r-- = =C2=A0 1 root =C2=A0wheel =C2=A0 =C2=A078B Oct 27 08:06 sqlite3rc.h
drwx= r-xr-x =C2=A0 6 root =C2=A0wheel =C2=A0 512B Oct 27 08:06 tea

root@generic:/usr/src/contrib/sqlite3 # cc -DSQLITE_THREADS= AFE=3D0 -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite3.c -o sqlite3

I've manually invoked the first compilation command ins= ide the sqlite3 source directory and it works just fine as seen below.
<= /div>

root@generic:/usr/src/contrib/sqlite3 # cc =C2=A0-= O2 -pipe -fno-common =C2=A0 -I/usr/src/contrib/sqlite3 =C2=A0-DSQLITE_THREA= DSAFE=3D0 =C2=A0-DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=3Dzlib -MD =C2=A0= -MF.depend.sqlite3.o -MTsqlite3.o -std=3Dgnu99 -Wno-format-zero-length -fst= ack-protector-strong -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno= -unused-parameter -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith = -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body -Wno-string-plus-int -= Wno-unused-const-variable -Wno-error=3Dunused-but-set-variable -Wno-tautolo= gical-compare -Wno-unused-value -Wno-parentheses-equality -Wno-unused-funct= ion -Wno-enum-conversion -Wno-unused-local-typedef -Wno-address-of-packed-m= ember =C2=A0-Qunused-arguments -c /usr/src/contrib/sqlite3/sqlite3.c -o sql= ite3.o

The second compilation command below seems = to break even when compiled manually.

cc -O2 -pipe -fno-common -I/usr/src/contrib/sqlite3=20 -DSQLITE_THREADSAFE=3D1 -DSQLITE_OMIT_LOAD_EXTENSION -fPIE -g -gz=3Dzlib=20 -std=3Dgnu99 -Wno-format-zero-length -fstack-protector-strong=20 -Wsystem-headers -Werror -Wall -Wno-format-y2k -W -Wno-unused-parameter=20 -Wstrict-prototypes -Wmissing-prototypes -Wpointer-arith=20 -Wno-uninitialized -Wno-pointer-sign -Wno-empty-body=20 -Wno-string-plus-int -Wno-unused-const-variable=20 -Wno-error=3Dunused-but-set-variable -Wno-tautological-compare=20 -Wno-unused-value -Wno-parentheses-equality -Wno-unused-function=20 -Wno-enum-conversion -Wno-unused-local-typedef=20 -Wno-address-of-packed-member -Qunused-arguments =C2=A0-Wl,-zrelro -pie =C2= =A0 -o=20 sqlite3.full sqlite3.o =C2=A0-L/usr/obj/usr/src/arm64.aarch64/lib/libthr=20 -lpthread
ld: error: undefined symbol: main
>>> referenced b= y crt1_c.c:72 (/usr/src/lib/csu/aarch64/crt1_c.c:72)
>>> =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /usr/lib/Scrt1.o:(__start)
cc= : error: linker command failed with exit code 1 (use -v to see invocation)<= br>*** Error code 1

Stop.
make: stopped in /usr/src/usr.bin/sqlit= e3

Just want to solicit if you have an idea o= f this particular problem or you might have encountered this problem before= ?

Thanks and best regards,
Archimedes

Hi Xin Li,
Kindly ignore my query as it has been resolved as I've pos= ted recently here https://lists.freebsd.org/archives/freebsd-= current/2022-November/002905.html.

Thanks = and best regards,
Archimedes
=C2=A0




=


=C2=A0
=C2=A0
--0000000000000ff9f905ee621a92--