Nagios 5.8.6 Failed to start

[matson-itops]

after upgrade, nagios ran fine for a few days then we lost the web interface. it just hangs.
we did a clean stop/start and same issue. All services report running except postgresql.

what logs should we check? postgresql permissions appear to be correct/have not changes.

Error :
[root@]# service postgresql status
Redirecting to /bin/systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Tue 2021-10-12 10:09:16 PDT; 16min ago
Process: 3801619 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql (code=exited, status=1/FAILURE)

Oct 12 10:09:16 xxx systemd[1]: Starting PostgreSQL database server...
Oct 12 10:09:16 xxx systemd[1]: postgresql.service: Control process exited, code=exited status=1
Oct 12 10:09:16 xxx systemd[1]: postgresql.service: Failed with result 'exit-code'.
Oct 12 10:09:16 xxx systemd[1]: Failed to start PostgreSQL database server.


Details :

service nagiosxi stop (deprecated service)
service npcd stop
service ndo2db stop
service nagios stop
service postgresql stop
service mysqld stop
service httpd stop


service httpd start
service mysqld start
service postgresql start
service nagios start
service ndo2db start
service npcd start

[pbroste]

Hello @@matson-itops

Thanks for reaching out, want to have you run through the database repair and follow up with the System Profile so we can see what is going on.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Please PM your updated system profile for us to review.

To send us your system profile.

• Login to the Nagios XI GUI using a web browser.
• Click the "Admin" > "System Profile" Menu
• Click the "Download Profile" button
• Save the profile.zip file and send via Private Message

Thanks,
Perry