Can't install sqlite3 4.2.0 #858

Yanpas · 2021-08-21T10:33:45Z

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

SQLTools Version 0.23
VSCode Version: [e.g 1.x.y]
OS: Windows
Driver:
- PostgreSQL/Redshift
- MySQL/MariaDB
- MSSQL/Azure
- SQLite
- Other? Which...
Database version: [e.g. MySQL v5.6, PostgreSQL vX...]

Additional context

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\yanpas\AppData\Local\npm-cache\_logs\2021-08-21T10_26_50_694Z-debug.log
, {"code":-32603}
    ns: "error-handler"
[1629541695321] INFO  (ext): EXECUTING COMMAND => sqltools.selectConnection
[1629541695323] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1629541695326] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1629541695330] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1629541695331] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1629541695338] INFO  (ls): REQUEST RECEIVED => connection/ConnectRequest
[1629541695338] INFO  (ls): Connection instance created for memory.
    ns: "conn-manager"
[1629541695346] ERROR (ls): Connecting error: {"code":1000,"data":{"notification":"Core/missingModule","dontNotify":true,"args":{"conn":{"previewLimit":500,"driver":"SQLite","name":"memory","database":":memory:","isActive":false,"isConnected":false,"id":"memory|SQLite||:memory:"},"action":"install","deps":[{"type":"package","name":"sqlite3","version":"4.2.0"}]}}}
    ns: "conn-manager"
[1629541695353] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1629541695372] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1629541695375] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1629541697527] INFO  (ls): REQUEST RECEIVED => DependencyInstaller/install
[1629541697528] INFO  (ls): Will install sqlite3 package
    ns: "dep-man"
npm WARN deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future
npm ERR! code 1
npm ERR! path C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
npm ERR! Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
npm ERR! node-pre-gyp info using node@16.7.0 | win32 | x64
npm ERR! node-pre-gyp WARN Using needle for node-pre-gyp https download 
npm ERR! node-pre-gyp info check checked for "C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz 
npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@16.7.0 (node-v93 ABI, unknown) (falling back to source compile with node-gyp) 
npm ERR! node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@16.7.0 | win32 | x64
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@16.7.0 | win32 | x64
npm ERR! gyp info find Python using Python version 3.9.6 found at "C:\Python39\python.exe"
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! find VS msvs_version not set from command line or npm config
npm ERR! gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
npm ERR! gyp ERR! find VS could not use PowerShell to find Visual Studio 2017 or newer, try re-running with '--loglevel silly' for more details
npm ERR! gyp ERR! find VS looking for Visual Studio 2015
npm ERR! gyp ERR! find VS - not found
npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS You need to install the latest version of Visual Studio
npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
npm ERR! gyp ERR! find VS For more information consult the documentation at:
npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! configure error 
npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
npm ERR! gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
npm ERR! gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
npm ERR! gyp ERR! stack     at ChildProcess.exithandler (node:child_process:404:5)
npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:394:28)
npm ERR! gyp ERR! stack     at maybeClose (node:internal/child_process:1064:16)
npm ERR! gyp ERR! System Windows_NT 10.0.19043
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\yanpas\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\sqlite3\\lib\\binding\\node-v93-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\sqlite3\\lib\\binding\\node-v93-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v93"
npm ERR! gyp ERR! cwd C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! gyp ERR! node -v v16.7.0
npm ERR! gyp ERR! node-gyp -v v7.1.2
npm ERR! gyp ERR! not ok 
npm ERR! node-pre-gyp ERR! build error 
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:394:28)
npm ERR! node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1064:16)
npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:301:5)
npm ERR! node-pre-gyp ERR! System Windows_NT 10.0.19043
npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! node-pre-gyp ERR! node -v v16.7.0
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\yanpas\AppData\Local\npm-cache\_logs\2021-08-21T10_28_36_609Z-debug.log
[1629541716741] ERROR (ext): ERROR: Failed to install dependencies for SQLite: Request DependencyInstaller/install failed with message: npm WARN deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future
npm ERR! code 1
npm ERR! path C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
npm ERR! Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
npm ERR! node-pre-gyp info using node@16.7.0 | win32 | x64
npm ERR! node-pre-gyp WARN Using needle for node-pre-gyp https download 
npm ERR! node-pre-gyp info check checked for "C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz 
npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@16.7.0 (node-v93 ABI, unknown) (falling back to source compile with node-gyp) 
npm ERR! node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@16.7.0 | win32 | x64
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@7.1.2
npm ERR! gyp info using node@16.7.0 | win32 | x64
npm ERR! gyp info find Python using Python version 3.9.6 found at "C:\Python39\python.exe"
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! find VS msvs_version not set from command line or npm config
npm ERR! gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
npm ERR! gyp ERR! find VS could not use PowerShell to find Visual Studio 2017 or newer, try re-running with '--loglevel silly' for more details
npm ERR! gyp ERR! find VS looking for Visual Studio 2015
npm ERR! gyp ERR! find VS - not found
npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS You need to install the latest version of Visual Studio
npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
npm ERR! gyp ERR! find VS For more information consult the documentation at:
npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
npm ERR! gyp ERR! find VS **************************************************************
npm ERR! gyp ERR! find VS 
npm ERR! gyp ERR! configure error 
npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
npm ERR! gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
npm ERR! gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
npm ERR! gyp ERR! stack     at C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
npm ERR! gyp ERR! stack     at ChildProcess.exithandler (node:child_process:404:5)
npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:394:28)
npm ERR! gyp ERR! stack     at maybeClose (node:internal/child_process:1064:16)
npm ERR! gyp ERR! System Windows_NT 10.0.19043
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\yanpas\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\sqlite3\\lib\\binding\\node-v93-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\sqlite3\\lib\\binding\\node-v93-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v93"
npm ERR! gyp ERR! cwd C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! gyp ERR! node -v v16.7.0
npm ERR! gyp ERR! node-gyp -v v7.1.2
npm ERR! gyp ERR! not ok 
npm ERR! node-pre-gyp ERR! build error 
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\yanpas\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:394:28)
npm ERR! node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1064:16)
npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:301:5)
npm ERR! node-pre-gyp ERR! System Windows_NT 10.0.19043
npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\yanpas\\AppData\\Local\\vscode-sqltools\\Data\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd C:\Users\yanpas\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
npm ERR! node-pre-gyp ERR! node -v v16.7.0
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\yanpas\AppData\Local\npm-cache\_logs\2021-08-21T10_28_36_609Z-debug.log
, {"code":-32603}
    ns: "error-handler"

Why vesion 4.2.0 is hard coded? Why not just use 4..?

The text was updated successfully, but these errors were encountered:

Yanpas · 2021-08-21T10:36:49Z

Thoughts: installing drivers is a major PITA. Maybe things were easier if backend was using java+JDBC instead of node

rgimenes26 · 2021-12-10T17:29:25Z

I'm having the same error and could not use SQLTools yet. Tried evething and cant make it work.

When i thy to connect to the database it ask to install sqlite3 v.4.2.0 and them it fails.

Windows 11 , node 16.13.1, npm 8.1.2.

The final part of the log here:

410 timing command:install Completed in 10635ms

411 verbose stack Error: command failed
411 verbose stack at ChildProcess. (C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules@npmcli\promise-spawn\index.js:64:27)
411 verbose stack at ChildProcess.emit (node:events:390:28)
411 verbose stack at maybeClose (node:internal/child_process:1064:16)
411 verbose stack at Process.ChildProcess._handle.onexit (node:internal/child_process:301:5)
412 verbose pkgid sqlite3@4.2.0
413 verbose cwd C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data
414 verbose Windows_NT 10.0.22000
415 verbose argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "sqlite3@4.2.0"
416 verbose node v16.13.1
417 verbose npm v8.1.2
418 error code 1
419 error path C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
420 error command failed
421 error command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
422 error Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
423 error node-pre-gyp info it worked if it ends with ok
423 error node-pre-gyp info using node-pre-gyp@0.11.0
423 error node-pre-gyp info using node@16.13.1 | win32 | x64
423 error node-pre-gyp WARN Using needle for node-pre-gyp https download
423 error node-pre-gyp info check checked for "C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node" (not found)
423 error node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
423 error node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
423 error node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
423 error node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@16.13.1 (node-v93 ABI, unknown) (falling back to source compile with node-gyp)
423 error node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v93-win32-x64.tar.gz
423 error gyp info it worked if it ends with ok
423 error gyp info using node-gyp@8.3.0
423 error gyp info using node@16.13.1 | win32 | x64
423 error gyp info ok
423 error gyp info it worked if it ends with ok
423 error gyp info using node-gyp@8.3.0
423 error gyp info using node@16.13.1 | win32 | x64
423 error gyp ERR! find Python
423 error gyp ERR! find Python Python is not set from command line or npm configuration
423 error gyp ERR! find Python Python is not set from environment variable PYTHON
423 error gyp ERR! find Python checking if "python3" can be used
423 error gyp ERR! find Python - "python3" is not in PATH or produced an error
423 error gyp ERR! find Python checking if "python" can be used
423 error gyp ERR! find Python - "python" is not in PATH or produced an error
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python39\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python39\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python39\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python39\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python39-32\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python39-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python39-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python39-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files (x86)\Python39-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files (x86)\Python39-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python38\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python38\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python38\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python38\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python38-32\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python38-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python38-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python38-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files (x86)\Python38-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files (x86)\Python38-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python37\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python37\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python37\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python37\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python37-32\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python37-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python37-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python37-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files (x86)\Python37-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files (x86)\Python37-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python36\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python36\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python36\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python36\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python36-32\python.exe
423 error gyp ERR! find Python - "C:\Users\rafael.gimenes\AppData\Local\Programs\Python\Python36-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files\Python36-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files\Python36-32\python.exe" could not be run
423 error gyp ERR! find Python checking if Python is C:\Program Files (x86)\Python36-32\python.exe
423 error gyp ERR! find Python - "C:\Program Files (x86)\Python36-32\python.exe" could not be run
423 error gyp ERR! find Python checking if the py launcher can be used to find Python 3
423 error gyp ERR! find Python - "py.exe" is not in PATH or produced an error
423 error gyp ERR! find Python
423 error gyp ERR! find Python **********************************************************
423 error gyp ERR! find Python You need to install the latest version of Python.
423 error gyp ERR! find Python Node-gyp should be able to find and use Python. If not,
423 error gyp ERR! find Python you can try one of the following options:
423 error gyp ERR! find Python - Use the switch --python="C:\Path\To\python.exe"
423 error gyp ERR! find Python (accepted by both node-gyp and npm)
423 error gyp ERR! find Python - Set the environment variable PYTHON
423 error gyp ERR! find Python - Set the npm configuration variable python:
423 error gyp ERR! find Python npm config set python "C:\Path\To\python.exe"
423 error gyp ERR! find Python For more information consult the documentation at:
423 error gyp ERR! find Python https://github.com/nodejs/node-gyp#installation
423 error gyp ERR! find Python **********************************************************
423 error gyp ERR! find Python
423 error gyp ERR! configure error
423 error gyp ERR! stack Error: Could not find any Python installation to use
423 error gyp ERR! stack at PythonFinder.fail (C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\lib\find-python.js:330:47)
423 error gyp ERR! stack at PythonFinder.runChecks (C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\lib\find-python.js:159:21)
423 error gyp ERR! stack at PythonFinder. (C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\lib\find-python.js:228:18)
423 error gyp ERR! stack at PythonFinder.execFileCallback (C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\lib\find-python.js:294:16)
423 error gyp ERR! stack at exithandler (node:child_process:404:5)
423 error gyp ERR! stack at ChildProcess.errorhandler (node:child_process:416:5)
423 error gyp ERR! stack at ChildProcess.emit (node:events:390:28)
423 error gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:288:12)
423 error gyp ERR! stack at onErrorNT (node:internal/child_process:477:16)
423 error gyp ERR! stack at processTicksAndRejections (node:internal/process/task_queues:83:21)
423 error gyp ERR! System Windows_NT 10.0.22000
423 error gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v93"
423 error gyp ERR! cwd C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
423 error gyp ERR! node -v v16.13.1
423 error gyp ERR! node-gyp -v v8.3.0
423 error gyp ERR! not ok
423 error node-pre-gyp ERR! build error
423 error node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\rafael.gimenes\AppData\Roaming\nvm\v16.13.1\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3\lib\binding\node-v93-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v93' (1)
423 error node-pre-gyp ERR! stack at ChildProcess. (C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
423 error node-pre-gyp ERR! stack at ChildProcess.emit (node:events:390:28)
423 error node-pre-gyp ERR! stack at maybeClose (node:internal/child_process:1064:16)
423 error node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (node:internal/child_process:301:5)
423 error node-pre-gyp ERR! System Windows_NT 10.0.22000
423 error node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
423 error node-pre-gyp ERR! cwd C:\Users\rafael.gimenes\AppData\Local\vscode-sqltools\Data\node_modules\sqlite3
423 error node-pre-gyp ERR! node -v v16.13.1
423 error node-pre-gyp ERR! node-pre-gyp -v v0.11.0
423 error node-pre-gyp ERR! not ok
424 verbose exit 1

magic-lantern · 2021-12-20T20:21:22Z

I've used this extension for about a year for SQLite. Has worked well and been easy to use. Somehow in the last month or two it stopped working and I get a similar error as reported above. Endless 'You need to install "sqlite3@4.2.0" to connect to...' messages.

s-wuest · 2022-01-02T17:06:45Z

I also have this very same error. Couldn't use SQLite until now because of it.
Does anyone know a workaround to this?

gotounix · 2022-06-01T07:55:17Z

In Windows:

npm install -g node-gyp

Then, go to C:\Users\USERNAME\AppData\Local\vscode-sqltools\Data:

npm install sqlite3

Last and Important, edit C:\Users\USERNAME\.vscode\extensions\mtxr.sqltools-driver-sqlite-0.2.0\out\ls\plugin.js file, search 4.2.0 and change it to 5.0.8(your installed version).

Restart VS Code, everything goes well.

s-wuest · 2022-06-05T13:29:15Z

In Windows:
npm install -g node-gyp
Then, go to C:\Users\USERNAME\AppData\Local\vscode-sqltools\Data:
npm install sqlite3
Last and Important, edit C:\Users\USERNAME\.vscode\extensions\mtxr.sqltools-driver-sqlite-0.2.0\out\ls\plugin.js file, search 4.2.0 and change it to 5.0.8(your installed version).

Restart VS Code, everything goes well.

This solution worked for me. Huge Kudos!

idantr · 2022-09-04T12:53:58Z

We too have this issue, and updating C:\Users\USERNAME.vscode\extensions\mtxr.sqltools-driver-sqlite-0.2.0\out\ls\plugin.js manually is a currently a workaround, is a more permanent solution planned?

mtxr · 2022-09-05T01:27:19Z

have anyone used better-sqlite3 library before? it seems to be a good alternative for the sqlite extension. I'm considering to give it a try for the sqlite driver if it helps on the installation workflow. This gyp issues is always trouble..

gjsjohnmurray · 2022-09-05T15:44:02Z

@idantr please use the link at #953 (comment) to download a zip containing a pre-release version of the SQLite driver VSIX. Install it (e.g. drag/drop into the Extension view of VS Code), then reload VS Code and retry your connection.

idantr · 2022-10-02T08:11:22Z

@mtxr when is v0.4.0 of sqlite plugin expected as it includes the fix #953 that i use?

gjsjohnmurray · 2022-10-02T11:54:14Z

@idantr it is already on Marketplace.

https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools-driver-sqlite

idantr · 2022-10-02T14:11:39Z

@idantr it is already on Marketplace.

https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools-driver-sqlite

thanks a lot , we cannot use the links in the marketplace due to licensing issues can you please also update https://github.com/mtxr/vscode-sqltools/releases/tag/v0.24.0 with the latest version of this plugin?

gjsjohnmurray · 2022-10-02T15:59:23Z

@mtxr please attach the new driver VSIX files to the 0.25.0 release record when you publish it (see #997). Similarly the main extension VSIX onto 0.25.1.

Yanpas added the triage label Aug 21, 2021

gjsjohnmurray added sqlite SQLite driver dependencies Pull requests that update a dependency file labels Jul 22, 2022

This was referenced Jul 28, 2022

Unable to connect to SQLite database #921

Closed

Unable to install sqlte3. #904

Closed

gjsjohnmurray mentioned this issue Sep 5, 2022

Sqlite3 v5 #953

Merged

gjsjohnmurray removed triage dependencies Pull requests that update a dependency file labels Sep 6, 2022

mtxr closed this as completed Sep 21, 2022

gjsjohnmurray mentioned this issue Oct 2, 2022

0.25.0 release record needs finalizing and 0.25.1 record needs adding #997

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Can't install sqlite3 4.2.0 #858

Can't install sqlite3 4.2.0 #858

Yanpas commented Aug 21, 2021

Yanpas commented Aug 21, 2021

rgimenes26 commented Dec 10, 2021

magic-lantern commented Dec 20, 2021

s-wuest commented Jan 2, 2022

gotounix commented Jun 1, 2022

s-wuest commented Jun 5, 2022

idantr commented Sep 4, 2022

mtxr commented Sep 5, 2022

gjsjohnmurray commented Sep 5, 2022

idantr commented Oct 2, 2022

gjsjohnmurray commented Oct 2, 2022

idantr commented Oct 2, 2022

gjsjohnmurray commented Oct 2, 2022

Can't install sqlite3 4.2.0 #858

Can't install sqlite3 4.2.0 #858

Comments

Yanpas commented Aug 21, 2021

Yanpas commented Aug 21, 2021

rgimenes26 commented Dec 10, 2021

magic-lantern commented Dec 20, 2021

s-wuest commented Jan 2, 2022

gotounix commented Jun 1, 2022

s-wuest commented Jun 5, 2022

idantr commented Sep 4, 2022

mtxr commented Sep 5, 2022

gjsjohnmurray commented Sep 5, 2022

idantr commented Oct 2, 2022

gjsjohnmurray commented Oct 2, 2022

idantr commented Oct 2, 2022

gjsjohnmurray commented Oct 2, 2022