Failed to start InsightVM console

Getting this error while starting the console, any help would be appreciated.

2024-07-25T11:08:08 [INFO] [Thread: Security Console] Error connecting to PostgreSQL: (08001): retrying…
org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2024-07-25T11:08:23 [ERROR] [Thread: Security Console] A critical error occurred during initialization
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2024-07-25T11:08:23 [INFO] [Thread: Security Console] Adding maintenance task NexposeRecovery
2024-07-25T11:08:23 [INFO] [Thread: Security Console] Reinitializing web server for maintenance mode…
2024-07-25T11:08:23 [INFO] [Thread: Security Console] Stopping ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Destroying ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Initializing ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Connector [https-jsse-nio-3780], TLS virtual host [default], certificate type [RSA] configured from keystore [/opt/rapid7/nexpose/nsc/keystores/nscweb.ks] using alias [nscweb] with trust store [null]
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Starting ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:25 [INFO] [Thread: Security Console] The start() method was called on component [Connector[“https-jsse-nio-3780”]] after start() had already been called. The second call will be ignored.
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Accepting web server logins.
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Found a pending maintenance task: NexposeRecovery
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Entering maintenance mode, only administrator logins permitted.
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Maintenance Task Started
2024-07-25T11:08:25 [INFO] [Thread: Security Console] Accepting console commands.
2024-07-25T11:08:29 [INFO] [Thread: Security Console] [Started: 2024-07-25T11:03:59] [Duration: 0:04:30.469] Security Console started.
2024-07-25T11:08:29 [ERROR] [Thread: Security Console] Error during server initialization.
java.lang.NullPointerException: null
at com.rapid7.nexpose.nsc.NSC.saveStartupTimes(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.run(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.main(Unknown Source)
2024-07-25T11:08:29 [INFO] [Thread: Security Console] Shutting down immediately
2024-07-25T11:08:29 [WARN] [Thread: Security Console] Error stopping quartz schedulers.
java.lang.IllegalArgumentException: A null value is not a valid The scanConfigRepository parameter cannot be null. value.
at com.rapid7.contracts.Contracts.nonNullValue(Contracts.java:50)
at com.rapid7.nexpose.scheduler.SchedulerService.setScanConfigRepository(Unknown Source)
at com.rapid7.nexpose.scheduler.SchedulerService.build(Unknown Source)
at com.rapid7.nexpose.scheduler.SchedulerService.build(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.shutdownQuartz(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.shutdownSubsystems(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.shutdown(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.shutdown(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.run(Unknown Source)
at com.rapid7.nexpose.nsc.NSC.main(Unknown Source)
2024-07-25T11:08:29 [INFO] [Thread: Security Console] Shutting down web server…
2024-07-25T11:08:29 [INFO] [Thread: Security Console] Pausing ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Pausing ProtocolHandler [“https-jsse-nio-3780”]
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Stopping service [Tomcat]
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Destroying Spring FrameworkServlet ‘MVC Dispatcher Servlet’
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Closing Spring root WebApplicationContext
2024-07-25T11:08:31 [INFO] [Thread: Security Console] ScanEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] AssetGroupEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] TagEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] VulnerabilityExceptionEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] UserEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] SiteEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] AssetEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] InvestigationEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Stopping the Disk Space Monitor.
2024-07-25T11:08:31 [WARN] [Thread: Security Console] Shutting down the scheduled executor pool for the agent integration.
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Stopping the Cloud Connectivity Monitor.
2024-07-25T11:08:31 [INFO] [Thread: Security Console] Successfully stopped the Cloud Connectivity Monitor.
2024-07-25T11:08:31 [INFO] [Thread: Security Console] ProductNotificationService unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] RiskModelUpdateEventHandler unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] ConsoleProductInfoProvider unregistered for events
2024-07-25T11:08:31 [WARN] [Thread: Security Console] Shutting down the scheduled executor pool for the scan event monitor.
2024-07-25T11:08:31 [INFO] [Thread: Security Console] NexposeDocumentExporter unregistered for events
2024-07-25T11:08:31 [INFO] [Thread: Security Console] ExposureAnalyticsProxyService unregistered for events

have you done any work in the NeXpose Console Postgres DB? its failing to connect to the DB, is this a new install, old install and just failing? Have you opened a support ticket and they unlocked your DB by changing your connection from MD5 to trust…

Is the database starting at console or system reboot?

Bump

We’re seeing a similar issue, DB doesn’t start

The pga conf file was corrupted so I had copied the file from backup and restored the console. This is what we did and it worked! but please open a ticket with support so they could guide you accordingly