A database connection error has been detected - how to solve

[qtg_tech]

Dear Support

My nagios is completely unavailable and Can see the following message

"Databse Error
A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB:

/usr/local/nagiosxi/scripts/repair_databases.sh
"
I run the script, but it still the same.

Could you please help me to solve this?

[ssax]

Did anything change prior to this like trying to offload the DB or anything?

What is the output of these commands (PM it to me):

Code: Select all

df -h
df -i
grep pgsql /usr/local/nagiosxi/html/config.inc.php
systemctl status mariadb
systemctl status mysql
systemctl status mysqld
systemctl status postgresql
systemctl status ndo2db
tail /var/log/messages
tail /var/log/mariadb/mariadb.log
tail /var/log/mysqld.log
tail /var/log/mysql/mysqld.log
uname -a
cat /etc/*release

Please try generating a profile.zip from the command line by running these commands as root:

Code: Select all

rm -rf /usr/local/nagiosxi/var/components/profile*​​
/usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORT

Then PM me the resulting /usr/local/nagiosxi/var/components/profile.zip​ file.​

If the profile script fails, please include the ENTIRE output.