Install Sqlite3 on nodeV8 problem

---

I had the same problem an ended up by installing it manually.

Thanks for the quick answers. After installing git, pimatic also ran until sqlite was installed, but now I’ve been at git for 30 minutes.
CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o

coffee-cache: compiling coffee-script file "config-schema.coffee"...Done
21:18:08.238 [pimatic] Installing database package sqlite3, this can take some minutes
21:19:17.891 [pimatic, ppm] > sqlite3@3.1.8 install /home/pi/pimatic-test/node_modules/sqlite3
21:19:17.935 [pimatic, ppm] > node-pre-gyp install --fallback-to-build
21:19:27.460 [pimatic, ppm] node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v57-linux-arm.tar.gz
21:19:27.474 [pimatic, ppm] node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@8.15.0 (node-v57 ABI) (falling back to source compile with node-gyp)
21:19:58.304 [pimatic, ppm] make: Entering directory '/home/pi/pimatic-test/node_modules/sqlite3/build'
21:19:58.332 [pimatic, ppm]   ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3150000/sqlite3.c
21:20:00.792 [pimatic, ppm]   TOUCH Release/obj.target/deps/action_before_build.stamp
21:20:00.876 [pimatic, ppm]   CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o

@smally what type of raspberry pi are you using? Compiling SQLite takes some time. I did this on on a model B and it also took quite a while

Model B+

@smally there’s a raspberry 1 and raspberry 3 model b+. If it’s the first and older version than it’s normal that it takes so long

@michbeck100 It’s a raspberry pi 1 Model B+ with 4 USB Slots and an extended 40 pin IO connector

@smally then just leave it running until it’s finished compiling. I just left mine over night 😜

@michbeck100 I’ll do that, too.
Thank you all and good night

yippie - With the default config.json pimatic has been completely run through.
that made my day.
Unfortunately my own configuration failed due to some plugins.

• pimatic-homeduino@0.9.11
• pimatic-ping@0.9.5" from npm-registry. (pemission denied???)
• “pimatic-amazing-dash-button@0.9.14” from npm-registry.

19:59:33.893 [pimatic] Installing: "pimatic-homeduino@0.9.11" from npm-registry.
20:01:11.867 [pimatic, ppm] > serialport@2.0.6 install /home/pi/pimatic-test/node_modules/pimatic-homeduino/node_modules/homeduino/node_modules/serialport
20:01:11.902 [pimatic, ppm] > node-pre-gyp install --fallback-to-build
20:01:44.667 [pimatic, ppm] make: Entering directory '/home/pi/pimatic-test/node_modules/pimatic-homeduino/node_modules/homeduino/node_modules/serialport/build'
20:01:44.754 [pimatic, ppm]   CXX(target) Release/obj.target/serialport/src/serialport.o
20:02:01.195 [pimatic, ppm] In file included from ../node_modules/nan/nan.h:182:0,
20:02:01.208 [pimatic, ppm]                  from ../src/serialport.h:5,
20:02:01.228 [pimatic, ppm]                  from ../src/serialport.cpp:3:
20:02:01.248 [pimatic, ppm] ../node_modules/nan/nan_maybe_43_inl.h: In function ‘Nan::MaybeLocal<v8::Object> Nan::CloneElementAt(v8::Local<v8::Array>, uint32_t)’:
20:02:01.268 [pimatic, ppm] ../node_modules/nan/nan_maybe_43_inl.h:221:58: warning: ‘v8::MaybeLocal<v8::Object> v8::Array::CloneElementAt(v8::Local<v8::Context>, uint32_t)’ is deprecated: Cloning is not supported. [-Wdeprecated-declarations]
20:02:01.288 [pimatic, ppm]    return array->CloneElementAt(GetCurrentContext(), index);
20:02:01.298 [pimatic, ppm]                                                           ^
20:02:01.442 [pimatic, ppm] In file included from /home/pi/pimatic-test/.node-gyp/8.15.0/include/node/v8.h:26:0,
20:02:01.464 [pimatic, ppm]                  from /home/pi/pimatic-test/.node-gyp/8.15.0/include/node/node.h:63,
20:02:01.478 [pimatic, ppm]                  from ../node_modules/nan/nan.h:24,
20:02:01.498 [pimatic, ppm]                  from ../src/serialport.h:5,
20:02:01.518 [pimatic, ppm]                  from ../src/serialport.cpp:3:
20:02:01.538 [pimatic, ppm] /home/pi/pimatic-test/.node-gyp/8.15.0/include/node/v8.h:3567:36: note: declared here
20:02:01.548 [pimatic, ppm]                  MaybeLocal<Object> CloneElementAt(Local<Context> context,
20:02:01.568 [pimatic, ppm]                                     ^
20:02:01.588 [pimatic, ppm] /home/pi/pimatic-test/.node-gyp/8.15.0/include/node/v8config.h:318:3: note: in definition of macro ‘V8_DEPRECATED’
20:02:01.608 [pimatic, ppm]    declarator __attribute__((deprecated(message)))
20:02:01.628 [pimatic, ppm]    ^~~~~~~~~~
...
20:02:13.026 [pimatic, ppm] ERR! Failed at the serialport@2.0.6 install script 'node-pre-gyp install --fallback-to-build'.
20:02:13.034 [pimatic, ppm] ERR! This is most likely a problem with the serialport package,
20:02:13.057 [pimatic, ppm] ERR! not with npm itself.
20:02:13.419 [pimatic, ppm] ERR! Tell the author that this fails on your system:
20:02:13.438 [pimatic, ppm] ERR!     node-pre-gyp install --fallback-to-build
20:02:13.446 [pimatic, ppm] ERR! You can get information on how to open an issue for this project with:
20:02:13.465 [pimatic, ppm] ERR!     npm bugs serialport
20:02:13.477 [pimatic, ppm] ERR! Or if that isn't available, you can get their info via:
20:02:13.492 [pimatic, ppm] ERR!
20:02:13.506 [pimatic, ppm] ERR!     npm owner ls serialport
20:02:13.519 [pimatic, ppm] ERR! There is likely additional logging output above.
20:02:31.524 [pimatic, ppm] ERR! Please include the following file with any support request:
20:02:31.577 [pimatic, ppm] ERR!     /home/pi/pimatic-test/npm-debug.log

and

20:05:10.726 [pimatic, ppm] > raw-socket@1.6.4 install /home/pi/pimatic-test/node_modules/pimatic-ping/node_modules/net-ping/node_modules/raw-socket
20:05:10.748 [pimatic, ppm] > node-gyp rebuild
20:05:10.864 [pimatic, ppm] sh: 1: node-gyp: Permission denied
20:05:10.956 [pimatic, ppm] ERR! Linux 4.14.79+
20:05:10.987 [pimatic, ppm] ERR! argv "/usr/local/bin/node" "/home/pi/pimatic-test/node_modules/pimatic/ppm.js" "install" "pimatic-ping@0.9.5" "--unsafe-perm"
20:05:11.028 [pimatic, ppm] ERR! node v8.15.0
20:05:11.036 [pimatic, ppm] ERR! npm  v2.15.12
20:05:11.057 [pimatic, ppm] ERR! code ELIFECYCLE
20:05:11.065 [pimatic, ppm] ERR! raw-socket@1.6.4 install: `node-gyp rebuild`
20:05:11.186 [pimatic, ppm] ERR! Exit status 126
20:05:11.204 [pimatic, ppm] ERR!

@smally Please try to install the master branch of pimatic-homeduino from GitHub:

cd /home/pi/pimatic-app/
sudo rm node_modules/pimatic-homeduino
sudo npm install pimatic/pimatic-homeduino 

For pimatic-ping, did you start pimatic using sudo?

@michbeck100 I have tried it with the procedure described by you in the following variations:
sudo npm pimatic/pimatic-homeduino
sudo npm pimatic-homeduino
sudo su
npm pimatic-homeduino

Unfortunately always with error message

root@raspberrypi:/home/pi/pimatic-test# npm install pimatic-homeduino

> serialport@2.0.6 install /home/pi/pimatic-test/node_modules/serialport
> node-pre-gyp install --fallback-to-build

node-pre-gyp info it worked if it ends with ok
node-pre-gyp verb cli [ '/usr/local/bin/node',
node-pre-gyp verb cli   '/home/pi/pimatic-test/node_modules/serialport/node_modules/.bin/node-pre-gyp',
node-pre-gyp verb cli   'install',
node-pre-gyp verb cli   '--fallback-to-build' ]
node-pre-gyp info using node-pre-gyp@0.6.18
node-pre-gyp info using node@8.15.0 | linux | arm
node-pre-gyp verb command install []
node-pre-gyp info check checked for "/home/pi/pimatic-test/node_modules/serialport/build/Release/node-v57-linux-arm/serialport.node" (not found)
node-pre-gyp http GET https://github.com/voodootikigod/node-serialport/releases/download/2.0.6/node-v57-linux-arm.tar.gz
node-pre-gyp http EACCES: permission denied, mkdir '/home/pi/pimatic-test/node_modules/serialport/build' (falling back to source compile with node-gyp)
node-pre-gyp verb command build [ 'rebuild' ]
node-pre-gyp http 404 https://github.com/voodootikigod/node-serialport/releases/download/2.0.6/node-v57-linux-arm.tar.gz
node-pre-gyp http Pre-built binary not available for your system, looked for https://github.com/voodootikigod/node-serialport/releases/download/2.0.6/node-v57-linux-arm.tar.gz (falling back to source compile with node-gyp)
node-pre-gyp verb command build [ 'rebuild' ]
gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/8.15.0"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/home/pi/pimatic-test/node_modules/serialport/.node-gyp"
gyp WARN install got an error, rolling back install
gyp WARN install got an error, rolling back install
gyp ERR! configure error
gyp ERR! stack Error: EACCES: permission denied, mkdir '/home/pi/pimatic-test/node_modules/serialport/.node-gyp'
gyp ERR! System Linux 4.14.79+
gyp ERR! command "/usr/local/bin/node" "/usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configure" "--fallback-to-build" "--module=/home/pi/pimatic-test/node_modules/serialport/build/Release/node-v57-linux-arm/serialport.node" "--module_name=serialport" "--module_path=/home/pi/pimatic-test/node_modules/serialport/build/Release/node-v57-linux-arm"
gyp ERR! cwd /home/pi/pimatic-test/node_modules/serialport
gyp ERR! node -v v8.15.0
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/local/bin/node /usr/local/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/home/pi/pimatic-test/node_modules/serialport/build/Release/node-v57-linux-arm/serialport.node --module_name=serialport --module_path=/home/pi/pimatic-test/node_modules/serialport/build/Release/node-v57-linux-arm' (1)
node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/pi/pimatic-test/node_modules/serialport/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
node-pre-gyp ERR! stack     at emitTwo (events.js:126:13)
node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:214:7)
node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:915:16)
node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:209:5)
node-pre-gyp ERR! System Linux 4.14.79+
node-pre-gyp ERR! command "/usr/local/bin/node" "/home/pi/pimatic-test/node_modules/serialport/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
…

I startet pimatic with -
sudo node_modules/pimatic/pimatic.js
I still get the error from pimatic-ping and pimatic-amazing-dash-button

Any idea?

@smally said in Install Sqlite3 on nodeV8 problem:

Any idea?

No, I don’t. But its obvious that there is a permission problem. Maybe it helps if you paste your complete installation procedure to a gist.

Besides that I think manually installing dependencies won’t work properly anyways, because when pimatic installs its plugins its currently using npm v2 which uses a different directory structure than the npm version that comes with node 8.
What do you think @mwittig, @sweetpi, @leader21?

@michbeck100 said in Install Sqlite3 on nodeV8 problem:

Please try to install the master branch of pimatic-homeduino from GitHub:

Thanks, i had these issues with 0.9.44 installing the homeduino-plugin from the frontend’s plugin-page - it always ended up like this:

npm ERR! serialport@2.0.6 install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the serialport@2.0.6 install script 'node-pre-gyp install --fallback-to-build'.
npm ERR! This is most likely a problem with the serialport 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 information on how to open an issue for this project with:
npm ERR!     npm bugs serialport
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! 
npm ERR!     npm owner ls serialport
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR!     /home/pi/pimatic-test/npm-debug.log´

now it’s up and running!

@daddycool I tried that unsuccessfully.

I have tried it with the procedure described by you in the following variations:
sudo npm pimatic/pimatic-homeduino
sudo npm pimatic-homeduino
sudo su
npm pimatic-homeduino
Unfortunately always with error message

I just installed homeduino with --unsafe-perm and everything is working again.

sudo npm install pimatic/pimatic-homeduino --unsafe-perm

@Ronald-van-Leuwen Thanks for the suggestion. Unfortunately it didn’t work, but again it caused an error due to missing permission.

That brought me to the search for the “note” directory :

npm config get prefix => /home/pi/.nvm/versions/node/v8.15.0
sudo npm config get prefix = /usr/local

What’s the impact?

I then tested the following call:

pi@raspberrypi:~/pimatic-test/node_modules $ npm install pimatic/pimatic-homeduino --unsafe-perm

— and without sudo the installation worked
Many thanks to all of you for your support.

How can I correct path to -note-.
I expect that the permission problems with pimatic-ping and pimatic-amazing-dash-button will be solved as soon as I have corrected the mess with the directories.

Translated with www.DeepL.com/Translator

@Smally What happens when you call sudo node --version? It seems that you are using nvm, which has problems when used with sudo (e.g. https://stackoverflow.com/questions/21215059/cant-use-nvm-from-root-or-sudo).

@michbeck100 this id the result:

pi@raspberrypi:~ $ sudo node --version
v8.15.0
pi@raspberrypi:~ $ node --version
v8.15.0

But you are right.Because my attempts were unsuccessful, I reinstalled raspian and installed note with nvm. Looks like this is creating new problems.

@smally Using nvm with sudo is problematic. There are workarounds, though. If you are not experienced with this, you should install node 8 using the official installer, as described here.
Unfortunately you cannot do without sudo, as some plugins need root privileges.

Next try!!
Starting with a fresh installation.

wget https://nodejs.org/dist/v8.15.0/node-v8.15.0-linux-armv6l.tar.gz -P /tmp
cd /usr/local
sudo tar xzvf /tmp/node-v8.15.0-linux-armv6l.tar.gz --strip=1

sudo apt-get install build-essential git

Using the install script from michbeck100
https://forum.pimatic.org/topic/4462/trouble-with-fresh-installation/49

pi@raspberrypi:~/pimatic-test $ sudo node_modules/pimatic/pimatic.js

Everything works as usually
Copy my config.json to the pimatic dir
Started manual installation of some plugin first.

npm install pimatic-ping@0.9.5 
npm install pimatic/pimatic-homeduino --unsafe-perm
npm install  pimatic-amazing-dash-button@0.9.14 --unsafe-perm
sudo node_modules/pimatic/pimatic.js

— ---- and running

************ Thanks to all************
How can I set this to solved??