it seems you are trying to follow Node and SQLite tutorial | Code for geek
And it seems the error "Illegal Instruction" means that sqlite3 you have installed is not intended for Galileo board,
because Galileo's CPU does not support some commands supported by your PC.
Need to install sqlite3 intended for Galileo board.
First, thank you for giving your help.
I have just found that sqlite3 can run perfectly on my galileo
I forgot testing sqlite3 by using commandline: Commandline Shell for SQLite . This mistake made me belive that sqlite3 isn't compatibe with Galileo board (iot-devkit).
So that I think the problem is NodeJS can't use sqlite3 library
probably the problem may be related with sqlite3.node - a nodejs module between sqlite3 library and nodejs.
How use sqlite3.node on Intel Galileo Gen 2, standart Yocto?
1.I make dir ~/a,
2. create file package.json :
3. in folder ~/a run "npm install" and have errors:
npm ERR! firstname.lastname@example.org install: `node-pre-gyp install --fallback-to-build`
npm ERR! Exit status 1
npm ERR! Failed at the email@example.com 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 3.8.7-yocto-standard
npm ERR! command "/usr/bin/node" "/usr/bin/npm" "install"
npm ERR! cwd /home/root/a
npm ERR! node -v v0.10.38
npm ERR! npm -v 1.4.28
npm ERR! code ELIFECYCLE
npm ERR! not ok code 0
SQLite3 on command line work without problem.
Is Node.JS work with SQLite3 on Intel Galileo Gen 2?
Anybody have working sample?
Before install sqlite3.node need to install development tools: "
opkg install packagegroup-core-buildessential"