Node-sqlite3: 403 fetching precompiled binary

[jpillora]

> [email protected] install /Users/jp/app/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.11/node-v59-darwin-x64.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)
  ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3150000/sqlite3.c
  TOUCH Release/obj.target/deps/action_before_build.stamp
  CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o
  LIBTOOL-STATIC Release/sqlite3.a
  CXX(target) Release/obj.target/node_sqlite3/src/database.o

And compile from source failed

[jacklau88]

i got the same problem too,how to fix it?

[DelboyDylan]

I was getting the same issue. To workaround it I've downgraded my NodeJS installation from 9, back to 8 for the time being (https://nodejs.org/dist/latest-v8.x/).

[slavarazum]

@springmeyer
The same issue. Looks like sqlite3 currently hasn't binary file for latest _node_ and _npm_ versions.
On any device
NPM version: 5.5.1
Node version: v9.2.1

Please, take attention, thanks.

[springmeyer]

I've just posted binaries for node v9 for the latest [email protected] release. So if you install v3.1.13 this should work now (binaries will be installed and no source compile will need to happen).

[slavarazum]

@springmeyer Huge thanks for operative solution! Think this issue can be closed.

[songzhj]

403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.1/node-v48-darwin-x64.tar.gz
node v6.9.2 has the same problem too

[vincent7128]

try #947 and https://github.com/mapbox/node-sqlite3#source-install

[nZeus]

Hi, I have the latest node (v9.7.1) installed on my RaspberryPi3 and still have this issue. I also tried with node v4, the same error:

pi@IT-Raspberry:~/pimatic-app $ sudo npm install sqlite3 --unsafe-perm

> [email protected] install /home/pi/pimatic-app/node_modules/sqlite3
> node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v59-linux-arm.tar.gz
node-pre-gyp ERR! Pre-built binaries not found for [email protected] and [email protected] (node-v59 ABI) (falling back to source compile with node-gyp)
make: Entering directory '/home/pi/pimatic-app/node_modules/sqlite3/build'
  ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3150000/sqlite3.c
  TOUCH Release/obj.target/deps/action_before_build.stamp
  CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3150000/sqlite3.o

Can someone help me how to fix this?

[vincent7128]

@nZeus I run node-sqlite3 on the raspberry pi, it will install build from src.
The process take about 6 min on the raspberry pi 3.

$ uname -a
Linux raspberrypi 4.9.59-v7+ #1047 SMP Sun Oct 29 12:19:23 GMT 2017 armv7l GNU/Linux
$ node -v
v9.7.1
$ npm -v
5.7.1

[nZeus]

This is what I have:

after an hour it's still the same >_<

[rzr]

@nzeus

I am able to build on pi3 but it's rather slow:

https://github.com/mapbox/node-sqlite3/issues/942

[jyy1082]

Is there anyone know how to fix it?

[neomh]

it works for me now

export LDFLAGS="-L/usr/local/lib"
export CPPFLAGS="-I/usr/local/include -I/usr/local/include/sqlcipher"
export CXXFLAGS="$CPPFLAGS"
npm install sqlite3 --build-from-source --sqlite_libname=sqlcipher --sqlite=/usr/local --verbose

node -e 'require("sqlite3")'

and then as root

npm install --only=production

[fmuntean]

Can we please get it to work without the need to compile?
Not everybody has the full development tools needed to do this.
I am currently getting the same issue on a Raspberry PI Zero.
node -v v8.11.1
node-pre-gyp -v v0.9.0
node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v57-linux-arm.tar.gz
node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.0.0/node-v57-linux-arm.tar.gz

[oppih]

node-sqlite3 does not support node v10 yet

see it here: https://github.com/mapbox/node-sqlite3/issues/977

[crazyyi]

@oppih Yes I have to revert back to node v9.5.0. Thanks for the info.

[springmeyer]

The errors reported here are all various and from different issues. Anyone hitting this please:

• use latest [email protected]
• use latest npm@6
• create a new issue if you are still having problems

If you are on ARM, we don't support binaries yet for easy install, so see #418

[answerquest]

use latest [email protected]
use latest npm@6

@springmeyer Could you give exact nvm commands to do so?