can not access NagiosXI, DB error ...

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

[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 ?!

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

[xpertech]

The command seems not work?! also can not get profile ...

[benjaminsmith]

Hello @xpertech,

It looks like the database is not running.

To check the status, on Cent 7, run the following:

Code: Select all

systemctl status mariadb.service

To restart:

Code: Select all

systemctl restart mariadb