NetBSD Problem Report #51947
From tsutsui@ceres.dti.ne.jp Sun Feb 5 12:47:26 2017
Return-Path: <tsutsui@ceres.dti.ne.jp>
Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200])
(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
(Client CN "mail.netbsd.org", Issuer "Postmaster NetBSD.org" (verified OK))
by mollari.NetBSD.org (Postfix) with ESMTPS id DBE497A283
for <gnats-bugs@gnats.NetBSD.org>; Sun, 5 Feb 2017 12:47:26 +0000 (UTC)
Message-Id: <201702051247.v15ClJhl020774@ceres.dti.ne.jp>
Date: Sun, 5 Feb 2017 21:47:19 +0900 (JST)
From: Izumi Tsutsui <tsutsui@ceres.dti.ne.jp>
Reply-To: tsutsui@ceres.dti.ne.jp
To: gnats-bugs@NetBSD.org
Cc: tsutsui@ceres.dti.ne.jp
Subject: more pkgsrc sqlite3 features for firefox
X-Send-Pr-Version: 3.95
>Number: 51947
>Category: pkg
>Synopsis: more pkgsrc sqlite3 features for firefox
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: pkg-manager
>State: closed
>Class: change-request
>Submitter-Id: net
>Arrival-Date: Sun Feb 05 12:50:00 +0000 2017
>Closed-Date: Fri Dec 23 13:02:39 +0000 2022
>Last-Modified: Fri Dec 23 13:02:39 +0000 2022
>Originator: Izumi Tsutsui
>Release: NetBSD 7.1_RC1 + pkgsrc-2016Q4
>Organization:
>Environment:
System: NetBSD mirage 7.1_RC1 NetBSD 7.1_RC1 (GENERIC.201701060741Z) i386
Architecture: i386
Machine: i386
>Description:
Currently www/firefox use internal sqlite3 instead of pkgsrc sqlite3,
probably because pkgsrc one does not enable features
(SQLITE_SECURE_DELETE and SQLITE_ENABLE_DBSTAT_VTAB)
required by firefox. It would be worth to enable them in pkgsrc sqlite3.
Per "Compile-time Options" document https://www.sqlite.org/compile.html
SQLITE_SECURE_DELETE is in "Options To Control Operating Characteristics"
and SQLITE_ENABLE_DBSTAT_VTAB is in "Options To Enable Features Normally
Turned Off."
I'm not sure if these options affect other packages that depend on
pkgsrc sqlite3, though.
>How-To-Repeat:
N/A (change request)
>Fix:
pkgsrc/database/sqlite3 (3.16.2 in HEAD) with the following patch allows
firefox builds with --enable-system-sqlite.
(BTW py-sqlite2 and other python version definitions in mozilla-common.mk
seem obsolete)
Other packages that refer common sqlite3/Makefile.version might also
want PKGREVISION bump.
Index: Makefile
===================================================================
RCS file: /cvsroot/pkgsrc/databases/sqlite3/Makefile,v
retrieving revision 1.113
diff -u -p -r1.113 Makefile
--- Makefile 2 Jan 2017 17:52:23 -0000 1.113
+++ Makefile 5 Feb 2017 12:10:15 -0000
@@ -5,6 +5,7 @@
.include "Makefile.common"
PKGNAME= sqlite3-${SQLITE3_VERSION}
+PKGREVISION= 1
CATEGORIES= databases
MAINTAINER= pkgsrc-users@NetBSD.org
@@ -36,6 +37,9 @@ CFLAGS+= -DSQLITE_ENABLE_LOCKING_STYLE=
# This define includes the sqlite3_unlock_notify() API in the build.
# It is required by Firefox 4.x.
CFLAGS+= -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
+# Firefox requires SECURE_DELETE and DBSTAT_VTAB.
+CFLAGS+= -DSQLITE_SECURE_DELETE
+CFLAGS+= -DSQLITE_ENABLE_DBSTAT_VTAB
# The following are defined in the NetBSD builtin version.
CFLAGS+= -DSQLITE_ENABLE_COLUMN_METADATA
CFLAGS+= -DSQLITE_ENABLE_LOAD_EXTENSION
>Release-Note:
>Audit-Trail:
State-Changed-From-To: open->closed
State-Changed-By: tsutsui@NetBSD.org
State-Changed-When: Fri, 23 Dec 2022 13:02:39 +0000
State-Changed-Why:
wontfix
>Unformatted:
(Contact us)
$NetBSD: query-full-pr,v 1.47 2022/09/11 19:34:41 kim Exp $
$NetBSD: gnats_config.sh,v 1.9 2014/08/02 14:16:04 spz Exp $
Copyright © 1994-2022
The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.