Enable IAM Access to a remote MySQL DB

Solved1.03K views
0
0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023

1 Answer

0
3.74K 1 Comment

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;

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 10th July 2023
Miguel Obregon [SLC] [DevOps Catalyst] commented

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