Need help - Install iMC 5.2 with remote mysql - failed

[Nicolas_Julien]

Hello,

i'm facing a problem for install the last version of iMC 5.2 with a remote mysql server.

All the distros are Centos 6.4.

When i launch the install.sh, the precheck are ok (also the database connectivity check), the install is done, but when it's the moment to do the deploy, the deployment failed into the "building database ....."

I can see in the log that the deployment try to use the local server adress........

But in the configuration i've specified the remote address of the mysql server.

Does someone has some information about this problem ?

Thank you very much.

Regards,

[RK_br]

Hello Nicolas,

During install IMC checks for MYSQL installation on the local machine. If the pre-reqs are not on there, it will attempt to install it's own database, so make sure you install the mysql client on the actual IMC server machine:

(from the IMC mysql 5.5 install manual)

1.Install both MySQL-server-5.5.18-1.rhel15.x86_64.rpm and
MySQL-client-5.5.18-1.rhel15.x86_64.rpm on the database server.
2. Install only MySQL-client-5.5.18-1.rhel15.x86_64.rpm on the IMC server that uses a remote
database server.
3. Select other serverfor the database location and enter the server IP address during IMC installation.

http://h20000.www2.hp.com/bizsupport/TechSupport/CoreRedirect.jsp?redirectReason=DocIndexPDF&prodSeriesId=4176520&targetPage=http%3A%2F%2Fbizsupport2.austin.hp.com%2Fbc%2Fdocs%2Fsupport%2FSupportManual%2Fc03382647%2Fc03382647.pdf

Best of luck,

RK

[Nicolas_Julien]

RK,

thank you for your answer.

1) the link gives me an 404 error page :)

2) i do exactly what you say.

On my iMC server, i've installed the Mysql-Client.

On the mysql server - i've installed the Mysql-server package, all is correct in the configuration, i can join mysql server from the iMC Server using the mysql cli.

When i start the installation of iMC, in the configuration i select a standard installation, and in the configuration box, i select other server for the database, specify the ip address of my MySQL server. At this moment, the check of prerequire is alright. The installer can join the DB.

After, that, the installation is done. Then, is the moment where the installer must "deploy" the differents components of iMC and at this, time, when the installer must create the tables of the DB, i think that the deploy of the package try to find a local mysql server. I suppose that because in the log of the deploy i see that the connectivity to the database was not possible on the local server IP address.

Maybe there is a problem into the management of the deploy ? The variables that i've set (other server, ip address, port, ....) are not passed to the deployment.

Need help :(

[Nicolas_Julien]

I've retried to install the iMC with my remote mysql.

I confirm that the installer has a problem, you can find my log here :

2013-07-19 20:55:37 [INFO ] [main] [com.h3c.imc.deploy.Util::getOracleHome(503)] Find ORACLE_HOME=/opt/oracle/product/11.2.0/client_1
2013-07-19 20:55:37 [INFO ] [Thread-2] [com.h3c.imc.deploy.dma.AgentMessageHandler$1::run(849)] Agent start connect to server
2013-07-19 20:55:47 [INFO ] [Thread-2] [com.h3c.imc.deploy.dma.AgentMessageHandler$1::run(881)] Agent connection started
2013-07-19 20:55:47 [INFO ] [Thread-2] [com.h3c.imc.deploy.dma.AgentMessageHandler::connectStateChanged(1013)] Agent-Server connect state changed: Connected
2013-07-19 20:55:47 [INFO ] [Thread-2] [com.h3c.imc.deploy.dma.AgentMessageHandler$1::run(904)] Create Agent MQ connection completed
2013-07-19 20:55:57 [INFO ] [Database Checking Thread] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(157)] Start loading server-addr.xml configuration file
2013-07-19 20:55:57 [WARN ] [Database Checking Thread] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(162)] Config file is not exist - /opt/iMC/common/conf/server-addr.xml
2013-07-19 20:55:57 [INFO ] [main] [com.h3c.imc.deploy.dma.DeployManager::loadComponentDeployInfo(734)] Component deploy state changed
2013-07-19 20:55:58 [INFO ] [ActiveMQ Session Task] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(157)] Start loading server-addr.xml configuration file
2013-07-19 20:55:58 [WARN ] [ActiveMQ Session Task] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(162)] Config file is not exist - /opt/iMC/common/conf/server-addr.xml
2013-07-19 20:55:58 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(594)] Components conformable check failed: no component deployed
2013-07-19 20:55:58 [INFO ] [ActiveMQ Session Task] [com.h3c.imc.deploy.dma.AgentMessageHandler::masterConnectStateChanged(1038)] Receive master state change message: Connected
2013-07-19 20:55:58 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(594)] Components conformable check failed: no component deployed
2013-07-19 20:55:58 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(594)] Components conformable check failed: no component deployed
2013-07-19 20:55:58 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(594)] Components conformable check failed: no component deployed
2013-07-19 20:56:02 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.DeployWizard$WizardData::parseTaskProperties(434)] Deploy component "iMC-PLAT" for the first time: true
2013-07-19 20:56:03 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(95)] data.isNeedSelectDatabase() is : true
2013-07-19 20:56:03 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(96)] data.isNeedInputWebServerPort() is : true
2013-07-19 20:56:03 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(97)] data.isNeedShowCustomPanels() is : false
2013-07-19 20:56:05 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(499)] Components conformable check failed: invalid state - deploying
2013-07-19 20:56:05 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(269)] Start deploy component: iMC-PLAT [iMC PLAT 5.2 (E0401)]
2013-07-19 20:56:05 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(281)] Replacement Variables: {${COUNTRY}=US, ${DATABASE_ADDRESS}=192.168.3.38, ${DATABASE_ADMIN_PASSWORD_ESCAPE}={PROTECTED}, ${DATABASE_ADMIN_PASSWORD}={PROTECTED}, ${DATABASE_ADMIN_USERNAME}=iMC_mysql, ${DATABASE_PORT}=3306, ${DATABASE_TYPE}=MySQL, ${DEPLOY_IP}=127.0.0.1, ${HTTPS_PORT}=443, ${HTTP_PORT}=80, ${INSTALL_DESTINATION_DIR}=/opt/iMC, ${LANGUAGE_U}=C, ${LANGUAGE}=en, ${LOCAL_IP_0}=192.168.14.2, ${LOCAL_IP_1}=fe80:0:0:0:250:56ff:feac:2d52%2, ${LOCAL_IP_COUNT}=2, ${MASTER_IP}=localhost, ${SERVER_TYPE}=Master, ${iMC-PLAT['DEPLOY_IP']}=127.0.0.1}
2013-07-19 20:56:05 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - server_linux.zip...)...
2013-07-19 20:56:07 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - l2topo_server_linux.zip...)...
2013-07-19 20:56:07 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client.zip...)...
2013-07-19 20:57:14 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - imc_dnd_sdk.zip...)...
2013-07-19 20:57:15 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client_topoplat.zip...)...
2013-07-19 20:57:33 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client_usertopo.zip...)...
2013-07-19 20:57:33 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client_webdm_mibbrowser.zip...)...
2013-07-19 20:57:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client_gencfg.zip...)...
2013-07-19 20:57:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - imcdm_topopanel_sdk_daily.zip...)...
2013-07-19 20:57:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - 3rd_license_plat.zip...)...
2013-07-19 20:57:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(Unzipping file - client_iccconf.zip...)...
2013-07-19 20:58:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(157)] Start loading server-addr.xml configuration file
2013-07-19 20:58:34 [WARN ] [Thread-14] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(162)] Config file is not exist - /opt/iMC/common/conf/server-addr.xml
2013-07-19 20:58:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(341)] Executing com.h3c.imc.deploy.tasks.BuildDatabaseTask(Building database - server/script_mysql.hz...)...
2013-07-19 20:58:34 [ERROR] [SwingWorker-pool-1-thread-4] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(902)] Execute database script error! return value: 1. For details, see log file: /etc/iMC-Reserved/log/dbresult_201307192058340.log
2013-07-19 20:58:34 [ERROR] [Thread-14] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(346)] Task execute failed
2013-07-19 20:58:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(157)] Start loading server-addr.xml configuration file
2013-07-19 20:58:34 [WARN ] [Thread-14] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(162)] Config file is not exist - /opt/iMC/common/conf/server-addr.xml
2013-07-19 20:58:34 [INFO ] [Thread-14] [com.h3c.imc.deploy.dma.IPConfigFileManager::saveAllConfigs(342)] Save server address config OK
2013-07-19 20:58:35 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(594)] Components conformable check failed: no component deployed

 And when i go into the file /etc/iMC-Reserved/log/dbresult_201307192058340.log

i see :

Begin to create config_db database...
ERROR 1044 (42000) at line 2: Access denied for user 'iMC_mysql'@'192.168.14.2' to database 'config_db'
The install of imcnetresdm finished unsuccessfully, please contact your local IMC support centre.

Why this **bleep**ing db script is going to try to install on the local server ???

If HP has some answer for that, i take....

[HEikelenboom]

Hello,

I want to jnstall imc 5.2 on cent os 6.4 x86_64
After running installatie.sh on the same server i got a error.
Cannot initialize graphics installation.
Do you have any glue.

Thanks
I have installed al the necessary files x64 and i386.

[LindsayHill]

Are you running a full GUI, or redirecting X to a remote server?