vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

Published 20 hours ago • verified publisher icon mtxr

Can't install sqlite3 4.2.0

Open Yanpas opened this issue 4 years ago • 6 comments

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

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. 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 [email protected]: 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 [email protected]
npm ERR! node-pre-gyp info using [email protected] | 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 [email protected] and [email protected] (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 [email protected]
npm ERR! gyp info using [email protected] | win32 | x64
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using [email protected]
npm ERR! gyp info using [email protected] | 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 [email protected]: 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 [email protected]
npm ERR! node-pre-gyp info using [email protected] | 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 [email protected] and [email protected] (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 [email protected]
npm ERR! gyp info using [email protected] | win32 | x64
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using [email protected]
npm ERR! gyp info using [email protected] | 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..?

Yanpas avatar Aug 21 '21 10:08 Yanpas

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

Yanpas avatar Aug 21 '21 10:08 Yanpas

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 [email protected] 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" "[email protected]" 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 [email protected] 423 error node-pre-gyp info using [email protected] | 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 [email protected] and [email protected] (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 [email protected] 423 error gyp info using [email protected] | win32 | x64 423 error gyp info ok 423 error gyp info it worked if it ends with ok 423 error gyp info using [email protected] 423 error gyp info using [email protected] | 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

rgimenes26 avatar Dec 10 '21 17:12 rgimenes26

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 "[email protected]" to connect to...' messages.

magic-lantern avatar Dec 20 '21 20:12 magic-lantern

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

s-wuest avatar Jan 02 '22 17:01 s-wuest

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.

gotounix avatar Jun 01 '22 07:06 gotounix

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!

s-wuest avatar Jun 05 '22 13:06 s-wuest

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?

idantr avatar Sep 04 '22 12:09 idantr

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..

mtxr avatar Sep 05 '22 01:09 mtxr

@idantr please use the link at https://github.com/mtxr/vscode-sqltools/pull/953#issuecomment-1237171674 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.

gjsjohnmurray avatar Sep 05 '22 15:09 gjsjohnmurray

@mtxr when is v0.4.0 of sqlite plugin expected as it includes the fix https://github.com/mtxr/vscode-sqltools/pull/953 that i use?

idantr avatar Oct 02 '22 08:10 idantr

@idantr it is already on Marketplace.

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

gjsjohnmurray avatar Oct 02 '22 11:10 gjsjohnmurray

@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?

idantr avatar Oct 02 '22 14:10 idantr

@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.

gjsjohnmurray avatar Oct 02 '22 15:10 gjsjohnmurray