DX UIM - oi_connector errors connecting to a MySQL 8.x database
book
Article ID: 368499
calendar_today
Updated On:
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.
Feedback
thumb_up
Yes
thumb_down
No