vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

Cann't create connection, with blank page showing

Open zayne-wang opened this issue 2 years ago • 2 comments

Describe the bug I'm using vs-code server(recently released by Microsoft) local mode. When I click create connection button, it only shows a blank page with no bottons or messages on it.

[1658708876336] INFO  (ext): SQLTools is starting
[1658708876344] INFO  (ext): initializing language client...
[1658708876347] INFO  (ext): Registering client for languages [{"scheme":"sqltools"},{"language":"sql","scheme":"untitled"},{"language":"sql","scheme":"file"},{"language":"sql","scheme":"sqltools"}]
    ns: "lc"
[1658708876355] INFO  (ext): loading plugins...
[1658708876355] INFO  (ext): registering Formatter Plugin.
    plugin: {
      "name": "Formatter Plugin"
    }
[1658708876356] INFO  (ext): registering Connection Manager Plugin.
    plugin: {
      "name": "Connection Manager Plugin"
    }
[1658708876357] INFO  (ext): registering CodeLens Plugin.
    plugin: {
      "name": "CodeLens Plugin",
      "registeredLanguages": []
    }
[1658708876358] INFO  (ext): registering Dependency Manager Plugin.
    plugin: {
      "name": "Dependency Manager Plugin",
      "installingDrivers": []
    }
[1658708876360] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1658708876361] INFO  (ext): registering History Manager Plugin.
    plugin: {
      "name": "History Manager Plugin"
    }
[1658708876361] INFO  (ext): registering Bookmarks Manager Plugin.
    plugin: {
      "name": "Bookmarks Manager Plugin"
    }
[1658708876363] INFO  (ext): SQLTools activation completed. 27.70944 ms
[1658708876368] INFO  (ext): Formatter Plugin registered!
[1658708876368] INFO  (ext): CodeLens Plugin registered!
[1658708876368] INFO  (ext): Dependency Manager Plugin registered!
[1658708876368] INFO  (ext): Connection Manager Plugin registered!
[1658708876368] INFO  (ext): History Manager Plugin registered!
[1658708876368] INFO  (ext): Bookmarks Manager Plugin registered!
[1658708876539] INFO  (ls): SQLTools Server started!
===============================
Using node runtime?: no
ExecPath: /home/matthew/.vscode-cli/server-stable-web/bin/3b889b090b5ad5793f524b5d1d39fda662b96a2a/node 
===============================
[1658708876543] INFO  (ls): Telemetry enabled!
    ns: "telemetry"
[1658708876547] INFO  (ext): LanguageClient ready
    ns: "lc"
[1658708877370] INFO  (ext): EXECUTING COMMAND => sqltools.refreshTree
[1658708877371] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1658708878361] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1658708880823] INFO  (ext): EXECUTING COMMAND => sqltools.openAddConnectionScreen
[1658708880825] INFO  (ext): EXECUTING COMMAND => sqltools.openAddConnectionScreen
[1658708910152] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1658709224703] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1658709224704] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1658709594325] INFO  (ext): registering MySQL/MariaDB Plugin (driver).
    plugin: {
      "extensionId": "mtxr.sqltools-driver-mysql",
      "name": "MySQL/MariaDB Plugin",
      "type": "driver"
    }
[1658709594328] INFO  (ls): REQUEST RECEIVED => ls/RegisterPlugin
[1658709594329] INFO  (ls): request to register plugin: "/home/matthew/.vscode-server/extensions/mtxr.sqltools-driver-mysql-0.2.0/out/ls/plugin.js"
[1658709594455] INFO  (ls): Driver mysql registered!
    place: "driver-map"
    ns: "ls-context"
[1658709594455] INFO  (ls): Driver mariadb registered!
    place: "driver-map"
    ns: "ls-context"
[1658709594456] INFO  (ext): MySQL/MariaDB Plugin (driver) registered!
[1658709595457] INFO  (ext): EXECUTING COMMAND => sqltools.refreshTree
[1658709595457] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1658709601049] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1658709601051] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1658709602203] INFO  (ext): EXECUTING COMMAND => sqltools.openAddConnectionScreen
[1658709604217] INFO  (ext): EXECUTING COMMAND => sqltools.openAddConnectionScreen
[1658709678135] INFO  (ext): EXECUTING COMMAND => sqltools.openAddConnectionScreen

To Reproduce Steps to reproduce the behavior:

  1. Install SQLTools extension and SQLTools MySQL/Mariadb extensions
  2. Restart the vscode server;
  3. Click SQLTools -> "Add new connection" button;
  4. See a blank page

Expected behavior It should be show a page with setting up info and process like desktop version

Screenshots

image

Desktop (please complete the following information):

  • SQLTools Version v0.23.0
  • VSCode Version: VS Code Server 20220708.2
  • OS:
    • Server OS: Linux version 5.10.0-16-amd64 ([email protected]) (gcc-10 (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP Debian 5.10.127-1 (2022-06-30)
    • Client OS: Windows 10/11 with using Microsoft Edge Browser
  • Driver:
    • [ ] PostgreSQL/Redshift
    • [x] MySQL/MariaDB
    • [ ] MSSQL/Azure
    • [ ] SQLite
    • [ ] Other? Which...
  • Database version: MySQL v5.7

Additional context When on desktop version, it shows like: image

zayne-wang avatar Jul 25 '22 00:07 zayne-wang

Does the problem also happen after you update to the new releases of the extensions?

gjsjohnmurray avatar Aug 23 '22 16:08 gjsjohnmurray

Does the problem also happen after you update to the new releases of the extensions?

Still the same issue

zayne-wang avatar Aug 26 '22 13:08 zayne-wang

I recently got added to the VS Code Server Preview but haven't yet been able to replicate your issue. I installed SQLTools extension 0.25.1 and MariaDB/MySQL driver 0.4.0, both current at Marketplace.

I am using insiders.vscode.dev with this About box info:

Version: 1.72.0-insider
Commit: 831678f718c8e998adc40d4854d9d35d9586a09f
Date: 2022-09-26T09:36:49.307Z
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:105.0) Gecko/20100101 Firefox/105.0

My uname -a output is:

Linux dem 4.15.0-191-generic #202-Ubuntu SMP Thu Aug 4 01:49:29 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

After checking those two extensions are up to date on your server please post the output of the SQLTools channel again, assuming the problem still occurs.

gjsjohnmurray avatar Sep 26 '22 16:09 gjsjohnmurray

After changing to online mode (vscode.dev), it works. I persume it caused by my network connection.

zayne-wang avatar Oct 03 '22 14:10 zayne-wang