Page 1 of 1

A database connection error has been detected - how to solve

Posted: Wed May 26, 2021 2:42 am
by 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?

Re: A database connection error has been detected - how to s

Posted: Wed May 26, 2021 2:12 pm
by 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.