Once you have finished Installing the Management Pack (MySQL) and Configuring the Management Pack (MySQL), check the Collection State and Collection Status for the adapter instance on the Solutions page. If they show as Not Collecting or No Data Receiving, respectively, the following troubleshooting topics can help you diagnose and correct common problems with your adapter instance.

  • Test Connection Errors
  • Adapter and Collector Log Files

Test Connection Errors

When Creating an Adapter Instance (MySQL), click Test Connection after entering all of your configuration settings to ensure vROps can connect to the specified host.

The following errors are possible:

Invalid Host

Error Message: Unable to establish a valid connection to the target system. Unable to connect to the server. Verify your Host settings.

Description: Verify your host URL or port number are appropriate.

Request Timed Out

Error Message: Unable to establish a valid connection to the target system. Unable to connect to the server. Request timed out.

Description: Verify your host URL or port number are appropriate.

User Authorization

Error Message: User Authentication error. Please check your user credentials or SSL settings.

Description: Verify the user credentials and SSL settings are appropriate.

Invalid Port Number

Error Message: "Port number specified contains invalid characters." – OR – "Invalid port number." Check your port number.

Description: Verify the port number is the correct database port for the server.

Invalid Connection Settings

Error Message: Unable to connect to the server. Verify your host settings.

Description: Verify the hostname/IP address for MySQL server is correct.

Invalid Database

Error Message: The database ‘<DatabaseName>’ not exist.

Description: Verify the correct database name was entered in the Database field.

Invalid SSL Certificate

Error Message: The given SSL certificate is invalid or does not exist.

Description: Verify the file path is correct and is the correct certificate for the MySQL server.

SSL Connection Error

Error Message: SSL Mode currently set is not supported by the server. Verify your SSL settings.

Description: The Use SSL field is set to True, but the server does not support SSL. Set the field to False.

Adapter and Collector Log Files

You can review adapter errors in the adapter and collector log files, which can be viewed in the vROps UI or in an external log viewer.

  • Adapter log files are located in the $ALIVE_BASE/user/log/adapters/MySQLAdapter/ folder.
  • Collector log files are located in the $ALIVE_BASE/user/log/ folder.

To set the base log level for the collector in vROps:

  1. Navigate to Administration > Logs.
  2. Expand the MASTER folder, then select the COLLECTOR folder.
  3. Click the Edit Properties configure_iconicon.
  4. In the Root logger level drop-down menu, select the desired option.
  • The default logging level is warning.
  • To troubleshoot issues, set the logging level to info.
  • To view detailed messages, including micro steps, queries, and returned results, set the logging level to debug.
Note: If you set the logging level to debug , log files can become large very quickly. Set the logging level to debug only for short periods of time.

For more information about viewing log files and modifying levels, refer to the vROps online help.