Unable to retrieve remote data connecting to postgresql database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

QOS in Metric view not available for postgresql probe.

Remote call Failed.

Unable to retrieve remote data. 

Message: Profile failed verification due to error (1) error, Failed to connect to the PostgreSQL Environment
Error Code: VM-001

From the postgresql probe log:

Nov 19 23:38:34:034 [attach_socket, postgresql] Failed to connect to database : FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 
Nov 19 23:38:34:035 [attach_socket, postgresql] Error connecting to postgresql database :FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 
Nov 19 23:38:34:035 [attach_socket, postgresql] org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "##.##.##.##", user "postgres", database "postgres", no encryption 

Environment

DX UIM 23.4.*
postgresql probe any version

Cause

The pg_hba.conf does not have an entry allowing the IP listed in the message to access the database, and with what type of authentication.

Resolution

Steps to resolve the issue: 

 

• Update the pg_hba.conf with the address that needs to connect.
  
  example:

host    all             all             ##.##.##.##/32       password
  
  
  

Note: The method should be set to 'password' as the probe currently only supports non-SSL connections.