Page 1 of 1

Database crash!

Posted: Fri Jul 18, 2014 8:41 am
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

Re: Database crash!

Posted: Fri Jul 18, 2014 9:01 am
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

Re: Database crash!

Posted: Fri Jul 18, 2014 10:23 am
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