Certain users getting Databse error when loading webpage

[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.

[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