PostgreSQL Adapter fails to collect data with error "The authentication type 10 is not supported."

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

When configuring or running the VMware Aria Operations Management Pack for PostgreSQL, the adapter instance fails to go into an "Online" state. The following error is observed in the adapter logs or the UI Test Connection:

Standard Connection Test Failed: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.

 

Environment

Aria Operations 8.x

VCF Operations 9.x

PostgreSQL Adapter 9.0.0

 

Cause

This issue occurs because the PostgreSQL server is configured to use SCRAM-SHA-256 authentication (Authentication Type 10). The JDBC driver bundled with current versions of the PostgreSQL Management Pack does not support SCRAM-SHA-256 and expects MD5 or Plaintext authentication.

Resolution

To resolve this, the PostgreSQL server must be configured to allow md5 authentication for the specific user account used by Aria Operations.