Bug #112994 Cannot create connection with mysql shell extension
Submitted: 7 Nov 2023 17:42 Modified: 8 Nov 2023 4:08
Reporter: Stefano Taino Email Updates:
Status: Analyzing Impact on me:
None 
Category:Shell VSCode Extension Severity:S1 (Critical)
Version:1.13.6 OS:Linux (Linux Mint 21)
Assigned to: MySQL Verification Team CPU Architecture:x86

[7 Nov 2023 17:42] Stefano Taino
Description:
Follow the instructions but the extension doesn't work..
I already checked that in the system under /etc/ssl/certs there is rootCA.pem and in /usr/local/share/ca-certificates there is rootCA.crt. Also in the config folder of extension there are all certificates. 
Nothing work

How to repeat:
1. Start vscode and install extension
2. Follow welcome wizard for installing certificates
3. Try to make a new connection but failed because rootCA certificates is not installed on the system

Below the debug, output information:
2023-11-07 17:01:50: Info: /home/stefano/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-linux-x64/shell/bin/mysqlsh   Ver 8.1.1-g2 for Linux on x86_64 - for MySQL 8.1.0 (MySQL Community Server (GPL)) - build 12914698 - commit_id 49c753ad55f63fa4f21f0265ce945071ac54b60f
2023-11-07 17:01:51: Info: Using credential store helper: /home/stefano/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-linux-x64/shell/bin/mysql-secret-store-login-path
2023-11-07 17:01:51: Info: Setting Python home to '/home/stefano/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-linux-x64/shell/lib/mysqlsh'
2023-11-07 17:01:51: Info: Loading startup files...
2023-11-07 17:01:51: Info: Loading plugins...
2023-11-07 17:01:52: Info: [MSG] Token read from STDIN
2023-11-07 17:01:52: Info: [MSG] Starting MySQL Shell GUI web server...
2023-11-07 17:01:52: Info: [MSG] 	Checking web server certificate...
2023-11-07 17:01:52: Info: [MSG] 	Certificate is installed.
2023-11-07 17:01:52: Info: [MSG] 	Port: 33336
2023-11-07 17:01:52: Info: [MSG] 	Secure: True
2023-11-07 17:01:52: Info: [MSG] 	Webroot: /home/stefano/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin/core/webroot
2023-11-07 17:01:52: Info: [MSG] 	Mode: Single user
2023-11-07 17:01:53: Info: [MSG] Websocket connected
2023-11-07 17:01:53: Info: [MSG] Registering session...
2023-11-07 17:01:53: Info: [MSG] Sending session response...
2023-11-07 17:01:53: Error: [MSG] Failed to log message in the database.
2023-11-07 17:01:53: Error: [MSG] Exception sending a message. 'request_id'
2023-11-07 17:06:58: Error: [MSG] Failed to log message in the database.

In vscode output extension:
Running on a local VS Code session.
Starting embedded MySQL Shell, using config dir '/home/stefano/.mysqlsh-gui' ...
Please enter the single instance token: 18:1:52.108913 INFO: Token read from STDIN
18:1:52.109680 INFO: Starting MySQL Shell GUI web server...
18:1:52.110075 INFO: 	Checking web server certificate...
18:1:52.110376 INFO: 	Certificate is installed.
18:1:52.117773 DEBUG3: Connecting BackendDB-anonymous...

18:1:52.365553 DEBUG3: Connecting BackendDB-anonymous...
18:1:52.367530 INFO: 	Port: 33336
18:1:52.367720 INFO: 	Secure: True
18:1:52.367785 INFO: 	Webroot: /home/stefano/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.13.6-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin/core/webroot
18:1:52.367838 INFO: 	Mode: Single user

18:1:53.626706 DEBUG: "GET /ws1.ws?token=**** HTTP/1.1" 101 -
18:1:53.627038 INFO: Websocket connected
18:1:53.627525 INFO: Registering session...
18:1:53.628604 DEBUG3: Connecting BackendDB-anonymous...
18:1:53.631116 DEBUG3: Connecting BackendDB-anonymous...

18:1:53.760036 INFO: Sending session response...
18:1:53.761538 ERROR: Failed to log message in the database.
18:1:53.761786 ERROR: Exception sending a message. 'request_id'

18:6:58.488961 DEBUG2: <- {"request_id": "ccc7a591-bd3e-4dab-c176-427f54098ff0", "request": "execute", "command": "mds.list.config_profiles", "kwargs": {}}

18:6:58.489573 ERROR: Failed to log message in the database.

18:6:58.489859 DEBUG2: -> {"request_state": {"type": "ERROR", "msg": "Response cancelled by the application."}, "request_id": "ccc7a591-bd3e-4dab-c176-427f54098ff0"}