Page 1 of 1
can not access NagiosXI, DB error ...
Posted: Sun Jul 07, 2019 11:06 pm
by xpertech
We had transferred NagiosXI to Amazon AWS couple days and looks good, today when tried to login NagiosXI but it failed, after repaired DB then can login, but after logged in, the DB error page displayed, we tried to repaired DB again but still DB error.
How to let it back to normal?
Re: can not access NagiosXI, DB error ...
Posted: Sun Jul 07, 2019 11:12 pm
by xpertech
We installed new same version of NagiosXI on AWS, then restore the NagiosXI backed up file successful without error, after couple days we login again, it displayed DB error ?!
Re: can not access NagiosXI, DB error ...
Posted: Mon Jul 08, 2019 10:25 am
by benjaminsmith
Hello
@xpertech,
Please try running the following command to repair the database:
Code: Select all
mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm
If the issue persists, please send us your system profile for us to review.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
Thanks.
Re: can not access NagiosXI, DB error ...
Posted: Tue Jul 09, 2019 1:26 pm
by xpertech
The command seems not work?! also can not get profile ...
Re: can not access NagiosXI, DB error ...
Posted: Tue Jul 09, 2019 2:33 pm
by benjaminsmith
Hello
@xpertech,
It looks like the database is not running.
To check the status, on Cent 7, run the following:
To restart: