Open hjrb opened 1 year ago
Note: i'm behind a corperate proxy with authentication. I have not set the environment variables http_proxy or https_proxy
Hi @hrjb,
Can you please update your Azure data studio and extension to latest and verify if the issue occurs?
Version: 1.46.0 (system setup) Commit: 39449bbe88a0bc4092c9b205cad10d0a556beffd Date: 2023-09-16T01:40:10.706Z VS Code: 1.79.2 Electron: 22.3.14 Chromium: 108.0.5359.215 Node.js: 16.17.1 V8: 10.8.168.25-electron.0 OS: Windows_NT x64 10.0.19045
Same error messages.
also occur when running as Administrator
Can you share the screenshot of exact error message?
Also please check if the path exists: (Replace the your-user-name)
C:\Users\
The content of the path should look like below:
No it does not exist
Tree /A output of folder C:\Users\xxxxx.azuredatastudio\extensions\microsoft.azuredatastudio-mysql-1.0.0
Folder PATH listing for volume Windows Volume serial number is 4E30-5906 C:. +---.pipelines +---documentation +---i18n | +---chs | | ---out | +---cht | | ---out | +---deu | | ---out | +---esn | | ---out | +---fra | | ---out | +---ita | | ---out | +---jpn | | ---out | +---kor | | ---out | +---ptb | | ---out | ---rus | ---out +---images | +---dark | ---light +---node_modules | +---@microsoft | | +---ads-extension-telemetry | | | ---lib | | ---ads-service-downloader | | +---node_modules | | | ---tmp | | | ---lib | | ---out | +---@tootallnate | | ---once | | ---dist | +---@vscode | | ---extension-telemetry | | ---lib | +---agent-base | | ---dist | | ---src | +---async-retry | | ---lib | +---balanced-match | | ---.github | +---brace-expansion | +---buffer-crc32 | +---chownr | +---concat-map | | +---example | | ---test | +---dataprotocol-client | | +---.github | | | ---workflows | | +---lib | | ---src | +---debug | | ---src | +---eventemitter2 | | ---lib | +---fd-slicer | | ---test | +---fs-minipass | +---fs.realpath | +---glob | +---http-proxy-agent | | ---dist | +---https-proxy-agent | | ---dist | +---inflight | +---inherits | +---minimatch | +---minipass | +---minizlib | +---mkdirp | | +---bin | | ---lib | +---ms | +---once | +---os-tmpdir | +---path-is-absolute | +---pend | +---retry | | +---example | | ---lib | +---rimraf | +---semver | +---tar | | +---lib | | ---node_modules | | ---minipass | +---tmp | | ---lib | +---vscode-jsonrpc | | ---lib | +---vscode-languageclient | | ---lib | | ---utils | +---vscode-languageserver-protocol | | ---lib | | ---utils | +---vscode-languageserver-types | | ---lib | | +---esm | | ---umd | +---vscode-nls | | ---lib | | +---browser | | +---common | | ---node | | ---test | +---wrappy | +---yallist | ---yauzl +---out | +---bin | | ---Windows | | ---v0.1.2 | +---contracts | +---dialogs | +---features | +---models | ---utils +---snippets ---syntaxes
We also have MS AppLocker running. Maybe that is blocking something.
Any updates on this? I have been seeing this same issue (as submitter @hjrb) on my system for a while now after an update to ADS at some point this broke (was working in preview). I've tried completely wiping and reinstalling ADS & MySQL extension (even locating where they are installed and deleting directories and cache, etc.) and that still hasn't solved the problem. One thing this post mentioned I didn't know to check was the extension bin directory - it doesn't exist. I have:
C:\Users\<user_name>\.azuredatastudio\extensions\microsoft.azuredatastudio-mysql-1.0.0\out\bin\Windows\v0.1.2\
But nothing else in that last version folder. Seems it did not build the extension, which makes sense why it's "failing to start MySQL tools service". I tried adding http_proxy and https_proxy to my environment variables (because corporate firewall here as well). Usually that fixes download issues (like nuget), but that didn't seem to help here either.
I have found the issue. I took my laptop home with me, logged off the VPN and network and reinstalled the extension to discover this:
Downloading https://github.com/microsoft/mysqltoolsservice/releases/download/v0.1.2/mysqltoolsservice-win-x64.zip (34,117 KB)....................Done!
Installing MySQL Tools Service to c:\Users\<user_name>\.azuredatastudio\extensions\microsoft.azuredatastudio-mysql-1.0.0\out\bin\Windows\v0.1.2
Installed MySQL Tools Service
This is the reason it is failing to install while on a corporate network: they block downloading zip files from the internet. This is downloading without permission and without validation to extract and install another application. This is highly suspect for an installer to go out to the internet, download a zip file, then extract it and run installer in that. This is how viruses are spread. This package cannot be checked for correct sha hash, virus programs, etc... Any corporation is going to block this for security reasons.
The suggested fix for this is: the code is already downloading all of the source code material into the extension directory - just fire off a script command to build/compile the code fresh and new into the out folder. No point in downloading a separate installer for bin libraries.
Steps to Reproduce: