My company recently made it mandatory to use SSL when connecting to the MySQL databases and we have to go via SSH tunnel as these are not publically accessible.
I was using the 'Maria DB or MySQL (SSH tunnel)' option before making the SSL mandatory. After the change, I enabled the Use SSL on advanced and provided the SSL CA certificate (which I had to switch to TCP/IP network type to do so and switch back to SSH tunnel).
When connecting it stalls and not do anything at all. Below is the session log.
/* 2019-05-14 10:31:37 [] */ /* Writing to session log file now: C:\Users\******\AppData\Roaming\HeidiSQL\Sessionlogs\000257.log */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Connecting to <fqdn of DB server> via MariaDB or MySQL (SSH tunnel), username <username>, using password: Yes ... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3307 in use. Checking if #3308 is available... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3308 in use. Checking if #3309 is available... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3309 in use. Checking if #3310 is available... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3310 in use. Checking if #3311 is available... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3311 in use. Checking if #3312 is available... */ /* 2019-05-14 10:36:27 [SAVED CONNECTION NAME] */ /* Port #3312 in use. Checking if #3313 is available... */ /* 2019-05-14 10:36:28 [SAVED CONNECTION NAME] */ /* Attempt to create plink.exe process, waiting 4s for response ... */ /* 2019-05-14 10:36:28 [SAVED CONNECTION NAME] */ /* C:\Program Files\PuTTY\plink.exe -ssh <fqdn of SSH tunnel> -pw "******" -P 22 -N -L 3313:<fqdn of DB server>:<port> */
I can connect to the database using MySQL workbench with the same settings so the reply from Network/DB admin was it's something to do with this tool (which is not very helpful).
Appreciate any help to resolve this problem. I'm not very tech savvy but can try out different options suggested.
Heidi version: 10.1.0.5464 (64 bit) Environment: windows v10.0
Thanks in Advance