Nagios XI suddenly stopped working - repaired db... no luck!

[dbsaust]

Hi,
We can't access Nagios XI system. Login page prompted the following. repair_databases.sh executed couple of times. No luck! Kindly assist.


Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, 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
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, 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

[kyang]

Which version of XI are you on and what OS?

Is your database running? Run this command to show us which db.

Code: Select all

awk '/"nagiosxi" => array\(/{getline;print}' /usr/local/nagiosxi/html/config.inc.php

Can you show us your db logs?

Code: Select all

tail -50 /var/log/mysqld.log

Or if you have mariadb

Code: Select all

tail -50 /var/log/mariadb.log

[dwasswa]

Hi @dbsaust ,

Please run the following commands and post the output:

MySQL
tail -n 20 /var/log/mysqld.log

MariaDB
tail -n 20 /var/log/mariadb/mariadb.log

Please send me your system profile by following the steps below:

Go to Admin >> System Profile

System_profile.PNG

Then click Download Profile and send it.

Download_system_profile.PNG

[dbsaust]

Hi @dwasswa and @kwang,
Thanks for your replies.
You guys are right. We checked the log and found disc space issue, as below. This is now resolved.

Code: Select all

170919 19:49:23 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
170919 19:49:23 [ERROR] Can't start server: can't create PID file: No space left on device

Thanks again.

[kyang]

Sounds great! I'll be closing this topic as resolved!

If you have any more questions, feel free to create another thread!

Thank you for using the Nagios Support Forum!