Issue with Postgresql Management Pack on Aria Operations 8.18.4/5 - "SSL connection is not enabled. Server required an SSL connection" & after SSL has been enabled the error "The server doesn't support SSL. Disable SSL mode"

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Postgresql Management Pack just installed on Aria Operations 8.18.4/5

 

Postgresql: After "validating the connection" when SSL is disabled the error "SSL connection is not enabled. Server required an SSL connection" & after SSL has been enabled the error "The server doesn't support SSL. Disable SSL mode"

Environment

 Aria Operations 8.X

Cause

 Confirmed issue via the /log/adapters/PostgreSQLAdapter/PostgreSQLAdapter.log 
 YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.error - com.bluemedora.slf4jtoexunologger.Logger: HikariPool-4071 - Exception during pool initialization.
 org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "<IP_ADDRESS>", user "postgres", database "postgres", SSL off
  YYYY-MM-DDTHH:MM:SS.sssZ FATAL [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.fatal - Caught an ExUno exception while collecting: Collection failed when determining database list. Failed to initialize pool: FATAL: no pg_hba.conf entry for host "<IP_ADDRESS>", user "postgres", database "postgres", SSL off
 com.bluemedora.exuno.common.ExUnoException: Collection failed when determining database list. Failed to initialize pool: FATAL: no pg_hba.conf entry for host "<IP_ADDRESS>", user "postgres", database "postgres", SSL off
 YYYY-MM-DDTHH:MM:SS.sssZ FATAL [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.fatal - com.bluemedora.exuno.common.ExUnoErrorCollection$Companion: Ex Uno Error: unknown|1 An unexpected error occurred during collection.
 YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.error - com.bluemedora.exuno.DataProvider: Diagnosing connection problem
 YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.error - com.bluemedora.slf4jtoexunologger.Logger: HikariPool-4072 - Exception during pool initialization.
 org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "<IP_ADDRESS>", user "postgres", database "postgres", SSL off
 YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.bluemedora.exuno.DataProvider.error - Diagnostic Result:

  ------------------------------
 --- Test Connection Result ---
 ------------------------------

   Overall Result: *** Failed! ***

   --- Critical Tests ---

 Username
   Type:                 username
   Result:               Passed
   Message:              'username' is valid.
   Referenced Parameter: username

 Password
   Type:                 password
   Result:               Passed
   Message:              'password' is valid.
   Referenced Parameter: password

 Host
   Type:                 host
   Result:               Passed
   Message:              'host' is valid.
   Referenced Parameter: host

 Port
   Type:                 port
   Result:               Passed
   Message:              'port' is valid.
   Referenced Parameter: port

 SSL Mode
   Type:                 ssl_mode
   Result:               Passed
   Message:              'ssl_mode' is valid.
   Referenced Parameter: ssl_mode

  Order Functions By
   Type:                 order_functions_by
   Result:               Passed
   Message:              'order_functions_by' is valid.
   Referenced Parameter: order_functions_by

 Order Queries By
   Type:                 order_queries_by
   Result:               Passed
   Message:              'order_queries_by' is valid.
   Referenced Parameter: order_queries_by

 Returned Function Count
   Type:                 function_count
   Result:               Passed
   Message:              'function_count' is valid.
   Referenced Parameter: function_count

 Returned Query Count
   Type:                 query_count
   Result:               Passed
   Message:              'query_count' is valid.
   Referenced Parameter: query_count

 Monitor Tables
   Type:                 monitor_tables
   Result:               Passed
   Message:              'monitor_tables' is valid.
   Referenced Parameter: monitor_tables

 SSL
   Type:                 ssl
   Result:               Failed
   Message:              SSL connection is not enabled. Server requires an SSL connection.

   --- Optional Tests ---

 Database(s)
   Type:                 database
   Result:               Failed
   Message:              'database' not specified. '' will be used.
   Referenced Parameter: database

  YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.bluemedora.vrealize.adapter.postgres.CollectionResultCache.getResult - Error performing collection: SSL connection is not enabled. Server requires an SSL connection.
  YYYY-MM-DDTHH:MM:SS.sssZ ERROR [Collector worker thread 12] (59761) com.vmware.tvs.vrealize.adapter.core.UnlicensedAdapter.onCollect - Encountered a CollectionException during live collection.

 

Resolution

Given the error was showing an SSL / Communication error  - advice is to check the firewall/proxy config.

This issue was resolved after enabling SSL & adding cloud proxy IP to the allowed connection list. 

 

Additional Information

Similar Issue - but different - https://knowledge.broadcom.com/external/article/388825/   - Error "No pg_hba.conf entry for host '###.###.###.###', user '<database user>', database '<database name>', no encryption." while configuring the PostgreSQL adapter in Aria Operations