No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

ATIC connected to database failed resulted in ATIC couldn't start normally

Publication Date:  2015-06-22 Views:  92 Downloads:  0
Issue Description

The ATIC management center's version was V200R001C00SPC900, after it was installed in IBM X3650 server, it can started normally. But if the IBM restarted, the ATIC will failed to start, and there will be a message" Failed to connect to the database. Syatem started unsuccessfully", it is shown as below:


Alarm Information
none
Handling Process

1Check the Mysql server was started or not. Open the client of MySQL, can login in normally after input the username and password, it is show as below:

http://support.huawei.com/enterprise/product/images/d8bfd0879fe54b58934e3eaf49ff61c8

2Start the ATIC configuration tool, and set the parameters of database according to the product documentation. Press “test”, the result was failed.

http://support.huawei.com/enterprise/product/images/e8a549228b6e4adf80c931aa8ca6b973

3Maybe there was something wrong with the installation of ATIC management center,

1Open the local user folder (C:\Documents and Settings \administrator in the Windows 2003 operating system and C:\Users\Administrator in the Windows 2008 operating system) and check whether the following files exist:

·         legoInstalled.xml records the installation information of the ATIC Management center: installation directory, database type, basic database information.

·         ddosCollectorInstalled.xml records the installation information of the Anti-DDoS collector software, and it is generated only in the centralized deployment.

If the file does not exist, re-install the ATIC Management center.

2Choose Start > Control Panel > Administrative Tools > Services.

3Check whether the following services exist and have been started.

    

System service list

Service Name

Intended Object

LEGOService

ATIC Management center server software

LEGOWebSrv

ATIC Management center server software

LEGOMonitor

ATIC Management center server software

mysqlservice

ATIC Management center server software

Anti-DDoS Collector Monitor Service

Anti-DDoS collector software

Anti-DDoS Collector Service

Anti-DDoS collector software

If the service exists and is started, the ATIC Management center server software is correctly installed.

If the service exists and is not started, right-click this service and choose Start from the shortcut menu.

If the service does not exist, reinstall the ATIC Management center server software.

     After follow the above steps, confirmed that the ATIC was installed correctly,

 

4Confirm there was nothing wrong with the installation of ATIC management center, Maybe there was some problem of the service of MySQL database. Select” Start>control panel>Management tool>Services”, check the status of MySQL service, we found there were two service, one was MySQL, the other one was mysqlservice. After restarted the IBM server, the default started service was “MySQL”, and the status of “mysqlservice” was “stopped”. But the built-in service of ATIC is “mysqlservice”, so, we should stop the “MySQL” and start the “mysqlservice”. But pay attention to that, we must stop “MySQL” service first, and then we can start the “mysqlservice” service.

http://support.huawei.com/enterprise/product/images/294b629f60474aae954ac10afc1c3560

5Restarted the ATIC after we started the “mysqlservice” service, and then ATCI could connect to the database successfully, finally, ATCI run successfully.

Root Cause
1、The root cause is that: before the installation of  built-in MySQL database of ATIC, there is already a MySQL dadabase has been installed in IBM X3650 server. When we restart the server, the default started service is mysqlservice, but not the built-in MySQL service-MySQL, and the default database serveice hasn't been initialized by ATIC. As a resualt, the ATIC started failed because it can't connect to the the database.
Solution

1、If there was no enough time to uninstall the default MySQL database, we can stoped the MySQL first, and then start the mysqlservice, the ATIC will start normally;

2、The fundamental solution is to uninstall the default MySQL database, and re-install the ATIC again.

Suggestions
1。Before we install the ATIC management center, we need to confirm whether there is a default MySQL database already installed in this server. If there is a default database already installed, need to uninstall it first, and then install the ATIC software.

END