MySql probe support for TLS in DX UIM: Access Denied for user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Does the MySql probe support TLS connections between the probe and a remote MySql DB? 

 

 

 

Environment

• DX UIM 23.4.2
• MySql probe 3.61

 

Cause

Product limitation

Resolution

The current code of the probe does not accept TLS connections.

As of December 2024, a Feature has been added to the backlog (F152565) and support for TLS is expected to be delivered in the first half of 2025.

Additional Information

Symptoms when connecting to a TLS DB with MySql probe: 

 

Trying to monitor MySQL/MariaDB remotely using the MySQL probe in DX UIM:

 

The MySQL probe is deployed to a robot that has connectivity to the remote db.

Testing connection gives the following error message: 

 

Access Denied for user '<username>'@'<ip_address>' (using password: YES)

 

 

 

Running the connect command directly from the host running the MySQL probe to the remote DB it works fine.

 

The LOGS SHOWS: 

 

Nov 18 15:59:12:886 [139899397656768] mysql: check_connection; from #.#.##.#/55130, service name: #.#.##.#, port : 5001 user: <username> option: 1 option_path:

Nov 18 15:59:12:895 [139899397656768] mysql: server_connect() : check_connection : Connection option is TCP

Nov 18 15:59:12:952 [139899397656768] mysql: server_connect(): check_connection-Access denied for user '<username>'@'#.#.##.#' (using password: YES)