# Failed to install: node-red-node-sqlite

**URL:** <https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214>\
**Category:** General\
**Created:** [5 May 2021 12:24 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214 "2021-05-05T12:24:00Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [5 May 2021 12:24 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/1 "2021-05-05T12:24:00Z")

</div>

I tried to install node-red-node-sqlite 0.6.0, both from node-red’s manage palette, and from cmd by running this command npm i --unsafe-perm node-red-node-sqlite, but the installation is not successful, there are the following errors:

```auto
C:\Users\Utente\.node-red>npm i --unsafe-perm node-red-node-sqlite
npm WARN deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future
npm ERR! code 1
npm ERR! path C:\Users\Utente\.node-red\node_modules\sqlite3
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
npm ERR! Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Utente\.node-red\node_modules\sqlite3\lib\binding\node-v88-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Utente\.node-red\node_modules\sqlite3\lib\binding\node-v88-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v88 --msvs_version=2019' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
npm ERR! node-pre-gyp info using node@15.6.0 | win32 | x64
npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download
npm ERR! node-pre-gyp info check checked for "C:\Users\Utente\.node-red\node_modules\sqlite3\lib\binding\node-v88-win32-x64\node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v88-win32-x64.tar.gz
npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v88-win32-x64.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v88-win32-x64.tar.gz
npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@15.6.0 (node-v88 ABI, unknown) (falling back to source compile with node-gyp)
npm ERR! node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v88-win32-x64.tar.gz
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@15.6.0 | win32 | x64
npm ERR! gyp info ok
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@15.6.0 | win32 | x64
npm ERR! gyp ERR! find Python
npm ERR! gyp ERR! find Python Python is not set from command line or npm configuration
npm ERR! gyp ERR! find Python Python is not set from environment variable PYTHON
npm ERR! gyp ERR! find Python checking if "python3" can be used
npm ERR! gyp ERR! find Python - "python3" is not in PATH or produced an error
npm ERR! gyp ERR! find Python checking if "python" can be used
npm ERR! gyp ERR! find Python - "python" is not in PATH or produced an error
npm ERR! gyp ERR! find Python checking if "python2" can be used
npm ERR! gyp ERR! find Python - "python2" is not in PATH or produced an error
npm ERR! gyp ERR! find Python checking if Python is C:\Python37\python.exe
npm ERR! gyp ERR! find Python - "C:\Python37\python.exe" could not be run
npm ERR! gyp ERR! find Python checking if Python is C:\Python27\python.exe
npm ERR! gyp ERR! find Python - "C:\Python27\python.exe" could not be run
npm ERR! gyp ERR! find Python checking if the py launcher can be used to find Python
npm ERR! gyp ERR! find Python - "py.exe" is not in PATH or produced an error
npm ERR! gyp ERR! find Python
npm ERR! gyp ERR! find Python **********************************************************
npm ERR! gyp ERR! find Python You need to install the latest version of Python.
npm ERR! gyp ERR! find Python Node-gyp should be able to find and use Python. If not,
npm ERR! gyp ERR! find Python you can try one of the following options:
npm ERR! gyp ERR! find Python - Use the switch --python="C:\Path\To\python.exe"
npm ERR! gyp ERR! find Python (accepted by both node-gyp and npm)
npm ERR! gyp ERR! find Python - Set the environment variable PYTHON
npm ERR! gyp ERR! find Python - Set the npm configuration variable python:
npm ERR! gyp ERR! find Python npm config set python "C:\Path\To\python.exe"
npm ERR! gyp ERR! find Python For more information consult the documentation at:
npm ERR! gyp ERR! find Python https://github.com/nodejs/node-gyp#installation
npm ERR! gyp ERR! find Python **********************************************************
npm ERR! gyp ERR! find Python
npm ERR! gyp ERR! configure error
npm ERR! gyp ERR! stack Error: Could not find any Python installation to use
npm ERR! gyp ERR! stack at PythonFinder.fail (C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-python.js:302:47)
npm ERR! gyp ERR! stack at PythonFinder.runChecks (C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-python.js:136:21)
npm ERR! gyp ERR! stack at PythonFinder.<anonymous> (C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-python.js:200:18)
npm ERR! gyp ERR! stack at PythonFinder.execFileCallback (C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-python.js:266:16)
npm ERR! gyp ERR! stack at exithandler (node:child_process:340:5)
npm ERR! gyp ERR! stack at ChildProcess.errorhandler (node:child_process:352:5)
npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:379:20)
npm ERR! gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:283:12)
npm ERR! gyp ERR! stack at onErrorNT (node:internal/child_process:477:16)
npm ERR! gyp ERR! stack at processTicksAndRejections (node:internal/process/task_queues:81:21)
npm ERR! gyp ERR! System Windows_NT 10.0.19042
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\Utente\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\\Users\\Utente\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v88-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\Utente\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v88-win32-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v88" "--msvs_version=2019"
npm ERR! gyp ERR! cwd C:\Users\Utente\.node-red\node_modules\sqlite3
npm ERR! gyp ERR! node -v v15.6.0
npm ERR! gyp ERR! node-gyp -v v7.1.2
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 'C:\Program Files\nodejs\node.exe C:\Users\Utente\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Utente\.node-red\node_modules\sqlite3\lib\binding\node-v88-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Utente\.node-red\node_modules\sqlite3\lib\binding\node-v88-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v88 --msvs_version=2019' (1)
npm ERR! node-pre-gyp ERR! stack at ChildProcess.<anonymous> (C:\Users\Utente\.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack at ChildProcess.emit (node:events:379:20)
npm ERR! node-pre-gyp ERR! stack at maybeClose (node:internal/child_process:1065:16)
npm ERR! node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:296:5)
npm ERR! node-pre-gyp ERR! System Windows_NT 10.0.19042
npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\Utente\\.node-red\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd C:\Users\Utente\.node-red\node_modules\sqlite3
npm ERR! node-pre-gyp ERR! node -v v15.6.0
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\Utente\AppData\Local\npm-cache\_logs\2021-05-05T10_21_01_261Z-debug.log

```

- Node-RED version: 1.3.4
- node.js version: 15.6.0
- npm version: 7.11.1
- Platform/OS: Windows 10 Home version 20H2
- Browser: Chrome
- Python version: 3.9.5  
thanks in advance.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [5 May 2021 12:31 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/2 "2021-05-05T12:31:05Z")

</div>

This has been covered on the forum many times.

Essentially, npm cant find a binary so tries to build sqlite. e.g...

> [@r-g0](#):
>
> `npm ERR! gyp ERR! stack Error: Could not find any Python installation to use`

...but once you get past that, you would get an error about not finding visual studio etc etc.

The bottom line is, install windows build essentials, restart node-red, try again.

> **[windows-build-tools](https://www.npmjs.com/package/windows-build-tools)**
>
> Install C++ Build Tools for Windows using npm. Latest version: 5.2.2, last published: 4 years ago. Start using windows-build-tools in your project by running \`npm i windows-build-tools\`. There are 7 other projects in the npm registry using...

---

<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:** [5 May 2021 12:49 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/3 "2021-05-05T12:49:12Z")

</div>

Also covered many times... Node15 is not supported for the very reason that sometimes nodes that need binary compilation (like sqlite) often fail on these dev versions of node js.

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [5 May 2021 18:14 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/4 "2021-05-05T18:14:52Z")

</div>

thank you for your answers.  
So, I installed node.js version: 14.16.1 and I tried to install npm install -g windows-build-tools, but there are other errors:

```auto

```

PS C:\> npm install -g windows-build-tools  
npm WARN deprecated har-validator@5.1.5: this library is no longer supported  
npm WARN deprecated request@2.88.2: request has been deprecated, see [Request’s Past, Present and Future · Issue #3142 · request/request · GitHub](https://github.com/request/request/issues/3142)  
npm ERR! code 1  
npm ERR! path C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools  
npm ERR! command failed  
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node ./dist/index.js  
npm ERR! C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\os.js:53  
npm ERR! throw resultError;  
npm ERR! ^  
npm ERR!  
npm ERR! Error: spawnSync powershell.exe ENOENT  
npm ERR! at Object.spawnSync (internal/child\_process.js:1067:20)  
npm ERR! at Object.spawnSync (child\_process.js:602:24)  
npm ERR! at spawnSync (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:67:36)  
npm ERR! at Object.queryRegFromPowershell (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:73:3)  
npm ERR! at loop (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:113:16)  
npm ERR! at C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:116:7  
npm ERR! at C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:100:5  
npm ERR! at spawnSync (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:68:2)  
npm ERR! at Object.queryRegFromRegExe (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:96:3)  
npm ERR! at loop (C:\Users\Utente\AppData\Roaming\npm\node\_modules\windows-build-tools\node\_modules\in-gfw\lib\geo.js:113:16) {  
npm ERR! errno: -4058,  
npm ERR! code: 'ENOENT',  
npm ERR! syscall: 'spawnSync powershell.exe',  
npm ERR! path: 'powershell.exe',  
npm ERR! spawnargs: [  
npm ERR! '-NoProfile',  
npm ERR! '-ExecutionPolicy',  
npm ERR! '-Command',  
npm ERR! '& {(Get-ItemProperty -Path "Registry::HKU\.DEFAULT\Control Panel\International\Geo" -Name Nation).Nation}'  
npm ERR! ]  
npm ERR! }

npm ERR! A complete log of this run can be found in:  
npm ERR! C:\Users\Utente\AppData\Local\npm-cache\_logs\2021-05-05T18\_00\_22\_086Z-debug.log  
`

```auto

```

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [5 May 2021 18:28 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/5 "2021-05-05T18:28:04Z")

</div>

> [@r-g0](#):
>
> npm ERR! code: 'ENOENT',

I believe this is due to changing node version.

The easiest solution is to delete global node\_modules (`C:\Users\Utente\AppData\Roaming\npm\node_modules`) folder, install build tools, then reinstall node-red, then sqlite.

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [5 May 2021 19:48 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/6 "2021-05-05T19:48:51Z")

</div>

I followed your instructions, but when I run node-red, this happens:

```auto
C:\Users\Utente>node-red
internal/modules/cjs/loader.js:883
  throw err;
  ^

Error: Cannot find module 'C:\Users\Utente\AppData\Roaming\npm\node_modules\node-red\red.js'
←[90m at Function.Module._resolveFilename (internal/modules/cjs/loader.js:880:15)←[39m
←[90m at Function.Module._load (internal/modules/cjs/loader.js:725:27)←[39m
←[90m at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:72:12)←[39m
←[90m at internal/main/run_main_module.js:17:47←[39m {
  code: ←[32m'MODULE_NOT_FOUND'←[39m,
  requireStack: []
}

```

What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [5 May 2021 19:52 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/7 "2021-05-05T19:52:28Z")

</div>

Did you reinstall node-red as per documentation?

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [5 May 2021 19:55 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/8 "2021-05-05T19:55:49Z")

</div>

I did these steps:

- npm remove -g node-red node-red-admin
- rm -R ~/. node-red
- npm install -g --unsafe-perm 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:** [6 May 2021 07:18 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/9 "2021-05-06T07:18:30Z")

</div>

> [@r-g0](#):
>
> I followed your instructions,

Did you do these bits before re-installing node-red?

> [@Steve-Mcl](#):
>
> The easiest solution is to delete global node\_modules ( `C:\Users\Utente\AppData\Roaming\npm\node_modules` ) folder, install build tools,

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [6 May 2021 07:34 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/10 "2021-05-06T07:34:35Z")

</div>

yes, I do that.  
I try to remake steps, but when i run this comand, there is this errors:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/c/dc9c5f9aeb55cf4950d6f5b2eef6ed683df0be80.png)

How can I proceed?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [6 May 2021 08:14 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/11 "2021-05-06T08:14:15Z")

</div>

> [@r-g0](#):
>
> How can I proceed?

This was [a known issue](https://github.com/react-static/react-static/issues/1360) in NPM v7

And something is proably messed up on your user account due to having previously had installed V15 and NPM v7.x

I suspect a re-do is necessary.

See [this thread](https://stackoverflow.com/questions/20711240/how-to-completely-remove-node-js-from-windows) to completely remove node and npm then start again.

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [6 May 2021 17:31 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/12 "2021-05-06T17:31:45Z")

</div>

Sorry again if I bother, I would like to ask for advice, I deleted everything as it was indicated, on my PC now there is no trace of node-red and the other components, I would just ask if the order of the components to be installed, and the versions mentioned, were right:

- windows-build-tools 2
- node.js LTS Version: 14.16.1 (includes npm 6.14.12)  
-node-red  
-node-sqlite?

Also, do I need to install node-Gyp-npm?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [6 May 2021 17:42 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/13 "2021-05-06T17:42:36Z")

</div>

- node.js LTS Version: 14.16.1 (includes npm 6.14.12)
- Install windows-build-tools
- Install node-red

Then run node red once (this creates `c:\users\?user?\.node-red`

Then..

- Stop node-red
- Open command prompt `cmd`
  - `cd c:\users\?user?\.node-red`
  - npm install node-red-node-sqlite

Note: substitute `?user?` for your user name as found in `c:\users`

---

<div class="post-metadata">

**Author:** ![r-g0](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/r-g0/32/41019_2.png) [@r-g0](https://discourse.nodered.org/u/r-g0)\
**Post date:** [6 May 2021 19:42 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/14 "2021-05-06T19:42:10Z")

</div>

thank you so much for your support!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [5 July 2021 19:42 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-node-sqlite/45214/15 "2021-07-05T19:42:14Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.