Buggy after installation

[kelvinccho]

I've installed the certificate after following the guide. Nothing I can do after installation.

Here's output prompted after the installation:

Starting embedded MySQL Shell, using config dir '/Users/cheukchunho/.mysqlsh-gui' ...
Please enter the single instance token: 
14:29:53.779798 INFO: Token read from STDIN

14:29:53.787618 INFO: Starting MySQL Shell GUI web server...

14:29:53.788176 INFO: 	Checking web server certificate...

14:29:53.811321 INFO: 	Certificate is installed.

14:29:53.817710 INFO: 	Port: 33336

14:29:53.817808 INFO: 	Secure: True
14:29:53.817830 INFO: 	Webroot: /Users/cheukchunho/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-darwin-arm64/shell/lib/mysqlsh/plugins/gui_plugin/core/webroot
14:29:53.817848 INFO: 	Mode: Single user

Could not establish websocket connection: {}

[JackWilb]

I have the same issue, but in a devcontainer. Not sure if you experienced the same problem @kelvinccho

[kali-777]

I had high hopes for this Extension , but I a have SAME problem windows 10 latest updates also latest version of VS Code & the Extension MySQL Shell for VS Code 1.16.4+9.0.1 Preview, as per netstat its do NOT even listening on port 33336 🤨

Running on a local VS Code session.
Starting embedded MySQL Shell, using config dir 'C:\Users\klakos\AppData\Roaming\MySQL\mysqlsh-gui' ...
Please enter the single instance token: 3:59:9.950262 INFO: Token read from STDIN
3:59:10.61236 INFO: Starting MySQL Shell GUI web server...
3:59:10.62237 INFO: Checking web server certificate...
3:59:10.319244 INFO: Certificate is installed.
3:59:10.367236 INFO: Port: 33336
3:59:10.367236 INFO: Secure: True
3:59:10.367236 INFO: Webroot: c:\Users\klakos.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot
3:59:10.367236 INFO: Mode: Single user

Could not establish websocket connection: {}

I uninstalled/reinstalled/reseted/etc.. as per the mysqlsh.log it was able to connected, but its never "show" that in Output?! 🙄

2024-10-23 21:53:34: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 21:53:34: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 21:53:34: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 21:53:34: Info: Loading startup files... 2024-10-23 21:53:34: Info: Loading plugins... 2024-10-23 21:53:54: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 21:53:54: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 21:53:54: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 21:53:54: Info: Loading startup files... 2024-10-23 21:53:54: Info: Loading plugins... 2024-10-23 21:53:57: Info: [MSG] Token read from STDIN 2024-10-23 21:53:57: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 21:53:57: Info: [MSG] Checking web server certificate... 2024-10-23 21:53:57: Info: [MSG] Certificate is installed. 2024-10-23 21:53:58: Info: [MSG] Port: 33336 2024-10-23 21:53:58: Info: [MSG] Secure: True 2024-10-23 21:53:58: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 21:53:58: Info: [MSG] Mode: Single user 2024-10-23 21:59:58: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 21:59:58: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 21:59:58: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 21:59:58: Info: Loading startup files... 2024-10-23 21:59:58: Info: Loading plugins... 2024-10-23 21:59:59: Info: [MSG] Token read from STDIN 2024-10-23 21:59:59: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 21:59:59: Info: [MSG] Checking web server certificate... 2024-10-23 21:59:59: Info: [MSG] Certificate is installed. 2024-10-23 21:59:59: Info: [MSG] Port: 33336 2024-10-23 21:59:59: Info: [MSG] Secure: True 2024-10-23 21:59:59: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 21:59:59: Info: [MSG] Mode: Single user 2024-10-23 22:00:01: Info: [MSG] Websocket connected 2024-10-23 22:00:01: Info: [MSG] Registering session... 2024-10-23 22:00:01: Info: [MSG] Sending session response... 2024-10-23 22:04:45: Error: [MSG] Error reading from the web socket: Websocket read aborted while listening. unpack requires a buffer of 2 bytes 2024-10-23 22:05:42: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:05:42: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:05:42: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:05:42: Info: Loading startup files... 2024-10-23 22:05:42: Info: Loading plugins... 2024-10-23 22:05:43: Info: [MSG] Token read from STDIN 2024-10-23 22:05:43: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:05:43: Info: [MSG] Checking web server certificate... 2024-10-23 22:05:43: Info: [MSG] Certificate is installed. 2024-10-23 22:05:43: Info: [MSG] Port: 33336 2024-10-23 22:05:43: Info: [MSG] Secure: True 2024-10-23 22:05:43: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:05:43: Info: [MSG] Mode: Single user 2024-10-23 22:05:43: Info: [MSG] Websocket connected 2024-10-23 22:05:44: Info: [MSG] Registering session... 2024-10-23 22:05:44: Info: [MSG] Sending session response... 2024-10-23 22:05:47: Info: [MSG] Websocket connected 2024-10-23 22:05:47: Info: [MSG] Registering session... 2024-10-23 22:05:47: Info: [MSG] Sending session response... 2024-10-23 22:19:49: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:19:50: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:19:50: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:19:50: Info: Loading startup files... 2024-10-23 22:19:50: Info: Loading plugins... 2024-10-23 22:19:50: Info: [MSG] Token read from STDIN 2024-10-23 22:19:50: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:19:50: Info: [MSG] Checking web server certificate... 2024-10-23 22:19:51: Info: [MSG] Certificate is installed. 2024-10-23 22:19:51: Info: [MSG] Port: 33336 2024-10-23 22:19:51: Info: [MSG] Secure: True 2024-10-23 22:19:51: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:19:51: Info: [MSG] Mode: Single user 2024-10-23 22:19:51: Info: [MSG] Websocket connected 2024-10-23 22:19:51: Info: [MSG] Registering session... 2024-10-23 22:19:51: Info: [MSG] Sending session response... 2024-10-23 22:20:01: Info: [MSG] Closing the already closed socket connection. Ignore. 2024-10-23 22:20:32: Info: [MSG] Websocket connected 2024-10-23 22:20:32: Info: [MSG] Registering session... 2024-10-23 22:20:32: Info: [MSG] Sending session response... 2024-10-23 22:20:33: Info: [MSG] Closing the already closed socket connection. Ignore. 2024-10-23 22:21:37: Info: [MSG] Closing the already closed socket connection. Ignore. 2024-10-23 22:23:46: Info: [MSG] Closing the already closed socket connection. Ignore. 2024-10-23 22:25:15: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:25:15: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:25:15: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:25:15: Info: Loading startup files... 2024-10-23 22:25:15: Info: Loading plugins... 2024-10-23 22:25:16: Info: [MSG] Token read from STDIN 2024-10-23 22:25:16: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:25:16: Info: [MSG] Checking web server certificate... 2024-10-23 22:25:16: Info: [MSG] Certificate is installed. 2024-10-23 22:25:16: Info: [MSG] Port: 33336 2024-10-23 22:25:16: Info: [MSG] Secure: True 2024-10-23 22:25:16: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:25:16: Info: [MSG] Mode: Single user 2024-10-23 22:25:16: Info: [MSG] Websocket connected 2024-10-23 22:25:16: Info: [MSG] Registering session... 2024-10-23 22:25:16: Info: [MSG] Sending session response... 2024-10-23 22:25:18: Info: [MSG] Websocket connected 2024-10-23 22:25:18: Info: [MSG] Registering session... 2024-10-23 22:25:18: Info: [MSG] Sending session response... 2024-10-23 22:26:21: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:26:21: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:26:21: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:26:21: Info: Loading startup files... 2024-10-23 22:26:21: Info: Loading plugins... 2024-10-23 22:28:52: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:28:52: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:28:52: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:28:52: Info: Loading startup files... 2024-10-23 22:28:52: Info: Loading plugins... 2024-10-23 22:29:07: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:29:07: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:29:07: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:29:07: Info: Loading startup files... 2024-10-23 22:29:07: Info: Loading plugins... 2024-10-23 22:29:09: Info: [MSG] Token read from STDIN 2024-10-23 22:29:10: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:29:10: Info: [MSG] Checking web server certificate... 2024-10-23 22:29:10: Info: [MSG] Certificate is installed. 2024-10-23 22:29:10: Info: [MSG] Port: 33336 2024-10-23 22:29:10: Info: [MSG] Secure: True 2024-10-23 22:29:10: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:29:10: Info: [MSG] Mode: Single user 2024-10-23 22:51:57: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:51:57: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:51:57: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:51:57: Info: Loading startup files... 2024-10-23 22:51:57: Info: Loading plugins... 2024-10-23 22:51:58: Info: [MSG] Token read from STDIN 2024-10-23 22:51:58: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:51:58: Info: [MSG] Checking web server certificate... 2024-10-23 22:51:58: Info: [MSG] Certificate is installed. 2024-10-23 22:51:58: Info: [MSG] Port: 33336 2024-10-23 22:51:58: Info: [MSG] Secure: True 2024-10-23 22:51:58: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:51:58: Info: [MSG] Mode: Single user 2024-10-23 22:51:58: Info: [MSG] Websocket connected 2024-10-23 22:51:58: Info: [MSG] Registering session... 2024-10-23 22:51:58: Info: [MSG] Sending session response... 2024-10-23 22:52:00: Info: [MSG] Websocket connected 2024-10-23 22:52:00: Info: [MSG] Registering session... 2024-10-23 22:52:00: Info: [MSG] Sending session response... 2024-10-23 22:52:35: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:52:35: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:52:35: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:52:35: Info: Loading startup files... 2024-10-23 22:52:35: Info: Loading plugins... 2024-10-23 22:52:52: Info: [MSG] Websocket closed 2024-10-23 22:54:25: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:54:25: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:54:25: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:54:25: Info: Loading startup files... 2024-10-23 22:54:25: Info: Loading plugins... 2024-10-23 22:54:39: Info: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysqlsh.exe Ver 9.0.1 for Win64 on x86_64 - for MySQL 9.0.1 (MySQL Community Server (GPL)) - build 16131816 - commit_id 9f8468e28322e8a1bdcc7498847987b3f78fa9a9 - product_id windows-x86-64bit-release zip 2024-10-23 22:54:39: Info: Using credential store helper: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\bin\mysql-secret-store-windows-credential.exe 2024-10-23 22:54:39: Info: Setting Python home to 'c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\Python3.12' 2024-10-23 22:54:39: Info: Loading startup files... 2024-10-23 22:54:39: Info: Loading plugins... 2024-10-23 22:54:41: Info: [MSG] Token read from STDIN 2024-10-23 22:54:41: Info: [MSG] Starting MySQL Shell GUI web server... 2024-10-23 22:54:41: Info: [MSG] Checking web server certificate... 2024-10-23 22:54:42: Info: [MSG] Certificate is installed. 2024-10-23 22:54:42: Info: [MSG] Port: 33336 2024-10-23 22:54:42: Info: [MSG] Secure: True 2024-10-23 22:54:42: Info: [MSG] Webroot: c:\Users\klakos\.vscode\extensions\oracle.mysql-shell-for-vs-code-1.16.4-win32-x64\shell\lib\mysqlsh\plugins\gui_plugin\core\webroot 2024-10-23 22:54:42: Info: [MSG] Mode: Single user