Page 1 of 1

Certain users getting Databse error when loading webpage

Posted: Tue Jan 15, 2019 11:27 am
by wjoyner
Certain users are getting the Database Error - A database Connection has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios Support.

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

This was run, but again its very intermittent to which user gets the error.

Re: Certain users getting Databse error when loading webpage

Posted: Tue Jan 15, 2019 2:54 pm
by benjaminsmith
Hi @wjoyner,

Take a backup or VM snapshot and run the following as root from the command line:

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
Also, do you have enough disk space on the server?

Code: Select all

df -h
If you're still having issues, check the log file for any errors and post them to this thread:

Code: Select all

tail -n 20 /var/log/mysqld.log
#OR
tail -n 20 /var/log/mariadb/mariadb.log
Repairing The Nagios XI Databases
https://assets.nagios.com/downloads/nag ... tabase.pdf