Node-red-node-sqlite Not Installing

General
21 
-----------------------------------------------------------
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.

22

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

23 
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:~ $
24

This installed fine, no errors.

25

Did you try installing the node again as I suggested?

26

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

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
27

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

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

28

Is this RaspiOS 32 bit or 64 bit ?

29

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

30

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

31

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.

2 Likes