rebuild: electron-rebuild failure with sqlite3

Hello all,

Thank you so much for all your hard work on this. I’m sure I will love it once I get it working.

Firstly, housekeeping. I’m using electron 1.7.9 sqlite3 3.1.13 electron-rebuild 1.6.0. macOS Sierra 10.12.6 npm 5.4.2 node 8.7.0

I was just trying to build a simple test-application by following this video and, before that, this video.

I could get neither to work.

Here is the error I got:

$ npm run rebuild

> sqlitetrial2@1.0.0 rebuild /Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2
> electron-rebuild -f -w sqlite3

✖ Rebuild Failed

An unhandled error occurred inside electron-rebuild
action_after_build.target.mk:6: *** missing separator.  Stop.
gyp ERR! build error
gyp ERR! stack Error: `make` failed with exit code: 2
gyp ERR! stack     at ChildProcess.onExit (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/node-gyp/lib/build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:125:13)
gyp ERR! stack     at ChildProcess.emit (events.js:213:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)
gyp ERR! System Darwin 16.7.0
gyp ERR! command "/usr/local/Cellar/node/8.7.0/bin/node" "/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/.bin/node-gyp" "rebuild" "--target=1.7.9" "--arch=x64" "--dist-url=https://atom.io/download/electron" "--build-from-source" "--module_name=node_sqlite3" "--module_path=/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/sqlite3/lib/binding/electron-v1.7-darwin-x64" "--host=https://mapbox-node-binary.s3.amazonaws.com" "--remote_path=./{name}/v3.1.13/{toolset}/" "--package_name=electron-v1.7-darwin-x64.tar.gz"
gyp ERR! cwd /Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/sqlite3
gyp ERR! node -v v8.7.0
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok

Failed with exit code: 1

Error: action_after_build.target.mk:6: *** missing separator.  Stop.
gyp ERR! build error
gyp ERR! stack Error: `make` failed with exit code: 2
gyp ERR! stack     at ChildProcess.onExit (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/node-gyp/lib/build.js:258:23)
gyp ERR! stack     at emitTwo (events.js:125:13)
gyp ERR! stack     at ChildProcess.emit (events.js:213:7)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:200:12)
gyp ERR! System Darwin 16.7.0
gyp ERR! command "/usr/local/Cellar/node/8.7.0/bin/node" "/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/.bin/node-gyp" "rebuild" "--target=1.7.9" "--arch=x64" "--dist-url=https://atom.io/download/electron" "--build-from-source" "--module_name=node_sqlite3" "--module_path=/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/sqlite3/lib/binding/electron-v1.7-darwin-x64" "--host=https://mapbox-node-binary.s3.amazonaws.com" "--remote_path=./{name}/v3.1.13/{toolset}/" "--package_name=electron-v1.7-darwin-x64.tar.gz"
gyp ERR! cwd /Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/sqlite3
gyp ERR! node -v v8.7.0
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok

Failed with exit code: 1
    at SafeSubscriber._error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/spawn-rx/lib/src/index.js:277:84)
    at SafeSubscriber.__tryOrUnsub (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:238:16)
    at SafeSubscriber.error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:197:26)
    at Subscriber._error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:128:26)
    at Subscriber.error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:102:18)
    at MapSubscriber.Subscriber._error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:128:26)
    at MapSubscriber.Subscriber.error (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:102:18)
    at SafeSubscriber._next (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/spawn-rx/lib/src/index.js:251:65)
    at SafeSubscriber.__tryOrUnsub (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:238:16)
    at SafeSubscriber.next (/Users/<name>/Documents/#Coding/InlandNewsRecorder/Electron/SQLiteTrial2/node_modules/rxjs/Subscriber.js:185:22)
npm ERR! code ELIFECYCLE
npm ERR! errno 255
npm ERR! sqlitetrial2@1.0.0 rebuild: `electron-rebuild -f -w sqlite3`
npm ERR! Exit status 255
npm ERR!
npm ERR! Failed at the sqlitetrial2@1.0.0 rebuild 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!     /Users/<name>/.npm/_logs/2017-10-19T04_25_41_870Z-debug.log

Any ideas? I followed both videos exactly as instructed and ran into issues for each. I’m lost!

Thank you so much for your help.

About this issue

Most upvoted comments

@trogers1 you need to install all dependency for sqlite3, like visual studio, python etc. or you can install it by single npm command ,just try it npm install -g windows-build-tools it will install all dependency for in windows.

then build sqlite3 with electron-rebuild. put this command to script in your package.json. “rebuild”: “electron-rebuild -f -w sqlite3”

Let me know if you have any issue.

+17
NikunjChotaliya on Feb 4, 2018

Same to me! windows 10 npm v6.4.1 sqlite3 v4.0.0.2 electron v3.0.0 electron-rebuild v1.8.2

i have node_modules/sqlite3/lib/binding/node-v64-win32-x64/node_sqlite3.node, but need node_modules/sqlite3/lib/binding/electron-v3.0-win32-x64/node_sqlite3.node

+6
coconutbox on Sep 24, 2018

@trogers1 i was facing the same issue. Just add this script in your package.json.

"postinstall": "electron-builder install-app-deps",

Then do npm run postinstall. This should rebuild native dependencies. After this change i am now successfully able to run npm run dev. Version that i have is as below.

"devDependencies": {
    "electron": "^1.7.10",
    "electron-builder": "^19.50.0"
}

Just give it a try. I found this at:- https://github.com/electron-userland/electron-builder/issues/2294. As per this reference, electron-rebuild is not required if we are using electron-builder.

+5
developeryashraj on Jan 2, 2018

@NikunjChotaliya Why it doesn’t work for me. I run: npm install -g windows-build-tools then: add “rebuild”: “electron-rebuild -f -w sqlite3” in my package.json. then run npm rebuild. It’s fine. But it generate a file “[sqlite3] Success: “D:\code\Mynote\node_modules_sqlite3@4.0.2@sqlite3\lib\binding\node-v57-win32-x64\node_sqlite3.node” already installed”

not file “node_modules_sqlite3@4.0.2@sqlite3\lib\binding\electron-v2.0-win32-x64\node_sqlite3.node”. So when I run npm start, there is still error: “electron-v2.0-win32-x64\node_sqlite3.node” file not found. My OS is Windows7. Can somebody help me?

+3
valleygtc on Aug 2, 2018

I had a similar problem, it seems python bin directory was not in my PATH, which was causing problems.

+2
ilkerulutas on Jul 19, 2018

Here is my package.json.

{
"dependencies": {
    "axios": "^0.17.1",
    "d3": "^4.10.2",
    "electron-is-dev": "^0.3.0",
    "electron-updater": "^2.17.6",
    "mqtt": "^2.15.0",
    "ncp": "^2.0.0",
    "react": "^15.6.2",
    "react-dom": "^15.6.2",
    "react-notify-toast": "^0.4.0",
    "react-redux": "^5.0.6",
    "react-router-dom": "^4.2.2",
    "react-tap-event-plugin": "^3.0.2",
    "redux": "^3.7.2",
    "redux-thunk": "^2.2.0",
    "sqlite3": "^3.1.13",
    "sqlite3-transactions": "0.0.5",
    "verbose": "^0.2.3"
  }, 
"scripts": {
    "start": "react-scripts start",
    "build": "react-scripts build",
    "rebuild": "electron-rebuild -f -w sqlite3",
    "test": "react-scripts test --env=jsdom",
    "eject": "react-scripts eject",
    "electron": "electron .",
    "postinstall": "electron-builder install-app-deps",
    "electron:build": "electron-builder",
    "dev": "nf start -p 3001",
    "electron-pack": "build --em.main=build/electron.js",
    "preelectron-pack": "npm run build"
  },
  "devDependencies": {
    "electron": "^1.7.10",
    "electron-builder": "^19.50.0",
    "electron-rebuild": "^1.6.0",
    "foreman": "^2.0.0",
    "react-scripts": "0.8.5"
  }
}

There is no such difference with your package.json. And Yes i am using sqlite3 as well. Previously getting same error that you have posted earlier but after doing this i’m not getting any error related to sqlite3 rebuild. This is what i did

  • Run command npm run postinstall
  • After completion of that i run npm run dev to start an application in dev environment. (this can be different in your case. i’ve used react with electron so have used foreman to run react and electron one after other).
  • I am not running npm run rebuild now. Just try to run npm start directly after npm run postinstall command executed.

Hope this helps 😃

+2
developeryashraj on Jan 3, 2018

Thank you for the “windows-build-tools” hint!

+1
dmr on Jun 23, 2018

I found it， it is the “https://atom.io/download/electron” url， has no related package

+1
epver on Nov 17, 2017
Read more comments on GitHub
← rebuild: Can't rebuild nslog on windows
rebuild: Failed Rebuilding canvas: error LNK2019: unresolved external symbol "__declspec(dllimport) public: class std::shared_ptr<class v8::BackingStore> __cdecl v8::ArrayBuffer::GetBackingStore(void)" →