Azure Database for MySQL connection throws error - "SSL connection error: ASN: bad other signature confirmation" about heidisql HOT 13 CLOSED

from heidisql.

I also ran into this.

HeidiSQL version: 9.5.0.5238 (64-bit)

I was able to verify that it works fine in MySQL Workbench.

from heidisql.

Same Problem here.
HeidiSQL 9.5.0.5196 64Bit
Also on
HeidiSQL 9.5.0.5278 64Bit
OS: Windows 10 1709 64Bit

from heidisql.

Same problem here:

• HeidiSQL 9.5.0.5196 (64 Bit)
• Client OS: Windows 10 1703 Pro 64 Bit
• connecting to MariaDB 10.1 (Ubuntu 16.04)
• no problems connecting using MySQL Workbench

from heidisql.

@ansgarbecker poke

from heidisql.

Once this works I can get the new connection instructions posted next to this document on Microsoft's site:
https://docs.microsoft.com/en-us/azure/mysql/connect-workbench

from heidisql.

Any solutions for this? I can't connect to my azure db because of this bug.

from heidisql.

@MystK Turning off SSL is sadly not an option, due to project requirements.

from heidisql.

hi, is the issue solved ? because i have the same issue here.

from heidisql.

I am not sure. The report is related to v9.5. Probably this was fixed along with my update for all libraries in HeidiSQL 10.0/10.1. Could someone please verify whether this is still an issue with the latest version?

from heidisql.

We had the same problem over the last years. I just tried with 10.1.0.5464 (x64) and indeed, the problem fixed. Thank you so much!

from heidisql.

@amitghosh-inwt thanks for the information. Do you try to using ssl ca certificate only ?

from heidisql.

Do you try to using ssl ca certificate only ?

We are using a server with a certificate issued from a private (Windows) CA and require the clients to authenticate with client certificates from the same CA.

from heidisql.