Package Details: sqlite2 2.8.17-10

Git Clone URL: https://aur.archlinux.org/sqlite2.git (read-only, click to copy)
Package Base: sqlite2
Description: A C library that implements an SQL database engine
Upstream URL: http://www.sqlite.org/
Licenses: custom
Submitter: City-busz
Maintainer: not_anonymous
Last Packager: not_anonymous
Votes: 15
Popularity: 0.048174
First Submitted: 2017-06-29 12:23 (UTC)
Last Updated: 2021-06-07 22:55 (UTC)

Dependencies (1)

Required by (3)

Sources (3)

Latest Comments

not_anonymous commented on 2021-06-11 20:13 (UTC)

Please consider using the following;

$ sudo grep -i cflag -r /etc/makepkg.conf CFLAGS="-march=x86-64 -mtune=generic -O2 -pipe -fstack-protector-strong" DEBUG_CFLAGS="-g -fvar-tracking-assignments"

TIA

(I compiled successfully 4 days ago....)

kfgz commented on 2021-06-11 15:24 (UTC)

It doesn't bulid. Error log:

https://pastebin.com/ac02vwyT

not_anonymous commented on 2021-06-07 22:57 (UTC)

Thank you moyamo for the patch in line 695 of the src/shell.c file. It IS now incorporated into the package !

amuze commented on 2021-06-06 08:19 (UTC) (edited on 2021-06-06 08:19 (UTC) by amuze)

Can confirm this does not compile. @not_anonymous please apply the patch indicated below and update the AUR.

moyamo commented on 2021-05-30 19:56 (UTC)

This patch fixes the issue

From f10c6b7eec2db88a096baf278ff5cc1ca2e6fd56 Mon Sep 17 00:00:00 2001
From: Yaseen Mowzer <yaseen@mowzer.co.za>
Date: Sun, 30 May 2021 21:42:57 +0200
Subject: [PATCH] Fix "[-Werror=format-security]" when trying to build

If you try to makepkg you get the following error

./src/shell.c:695:20: error: format not a string literal and no format arguments [-Werror=format-security]
  695 |     fprintf(stderr,zHelp);
      |                    ^~~~~
cc1: some warnings being treated as errors
make: *** [Makefile:199: sqlite] Error 1
---
 PKGBUILD              | 10 +++++++++-
 format_security.patch | 11 +++++++++++
 2 files changed, 20 insertions(+), 1 deletion(-)
 create mode 100644 format_security.patch

diff --git a/PKGBUILD b/PKGBUILD
index f918035..337cbd5 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -10,9 +10,15 @@ arch=('i686' 'x86_64')
 url="http://www.sqlite.org/"
 depends=('readline>=6.0.00')
 license=('custom')
-source=("https://www.sqlite.org/sqlite-$pkgver.tar.gz" 
+source=("https://www.sqlite.org/sqlite-$pkgver.tar.gz"
+        'format_security.patch'
         'LICENSE')

+prepare() {
+  cd "${srcdir}/sqlite-${pkgver}"
+  patch -Np1 < '../format_security.patch'
+}
+
 build() {
   cd ${srcdir}/sqlite-${pkgver}

@@ -30,6 +36,8 @@ package() {
    ${pkgdir}/usr/share/licenses/${pkgname}/LICENSE 
 }
 md5sums=('838dbac20b56d2c4292e98848505a05b'
+         '05a70d51e3c8104b8694b2765fab29e3'
          '5d3b333e59a37747284f66081660f8a1')
 sha256sums=('3f35ebfb67867fb5b583a03e480f900206af637efe7179b32294a6a0cf806f37'
+            'e1c9cf5c6062f8bdd30d9b68c9ff0c6aa95438efea0905a12b5e17783a2158cf'
             'f5c6d91e17fd798af2ab9106a067ac80331eb96a182859630d211e94f9164d10')
diff --git a/format_security.patch b/format_security.patch
new file mode 100644
index 0000000..fba438d
--- /dev/null
+++ b/format_security.patch
@@ -0,0 +1,11 @@
+--- a/src/shell.c  2021-05-30 21:37:24.931265212 +0200
++++ b/src/shell.c  2021-05-30 21:37:52.301497343 +0200
+@@ -692,7 +692,7 @@
+   }else
+ 
+   if( c=='h' && strncmp(azArg[0], "help", n)==0 ){
+-    fprintf(stderr,zHelp);
++    fprintf(stderr,"%s",zHelp);
+   }else
+ 
+   if( c=='i' && strncmp(azArg[0], "indices", n)==0 && nArg>1 ){
-- 
2.31.1

mireiner commented on 2021-05-30 06:50 (UTC) (edited on 2021-05-30 10:36 (UTC) by mireiner)

It doesn't build using pamac or paru on vanilla Arch. Getting following error message:

./src/shell.c:695:20: error: format not a string literal and no format arguments [-Werror=format-security]
  695 |     fprintf(stderr,zHelp);
      |                    ^~~~~
cc1: some warnings being treated as errors
make: *** [Makefile:199: sqlite] Error 1

pika02 commented on 2021-05-09 03:40 (UTC)

./src/shell.c:695:20: error: format not a string literal and no format arguments [-Werror=format-security] 695 | fprintf(stderr,zHelp); | ^~~~~ cc1: some warnings being treated as errors

Please update the package, thank you!

not_anonymous commented on 2020-07-20 00:21 (UTC)

NOTE: This package is NOT out-of date, as it is the last available sqlite2. PLEASE do NOT confuse this with sqlite3 (or sqlite) !!

Updated to version 2.8.17-9 to reflect the need for HTTPS in the file acquisition. This DOES compile and FULLY build.

windy commented on 2018-01-26 08:46 (UTC)

The archive is downloaded with HTTP, please change this to HTTPS for encrypted transfer.