Running setup_boxi.sh failed at step 4 for SRM due to error: Connection refused

Document ID : KB000051310
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Running setup_boxi.sh failed at step 4 for SRM due to the error: ERROR - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception. See solution for full text of error. The problem normally occurs because MySQL database server is not running.

Solution:

To make sure that MySQL database server is running

  1. Log in as SPECTRUM owner user and launch a bash shell.
    By default MySQL database server process is started when processd is started.

  2. Verify that processd process is running.
    When processd process is running, the following command will display its process ID:
    ps -f | grep processd

  3. If processd is not running, then run the following to restart processd:
    cd $SPECROOT/lib/SDPM
    ./processd.pl start

    Note: On a Solaris or Linux platform you may need to su to root to run this command.
    Go to step 5.

  4. If processd is running, then execute the command to start MySQL database server:
    cd $SPECROOT/bin
    ./launchinstdbapp <hostname> MYSQL y MYSQL.OUT
    Note: substitute <hostname> with the hostname of the system.

  5. Verify MySQL database server is running.
    When MySQL database server is running the cmdC command will show "ticket application_name = SPECTRUM MYSQL Database Server" line in the result.
    cd $SPECROOT/bin
    ./cmdC <hostname> 6 | grep application_name

    Note: substitute <hostname> with the hostname of the system.

  6. Rerun "setup_boxi.sh"

For more information about launchinstdbapp and cmdC command, see TEC516061.

** BEGIN NESTED EXCEPTION **  
java.net.SocketException   
   MESSAGE: java.net.ConnectException: Connection refused: connect  
STACKTRACE:  
   java.net.SocketException: java.net.ConnectException: Connection refused: connect   
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)   
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)   
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)   
   at com.mysql.jdbc.Connection.<init>(Connection.java:1531)   
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)   
   at java.sql.DriverManager.getConnection(DriverManager.java:582)   
   at java.sql.DriverManager.getConnection(DriverManager.java:154)   
   at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager
(DriverManagerDataSource.java:291)   
   at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager
(DriverManagerDataSource.java:277)   
   at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager
(DriverManagerDataSource.java:259)   
   at org.springframework.jdbc.datasource.SingleConnectionDataSource.init(SingleConnectionDataSource.java:178)   
   at org.springframework.jdbc.datasource.SingleConnectionDataSource.getConnection(SingleConnectionDataSource.java:216)   
   at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)   
   at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)   
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:268)   
   at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:413)   
   at com.aprisma.spectrum.app.repmgr.common.registry.SRMRegistry.addEntries(SRMRegistry.java:312)   
   at com.aprisma.spectrum.app.repmgr.install.crystal.SRMBOXIInstaller.setSRMRegistryEntries(SRMBOXIInstaller.java:311)   
   at com.aprisma.spectrum.app.repmgr.install.crystal.SRMBOXIInstaller.doInstall(SRMBOXIInstaller.java:131)   
   at com.aprisma.spectrum.app.repmgr.install.crystal.BaseBOXIInstaller.install(BaseBOXIInstaller.java:96)   
   at com.aprisma.spectrum.app.repmgr.install.crystal.SRMBOXIInstaller.main(SRMBOXIInstaller.java:86)  
 ** END NESTED EXCEPTION **