UIM installation fails during database creation (Linux with MySQL)

book

Article ID: 4985

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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

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.

Environment

- UIM v8.47- Linux- MySQL database

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.