During UnitedDB instance configuration in TCM, the database service remains stuck and does not start.

Publication Date:  2015-02-13 Views:  273 Downloads:  0
Issue Description

When we install TCM software or reconfigure UnitedDB instance on TCM machine, the relevant service remains stuck and does not start.


Alarm Information
No specific Alarms are generated about this issue in Windows event viewer or FusionSphere
Handling Process

A.   During the configuration process of TCM, when it tries to start the the service and remains stuck the method to follow is:

1.   Go to "C:\Program Files (x86)\MySQL\MySQL Server 5.5"

2.   Edit my.ini file

3.   Look for "storage engine" parameter and change from "InnoDB" to "MYISAM"

4.   Then save and manually start MYSQL service from "services.msc" in windows

B.   After the DB service has started the configuration wizard remains stuck and fails to apply security settings the method to follow is:

1.   Go to "C:\Windows\System32\drivers\etc" and copy the hosts file on your desktop (due to security permissions).

2.   Edit "hosts" file and comment 127.0.0.1 line if it is uncommented and save it.

3.   Copy this file back to its previous location and overwrite it when asked.

Root Cause
INNODB is no longer supported in MYSQL 5.5 version, rathere MYISAM is used to consider this approach or adapt in TCM version
Solution

A.   During the configuration process of TCM, when it tries to start the the service and remains stuck the method to follow is:

1.   Go to "C:\Program Files (x86)\MySQL\MySQL Server 5.5"

2.   Edit my.ini file

3.   Look for "storage engine" parameter and change from "InnoDB" to "MYISAM"

4.   Then save and manually start MYSQL service from "services.msc" in windows

B.   After the DB service has started the configuration wizard remains stuck and fails to apply security settings the method to follow is:

1.   Go to "C:\Windows\System32\drivers\etc" and copy the hosts file on your desktop (due to security permissions).

2.   Edit "hosts" file and comment 127.0.0.1 line if it is uncommented and save it.

3.   Copy this file back to its previous location and overwrite it when asked.

Suggestions
The above solution needs to be incorporated in the TCM software to avoid any reconfiguration issues during POC Projects or in Production environment.

END