Bug #118255 MySql Sehll for VS Code Fails To Install Certificate
Submitted: 22 May 19:19 Modified: 26 May 7:35
Reporter: Eric Moore Email Updates:
Status: Duplicate Impact on me:
None 
Category:Shell VSCode Extension Severity:S1 (Critical)
Version:1.19.11 OS:Linux (Fedora 42 KDE Linux 6.14.6-300.fc42.x86_64)
Assigned to: CPU Architecture:x86 (Intel Xeon E5462 )
Tags: MySql Shell For VS Code

[22 May 19:19] Eric Moore 
Description:
Fedora 42
MySQL Shell For VS Code Wizard Fails on Certificate Installation. 

Kind of stuck because I have the output window open and nothing is being returned.
SELinux is set to permissive on the system. 

I am seeing no output in output to determine what the system is trying to do. 
I have looked at my System Logs and I don't see anything related to the effort to install the MySql Workbench. 

Local MySql install of MariaDB 10.11.11-MariaDB. 

Checked every entry in the Visual Studio Logs at ~/.config/Code/logs and there is nothing in any of these files that I can use to deduce what the failure might be.  

Machine is just being used local on localhost.   If there were clear direction to manually install the certificate.  I've visited the MySql page for this but I want to point out they go into a general discussion of installing Root-CA certificate but it doesn't really tie back to MySQL and the instruction are not clear and I really had no success because I can't actually find where to get the MySql Shell Certificate manually. 

Version: 1.100.2
Commit: 848b80aeb52026648a8ff9f7c45a9b0a80641e2e
Date: 2025-05-14T21:47:40.416Z
Electron: 34.5.1
ElectronBuildId: 11369351
Chromium: 132.0.6834.210
Node.js: 20.19.0
V8: 13.2.152.41-electron.0
OS: Linux x64 6.14.6-300.fc42.x86_64 snap

How to repeat:
Simply installed latest Fedora 42.  Set up Apache, MySql, Php those are all working. 
While I can use PHPMYADMIN, I'd like to get this solution working.  At least, maybe something that might be used to update Mysql Shell documentation for this problem that people can use to troubleshoot.
[22 May 19:27] Eric Moore 
From AI Response: 
On Fedora, logs for the MySQL Shell extension in Visual Studio Code (VS Code) are primarily stored within the VS Code extension directory structure. Specifically, they are located within the extension's folder, often found in a user's home directory. You can find the log files in the following location: ~/.vscode/extensions/oracle.mysql-shell-for-vs-code-<release>/shell/lib/mysqlsh/plugins/gui_plugin/internal/logs. 

THERE IS NO LOG FILE THAT I CAN FIND!!!

Terminal output of that folder: 
em@dreamfield:~/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.19.11-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin$ ls -l
total 548
drwxr-xr-x. 1 em em     64 May 21 16:24 cluster
drwxr-xr-x. 1 em em    664 May 21 16:24 core
drwxr-xr-x. 1 em em     86 May 21 16:24 db
drwxr-xr-x. 1 em em     76 May 21 16:24 db_connections
drwxr-xr-x. 1 em em     80 May 21 16:24 debugger
-rw-r--r--. 1 em em   3023 May 21 16:20 debug_utils.py
-rw-r--r--. 1 em em   1732 May 21 16:20 general.py
-rw-r--r--. 1 em em   1244 May 21 16:20 __init__.py
-rw-r--r--. 1 em em   4604 May 21 16:20 init.py
-rw-r--r--. 1 em em 539828 May 21 16:20 LICENSE
drwxr-xr-x. 1 em em     56 May 21 16:24 mds
drwxr-xr-x. 1 em em     64 May 21 16:24 modeler
drwxr-xr-x. 1 em em     84 May 21 16:24 modules
drwxr-xr-x. 1 em em    134 May 21 16:24 __pycache__
drwxr-xr-x. 1 em em    102 May 21 16:24 shell
drwxr-xr-x. 1 em em    138 May 21 16:24 sql_editor
drwxr-xr-x. 1 em em     60 May 21 16:24 start
drwxr-xr-x. 1 em em     98 May 21 16:24 users
[22 May 19:27] Eric Moore 
From AI Response: 
On Fedora, logs for the MySQL Shell extension in Visual Studio Code (VS Code) are primarily stored within the VS Code extension directory structure. Specifically, they are located within the extension's folder, often found in a user's home directory. You can find the log files in the following location: ~/.vscode/extensions/oracle.mysql-shell-for-vs-code-<release>/shell/lib/mysqlsh/plugins/gui_plugin/internal/logs. 

THERE IS NO LOG FILE THAT I CAN FIND!!!

Terminal output of that folder: 
em@dreamfield:~/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.19.11-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin$ ls -l
total 548
drwxr-xr-x. 1 em em     64 May 21 16:24 cluster
drwxr-xr-x. 1 em em    664 May 21 16:24 core
drwxr-xr-x. 1 em em     86 May 21 16:24 db
drwxr-xr-x. 1 em em     76 May 21 16:24 db_connections
drwxr-xr-x. 1 em em     80 May 21 16:24 debugger
-rw-r--r--. 1 em em   3023 May 21 16:20 debug_utils.py
-rw-r--r--. 1 em em   1732 May 21 16:20 general.py
-rw-r--r--. 1 em em   1244 May 21 16:20 __init__.py
-rw-r--r--. 1 em em   4604 May 21 16:20 init.py
-rw-r--r--. 1 em em 539828 May 21 16:20 LICENSE
drwxr-xr-x. 1 em em     56 May 21 16:24 mds
drwxr-xr-x. 1 em em     64 May 21 16:24 modeler
drwxr-xr-x. 1 em em     84 May 21 16:24 modules
drwxr-xr-x. 1 em em    134 May 21 16:24 __pycache__
drwxr-xr-x. 1 em em    102 May 21 16:24 shell
drwxr-xr-x. 1 em em    138 May 21 16:24 sql_editor
drwxr-xr-x. 1 em em     60 May 21 16:24 start
drwxr-xr-x. 1 em em     98 May 21 16:24 users
[22 May 19:32] Eric Moore 
journalctl | grep "mysql-shell"
May 18 17:13:05 dreamfield sudo[30794]:       em : TTY=pts/1 ; PWD=/home/em ; USER=root ; COMMAND=/usr/sbin/find / -type d -name mysql-shell-plugins
May 18 17:52:50 dreamfield sudo[36934]:       em : TTY=pts/1 ; PWD=/home/em/.vscode/extensions ; USER=root ; COMMAND=/usr/sbin/rm oracle.mysql-shell-for-vs-code-1.19.10-linux-x64 oracle.mysql-shell-for-vs-code-1.19.6-linux-x64
May 18 17:53:03 dreamfield sudo[36989]:       em : TTY=pts/1 ; PWD=/home/em/.vscode/extensions ; USER=root ; COMMAND=/usr/sbin/rm -rF oracle.mysql-shell-for-vs-code-1.19.10-linux-x64 oracle.mysql-shell-for-vs-code-1.19.6-linux-x64
May 18 17:53:20 dreamfield sudo[37034]:       em : TTY=pts/1 ; PWD=/home/em/.vscode/extensions ; USER=root ; COMMAND=/usr/sbin/rm -rf oracle.mysql-shell-for-vs-code-1.19.10-linux-x64 oracle.mysql-shell-for-vs-code-1.19.6-linux-x64
May 18 18:21:43 dreamfield sudo[39578]:       em : TTY=pts/2 ; PWD=/home/em/mysql-shell-plugins ; USER=root ; COMMAND=/var/lib/snapd/snap/bin/npm install
May 18 18:21:43 dreamfield audit[39578]: USER_CMD pid=39578 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/em/mysql-shell-plugins" cmd=6E706D20696E7374616C6C exe="/usr/bin/sudo" terminal=pts/2 res=success'
May 18 18:22:23 dreamfield sudo[39691]:       em : TTY=pts/2 ; PWD=/home/em/mysql-shell-plugins/gui/frontend ; USER=root ; COMMAND=/var/lib/snapd/snap/bin/npm install
May 18 18:22:23 dreamfield audit[39691]: USER_CMD pid=39691 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/em/mysql-shell-plugins/gui/frontend" cmd=6E706D20696E7374616C6C exe="/usr/bin/sudo" terminal=pts/2 res=success'
May 18 18:22:59 dreamfield sudo[39944]:       em : TTY=pts/2 ; PWD=/home/em/mysql-shell-plugins/gui/frontend ; USER=root ; COMMAND=/var/lib/snapd/snap/bin/npm audit fix --force
May 18 18:22:59 dreamfield audit[39944]: USER_CMD pid=39944 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/em/mysql-shell-plugins/gui/frontend" cmd=6E706D20617564697420666978202D2D666F726365 exe="/usr/bin/sudo" terminal=pts/2 res=success'
May 19 13:04:22 dreamfield audit[13597]: USER_CMD pid=13597 uid=1000 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='cwd="/home/em/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.19.10-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin" cmd=7365637572697479202D2D68656C70 exe="/usr/bin/sudo" terminal=pts/1 res=failed'
May 21 16:34:17 dreamfield sudo[145328]:       em : TTY=pts/1 ; PWD=/home/em/.mysqlsh-gui ; USER=root ; COMMAND=/usr/sbin/dnf install mysql-shell
May 21 16:39:10 dreamfield sudo[147406]:       em : TTY=pts/1 ; PWD=/home/em/Downloads/Fedora/MySqlCommunityDownloads ; USER=root ; COMMAND=/usr/sbin/yum install mysql-shell
May 21 16:39:44 dreamfield audit[147431]: SOFTWARE_UPDATE pid=147431 uid=0 auid=1000 ses=3 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=install sw="mysql-shell-8.4.5-1.fc42.x86_64" sw_type=rpm key_enforce=0 gpg_res=1 root_dir="/" comm="yum" exe="/usr/bin/dnf5" hostname=dreamfield addr=? terminal=pts/2 res=success'
[26 May 7:35] MySQL Verification Team 
Hello Eric Moore,

Thank you for the report.
Imho this is duplicate of Bug #112963, please see Bug #112963.

Regards,
Ashwini Patil