Getting an error whe trying to install the certificate

[sys-auditing]

Hi,
i'm getting this issue when trying to install the certificate.

Windows 10
vscode insiders
WSL2

�[31mERROR: �[0mcore.installShellWebCertificate: User-defined function threw an exception: Traceback (most recent call last): File "/home/user/.vscode-server-insiders/extensions/oracle.mysql-shell-for-vs-code-1.1.2-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin/core/Certificates.py", line 159, in install_shell_web_certificate raise SystemError("UNABLE to find terminal!") SystemError: UNABLE to find terminal!

Thank you

[gereval]

Ubuntu 20.04.4 LTS (GNU/Linux 5.4.0-105-generic x86_64)

�[31mERROR: �[0mcore.installShellWebCertificate: User-defined function threw an exception: Traceback (most recent call last): File "/root/.vscode-server/extensions/oracle.mysql-shell-for-vs-code-1.1.2/shell/lib/mysqlsh/plugins/gui_plugin/core/Certificates.py", line 159, in install_shell_web_certificate raise SystemError("UNABLE to find terminal!") SystemError: UNABLE to find terminal!

[rennox]

Hi, i'm getting this issue when trying to install the certificate.

Windows 10 vscode insiders WSL2

�[31mERROR: �[0mcore.installShellWebCertificate: User-defined function threw an exception: Traceback (most recent call last): File "/home/user/.vscode-server-insiders/extensions/oracle.mysql-shell-for-vs-code-1.1.2-linux-x64/shell/lib/mysqlsh/plugins/gui_plugin/core/Certificates.py", line 159, in install_shell_web_certificate raise SystemError("UNABLE to find terminal!") SystemError: UNABLE to find terminal!

Thank you

Would like to understand how are you getting to that error given you are installing on Windows but it seems it is trying to install the linux version of the extension (oracle.mysql-shell-for-vs-code-1.1.2-linux-x64), could you provide more details about how did you get there?.

[rennox]

Ubuntu 20.04.4 LTS (GNU/Linux 5.4.0-105-generic x86_64)

�[31mERROR: �[0mcore.installShellWebCertificate: User-defined function threw an exception: Traceback (most recent call last): File "/root/.vscode-server/extensions/oracle.mysql-shell-for-vs-code-1.1.2/shell/lib/mysqlsh/plugins/gui_plugin/core/Certificates.py", line 159, in install_shell_web_certificate raise SystemError("UNABLE to find terminal!") SystemError: UNABLE to find terminal!

In Linux, the installation of the certificate creates an install script and tries to execute it using either gnome-terminal or xterm. If none of them are available you will get this error.

As a workaround you can execute the script in your terminal, it is located at: ~/.mysqlsh-gui/plugin_data/web_certs/install.sh

Once executed, restart VSCode (this is the equivalent to running the Setup Wizard)

[mzinner]

The issue seems to be related that there is no xterm or gnome-terminal installed on your system. We are working to support more terminal apps - which one is available on your system?

In the meantime, please check the following directory ~/.mysqlsh-gui/plugin_data/gui_plugin/web_certs.

There should be a install.sh in that directory. If you run that in your terminal app, it should guide you through the certificate generation process.

After installing the certificate, please restart VS Code. Then the MySQL Shell for VS Code extension should work as expected.

[cognitom]

Windows 11, WSL2 (Ubuntu), VSCode lastest (1.65.2)

�[31mERROR: �[0mcore.installShellWebCertificate: User-defined function threw an exception: Traceback (most recent call last): File "/home/cognitom/.vscode-server/extensions/oracle.mysql-shell-for-vs-code-1.1.2/shell/lib/mysqlsh/plugins/gui_plugin/core/Certificates.py", line 159, in install_shell_web_certificate raise SystemError("UNABLE to find terminal!") SystemError: UNABLE to find terminal!

I've run install.sh manually and it said "Certificate has been installed successfully!" and restarted VS Code. But still I couldn't make any connection. Just black screen...

Thank you.

[rennox]

Hi @cognitom I've followed your instructions and confirmed the certificate was installed as required by running the script by hand, and I got to the same state.

A quick review did not lead me to any conclusion so we will have to investigate.

Would be good if you can help us submitting a bug report into our system, you can start it through the Extension itself:

[cognitom]

@rennox sure. I'll try it.

[emudojo]

I'm having the exact same problem, windows 10 + WSL2
Vscode fails to install the certificate and if I do it manually, then I just get a black screen

[rennox]

Hi Guys

Long story short: the missing piece to make the puzzle complete in WSL2 is to get the certificate also installed in Windows.

(We will work on resolving this problem)

In the meantime, if you want to solve the problem what you can do is:

• Copy ~/.mysqlsh-gui/plugin_data/gui_plugin/web_certs/rootCA.crt into a location visible in the Windows explorer
• Then right click -> Install Certificate
• Select "Current User" and Next
• Select "Place all certificates in the following store" and browse to "Trusted Root Certification Authorities"

Restart VSCode and try the extension.

[sys-auditing]

Hi @rennox, i have tried your solution, but unfortunately not working. Instead i have a new issue after doing your steps, so when calling code-insiders . command i'm getting this message error :

/home/user/.vscode-server-insiders/bin/95e8ecaa65bf2d790a4e3b586e843435fc5c0f77/bin/remote-cli/code-insiders: 12: /home/user/.vscode-server-insiders/bin/95e8ecaa65bf2d790a4e3b586e843435fc5c0f77/bin/node: not found

Thank you

[rennox]

Hi @sys-auditing not glad to see you got a new problem, but it seems totally unrelated as those steps just register a certificate in windows, to undo it you can do this:

[sys-auditing]

My apologies, it totally unrelated, it coincides with vs code insiders update.

I just get a black screen, even a certificate successfully installed on my windows,

Thank you

[benzdouglas]

Also having problems on MacOS. Getting the following error:
Could not register plugin object 'gui'. ERROR: dlopen(/Users/(my-user-name)/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.1.3-darwin-x64/shell/lib/mysqlsh/lib/python3.10/lib-dynload/_ctypes.cpython-310-darwin.so, 2): Symbol not found: __dyld_shared_cache_contains_path Referenced from: /Users/(my-user-name)/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.1.3-darwin-x64/shell/lib/mysqlsh/lib/python3.10/lib-dynload/_ctypes.cpython-310-darwin.so (which was built for Mac OS X 12.0) Expected in: /usr/lib/libSystem.B.dylib Could not register plugin object 'gui'. ERROR: dlopen(/Users/(my-user-name)/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.1.3-darwin-x64/shell/lib/mysqlsh/lib/python3.10/lib-dynload/_ctypes.cpython-310-darwin.so, 2): Symbol not found: __dyld_shared_cache_contains_path Referenced from: /Users/(my-user-name)/.vscode/extensions/oracle.mysql-shell-for-vs-code-1.1.3-darwin-x64/shell/lib/mysqlsh/lib/python3.10/lib-dynload/_ctypes.cpython-310-darwin.so (which was built for Mac OS X 12.0) Expected in: /usr/lib/libSystem.B.dylib

[mzinner]

@benzdouglas Thanks for sharing, you are touching a sensitive point there! We are shipping a MySQL Shell binary that serves the MySQL feature set. That mysqlsh binary + dependencies like Python have to be targeting a specific macOS version (macOS 12 in our case) and only work back a limited number of macOS releases (macOS 11 + macOS 12). Based on the error it seems you are running an older version of macOS and therefore the mysqlsh binary does not work on your system.

To make this cleared I will do the following things.

1. Add this list of supported platforms at the top of the README.md to avoid anybody going through the trouble of installing the extension and only later find out that it will not run on the system.
2. Add a OS release check on the first page of the Welcome Wizard that will check if the mysqlsh is supported on that platform.

I will also talk to our release engineering team and see if we can target an older version of macOS. Problem with that is we cannot use the more recent APIs and that would limit what we can do feature wise.

Do you have a specific reason for not upgrading to macOS 11? I have an old MacPro 3,1 running a patched version of macOS 10.15.6 myself where I could reproduce the issue. I plan to update it to macOS 12 with https://dortania.github.io/OpenCore-Legacy-Patcher/ once I have some spare time.

[benzdouglas]

Do you have a specific reason for not upgrading to macOS 11?

Actually my reason is that I have one last application in 32bit mode - the last version of Adobe Lightroom that was not subscription based. Planning to transition all of my photography to an open source application so that I can make the transition, just haven't gotten around to it yet!

I look forward to the advancement of this extension as I have tried many different MySQL management extensions for VSCode and each of them have something not working or something I don't like about them.