DX UIM - oi_connector errors connecting to a MySQL 8.x database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In working to configure oi_connector probe in UIM and when the UIM database is MySQL 8.x, the following errors are observed in the logs:

• Exception retrieving db_Connection Info: Received status (4) on response ( for sendRcv) for cmd= 'nametoip' name ='data_engine'
• [main, oi_connector] java.sql.SQLInvalidAuthorizationSpecException: Access denied for user '<UserName>'@'' (using password: NO)

Environment

DX UIM 20.4+
oi_connector 1.52 and earlier

Cause

oi_connector 1.52 and earlier doesn't support sha2 password authentication used by MySQL 8.x

Resolution

oi_connector 1.55 has been released to provide this functionality.