Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

HeidiSQL 10.1.0.5550 64bit - Plink 0.71 64bit - Windows 10 Home 64bit

mtjmohr's profile image mtjmohr posted 3 months ago in Creating a connection

Hello, Ansgar and helpers,

I have thoroughly read GitHub's 521 issue entry and other Plink-related material in this forum and elsewhere on the net. But I have not found any solution for this problem as of now.

I continually experience the recurring error as to be seen within the screenshot, and it does not depend on a specific version of plink.exe (tested: 0.71 (64bit), 0.70 (64bit), 0.60 (32 bit), 0.55 (32bit)).

The command line parameter to invoke plink.exe, as you can see, contains both "-ssh" and "-batch" - I guess this is hardcoded and I cannot change this by myself?

How can we go on from here, or have I overlooked that there is already a solution?

Best regards

Markus

1 attachment(s):
  • 30-04-_2019_16-38-18
ansgar's profile image ansgar posted 3 months ago

Yes, the ssh and batch parameters are hardcoded. You should try to execute plink yourself, with the same command line, but in your own command prompt window. If you experience the same crash of plink, you probably know how to debug.

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

thank you for your answer, I will check this and get back to you.

But what is this error due to? Under Windows 8.1, the same configuration worked like a charm, and now under Windows 10 it does not?

Bes regards

Markus



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

I have received the following message within my shell:

C:\Program Files\PuTTY>plink -ssh -batch ***.*******.** -pw "**********$" -P 22 -i "C:\Users\user\Documents\Zertifikate\**********.ppk"
Using username "**********".
Linux **********.***.*** 4.9.0-5-amd64 #1 SMP Debian 4.9.65-3+deb9u2 (2018-01-04) x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
**********@*****-**:~$

Okay so far.

And now it does work once I append "... -N -L 3307:localhost:3306".

So, a solution can be that one must have made the connection beforehand once without the "... -N -L 3307:localhost:3306" or whatever you individual configuration might be.

Problem solved for me.

mtjmohr's profile image mtjmohr posted 3 months ago

Sorry for the textual mess above, apparently I cannot edit it ...

ansgar's profile image ansgar posted 3 months ago

I just edited your plink output to see where the line breaks are.

What happens if you directly use the "-N -L..." stuff?

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

thanks for the editing ... ;-)

Once I have used plink.exe only one time without the appendix "-N -L ...", I can make the (in my case UNIX-shell-based) connection to the server the database lies on.

And only then is it possible to successfully establish a database connection using this appendix again from the DOS shell or from within HeidiSQL.

Are you interested in the debug log for this?

Best regards

Markus

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

here you have the latest log contents:

/* 2019-05-01 08:57:53 [ods.ogamc.at - ReadOnly] */
/* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-05-01 08:57:55 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */
/* 2019-05-01 08:57:55 [***.*****.** - ReadOnly] */ /* C:\Program Files\PuTTY\plink.exe -ssh -batch **********@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\**********.ppk" -N -L 3307:localhost:3306 */
/* 2019-05-01 08:57:55 [***.*****.** - ReadOnly] */ /* PLink output after 400 ms. OutPipe: ""  ErrorPipe: "Using username "**********".
" */

This is the session log equivalence of my being able to log on using the mentioned SSH connection.

Best regards

Markus

ansgar's profile image ansgar posted 3 months ago

Please ensure you use the latest HeidiSQL build.

If that does not change anything, you should post more of the debug log here. I suppose there is more than the few lines from above, isn't there?

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

I have using build 5550 already with yesterday's log and maximized all the input options. So there is no change to today's log which is equivalent to my SSHing onto a Linux-based MySQL server in Austria:

/* 2019-05-02 11:23:05 [] */ /* Schreibe ab jetzt in Sitzungs Logdatei: C:\Users\user\AppData\Roaming\HeidiSQL\Sessionlogs\000012.log */
/* 2019-05-02 11:23:05 [] */ /* Setting up TSynMemo "SynMemoQuery" */
/* 2019-05-02 11:23:05 [] */ /* Setting up TSynMemo "SynMemoFilter" */
/* 2019-05-02 11:23:05 [] */ /* Setting up TSynMemo "SynMemoProcessView" */
/* 2019-05-02 11:23:05 [] */ /* Setting up TSynMemo "SynMemoSQLLog" */
/* 2019-05-02 11:23:05 [] */ /* Pfad zur Anwendung: "C:\Program Files\HeidiSQL\heidisql.exe" */
/* 2019-05-02 11:23:05 [] */ /* Version: "10.1.0.5550" */
/* 2019-05-02 11:23:05 [] */ /* Theme: "Material" */
/* 2019-05-02 11:23:05 [] */ /* Pixel pro Zoll auf aktuellem Bildschirm: 96 */
/* 2019-05-02 11:23:12 [] */ /* Setting up TSynMemo "SynMemoQuery" */
/* 2019-05-02 11:23:12 [] */ /* Setting up TSynMemo "SynMemoFilter" */
/* 2019-05-02 11:23:12 [] */ /* Setting up TSynMemo "SynMemoProcessView" */
/* 2019-05-02 11:23:12 [] */ /* Setting up TSynMemo "SynMemoSQLLog" */
/* 2019-05-02 11:23:12 [] */ /* Setting up TSynMemo "SynMemoSQLSample" */
/* 2019-05-02 11:24:00 [] */ /* Setting up TSynMemo "SynMemoQuery" */
/* 2019-05-02 11:24:00 [] */ /* Setting up TSynMemo "SynMemoFilter" */
/* 2019-05-02 11:24:00 [] */ /* Setting up TSynMemo "SynMemoProcessView" */
/* 2019-05-02 11:24:00 [] */ /* Setting up TSynMemo "SynMemoSQLLog" */
/* 2019-05-02 11:24:00 [] */ /* Setting up TSynMemo "SynMemoSQLSample" */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Lade Bibliothek Datei libmariadb.dll ... */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_affected_rows" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_character_set_name" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_close" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_data_seek" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_errno" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_error" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_field_direct" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_lengths" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_row" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_free_result" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_get_client_info" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_get_server_info" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_init" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_num_fields" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_num_rows" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_ping" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_options" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_real_connect" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_real_query" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_ssl_set" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_stat" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_store_result" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_id" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_next_result" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_set_character_set" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_init" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_end" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_warning_count" zuweisen */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* libmariadb.dll v10.3.6 loaded. */
/* 2019-05-02 11:24:04 [***.*****.** - ReadOnly] */ /* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-05-02 11:24:05 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */
/* 2019-05-02 11:24:05 [***.*****.** - ReadOnly] */ /* C:\Program Files\PuTTY\plink.exe -ssh -batch *******@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\*******-*******.ppk" -N -L 3307:localhost:3306 */
/* 2019-05-02 11:24:06 [***.*****.** - ReadOnly] */ /* PLink output after 600 ms. OutPipe: ""  ErrorPipe: "Using username "*******".
" */
/* 2019-05-02 11:24:06 [***.*****.** - ReadOnly] */ /* PLink: Using username "*******".
 */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SELECT CONNECTION_ID();
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for CONNECTION_ID(): BIGINT */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Verbunden. Prozess-ID: 207872 */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Zeichensatz: utf8mb4 */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SHOW STATUS;
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Variable_name: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Value: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SELECT NOW();
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for NOW(): DATETIME */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SHOW VARIABLES;
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Variable_name: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Value: VARCHAR */
/* 2019-05-02 11:24:09 [] */ /* DBtreeFocusChanged without node. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SHOW DATABASES;
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Database: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Ping server ... */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ SHOW OPEN TABLES FROM ods01 WHERE `in_use`!=0;
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Result #1 fetched. */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Database: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Table: VARCHAR */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for In_use: BIGINT */
/* 2019-05-02 11:24:09 [***.*****.** - ReadOnly] */ /* Detected column type for Name_locked: BIGINT */

I hope this is helpful. Concerning the plink output, the result within the log is rather small.

Best regards

Markus



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ansgar's profile image ansgar posted 3 months ago

Ok, this looks like a working tunnel connection, doesn't it? You said you can not connect the first time Heidi fires that "-N -L ..." command, or was that now the second one? If so, please post the log of the non-successful connect here.

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

yes, what I sid during the last posts.

I am sitting in a café in Palermo right now eatin a bit and writing from my iPad. I will shortly get back, though, and send you the log from the unsuccessful connection tries.

Best regards

Markus

mtjmohr's profile image mtjmohr posted 3 months ago

Hm. Isn‘t there an edit mode for my own posts?

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

here is the first log file under Windows 10 Home 64 bit used as a pristine new installation of a new hard disk having imported the configuration file saved und Windows 8.1 and having installed Putty 0.71 64 bit:

/* 2019-04-30 16:15:23 [] */ /* Schreibe ab jetzt in Sitzungs Logdatei: C:\Users\user\AppData\Roaming\HeidiSQL\Sessionlogs\000003.log */
/* 2019-04-30 16:15:23 [] */ /* Setting up TSynMemo "SynMemoQuery" */
/* 2019-04-30 16:15:23 [] */ /* Setting up TSynMemo "SynMemoFilter" */
/* 2019-04-30 16:15:23 [] */ /* Setting up TSynMemo "SynMemoProcessView" */
/* 2019-04-30 16:15:23 [] */ /* Setting up TSynMemo "SynMemoSQLLog" */
/* 2019-04-30 16:15:23 [] */ /* Pfad zur Anwendung: "C:\Program Files\HeidiSQL\heidisql.exe" */
/* 2019-04-30 16:15:23 [] */ /* Version: "10.1.0.5550" */
/* 2019-04-30 16:15:23 [] */ /* Theme: "Material" */
/* 2019-04-30 16:15:23 [] */ /* Pixel pro Zoll auf aktuellem Bildschirm: 96 */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Lade Bibliothek Datei libmariadb.dll ... */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_affected_rows" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_character_set_name" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_close" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_data_seek" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_errno" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_error" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_field_direct" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_lengths" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_fetch_row" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_free_result" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_get_client_info" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_get_server_info" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_init" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_num_fields" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_num_rows" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_ping" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_options" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_real_connect" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_real_query" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_ssl_set" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_stat" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_store_result" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_id" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_next_result" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_set_character_set" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_init" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_thread_end" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Prozedur "mysql_warning_count" zuweisen */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* libmariadb.dll v10.3.6 loaded. */
/* 2019-04-30 16:15:50 [***.*****.** - ReadOnly] */ /* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-04-30 16:15:51 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */

-> Here you find an older version of plink.exe, used test-wise, and thereafter the current version 0.71 64bit again:
/* 2019-04-30 16:15:51 [***.*****.** - ReadOnly] */ /* C:\Users\user\Downloads\plink(2).exe -ssh -batch *******@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\*******-*******.ppk" -N -L 3307:localhost:3306 */
/* 2019-04-30 16:16:20 [***.*****.** - ReadOnly] */ /* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-04-30 16:16:21 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */
/* 2019-04-30 16:16:21 [***.*****.** - ReadOnly] */ /* C:\Program Files\PuTTY\plink.exe -ssh -batch *******@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\*******-*******.ppk" -N -L 3307:localhost:3306 */
/* 2019-04-30 16:23:29 [***.*****.** - ReadOnly] */ /* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-04-30 16:23:30 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */
/* 2019-04-30 16:23:30 [***.*****.** - ReadOnly] */ /* C:\Program Files\PuTTY\plink.exe -ssh -batch *******@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\*******-*******.ppk" -N -L 3307:localhost:3306 */
/* 2019-04-30 17:22:34 [***.*****.** - ReadOnly] */ /* Verbindung zu localhost über MariaDB or MySQL (SSH tunnel), Benutzername **********, benutze Passwort: Yes ... */
/* 2019-04-30 17:22:35 [***.*****.** - ReadOnly] */ /* Versuche plink.exe Prozess zu starten, warte 4s auf Antwort ... */
/* 2019-04-30 17:22:35 [***.*****.** - ReadOnly] */ /* C:\Program Files\PuTTY\plink.exe -ssh -batch *******@***.*****.** -pw "******" -P 22 -i "C:\Users\user\Documents\Zertifikate\*******-*******.ppk" -N -L 3307:localhost:3306 */

This is the log for a non-successful connection through SSH.

Best regards

Markus

ansgar's profile image ansgar posted 3 months ago

OK, the log looks very normal. What exactly happens after that "Versuche plink.exe Prozess zu starten"?

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

nothing apart from the above-mentioned and screenshot error message.

Best regards

Markus

P. S.: Maybe i should stress again that the trick was to one-time establish an SSH connection to the MySQL server without the "-N -L ..." appendix using a DOS shell. After that, immediately, the connection using this appendix worked and has been working since using HeidiSQL.

ansgar's profile image ansgar posted 3 months ago

Yes, I am aware of that trick. This is just very odd.

You did not perhaps (like one other user recently did) download putty.exe, rename it to plink.exe and try to use it as a replacement for plink?

How's the setting for "plink.exe timeout" ?

mtjmohr's profile image mtjmohr posted 3 months ago

Hello, Ansgar,

no, I used the plink.exe referral from my 0.71 Putty installaiton from within HeidiSQL, so no replacement.

About the setting, I have no idea, I did not configure anything there.

Best regards

Markus

ansgar's profile image ansgar posted 3 months ago

Please just look at the timeout setting for plink, and increase it by some seconds, for testing purposes.

RTurala's profile image RTurala posted 2 months ago

I've found workaround for this issue but this forum marks my reply to this topic as a spam :/

ansgar's profile image ansgar posted 2 months ago

I am disabling users which post spam here. But this thread here has no disabled users, so which thread do you mean?

RTurala's profile image RTurala posted 2 months ago

This one. But nevermind. I found out at GitHub, that you know what's the problem mentioned here :)

Please login to leave a reply, or register at first.