UIM installation fails during database creation (Linux with MySQL)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

UIM installation failed during a fresh installation (Linux/MySQL)

Environment

- UIM v8.47- Linux- MySQL database

Cause

mySQL database installation issue

During UIM installation the database could not be created. Installation failed.

The dba created the database as CA_UIM before the on-site installation took place. The DBA created the database using all uppercase letters.

Since mySQL doesn't allow 2 databases of the same name even if the case is different, installation was failing because during the install the customer was specifying the database name in lowercase as uim_db.

The customer was trying to create a new database using the lowercase name BUT it was failing since the lowercase name was the same except for the difference in case.

Resolution

In the end we deleted the CA_UIM database and had the installer create it anew and then there was no conflict with the name and it was then successful.