Vscode-mssql: Crash on Fedora 30

[paaland]

• MSSQL Extension Version: 1.6.0
• VSCode Version: 1.33.1
• Electron: 3.1.6
• Chrome: 66.0.3359.181
• Node.js: 10.2.0
• V8: 6.6.346.32
• OS Version: Fedora 30 (Linux x64 5.0.11-300.fc30.x86_64 snap)

Steps to Reproduce:

1. Install VS Code on Fedora 30 as snap
2. Try to use mssql extension either in VSCode or Azure Data Studio
3. Extension crashes on start.

Auto configuration failed
140125746112160:error:25066067:DSO support routines:DLFCN_LOAD:could not load the shared library:dso_dlfcn.c:186:filename(libssl_conf.so): libssl_conf.so: cannot open shared object file: No such file or directory
140125746112160:error:25070067:DSO support routines:DSO_load:could not load the shared library:dso_lib.c:244:
140125746112160:error:0E07506E:configuration file routines:MODULE_LOAD_DSO:error loading dso:conf_mod.c:285:module=ssl_conf, path=ssl_conf
140125746112160:error:0E076071:configuration file routines:MODULE_RUN:unknown module name:conf_mod.c:222:module=ssl_conf
[Error - 08:47:26] Connection to server got closed. Server will not be restarted.

I have installed the prerequisites for .NET Core on Linux (https://docs.microsoft.com/en-us/dotnet/core/linux-prerequisites?tabs=netcore2x) among them the openssl-libs and the compat-openssl10 packages.

[paaland]

I managed to "fix" the SSL error by adding these to my .bashrc:

export SSL_CERT_FILE=/etc/ssl/certs/ca-bundle.crt
export SSL_CERT_DIR=/dev/null
export OPENSSL_CONF=/etc/pki/openssl10.cnf

But it still crash when I try to connect to a server (both VSCode and Azure Data Studio).

[29993:0506/091637.098097:INFO:CONSOLE(2370)] "mssql: SQL Tools Service component could not start.", source: file:///var/lib/snapd/snap/code/6/usr/share/code/resources/app/out/vs/workbench/workbench.main.js (2370)

[Error - 09:16:37] Connection to server got closed. Server will not be restarted.

dmesg shows a segfault:

[35499.343258] MicrosoftSqlToo[18799]: segfault at 23 ip 00007f383c38beba sp 00007f3824816300 error 4 in libcrypto.so.1.0.0i[7f383c2bb000+175000]

[mcsage]

Thanks @paaland for the .net hint. I fixed it by doing the following:

1. Installing pkg deps

sudo dnf install lttng-ust libcurl openssl-libs krb5-libs libicu zlib compat-openssl10

1. Enable repo

sudo rpm --import https://packages.microsoft.com/keys/microsoft.asc
wget -q https://packages.microsoft.com/config/fedora/27/prod.repo
sudo mv prod.repo /etc/yum.repos.d/microsoft-prod.repo
sudo chown root:root /etc/yum.repos.d/microsoft-prod.repo

1. Install .net 2.2

sudo dnf update
sudo dnf install dotnet-sdk-2.2

1. Restart azuredatastudio

azuredatastudio

[paaland]

No such luck. Tried your receipt, but still same error. Then I tried the insiders build from here: https://github.com/Microsoft/azuredatastudio

That worked.