BUG: Connect via ssh tunnel failed

[syntaxys]

Describe the bug
Can't connect to a specific MySQL host via ssh tunnel while it is possible with i. e. the app „Sequel Ace“ on the same machine. Other tunneled connections work without a problem in DbGate. Is there a way to debug this? I don't have access to the host providers log files.

Log details

Error
    at e.exports (/Applications/DbGate.app/Contents/Resources/app.asar/packages/api/dist/bundle.js:11:86455)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async process.<anonymous> (/Applications/DbGate.app/Contents/Resources/app.asar/packages/api/dist/bundle.js:456:325634)

Error JSON: {}

Connection: {
  "server": "***",
  "engine": "mariadb@dbgate-plugin-mysql",
  "sshMode": "keyFile",
  "sshKeyfile": "***",
  "displayName": "***",
  "connectionColor": "***",
  "useSshTunnel": true,
  "sshHost": "***",
  "sshLogin": "***",
  "sshKeyfilePassword": "***",
  "_id": "***",
  "unsaved": false,
  "user": "***",
  "defaultDatabase": "***",
  "singleDatabase": false,
  "password": "***",
  "parent": "***",
  "passwordMode": "saveRaw",
  "sshPassword": "***"
}

Platform: darwin

Version Information:

• OS: MacOS Big Sur
• App Version 5.2.7
• Install source: installer
• Database engine: MySQL

[ProjectInfinity]

Please try the following Beta https://github.com/dbgate/dbgate/releases/tag/v5.2.9-beta.2

[0rax]

Had a similar issue on Linux with SSH tunneling no longer working running:

• OS: Arch Linux (Linux 6.9.1)
• App Version 5.2.8
• Install source: AppImage
• Database engine: PostgreSQL

Tried the latest beta (v5.2.9-beta.4) which fixed the issue for me.

[gordonlau]

The issue still persists for Linux.

• OS: Ubuntu Linux 24.04
• App Version: 5.3.0
• Installation: AppImage
• Engine: PostgreSQL

Installing older version does not work anymore. The error is still the same.

Error
    at e.exports (/tmp/.mount_dbgateWrc88x/resources/app.asar/packages/api/dist/bundle.js:2:2117465)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async process.<anonymous> (/tmp/.mount_dbgateWrc88x/resources/app.asar/packages/api/dist/bundle.js:2:2076560)

Error JSON: {}

Connection: {
  "server": "***",
  "engine": "postgres@dbgate-plugin-postgres",
  "sshMode": "keyFile",
  "sshKeyfile": "***",
  "user": "***",
  "defaultDatabase": "***",
  "displayName": "***",
  "connectionColor": "***",
  "password": "***",
  "useSshTunnel": true,
  "sshHost": "***",
  "sshLogin": "***",
  "_id": "***",
  "unsaved": false,
  "singleDatabase": true
}

Platform: linux

[gordonlau]

Just to document for people who want to use SSH Tunnel with DBGate but is currently blocking by this issue.

It is perfectly working to use ssh command to create the ssh tunnel and set the tunnel to connect to the local port 5433.

ssh -NfL 5433:<db-host>:5432 <ssh-host>

Then you can connect to the database by connecting the local port 5433 instead. The performance seems to be better than using DBGate built-in ssh-tunnel feature.
You can also use autossh if you want to maintain the tunnel automatically.

[josbeir]

Check if

127.0.0.1 localhost

is missing in your /ets/hosts file. It was missing for me on Arch, it started working after adding it (using the flatpak version).

Authentication mode: Username & password
Didn't check Agent / key mode.