Can't get sqlite node installed

#1

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/
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.

0 Likes

#2

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 ?

0 Likes

#3

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

0 Likes

#4

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

0 Likes

#5

Run it as per the instructions...

0 Likes

#6

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

0 Likes

#7

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
0 Likes

#8

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

0 Likes