UIM not working after upgrade to 20.4 with MySQL DB

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After upgrade from UIM 20.1 to 20.4 version OC and Admin console were not accepting credentials.

data_engine probe connectivity issue with MySQL server during tconnectivity test generated the error shown below:

test connection DONE - result: 
Connected: no
Ping: no
DB Version: n/a
data_engine schema version: n/a
[testConnection for X.X.X.X/65088] thread_id: 0, error: Open: Lost connection to MySQL server at 'handshake: waiting for inital communication packet', system error: 110 (errno:2013)(1)
 
Error as it appeared in the data engine log:
Feb 10 19:06:41:274 [140] 0 de: data_engine [main] [main] - Open - Error: [main] thread_id: 0, error: Open: Lost connection to MySQL server at 'handshake: waiting for inital communication packet', system error: 110 (errno:2013)
Feb 10 19:06:41:274 [140] 0 de: Unable to connect to database. so exiting

Environment

Release : 20.4

Component : UIM - DATA_ENGINE 20.40

Cause

• Missing configuration setting in the mysql config file that was causing connection timeouts.

Resolution

Modofied mysql configuration adding both entries in the my.cnf file

/etc/my.cnf
[mysqld]
skip-host-cache
skip-name-resolve

Additional Information

Related error in the Mysql logs: 

"MySQL [Warning] IP address could not be resolved"