# Node-sqlite installation issue

**URL:** <https://discourse.nodered.org/t/node-sqlite-installation-issue/43380>\
**Category:** General\
**Created:** [30 March 2021 02:58 UTC](https://discourse.nodered.org/t/node-sqlite-installation-issue/43380 "2021-03-30T02:58:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![NaniAP](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NaniAP](https://discourse.nodered.org/u/NaniAP)\
**Post date:** [30 March 2021 02:58 UTC](https://discourse.nodered.org/t/node-sqlite-installation-issue/43380/1 "2021-03-30T02:58:52Z")

</div>

0 verbose cli [  
0 verbose cli 'C:\Program Files\nodejs\node.exe',  
0 verbose cli 'C:\Users\user\AppData\Roaming\npm\node\_modules\npm\bin\npm-cli.js',  
0 verbose cli 'install',  
0 verbose cli 'node-red-node-sqlite'  
0 verbose cli ]  
1 info using npm@7.7.5  
2 info using node@v14.4.0  
3 timing npm:load:whichnode Completed in 2ms  
4 timing config:load:defaults Completed in 2ms  
5 timing config:load:file:C:\Users\user\AppData\Roaming\npm\node\_modules\npm\npmrc Completed in 3ms  
6 timing config:load:builtin Completed in 3ms  
7 timing config:load:cli Completed in 2ms  
8 timing config:load:env Completed in 0ms  
9 timing config:load:project Completed in 1ms  
10 timing config:load:file:C:\Users\user.npmrc Completed in 1ms  
11 timing config:load:user Completed in 1ms  
12 timing config:load:file:C:\Users\user\AppData\Roaming\npm\etc\npmrc Completed in 0ms  
13 timing config:load:global Completed in 0ms  
14 timing config:load:validate Completed in 0ms  
15 timing config:load:setEnvs Completed in 1ms  
16 timing config:load Completed in 11ms  
17 timing npm:load:configload Completed in 11ms  
18 timing npm:load:setTitle Completed in 0ms  
19 timing npm:load:setupLog Completed in 3ms  
20 timing npm:load:cleanupLog Completed in 4ms  
21 timing npm:load:configScope Completed in 0ms  
22 timing npm:load:projectScope Completed in 1ms  
23 timing npm:load Completed in 22ms  
24 timing config:load:flatten Completed in 4ms  
25 timing arborist:ctor Completed in 0ms  
26 timing idealTree:init Completed in 163ms  
27 timing idealTree:userRequests Completed in 1ms  
28 silly idealTree buildDeps  
29 silly fetch manifest node-red-node-sqlite@\*  
30 timing arborist:ctor Completed in 0ms  
31 http fetch GET 304 [https://registry.npmjs.org/node-red-node-sqlite](https://registry.npmjs.org/node-red-node-sqlite) 606ms (from cache)  
32 silly placeDep ROOT node-red-node-sqlite@0.6.0 OK for: want: \*  
33 silly fetch manifest sqlite3@~4.2.0  
34 http fetch GET 304 [https://registry.npmjs.org/sqlite3](https://registry.npmjs.org/sqlite3) 142ms (from cache)  
35 timing idealTree:#root Completed in 759ms  
36 silly placeDep node\_modules/node-red-node-sqlite sqlite3@4.2.0 OK for: node-red-node-sqlite@0.6.0 want: ~4.2.0  
37 silly fetch manifest nan@^2.12.1  
38 silly fetch manifest node-pre-gyp@^0.11.0  
39 http fetch GET 200 [https://registry.npmjs.org/nan](https://registry.npmjs.org/nan) 202ms  
40 http fetch GET 304 [https://registry.npmjs.org/node-pre-gyp](https://registry.npmjs.org/node-pre-gyp) 367ms (from cache)  
41 timing idealTree:node\_modules/node-red-node-sqlite Completed in 389ms  
42 silly placeDep ROOT nan@2.14.2 OK for: sqlite3@4.2.0 want: ^2.12.1  
43 silly placeDep ROOT node-pre-gyp@0.11.0 OK for: sqlite3@4.2.0 want: ^0.11.0  
44 silly fetch manifest nopt@^4.0.1  
45 http fetch GET 200 [https://registry.npmjs.org/nopt](https://registry.npmjs.org/nopt) 10ms (from cache)  
46 timing idealTree:node\_modules/node-red-node-sqlite/node\_modules/sqlite3 Completed in 27ms  
47 timing idealTree:node\_modules/nan Completed in 0ms  
48 silly placeDep ROOT nopt@4.0.3 OK for: node-pre-gyp@0.11.0 want: ^4.0.1  
49 timing idealTree:node\_modules/node-pre-gyp Completed in 2ms  
50 timing idealTree:node\_modules/nopt Completed in 0ms  
51 timing idealTree:buildDeps Completed in 1180ms  
52 timing idealTree:fixDepFlags Completed in 6ms  
53 timing idealTree Completed in 1354ms  
54 timing reify:loadTrees Completed in 1356ms  
55 silly reify mark deleted [  
55 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\node-pre-gyp',  
55 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp',  
55 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.cmd',  
55 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.ps1'  
55 silly reify ]  
56 silly reify mark deleted [  
56 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\nopt',  
56 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt',  
56 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.cmd',  
56 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.ps1'  
56 silly reify ]  
57 timing reify:diffTrees Completed in 22ms  
58 silly reify mark retired [  
58 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\node-pre-gyp',  
58 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp',  
58 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.cmd',  
58 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.ps1'  
58 silly reify ]  
59 silly reify mark retired [  
59 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\nopt',  
59 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt',  
59 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.cmd',  
59 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.ps1'  
59 silly reify ]  
60 silly reify moves {  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\node-pre-gyp': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.node-pre-gyp-8MRd6TOZ',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.node-pre-gyp-7fHVPUJL',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.cmd': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.node-pre-gyp.cmd-pETFo1el',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\node-pre-gyp.ps1': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.node-pre-gyp.ps1-JuATphR3',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\nopt': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.nopt-p5Hypyr7',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.nopt-C3KLGhSa',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.cmd': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.nopt.cmd-XY3i4QvG',  
60 silly reify 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\nopt.ps1': 'C:\Users\user\node\_modules\sqlite3\node\_modules\.bin\.nopt.ps1-ykCHTgua'  
60 silly reify }  
61 timing reify:retireShallow Completed in 16ms  
62 timing reify:createSparse Completed in 5ms  
63 timing reify:loadBundles Completed in 0ms  
64 silly tarball no local data for nan@[https://registry.npmjs.org/nan/-/nan-2.14.2.tgz](https://registry.npmjs.org/nan/-/nan-2.14.2.tgz). Extracting by manifest.  
65 timing reifyNode:node\_modules/nopt Completed in 164ms  
66 timing reifyNode:node\_modules/node-red-node-sqlite Completed in 191ms  
67 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  
68 timing reifyNode:node\_modules/node-pre-gyp Completed in 262ms  
69 http fetch GET 200 [https://registry.npmjs.org/nan/-/nan-2.14.2.tgz](https://registry.npmjs.org/nan/-/nan-2.14.2.tgz) 407ms  
70 timing reifyNode:node\_modules/nan Completed in 426ms  
71 timing reifyNode:node\_modules/node-red-node-sqlite/node\_modules/sqlite3 Completed in 435ms  
72 timing reify:unpack Completed in 436ms  
73 timing reify:unretire Completed in 1ms  
74 timing build:queue Completed in 4ms  
75 timing build:link:node\_modules/nopt Completed in 15ms  
76 timing build:link:node\_modules/node-pre-gyp Completed in 17ms  
77 timing build:link Completed in 17ms  
78 info run sqlite3@4.2.0 install node\_modules/node-red-node-sqlite/node\_modules/sqlite3 node-pre-gyp install --fallback-to-build  
79 http fetch POST 200 [https://registry.npmjs.org/-/npm/v1/security/advisories/bulk](https://registry.npmjs.org/-/npm/v1/security/advisories/bulk) 877ms  
80 timing auditReport:getReport Completed in 880ms  
81 timing auditReport:init Completed in 0ms  
82 timing reify:audit Completed in 881ms  
83 info run sqlite3@4.2.0 install { code: 1, signal: null }  
84 timing reify:rollback:createSparse Completed in 98ms  
85 timing reify:rollback:retireShallow Completed in 9ms  
86 timing command:install Completed in 12104ms  
87 verbose stack Error: command failed  
87 verbose stack at ChildProcess. (C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules@npmcli\promise-spawn\index.js:64:27)  
87 verbose stack at ChildProcess.emit (events.js:315:20)  
87 verbose stack at maybeClose (internal/child\_process.js:1051:16)  
87 verbose stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:287:5)  
88 verbose pkgid sqlite3@4.2.0  
89 verbose cwd C:\Users\user  
90 verbose Windows\_NT 10.0.18363  
91 verbose argv "C:\Program Files\nodejs\node.exe" "C:\Users\user\AppData\Roaming\npm\node\_modules\npm\bin\npm-cli.js" "install" "node-red-node-sqlite"  
92 verbose node v14.4.0  
93 verbose npm v7.7.5  
94 error code 1  
95 error path C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3  
96 error command failed  
97 error command C:\Windows\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build  
98 error Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.  
98 error unpack\_sqlite\_dep  
98 error Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings \> Manage App Execution Aliases.  
98 error C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\VC\VCTargets\Microsoft.CppCommon.targets(209,5): error MSB6006: "cmd.exe" exited with code 9009. [C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\build\deps\action\_before\_build.vcxproj]  
98 error Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=6 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83' (1)  
99 error node-pre-gyp info it worked if it ends with ok  
99 error node-pre-gyp info using node-pre-gyp@0.11.0  
99 error node-pre-gyp info using node@14.4.0 | win32 | x64  
99 error node-pre-gyp WARN Using request for node-pre-gyp https download  
99 error node-pre-gyp info check checked for "C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node" (not found)  
99 error node-pre-gyp http GET [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
99 error node-pre-gyp http 403 [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
99 error node-pre-gyp WARN Tried to download(403): [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
99 error node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.4.0 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)  
99 error node-pre-gyp http 403 status code downloading tarball [https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz](https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz)  
99 error gyp info it worked if it ends with ok  
99 error gyp info using node-gyp@7.1.2  
99 error gyp info using node@14.4.0 | win32 | x64  
99 error gyp info ok  
99 error gyp info it worked if it ends with ok  
99 error gyp info using node-gyp@7.1.2  
99 error gyp info using node@14.4.0 | win32 | x64  
99 error gyp info find Python using Python version 3.9.2 found at "C:\Users\user\AppData\Local\Programs\Python\Python39\python.exe"  
99 error gyp info find VS using VS2017 (15.9.28307.1177) found at:  
99 error gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community"  
99 error gyp info find VS run with --verbose for detailed information  
99 error gyp info spawn C:\Users\user\AppData\Local\Programs\Python\Python39\python.exe  
99 error gyp info spawn args [  
99 error gyp info spawn args 'C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\gyp\gyp\_main.py',  
99 error gyp info spawn args 'binding.gyp',  
99 error gyp info spawn args '-f',  
99 error gyp info spawn args 'msvs',  
99 error gyp info spawn args '-I',  
99 error gyp info spawn args 'C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\build\config.gypi',  
99 error gyp info spawn args '-I',  
99 error gyp info spawn args 'C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\addon.gypi',  
99 error gyp info spawn args '-I',  
99 error gyp info spawn args 'C:\Users\user\AppData\Local\node-gyp\Cache\14.4.0\include\node\common.gypi',  
99 error gyp info spawn args '-Dlibrary=shared\_library',  
99 error gyp info spawn args '-Dvisibility=default',  
99 error gyp info spawn args '-Dnode\_root\_dir=C:\Users\user\AppData\Local\node-gyp\Cache\14.4.0',  
99 error gyp info spawn args '-Dnode\_gyp\_dir=C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp',  
99 error gyp info spawn args '-Dnode\_lib\_file=C:\\Users\\user\\AppData\\Local\\node-gyp\\Cache\\14.4.0\\\<(target\_arch)\\node.lib',  
99 error gyp info spawn args '-Dmodule\_root\_dir=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3',  
99 error gyp info spawn args '-Dnode\_engine=v8',  
99 error gyp info spawn args '--depth=.',  
99 error gyp info spawn args '--no-parallel',  
99 error gyp info spawn args '--generator-output',  
99 error gyp info spawn args 'C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\build',  
99 error gyp info spawn args '-Goutput\_dir=.'  
99 error gyp info spawn args ]  
99 error gyp info ok  
99 error gyp info it worked if it ends with ok  
99 error gyp info using node-gyp@7.1.2  
99 error gyp info using node@14.4.0 | win32 | x64  
99 error gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\MSBuild.exe  
99 error gyp info spawn args [  
99 error gyp info spawn args 'build/binding.sln',  
99 error gyp info spawn args '/clp:Verbosity=minimal',  
99 error gyp info spawn args '/nologo',  
99 error gyp info spawn args '/p:Configuration=Release;Platform=x64'  
99 error gyp info spawn args ]  
99 error gyp ERR! build error  
99 error gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\MSBuild.exe` failed with exit code: 1  
99 error gyp ERR! stack at ChildProcess.onExit (C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\lib\build.js:194:23)  
99 error gyp ERR! stack at ChildProcess.emit (events.js:315:20)  
99 error gyp ERR! stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:276:12)  
99 error gyp ERR! System Windows\_NT 10.0.18363  
99 error gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js" "build" "--fallback-to-build" "--module=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node" "--module\_name=node\_sqlite3" "--module\_path=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi\_version=6" "--node\_abi\_napi=napi" "--napi\_build\_version=0" "--node\_napi\_label=node-v83"  
99 error gyp ERR! cwd C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3  
99 error gyp ERR! node -v v14.4.0  
99 error gyp ERR! node-gyp -v v7.1.2  
99 error gyp ERR! not ok  
99 error node-pre-gyp ERR! build error  
99 error node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user\AppData\Roaming\npm\node\_modules\npm\node\_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64\node\_sqlite3.node --module\_name=node\_sqlite3 --module\_path=C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi\_version=6 --node\_abi\_napi=napi --napi\_build\_version=0 --node\_napi\_label=node-v83' (1)  
99 error node-pre-gyp ERR! stack at ChildProcess. (C:\Users\user\node\_modules\node-pre-gyp\lib\util\compile.js:83:29)  
99 error node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20)  
99 error node-pre-gyp ERR! stack at maybeClose (internal/child\_process.js:1051:16)  
99 error node-pre-gyp ERR! stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:287:5)  
99 error node-pre-gyp ERR! System Windows\_NT 10.0.18363  
99 error node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\user\node\_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"  
99 error node-pre-gyp ERR! cwd C:\Users\user\node\_modules\node-red-node-sqlite\node\_modules\sqlite3  
99 error node-pre-gyp ERR! node -v v14.4.0  
99 error node-pre-gyp ERR! node-pre-gyp -v v0.11.0  
99 error node-pre-gyp ERR! not ok  
100 verbose exit 1

above is my install log. how to solve this issue?

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [30 March 2021 04:54 UTC](https://discourse.nodered.org/t/node-sqlite-installation-issue/43380/2 "2021-03-30T04:54:46Z")

</div>

> [@NaniAP](#):
>
> 99 error node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.4.0 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)

This line gives the clue. It can't find pre-built native code for the package, so it needs to be compiled for your NodeJS version and OS.

Do do that, you need to setup your build environment. The instructions can be found here:

> **[GitHub - nodejs/node-gyp: Node.js native addon build tool](https://github.com/nodejs/node-gyp#on-windows)**
>
> Node.js native addon build tool. Contribute to nodejs/node-gyp development by creating an account on GitHub.

---

<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:** [29 May 2021 04:55 UTC](https://discourse.nodered.org/t/node-sqlite-installation-issue/43380/3 "2021-05-29T04:55:36Z")

</div>

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