# Node-red-node-sqlite Not Installing

**URL:** https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950
**Category:** General
**Created:** [10 December 2022 00:23 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950 "2022-12-10T00:23:19Z")
**Posts on this page:** 11
**Page:** 2

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [11 December 2022 18:25 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/21 "2022-12-11T18:25:10Z")

</div>

> [@Colin](#):
>
> Lets see if it is something to do with what is already in your .node-red folder. Temporarily rename the .node-red folder to something else and restart node-red. That should make a new .node-red folder with empty flows. Check in the editor that that is the case. Then go into the new .node-red folder and run  
> `npm install node-red-node-squlite`  
> and see what happens.

```auto
-----------------------------------------------------------
2022-12-11T18:15:55.952Z Install : node-red-node-sqlite 1.0.3

2022-12-11T18:15:55.983Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@1.0.3
2022-12-11T18:15:58.818Z [err] npm
2022-12-11T18:15:58.819Z [err] WARN
2022-12-11T18:15:58.820Z [err] config production Use `--omit=dev` instead.
2022-12-11T18:16:21.581Z [err] npm
2022-12-11T18:16:21.581Z [err] WARN deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs
2022-12-11T18:16:28.139Z [err] npm
2022-12-11T18:16:28.139Z [err] ERR! code 1
2022-12-11T18:16:28.139Z [err] npm ERR! path /home/pi/.node-red/node_modules/sqlite3
2022-12-11T18:16:28.149Z [err] npm ERR!
2022-12-11T18:16:28.151Z [err] command failed
2022-12-11T18:16:28.151Z [err] npm ERR! command sh -c -- node-pre-gyp install --fallback-to-build
2022-12-11T18:16:28.152Z [err] npm ERR! Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js clean' (1)
2022-12-11T18:16:28.153Z [err] npm ERR! node-pre-gyp info it worked if it ends with ok
2022-12-11T18:16:28.153Z [err] npm ERR! node-pre-gyp info using node-pre-gyp@1.0.10
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp info using node@16.18.1 | linux | arm
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp info check checked for "/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" (not found)
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz 
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp WARN Pre-built binaries not installable for sqlite3@5.1.2 and node@16.18.1 (node-v93 ABI, glibc) (falling back to source compile with node-gyp) 
2022-12-11T18:16:28.155Z [err] npm ERR! node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz 
2022-12-11T18:16:28.155Z [err] npm ERR! node:internal/modules/cjs/loader:988
2022-12-11T18:16:28.155Z [err] npm ERR!
2022-12-11T18:16:28.156Z [err] throw err;
2022-12-11T18:16:28.157Z [err] npm ERR! ^
2022-12-11T18:16:28.157Z [err] npm ERR! 
2022-12-11T18:16:28.157Z [err] npm ERR! Error: Cannot find module 'object-assign'
2022-12-11T18:16:28.157Z [err] npm ERR! Require stack:
2022-12-11T18:16:28.157Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/render-template.js
2022-12-11T18:16:28.157Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/plumbing.js
2022-12-11T18:16:28.157Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/index.js
2022-12-11T18:16:28.158Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/npmlog/log.js
2022-12-11T18:16:28.158Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/lib/node-gyp.js
2022-12-11T18:16:28.158Z [err] npm ERR! - /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js
2022-12-11T18:16:28.158Z [err] npm ERR! at Function.Module._resolveFilename (node:internal/modules/cjs/loader:985:15)
2022-12-11T18:16:28.158Z [err] npm ERR! at Function.Module._load (node:internal/modules/cjs/loader:833:27)
2022-12-11T18:16:28.158Z [err] npm ERR! at Module.require (node:internal/modules/cjs/loader:1057:19)
2022-12-11T18:16:28.158Z [err] npm ERR! at require (node:internal/modules/cjs/helpers:103:18)
2022-12-11T18:16:28.158Z [err] npm 
2022-12-11T18:16:28.159Z [err] ERR! at Object.<anonymous> (/usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/render-template.js:4:20)
2022-12-11T18:16:28.159Z [err] npm ERR! at Module._compile (node:internal/modules/cjs/loader:1155:14)
2022-12-11T18:16:28.159Z [err] npm ERR! at Object.Module._extensions..js (node:internal/modules/cjs/loader:1209:10)
2022-12-11T18:16:28.159Z [err] npm ERR! at Module.load (node:internal/modules/cjs/loader:1033:32)
2022-12-11T18:16:28.159Z [err] npm ERR! at Function.Module._load (node:internal/modules/cjs/loader:868:12)
2022-12-11T18:16:28.159Z [err] npm ERR! at Module.require (node:internal/modules/cjs/loader:1057:19) {
2022-12-11T18:16:28.159Z [err] npm ERR! code: 'MODULE_NOT_FOUND',
2022-12-11T18:16:28.159Z [err] npm ERR! requireStack: [
2022-12-11T18:16:28.159Z [err] npm 
2022-12-11T18:16:28.159Z [err] ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/render-template.js',
2022-12-11T18:16:28.159Z [err] npm ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/plumbing.js',
2022-12-11T18:16:28.159Z [err] npm ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/gauge/index.js',
2022-12-11T18:16:28.159Z [err] npm ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/node_modules/npmlog/log.js',
2022-12-11T18:16:28.159Z [err] npm ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/lib/node-gyp.js',
2022-12-11T18:16:28.159Z [err] npm ERR! '/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js'
2022-12-11T18:16:28.159Z [err] npm ERR! ]
2022-12-11T18:16:28.159Z [err] npm ERR! }
2022-12-11T18:16:28.159Z [err] npm 
2022-12-11T18:16:28.161Z [err] ERR! node-pre-gyp ERR! build error 
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js clean' (1)
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! stack at ChildProcess.<anonymous> (/home/pi/.node-red/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! stack at ChildProcess.emit (node:events:513:28)
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! stack at maybeClose (node:internal/child_process:1100:16)
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:304:5)
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! System Linux 5.15.76-v7l+
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! command "/usr/bin/node" "/home/pi/.node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! cwd /home/pi/.node-red/node_modules/sqlite3
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! node -v v16.18.1
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! node-pre-gyp -v v1.0.10
2022-12-11T18:16:28.161Z [err] npm ERR! node-pre-gyp ERR! not ok
2022-12-11T18:16:28.175Z [err] 
2022-12-11T18:16:28.175Z [err] npm ERR!
2022-12-11T18:16:28.177Z [err] A complete log of this run can be found in:
2022-12-11T18:16:28.177Z [err] npm ERR! /home/pi/.npm/_logs/2022-12-11T18_15_58_632Z-debug-0.log
2022-12-11T18:16:28.211Z rc=1

```

Renamed the .node-red directory and restarted node-red. Had a clean sheet, no flows. Attempted to install node-red-node-sqlite and the errors are above.

So there is something bigger that node-red.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 December 2022 19:27 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/22 "2022-12-11T19:27:16Z")

</div>

All very odd.

What do these show  
`npm list -g object-assign`  
`npm list object-assign`  
`npm list -g node-gyp`

Try installing it manually  
`sudo npm install -g object-assign`  
and try the node install again.

**[Edit]** Corrected the command above, I had sudo apt install instead of npm

---

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [11 December 2022 20:38 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/23 "2022-12-11T20:38:32Z")

</div>

> [@Colin](#):
>
> npm list -g object-assign  
> npm list object-assign  
> npm list -g node-gyp

```auto
pi@4gbpi:~ $ npm list -g object-assign
/usr/lib
+-- node-red@3.0.2
| `-- @node-red/editor-api@3.0.2
| +-- cors@2.8.5
| | `-- object-assign@4.1.1
| `-- multer@1.4.5-lts.1
| `-- object-assign@4.1.1 deduped
`-- serverless@2.16.0
  +-- decompress@4.2.1
  | `-- decompress-unzip@4.0.1
  | `-- get-stream@2.3.1
  | `-- object-assign@4.1.1
  `-- download@8.0.0
    `-- got@8.3.2
      `-- cacheable-request@2.1.4
        `-- normalize-url@2.0.1
          `-- query-string@5.1.1
            `-- object-assign@4.1.1 deduped

pi@4gbpi:~ $ npm list object-assign
/home/pi
`-- (empty)

pi@4gbpi:~ $ npm list -g node-gyp
/usr/lib
`-- npm@8.19.2
  +-- @npmcli/run-script@4.2.1
  | `-- node-gyp@9.1.0 deduped
  `-- node-gyp@9.1.0

pi@4gbpi:~ $

```

---

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [11 December 2022 20:41 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/24 "2022-12-11T20:41:00Z")

</div>

> [@Colin](#):
>
> Try installing it manually  
> `sudo npm install -g object-assign`  
> and try the node install again.

This installed fine, no errors.

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 December 2022 21:31 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/25 "2022-12-11T21:31:27Z")

</div>

Did you try installing the node again as I suggested?

---

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [11 December 2022 21:40 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/26 "2022-12-11T21:40:22Z")

</div>

Yes I did and the same problems, error shown below:

```auto
pm WARN deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs
npm ERR! code 1
npm ERR! path /home/pi/.node-red/node_modules/sqlite3
npm ERR! command failed
npm ERR! command sh -c -- node-pre-gyp install --fallback-to-build
npm ERR! make: Entering directory '/home/pi/.node-red/node_modules/sqlite3/build'
npm ERR! CC(target) Release/obj.target/nothing/node_modules/node-addon-api/nothing.o
npm ERR! AR(target) Release/obj.target/node_modules/node-addon-api/nothing.a
npm ERR! COPY Release/nothing.a
npm ERR! ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c
npm ERR! TOUCH Release/obj.target/deps/action_before_build.stamp
npm ERR! CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3390400/sqlite3.o
npm ERR! AR(target) Release/obj.target/deps/sqlite3.a
npm ERR! COPY Release/sqlite3.a
npm ERR! CXX(target) Release/obj.target/node_sqlite3/src/backup.o
npm ERR! make: Leaving directory '/home/pi/.node-red/node_modules/sqlite3/build'
npm ERR! Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@1.0.10
npm ERR! node-pre-gyp info using node@16.18.1 | linux | arm
npm ERR! node-pre-gyp info check checked for "/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz
npm ERR! node-pre-gyp ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz 
npm ERR! node-pre-gyp WARN Pre-built binaries not installable for sqlite3@5.1.2 and node@16.18.1 (node-v93 ABI, glibc) (falling back to source compile with node-gyp) 
npm ERR! node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-arm.tar.gz 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@16.18.1 | linux | arm
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@16.18.1 | linux | arm
npm ERR! gyp info find Python using Python version 3.9.2 found at "/usr/bin/python3"
npm ERR! gyp info spawn /usr/bin/python3
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/gyp/gyp_main.py',
npm ERR! gyp info spawn args 'binding.gyp',
npm ERR! gyp info spawn args '-f',
npm ERR! gyp info spawn args 'make',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/home/pi/.node-red/node_modules/sqlite3/build/config.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/usr/lib/node_modules/npm/node_modules/node-gyp/addon.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/home/pi/.cache/node-gyp/16.18.1/include/node/common.gypi',
npm ERR! gyp info spawn args '-Dlibrary=shared_library',
npm ERR! gyp info spawn args '-Dvisibility=default',
npm ERR! gyp info spawn args '-Dnode_root_dir=/home/pi/.cache/node-gyp/16.18.1',
npm ERR! gyp info spawn args '-Dnode_gyp_dir=/usr/lib/node_modules/npm/node_modules/node-gyp',
npm ERR! gyp info spawn args '-Dnode_lib_file=/home/pi/.cache/node-gyp/16.18.1/<(target_arch)/node.lib',
npm ERR! gyp info spawn args '-Dmodule_root_dir=/home/pi/.node-red/node_modules/sqlite3',
npm ERR! gyp info spawn args '-Dnode_engine=v8',
npm ERR! gyp info spawn args '--depth=.',
npm ERR! gyp info spawn args '--no-parallel',
npm ERR! gyp info spawn args '--generator-output',
npm ERR! gyp info spawn args 'build',
npm ERR! gyp info spawn args '-Goutput_dir=.'
npm ERR! gyp info spawn args ]
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@16.18.1 | linux | arm
npm ERR! gyp info spawn make
npm ERR! gyp info spawn args ['BUILDTYPE=Release', '-C', 'build']
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c: In function 'cellArea':
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200223:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200223 | case 5: area = p->aCoord[9].f - p->aCoord[8].f;
npm ERR! | ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200224:7: note: here
npm ERR! 200224 | case 4: area *= p->aCoord[7].f - p->aCoord[6].f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200224:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200224 | case 4: area *= p->aCoord[7].f - p->aCoord[6].f;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200225:7: note: here
npm ERR! 200225 | case 3: area *= p->aCoord[5].f - p->aCoord[4].f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200225:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200225 | case 3: area *= p->aCoord[5].f - p->aCoord[4].f;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200226:7: note: here
npm ERR! 200226 | case 2: area *= p->aCoord[3].f - p->aCoord[2].f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200226:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200226 | case 2: area *= p->aCoord[3].f - p->aCoord[2].f;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200227:7: note: here
npm ERR! 200227 | default: area *= p->aCoord[1].f - p->aCoord[0].f;
npm ERR! | ^ ~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200233:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200233 | case 5: area = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i;
npm ERR! | ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200234:7: note: here
npm ERR! 200234 | case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200234:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200234 | case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200235:7: note: here
npm ERR! 200235 | case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200235:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200235 | case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200236:7: note: here
npm ERR! 200236 | case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200236:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 200236 | case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
npm ERR! | ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:200237:7: note: here
npm ERR! 200237 | default: area *= (i64)p->aCoord[1].i - (i64)p->aCoord[0].i;
npm ERR! | ^ ~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c: In function 'rtreeCallbackConstraint':
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199362:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199362 | readCoord(pCellData+32, &c); aCoord[8] = c.f;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199363:7: note: here
npm ERR! 199363 | case 8: readCoord(pCellData+28, &c); aCoord[7] = c.f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199364:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199364 | readCoord(pCellData+24, &c); aCoord[6] = c.f;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199365:7: note: here
npm ERR! 199365 | case 6: readCoord(pCellData+20, &c); aCoord[5] = c.f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199366:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199366 | readCoord(pCellData+16, &c); aCoord[4] = c.f;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199367:7: note: here
npm ERR! 199367 | case 4: readCoord(pCellData+12, &c); aCoord[3] = c.f;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199368:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199368 | readCoord(pCellData+8, &c); aCoord[2] = c.f;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199369:7: note: here
npm ERR! 199369 | default: readCoord(pCellData+4, &c); aCoord[1] = c.f;
npm ERR! | ^ ~~~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199377:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199377 | readCoord(pCellData+32, &c); aCoord[8] = c.i;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199378:7: note: here
npm ERR! 199378 | case 8: readCoord(pCellData+28, &c); aCoord[7] = c.i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199379:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199379 | readCoord(pCellData+24, &c); aCoord[6] = c.i;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199380:7: note: here
npm ERR! 199380 | case 6: readCoord(pCellData+20, &c); aCoord[5] = c.i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199381:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199381 | readCoord(pCellData+16, &c); aCoord[4] = c.i;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199382:7: note: here
npm ERR! 199382 | case 4: readCoord(pCellData+12, &c); aCoord[3] = c.i;
npm ERR! | ^~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199383:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
npm ERR! 199383 | readCoord(pCellData+8, &c); aCoord[2] = c.i;
npm ERR! | ~~~~~~~~~~^~~~~
npm ERR! Release/obj/gen/sqlite-autoconf-3390400/sqlite3.c:199384:7: note: here
npm ERR! 199384 | default: readCoord(pCellData+4, &c); aCoord[1] = c.i;
npm ERR! | ^ ~~~~~~
npm ERR! make: g++: No such file or directory
npm ERR! make: *** [node_sqlite3.target.mk:138: Release/obj.target/node_sqlite3/src/backup.o] Error 127
npm ERR! gyp ERR! build error 
npm ERR! gyp ERR! stack Error: `make` failed with exit code: 2
npm ERR! gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:201:23)
npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:513:28)
npm ERR! gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:293:12)
npm ERR! gyp ERR! System Linux 5.15.76-v7l+
npm ERR! gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6"
npm ERR! gyp ERR! cwd /home/pi/.node-red/node_modules/sqlite3
npm ERR! gyp ERR! node -v v16.18.1
npm ERR! gyp ERR! node-gyp -v v9.1.0
npm ERR! gyp ERR! not ok 
npm ERR! node-pre-gyp ERR! build error 
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
npm ERR! node-pre-gyp ERR! stack at ChildProcess.<anonymous> (/home/pi/.node-red/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
npm ERR! node-pre-gyp ERR! stack at ChildProcess.emit (node:events:513:28)
npm ERR! node-pre-gyp ERR! stack at maybeClose (node:internal/child_process:1100:16)
npm ERR! node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:304:5)
npm ERR! node-pre-gyp ERR! System Linux 5.15.76-v7l+
npm ERR! node-pre-gyp ERR! command "/usr/bin/node" "/home/pi/.node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd /home/pi/.node-red/node_modules/sqlite3
npm ERR! node-pre-gyp ERR! node -v v16.18.1
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v1.0.10
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR! /home/pi/.npm/_logs/2022-12-11T21_32_56_907Z-debug-0.log

```

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 December 2022 22:04 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/27 "2022-12-11T22:04:02Z")

</div>

> [@pjockey](#):
>
> same problems

That doesn't look like the same problem to me. It is completely different in fact.

> [@pjockey](#):
>
> ```auto
> npm ERR! make: g++: No such file or directory
> npm ERR! make: *** [node_sqlite3.target.mk:138: Release/obj.target/node_sqlite3/src/backup.o] Error 127
> npm ERR! gyp ERR! build error 
> 
> ```

I think that may be the significant bit of the output, but I am not sure what it means.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [11 December 2022 22:50 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/28 "2022-12-11T22:50:24Z")

</div>

Is this RaspiOS 32 bit or 64 bit ?

---

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [11 December 2022 23:35 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/29 "2022-12-11T23:35:25Z")

</div>

According to the uname -m, it is 32 bit.  
armv7l

---

<div class="post-metadata">

### Author: ![pjockey](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/pjockey/32/12624_2.png) [@pjockey](https://discourse.nodered.org/u/pjockey)
#### Post date: [12 December 2022 00:09 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/30 "2022-12-12T00:09:22Z")

</div>

Ah, I think I have it fix. This part `npm ERR! make: g++: No such file or directory` made me think about other posts I'd seen on the forums. I feel so stupid. I check to see if the `build-essential` was installed and it wasn't. Once that was installed, it all worked.

I've installed lots of other packages and never had any problems.

Thank you @Colin @zenofmud and @dceejay for your help and patience.

Scott

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [12 December 2022 08:56 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950/31 "2022-12-12T08:56:05Z")

</div>

> [@pjockey](#):
>
> I check to see if the `build-essentials` was installed and it wasn't.

It is actually build-essential (not essentials). I can't believe we had not asked you to check that, usually it is one of the first things we ask. I think I was mixing up this thread and another that has been running. It is odd, though, that `make` was installed but not other tools, apparently. I think that threw me.

[Previous page](https://discourse.nodered.org/t/node-red-node-sqlite-not-installing/71950.md?page=1)
