Skip to content

SSH-tunnel doesn't work with PuTTY > v0.81 #2118

@JHCD

Description

@JHCD

Description

To access our databases, I need to establish an SSH tunnel with a password-protected certificate.
I've been using HeidiSQL and PuTTY for this for years.

After upgrading PuTTY to a version higher than 0.81, this no longer works. I tried v0.82 and v0.83. As soon as I reinstalled v0.81, access worked again.

With PuTTY v0.81, a window for entering my passphrase appears in HeidiSQL when establishing a connection.
With v0.83, I get an error message instead of the passphrase pop-up.

If I manually open the connection in the terminal with v0.83, I can successfully connect to the database in HeidiSQL using host 127.0.0.1.

Apparently, the necessary interaction with plink.exe has changed.

Current Setup:

  • Windows 11 Enterprise 24H2 Build 26100.3476.
  • PuTTY (64-bit) v0.81
  • HeidiSQL 12.10.0.7024

Debug-Log with PuTTY v.0.81:

/* 2025-03-14 10:31:54 [10 - Staging] */ /* Lade Bibliothek Datei C:\Program Files\HeidiSQL\libmariadb.dll … */
/* 2025-03-14 10:31:54 [10 - Staging] */ /* C:\Program Files\HeidiSQL\libmariadb.dll v3.4.3 loaded. */
/* 2025-03-14 10:31:54 [10 - Staging] */ /* Verbindung zu hur-app-staging_mysql_1 über MariaDB or MySQL (SSH tunnel), Benutzername root, benutze Passwort: Yes … */
/* 2025-03-14 10:31:56 [10 - Staging] */ /* Versuche SSH-Prozess zu starten, warte 4s auf Antwort … */
/* 2025-03-14 10:31:56 [10 - Staging] */ /* C:\Program Files\PuTTY\plink.exe -ssh [email protected] -P 2222 -i "C:\Users\xxxxxxxx\ssh\xxxxxxxx_ssh-docker.ppk" -N -L 3307:hur-app-staging_mysql_1:3306 */
/* 2025-03-14 10:31:56 [10 - Staging] */ /* SSH output after 407 ms. OutPipe: "Passphrase for key "imported-openssh-key":"  ErrorPipe: "Using username "root".
" */
/* 2025-03-14 10:31:56 [10 - Staging] */ /* SSH: Using username "root".
*/

Debug-Log with PuTTY v.0.83:

/* 2025-03-14 10:41:25 [10 - Staging] */ /* Lade Bibliothek Datei C:\Program Files\HeidiSQL\libmariadb.dll   */
/* 2025-03-14 10:41:25 [10 - Staging] */ /* C:\Program Files\HeidiSQL\libmariadb.dll v3.4.3 loaded. */
/* 2025-03-14 10:41:25 [10 - Staging] */ /* Verbindung zu hur-app-staging_mysql_1  ber MariaDB or MySQL (SSH tunnel), Benutzername root, benutze Passwort: Yes   */
/* 2025-03-14 10:41:27 [10 - Staging] */ /* Versuche SSH-Prozess zu starten, warte 4s auf Antwort   */
/* 2025-03-14 10:41:27 [10 - Staging] */ /* C:\Program Files\PuTTY\plink.exe -ssh [email protected] -P 2222 -i "C:\Users\xxxxxxxx\ssh\xxxxxxxx_ssh-docker.ppk" -N -L 3307:hur-app-staging_mysql_1:3306 */
/* 2025-03-14 10:41:27 [10 - Staging] */ /* SSH output after 407 ms. OutPipe: ""  ErrorPipe: "Using username "root".
" */
/* 2025-03-14 10:41:27 [10 - Staging] */ /* SSH: Using username "root".
*/
/* 2025-03-14 10:41:33 [10 - Staging] */ /* Can't connect to s

When I call plink.exe manuelly in the console, I can't see any difference in the output between v0.81 and v.83 (screenshot v0.83):
Image

HeidiSQL version

12.10.0.7024

Database server version

Reproduction recipe

Try a SSH-tunnel with a password protected certificate with PuTTY > v0.81

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLssh-tunnelRelated to SSH tunneling with ssh or plink

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions