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 - 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 was specifying the database name in lowercase as uim_db.

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

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.