Database crash!

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
wajlerl
Posts: 12
Joined: Fri Oct 19, 2012 10:15 am

Database crash!

Post by wajlerl »

Good Morning!
I hope you can help me with an XI database issue. I tried to login to the XI console and got this on the screen. I tried running the repair_databases.sh but these is no such file on the system.

Appreciate any help!
Thanks,
Leszek

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
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
wajlerl
Posts: 12
Joined: Fri Oct 19, 2012 10:15 am

Re: Database crash!

Post by wajlerl »

ok, after digging some more, found out that the logs in http/ filled up /var. I clear up some space and rebooted the nagios server. came up ok. Should I still run the repair_database.sh script. I was initially looking for it on the database server, it's actually on the XI server.

THx,
Leszek
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Database crash!

Post by slansing »

Yeah it's always a good idea to run through that script against the nagios and nagiosql databases after a crash. If you have further questions on their usage, though it is pretty simple, you can take a look at:

http://assets.nagios.com/downloads/nagi ... tabase.pdf
Locked