Skip to content

mariadb-dump fails with “SSL is required” when using SSH tunnel (needs --ssl-mode=DISABLED option) #1660

@jjnxpct

Description

@jjnxpct

Environment

  • VS Code: 1.xx (Windows 11, PowerShell 7.5.4)
  • Extension: Database Client (cweijan.vscode-mysql-client2) v8.4.2
  • MariaDB Client: 12.0.2 (on PATH)
  • Connection type: SSH tunnel to remote server (queries work fine)

Steps to Reproduce

  1. Connect to a MariaDB database through an SSH tunnel.
  2. Open a table.
  3. Click Export → SQL (Dump).
  4. Wait for the dump to start.

Actual Behavior

The export fails with:

mariadb-dump: Got error: 2026: "TLS/SSL error: SSL is required, but the server does not support it" when trying to connect

Logged command:

mariadb-dump -h 127.0.0.1 -P 11499 -u myuser -p"<password>" --skip-lock-tables ...

Expected Behavior

The dump should succeed through the SSH tunnel without requiring SSL,
or the extension should provide an option to disable SSL for dump operations.


Workaround

Running the same command manually works when adding:

--ssl-mode=DISABLED

Example:

mariadb-dump -h 127.0.0.1 -P 11499 -u myuser -p --ssl-mode=DISABLED dbname > dump.sql

Feature Request

Please add:

  • A setting or field to control --ssl-mode for dump/export operations,
  • Or a global option such as:
    "database-client.dumpCommand": "mariadb-dump --ssl-mode=DISABLED"

Notes

The SSH tunnel already provides encryption, so SSL is redundant in this case.
All query operations in the same connection work fine without SSL.

Thanks for maintaining this extension.

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions