8.8 Utilities and Troubleshooting

8.8.1 Starting MySQL

To make sure MySQL is running:

  1. Log in as crystal user.

  2. cd /opt/crystal_xir2/bobje

  3. ./mysqlstartup.sh

8.8.2 Starting Tomcat

To make sure Tomcat is running:

  1. Log in as crystal user

  2. cd /opt/crystal_xir2/bobje

  3. ./tomcatstartup.sh

8.8.3 Starting Crystal Reports Servers

To make sure Crystal Reports Servers are running:

  1. Log in as crystal user

  2. cd /opt/crystal_xir2/bobje

  3. ./startservers

8.8.4 Crystal Host Name Error

To resolve Host Name error

  1. If you get the following error:

    Warning: ORB::BOA_init: hostname lookup returned `localhost' (127.0.0.1)
Use the -OAhost option to select some other hostname

    Make sure your IP and hostname are in the /etc/hosts file. For example,

    10.0.0.1   linuxCE02

8.8.5 Cannot Connect to CMS

If the system reports that it cannot connect to the CMS, try executing the following commands.

To Troubleshoot CMS connection failure:

  1. If the command netstat –an | grep 6400 does not return any results, try the following:

    • Provide MySQL connection information again:

      1. Login as crystal user

      2. cd /opt/crystal_xir2/bobje

      3. ./cmsdbsetup.sh

      4. Press Enter when [<hostname>.cms] displays.

      5. Select select and provide all your MySQL DB info that was entered during install time. For more information, see install instructions in Section 3.0, Installing Sentinel 6.1 SP2.

      6. When done, quit cmsdbsetup.sh

      7. ./stopservers

      8. ./startservers

    • Re-initialize MySQL DB:

      1. Login as crystal user

      2. cd /opt/crystal_xir2/bobje

      3. ./cmsdbsetup.sh

      4. Press Enter when [<hostname>.cms] displays.

      5. Select reinitialize and follow instructions.

      6. When done, quit cmsdbsetup.sh

      7. ./stopservers

      8. ./startservers

  2. Make sure all CCM servers are enabled:

    1. Login as crystal user

    2. cd /opt/crystal_xir2/bobje

    3. ./ccm.sh -enable all