# Can't get sqlite node installed

**URL:** <https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369>\
**Category:** General\
**Created:** [3 January 2019 22:53 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369 "2019-01-03T22:53:40Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ejcmiddl](https://avatars.discourse-cdn.com/v4/letter/e/d26b3c/32.png) [@ejcmiddl](https://discourse.nodered.org/u/ejcmiddl)\
**Post date:** [3 January 2019 22:53 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/1 "2019-01-03T22:53:40Z")

</div>

I have node-red running on a Raspberry PI 3+.  
Having an issue installing/running since attempting to install node-red-node-sqlite module.  
After restarting node-red I get the following:

# Welcome to Node-RED

## 3 Jan 17:44:36 - [info] Node-RED version: v0.19.5 3 Jan 17:44:36 - [info] Node.js version: v10.14.2 3 Jan 17:44:36 - [info] Linux 4.14.79-v7+ arm LE 3 Jan 17:44:38 - [info] Loading palette nodes 3 Jan 17:44:48 - [info] Dashboard version 2.13.0 started at /ui 3 Jan 17:44:51 - [warn] ------------------------------------------------------ 3 Jan 17:44:51 - [warn] [node-red-node-sqlite/sqlite] Error: Cannot find module '/home/pi/.node-red/node\_modules/sqlite3/lib/binding/node-v64-linux-arm/node\_sqlite3.node' 3 Jan 17:44:51 - [warn] ------------------------------------------------------ 3 Jan 17:44:51 - [info] Settings file : /home/pi/.node-red/settings.js 3 Jan 17:44:51 - [info] Context store : 'default' [module=memory] 3 Jan 17:44:51 - [info] User directory : /home/pi/.node-red 3 Jan 17:44:51 - [warn] Projects disabled : editorTheme.projects.enabled=false 3 Jan 17:44:51 - [info] Flows file : /home/pi/.node-red/flows\_raspberrypi.json 3 Jan 17:44:51 - [info] Server now running at [http://127.0.0.1:1880/](http://127.0.0.1:1880/) 3 Jan 17:44:51 - [warn]

## Your flow credentials file is encrypted using a system-generated key. If the system-generated key is lost for any reason, your credentials file will not be recoverable, you will have to delete it and re-enter your credentials. You should set your own key using the 'credentialSecret' option in your settings file. Node-RED will then re-encrypt your credentials file using your chosen key the next time you deploy a change.

3 Jan 17:44:51 - [info] Waiting for missing types to be registered:  
3 Jan 17:44:51 - [info] - sqlitedb

When I view the localhost:1880 I get a popup stating:  
Flow stopped due to missing node types.  
sqlitedb

How do I resolve this issue. My node-red is dead in the water with this failure.

Thanks.

---

<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:** [3 January 2019 22:59 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/2 "2019-01-03T22:59:11Z")

</div>

Did you follow the readme instructions ?  
It can take about 20 mins to recompile itself and install. Was there any error reported as it installed ?

---

<div class="post-metadata">

**Author:** ![ejcmiddl](https://avatars.discourse-cdn.com/v4/letter/e/d26b3c/32.png) [@ejcmiddl](https://discourse.nodered.org/u/ejcmiddl)\
**Post date:** [3 January 2019 23:17 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/3 "2019-01-03T23:17:01Z")

</div>

Never saw the readme instructions.  
But that's water over the dam now.  
So how do I fix the issue?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [3 January 2019 23:27 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/4 "2019-01-03T23:27:10Z")

</div>

> [@ejcmiddl](#):
>
> Never saw the readme instructions.

I suggest you go and read them before you do anything else.

---

<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:** [3 January 2019 23:30 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/5 "2019-01-03T23:30:07Z")

</div>

Run it as per the instructions...

---

<div class="post-metadata">

**Author:** ![ejcmiddl](https://avatars.discourse-cdn.com/v4/letter/e/d26b3c/32.png) [@ejcmiddl](https://discourse.nodered.org/u/ejcmiddl)\
**Post date:** [4 January 2019 00:53 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/6 "2019-01-04T00:53:59Z")

</div>

Thanks. I think i'm to the point of uninstalling node-red and reinstalling it.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [4 January 2019 00:57 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/7 "2019-01-04T00:57:58Z")

</div>

Reinstalling Node-RED itself won't have any bearing on any extra modules you've tried to install - unless you mean a full wipe and start from scratch.

Before you do that, try:

1. go to /home/pi/.node-red/
2. run `npm rebuild sqlite3`

---

<div class="post-metadata">

**Author:** ![ejcmiddl](https://avatars.discourse-cdn.com/v4/letter/e/d26b3c/32.png) [@ejcmiddl](https://discourse.nodered.org/u/ejcmiddl)\
**Post date:** [4 January 2019 02:52 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/8 "2019-01-04T02:52:19Z")

</div>

This worked. I no longer get the node-red startup issues and the sqlite node is present.  
Thanks for your Very Helpful reply.

---

<div class="post-metadata">

**Author:** ![mikegg](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mikegg/32/99746_2.png) [@mikegg](https://discourse.nodered.org/u/mikegg)\
**Post date:** [25 April 2019 11:24 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/9 "2019-04-25T11:24:03Z")

</div>

Worked for me too thanks knolleary & ecjmiddl.  
My thanks to all the contributors who assisted in my endeavors to get sqlite installed. Being new to node-red I found installing this node a challenge. I set out my final process below in the hope it might assist others.

My initial attempts at installing sqlite on a Pi Zero via "npm i --unsafe-perm node-red-node-sqlite"  
failed as I erroneously assumed I had a lock up while in fact it was compiling. Took approx 15 minutes before a raft of messages gave an insight something was actually taking place.

After a restart I remained frustrated as while the palette manager advised sqlite node was now installed it was not showing and there was a nice little red triangle with exclamation mark.

A review of the start up script gave me the message:  
[warn] [node-red-node-sqlite/sqlite] Error: Cannot find module '/home/pi/.node-red/node\_modules/node-red-node-sqlite/node\_modules/sqlite3/lib/binding/node-v57-linux-arm/node\_sqlite3.node'

Then "npm rebuild sqlite3" fixed this, red triangle is no more and node showing.

Think it would be worth adding a rider to the node instructions about the lengthy compile and that the rebuild command will fix the red triangle.

---

<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:** [25 April 2019 11:42 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/10 "2019-04-25T11:42:17Z")

</div>

Thanks - have added to the readme

---

<div class="post-metadata">

**Author:** ![skythe83](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@skythe83](https://discourse.nodered.org/u/skythe83)\
**Post date:** [24 July 2020 10:00 UTC](https://discourse.nodered.org/t/cant-get-sqlite-node-installed/6369/11 "2020-07-24T10:00:19Z")

</div>

Rebuild sqlite3 has also solved the issue for me. I was updating node-red with the bash script on [https://nodered.org/docs/getting-started/raspberrypi](https://nodered.org/docs/getting-started/raspberrypi), coming from version 1.0.1, going to 1.1.2, node.js v8.11.1 to v12.16.3