jdbc_response probe exception - The authentication type 10 is not supported

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Trying to monitor postgres DB using jdbc_response probe. Have deployed the latest version of the probe (v1.25) & downloaded jdbc driver (PostgreSQL JDBC 4.2 Driver, 42.2.5).

Only able to successfully test the connection using password auth MD5 which is for version lower than 10. 

Trying to monitor version 11 which uses scram-sha-256 authentication

On testing connection it fails with error message prompting type 10 is not supported. 

Environment

Release :

Component : UIM JDBC RESPONSE

Resolution

Download the driver and put it into the default probe lib path and restart the jdbc_response probe: 

The default location of the JDBC driver JAR file is [CA UIM Installation Directory] \probes\database\jdbc_response\lib folder.

Additional Information

jdbc_response (Java Database Connectivity SQL Queries Response Monitoring) Release Notes (broadcom.com)