# Sqlite install error in nodered 0.19.5

**URL:** https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960
**Category:** General
**Created:** [18 January 2019 11:12 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960 "2019-01-18T11:12:13Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![au190](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/au190/32/5251_2.png) [@au190](https://discourse.nodered.org/u/au190)
#### Post date: [18 January 2019 11:12 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/1 "2019-01-18T11:12:13Z")

</div>

Hi

Iam trying to install sql lite without success (: any advice ? I tryed in cli and also from noded palette, same error.  
Iam using :  
hassio 0.85.1  
nodered 0.19.5

```
node-red npm i --unsafe-perm node-red-node-sqlite

> sqlite3@4.0.6 install /config/node-red/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp WARN Using request for node-pre-gyp https download 
node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.0.6/node-v59-linux-arm.tar.gz 
node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.0.6 and node@9.11.1 (node-v59 ABI, musl) (falling back to source compile with node-gyp) 
gyp ERR! build error 
gyp ERR! stack Error: not found: make
gyp ERR! stack at getNotFoundError (/usr/local/share/.config/yarn/global/node_modules/npm/node_modules/which/which.js:13:12)
gyp ERR! stack at F (/usr/local/share/.config/yarn/global/node_modules/npm/node_modules/which/which.js:68:19)
gyp ERR! stack at E (/usr/local/share/.config/yarn/global/node_modules/npm/node_modules/which/which.js:80:29)
gyp ERR! stack at /usr/local/share/.config/yarn/global/node_modules/npm/node_modules/which/which.js:89:16
gyp ERR! stack at /usr/local/share/.config/yarn/global/node_modules/npm/node_modules/isexe/index.js:42:5
gyp ERR! stack at /usr/local/share/.config/yarn/global/node_modules/npm/node_modules/isexe/mode.js:8:5
gyp ERR! stack at FSReqWrap.oncomplete (fs.js:170:21)
gyp ERR! System Linux 4.14.81-v7
gyp ERR! command "/usr/bin/node" "/usr/local/share/.config/yarn/global/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm" "--napi_version=3" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v59"
gyp ERR! cwd /config/node-red/node_modules/sqlite3
gyp ERR! node -v v9.11.1
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok 
node-pre-gyp ERR! build error 
node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/local/share/.config/yarn/global/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm --napi_version=3 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v59' (1)
node-pre-gyp ERR! stack at ChildProcess.<anonymous> (/config/node-red/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:180:13)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:936:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:220:5)
node-pre-gyp ERR! System Linux 4.14.81-v7
node-pre-gyp ERR! command "/usr/bin/node" "/config/node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp ERR! cwd /config/node-red/node_modules/sqlite3
node-pre-gyp ERR! node -v v9.11.1
node-pre-gyp ERR! node-pre-gyp -v v0.11.0
node-pre-gyp ERR! not ok 
Failed to execute '/usr/bin/node /usr/local/share/.config/yarn/global/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/config/node-red/node_modules/sqlite3/lib/binding/node-v59-linux-arm --napi_version=3 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v59' (1)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! sqlite3@4.0.6 install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the sqlite3@4.0.6 install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2019-01-18T10_45_40_478Z-debug.log
➜ node-red
```

---

<div class="post-metadata">

### Author: ![cymplecy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/cymplecy/32/2773_2.png) [@cymplecy](https://discourse.nodered.org/u/cymplecy)
#### Post date: [18 January 2019 11:40 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/2 "2019-01-18T11:40:11Z")

</div>

I seem to remember quite a few posts on sqlite problems recently, so a search on the forum may already provide an answer to your problem

---

<div class="post-metadata">

### Author: ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)
#### Post date: [18 January 2019 12:31 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/3 "2019-01-18T12:31:57Z")

</div>

Nodejs v9 has been end-of-life since May last year. Probably time to upgrade...

---

<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: [18 January 2019 13:56 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/4 "2019-01-18T13:56:53Z")

</div>

> [@au190](#):
>
> gyp ERR! stack Error: not found: make

looks llke you don't have the basic compiler tools installed... maybe you need

sudo apt-get install build-essential

to get them in place before you do the install (assuming this is linux or raspbian of course

---

<div class="post-metadata">

### Author: ![au190](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/au190/32/5251_2.png) [@au190](https://discourse.nodered.org/u/au190)
#### Post date: [18 January 2019 14:38 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/5 "2019-01-18T14:38:49Z")

</div>

Thx for the advice, but i have a closed system. It that possibile that the bin package is not on that repository ?

---

<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: [18 January 2019 16:53 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/6 "2019-01-18T16:53:40Z")

</div>

> [@au190](#):
>
> Thx for the advice, but i have a colsed system. It that possibile that the bin package is not on that repository

It's no good asking us that. You need to look at the spec of your closed (I presume you meant closed, not colsed) system, or ask whoever supplied it.

---

<div class="post-metadata">

### Author: ![au190](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/au190/32/5251_2.png) [@au190](https://discourse.nodered.org/u/au190)
#### Post date: [18 January 2019 17:40 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/7 "2019-01-18T17:40:03Z")

</div>

Sorry I misstyed the word.  
I can use the istructions from the link.

> **[node-red-node-sqlite](https://www.npmjs.com/package/node-red-node-sqlite)**
>
> A sqlite node for Node-RED

```auto
npm i --unsafe-perm node-red-node

```

---

<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: [18 January 2019 18:05 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/8 "2019-01-18T18:05:37Z")

</div>

Have you installed it ok now?

---

<div class="post-metadata">

### Author: ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)
#### Post date: [18 January 2019 18:11 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/9 "2019-01-18T18:11:51Z")

</div>

But given you are using a version of nodejs that is no longer supported its still worth asking whoever supplied it about an update.

---

<div class="post-metadata">

### Author: ![au190](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/au190/32/5251_2.png) [@au190](https://discourse.nodered.org/u/au190)
#### Post date: [18 January 2019 18:38 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/10 "2019-01-18T18:38:35Z")

</div>

When I run that command I hot the error posted before.

---

<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: [18 January 2019 18:49 UTC](https://discourse.nodered.org/t/sqlite-install-error-in-nodered-0-19-5/6960/11 "2019-01-18T18:49:20Z")

</div>

Until you get the make command installed it will continue to fail.
