Problems installing node-red-node-sqlite on Raspberry Pi

[Nico vd Dussen]

Hi,

I'm running a flow on Windows 10 and want to transfer it to my Raspberry Pi.

For this I need node-red-node-sqlite.

Unfortunately I can't get it t install :(

I'm using the latest version of Rasbian, properly updated and upgraded.

When running npm install node-red-node-sqlite in ~/.node-red i get the errors below.

What am I doing wrong?

What does these lines mean?

npm WARN This failure might be due to the use of legacy binary "node"

npm WARN For further explanations, please read

/usr/share/doc/nodejs/README.Debian

Thanks

Nico

        

node_sqlite3.target.mk:100: recipe for target 'Release/obj.target/node_sqlite3/src/database.o' failed

make: *** [Release/obj.target/node_sqlite3/src/database.o] Error 1

make: Leaving directory '/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/build'

gyp ERR! build error

gyp ERR! stack Error: `make` failed with exit code: 2

gyp ERR! stack     at ChildProcess.onExit (/usr/share/node-gyp/lib/build.js:267:23)

gyp ERR! stack     at ChildProcess.emit (events.js:98:17)

gyp ERR! stack     at Process.ChildProcess._handle.onexit (child_process.js:809:12)

gyp ERR! System Linux 4.4.11+

gyp ERR! command "nodejs" "/usr/bin/node-gyp" "build" "--fallback-to-build" "--module=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm"

gyp ERR! cwd /home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3

gyp ERR! node -v v0.10.29

gyp ERR! node-gyp -v v0.12.2

gyp ERR! not ok

node-pre-gyp ERR! build error

node-pre-gyp ERR! stack Error: Failed to execute 'node-gyp build --fallback-to-build --module=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm' (1)

node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/node_modules/node-pre-gyp/lib/util/compile.js:83:29)

node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:98:17)

node-pre-gyp ERR! stack     at maybeClose (child_process.js:755:16)

node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (child_process.js:822:5)

node-pre-gyp ERR! System Linux 4.4.11+

node-pre-gyp ERR! command "node" "/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"

node-pre-gyp ERR! cwd /home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3

node-pre-gyp ERR! node -v v0.10.29

node-pre-gyp ERR! node-pre-gyp -v v0.6.28

node-pre-gyp ERR! not ok

Failed to execute 'node-gyp build --fallback-to-build --module=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v11-linux-arm' (1)

npm WARN This failure might be due to the use of legacy binary "node"

npm WARN For further explanations, please read

/usr/share/doc/nodejs/README.Debian

npm ERR! sql...@3.1.4 install: `node-pre-gyp install --fallback-to-build`

npm ERR! Exit status 1

npm ERR!

npm ERR! Failed at the sql...@3.1.4 install script.

npm ERR! This is most likely a problem with the sqlite3 package,

npm ERR! not with npm itself.

npm ERR! Tell the author that this fails on your system:

npm ERR!     node-pre-gyp install --fallback-to-build

npm ERR! You can get their info via:

npm ERR!     npm owner ls sqlite3

npm ERR! There is likely additional logging output above.

npm ERR! System Linux 4.4.11+

npm ERR! command "/usr/bin/nodejs" "/usr/bin/npm" "install" "node-red-node-sqlite"

npm ERR! cwd /home/pi/.node-red

npm ERR! node -v v0.10.29

npm ERR! npm -v 1.4.21

npm ERR! code ELIFECYCLE

npm ERR!

npm ERR! Additional logging details can be found in:

npm ERR!     /home/pi/.node-red/npm-debug.log

npm ERR! not ok code 0

pi@raspberrypi:~/.node-red $

[Mark Setrem]

You haven't installed the correct version of npm, see the instructions on http://nodered.org/docs/hardware/raspberrypi

Also unless there is a specific reason to run the very outdated version of node that comes preinstalled on the raspberry pi, it is worth sending the time to update that to a newer version as well.
The instructions to do this are on the same page

[Nico vd Dussen]

Many thanks!

Problem solved!

Nico