Hi Dojo,
What is the procedure to let DataMiner Inventory Asset Manager (IAM) access a remote MySQL 8 database on TCP/IP port 3306 ?
The MySQL user connection established for that purpose must use TLS encryption 1.2, because we are forced by some policies to disable TLS 1.0 and 1.1. (The MySQL 8 server we are using is configured accordingly.) [DB version - MySQL 8.0.19]
We need to enable DataMiner’s IAM to support a TLS 1.2 encrypted connection to a MySQL 8 server. It seems like that this means a usage of either Connector/NET 6.10.4 or Connector/NET 8.0.11, as stated in this link:
https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html
Thanks in advance.
Hi ArunKrishna, can you try if it works using a custom connection string instead of the general fields in System Center/database/others.
example with encryption:
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;SslMode=Required;
example with a file-based certificate: Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;SSL Mode=Required;CertificateFile=C:\folder\client.pfx;CertificatePassword=pass;
An update about this topic. After further investigation we found that DMA version 10.0.0.0 uses an SLDatabase.dll which was built with .NET4.5. TLS1.2 is only supported as of 4.5.2, therefore it does not work.
A fix for this issue will be available:
Main release: 10.1.0
Feature release: 10.0.6.0-9101
Reference: DCP146754