Once you have finished Installing the Management Pack (PostgreSQL) and Configuring the Management Pack (PostgreSQL), 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 (PostgreSQL), click Test Connection after entering all of your configuration settings to ensure vROps can connect to the specified host.

The following errors are possible:

Wrong Credentials

Error: Unable to establish a valid connection to target system. Connection authorization failure occurred. Reason: User ID or Password invalid.

Action: Ensure the correct PostgreSQL and vRealize Operations User Name and Password was entered when Creating a Credential (PostgreSQL).

Wrong Host

Error: Unable to establish a valid connection to target system. Required property is unknown host.

Action: Ensure the correct hostname or IP address of the PostgreSQL instance was entered when Creating an Adapter Instance (PostgreSQL).

Wrong Port

Error: Unable to establish a valid connection to target system. Connection authorization failure occurred. Error opening socket server <name> on port with message: Connection refused.

Action: Check your PostgreSQL database system and ensure the connection port number matches the port number entered (if other than default of 5432) when Creating an Adapter Instance (PostgreSQL)

Wrong Database

Error: Connection authorization failure occurred. The application server rejected establishment of the connection. An attempt was made to access a database, <name>, which was either not found or does not support transactions.

Action: Ensure the database name(s) provided match the PostgreSQL system. Multiple databases should be separated by commas in the Manage Solution window. See: Creating an Adapter Instance (PostgreSQL).

SSL Not Enabled

Error: SSL connection is not enabled.

Action: Under Advanced Settings, set SSL mode to be Enabled (required). See: Creating an Adapter Instance (PostgreSQL).

Server Does Not Support SSL

Error: The server does not support SSL connections.

Action: Under Advanced Settings, set SSL mode setting to Disabled. See: Creating an Adapter Instance (PostgreSQL).

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 $VCOPS_BASE/user/log/adapters/PostgreSQLAdapter/ folder.
  • Collector log files are located in the $VCOPS_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.