Better-sqlite3: Raspbian Support

[tomjamescn]

Hi, my env is raspbian jessie on Raspberry Pi 3

npm install failed:

[email protected] install /home/tomjamescn/proxy-ng/node_modules/better-sqlite3
node tools/install

==> cwd: /home/tomjamescn/proxy-ng/node_modules/better-sqlite3
==> /home/tomjamescn/proxy-ng/node_modules/lzz-gyp/lzz-compiled/linux -hx hpp -sx cpp -k BETTER_SQLITE3 -d -hl -sl -e ./src/better_sqlite3.lzz
/home/tomjamescn/proxy-ng/node_modules/lzz-gyp/lzz-compiled/linux: 1: /home/tomjamescn/proxy-ng/node_modules/lzz-gyp/lzz-compiled/linux: Syntax error: Unterminated quoted string
Error: exit code 2
at ChildProcess. (/home/tomjamescn/proxy-ng/node_modules/lzz-gyp/lib/exec.js:19:12)
at emitTwo (events.js:106:13)
at ChildProcess.emit (events.js:191:7)
at Process.ChildProcess._handle.onexit (internal/child_process.js:215:12)
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@^1.0.0 (node_modules/chokidar/node_modules/fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for [email protected]: wanted {"os":"darwin","arch":"any"} (current: {"os":"linux","arch":"arm"})
npm WARN [email protected] No description
npm ERR! Linux 4.4.34-v7+
npm ERR! argv "/usr/local/bin/node" "/usr/local/bin/npm" "install"
npm ERR! node v6.10.3
npm ERR! npm v3.10.10
npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: node tools/install
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script 'node tools/install'.
npm ERR! Make sure you have the latest version of node.js and npm installed.
npm ERR! If you do, this is most likely a problem with the better-sqlite3 package,
npm ERR! not with npm itself.
npm ERR! Tell the author that this fails on your system:
npm ERR! node tools/install
npm ERR! You can get information on how to open an issue for this project with:
npm ERR! npm bugs better-sqlite3
npm ERR! Or if that isn't available, you can get their info via:
npm ERR! npm owner ls better-sqlite3
npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:
npm ERR! /home/tomjamescn/proxy-ng/npm-debug.log

[JoshuaWise]

Try updating to version 3.1.1 and setting LZZ_COMPAT=1 in your environment variables.

[JoshuaWise]

Did that work for you? @tomjamescn

[mrcity]

I ran into this issue just now on my Pi and your suggestion worked. Thanks!

[JoshuaWise]

Great, closing this issue.

[tichaonax]

I tried the same it did not work on my raspberry PI

[JoshuaWise]

Reopening this for @tichaonax

[JoshuaWise]

@tichaonax What happened when you tried using LZZ_COMPAT=1?

[kvanee]

Same issue here:

pi@rpiz3:~/test$ LZZ_COMPAT=1
pi@rpiz3:~/test$ sudo npm install --save better-sqlite3

[email protected] install /home/pi/test/node_modules/integer
node tools/install

gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/8.2.1"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/home/pi/test/node_modules/integer/.node-gyp"
make: Entering directory '/home/pi/test/node_modules/integer/build'
CXX(target) Release/obj.target/integer/src/integer.o
SOLINK_MODULE(target) Release/obj.target/integer.node
COPY Release/integer.node
make: Leaving directory '/home/pi/test/node_modules/integer/build'

[email protected] install /home/pi/test/node_modules/better-sqlite3
node tools/install

==> cwd: /home/pi/test/node_modules/better-sqlite3
==> /home/pi/test/node_modules/lzz-gyp/lzz-compiled/linux -hx hpp -sx cpp -k BETTER_SQLITE3 -d -hl -sl -e ./src/better_sqlite3.lzz
/home/pi/test/node_modules/lzz-gyp/lzz-compiled/linux: 1: /home/pi/test/node_modules/lzz-gyp/lzz-compiled/linux: Syntax error: Unterminated quoted string
Error: exit code 2
at ChildProcess. (/home/pi/test/node_modules/lzz-gyp/lib/exec.js:19:12)
at emitTwo (events.js:125:13)
at ChildProcess.emit (events.js:213:7)
at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)
npm WARN [email protected] No repository field.

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: node tools/install
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2017-08-12T17_06_44_832Z-debug.log

[tichaonax]

LZZ_COMPAT=1 worked with version @3.1.2 today. Last time I used the same environment variable it did not work with @3.1.1. Thanks for the good work. I love better-sqlite3

[JoshuaWise]

Great, I'm glad to hear it's working for you now 👍

[abcd-ca]

LZZ_COMPAT=1 Also worked for me on 4.0.3 using Beaglebone (ARM) microprocessor

[baggyg]

I am getting FATAL ERROR: v8:ToLocalChecked Empty MaybeLocal. on a Beaglebone just requiring the library. Has anyone come across the same message?

[gilbert]

@baggyg I'm getting the FATAL ERROR message upon requiring the library on node 4.8.7.

[JoshuaWise]

@gilbert, better-sqlite3 is only supported for node 6 and higher

[MackenzieMolloy]

pi@MackPi:~/Desktop/xDrakon/Bot $ sudo npm install better-sqlite3

[email protected] install /home/pi/Desktop/xDrakon/Bot/node_modules/integer
node-gyp rebuild

gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/11.8.0"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/home/pi/Desktop/xDrakon/Bot/node_modules/integer/.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/Desktop/xDrakon/Bot/node_modules/integer/.node-gyp'
gyp ERR! System Linux 4.14.79-v7+
gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "rebuild"
gyp ERR! cwd /home/pi/Desktop/xDrakon/Bot/node_modules/integer
gyp ERR! node -v v11.8.0
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok
npm WARN discord.[email protected] requires a peer of bufferutil@^3.0.3 but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of erlpack@discordapp/erlpack but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of node-opus@^0.2.7 but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of opusscript@^0.0.6 but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of sodium@^2.0.3 but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of libsodium-wrappers@^0.7.3 but none is installed. You must install peer dependencies yourself.
npm WARN discord.[email protected] requires a peer of uws@^9.14.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] No description
npm WARN [email protected] No repository field.

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] install: node-gyp rebuild
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2019-03-03T17_29_23_417Z-debug.log

I'm running version 11.8.0 of NodeJS

[JoshuaWise]

@MackenzieMolloy

The relevant error message is:

gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/11.8.0"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/home/pi/Desktop/xDrakon/Bot/node_modules/integer/.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/Desktop/xDrakon/Bot/node_modules/integer/.node-gyp'

You have a Unix permission error. You'll need to change the permissions on the directory you're installing into

[MackenzieMolloy]

@MackenzieMolloy

The relevant error message is:

gyp WARN EACCES user "root" does not have permission to access the dev dir "/root/.node-gyp/11.8.0"
gyp WARN EACCES attempting to reinstall using temporary dev dir "/home/pi/Desktop/xDrakon/Bot/node_modules/integer/.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/Desktop/xDrakon/Bot/node_modules/integer/.node-gyp'

You have a Unix permission error. You'll need to change the permissions on the directory you're installing into

So, would you be able to guide on what to do? I'll be honest, I'm quite a noobie.