Dashboards Disappearing Nagios XI 5.4.13

[dfaenza]

Hello All,
I am having an issue where some of my Nagios XI custom dashboards have gone missing. I cannot find any evidence that they were deleted by another user in our system and the records still appear to be on the xi_usermeta table.

I have tried the steps at:

https://support.nagios.com/forum/viewto ... =6&t=39490

and

https://support.nagios.com/forum/viewto ... XT#p202912

however, the dashboards have not returned.

I am wondering if anyone has run into this previously and may help to guide me in the right direction as I have not yet found a solution outside of rebuilding these dashboards.

The dashboards are missing for all users. Our installation is one that has been upgraded over the years and converted from postgresql to mysql.

Any help is greatly appreciated.

[npolovenko]

Hello, @dfaenza. Possibly some of the links in the database got corrupted. Please run the following command to repair the DB:

/usr/local/nagiosxi/scripts/repair_databases.sh

If the dashboards didn't come back please 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 upload it to a cloud storage of your choice. You can share a link with me in a personal message.
After you upload the profile please post something in this thread to bring it up in the support queue.

[dfaenza]

Hello @npolovenko,

Thank you for your response.

I have tried the above database repair and it did not correct the issue. I have downloaded our system profile, however the forum states that I am not authorized to use the private message feature. Is there a way to get this access so I may send you the details for the download?

[scottwilkerson]

I've adjusted your forum rights, you can PM the file to @npolovenko now.

[npolovenko]

@dfaenza, I examined your system profile and I could definitely see some database corruption. Please run through the following commands to repair the database:

service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f *
cd /var/lib/mysql/nagiosql
myisamchk -r -f *
cd /var/lib/mysql/nagiosxi
myisamchk -r -f *
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/bin/php /usr/local/nagiosxi/cron/dbmaint.php
service nagios restart
service httpd restart

Then restart the browser and let me know if dashboards appeared.

[dfaenza]

@npolovenko,
I have performed the steps above, however it did not recover the dashboards. Perhaps I am incorrect in this, but I was under the assumption that xi_usermeta table is where the dashboard data is stored. If I perform the following:

Code: Select all

echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -u[redacted] -p[redacted] nagiosxi

I do see the dashboard information there if I search for the name that the previous dashboard had.

[npolovenko]

@dfaenza, Can you send me a small example of this query so that I could compare the syntax of the entries in your database to mine?

echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -u[redacted] -p[redacted] nagiosxi

[npolovenko]

@dfaenza, I received the sample, thank you. Can you verify that the user who no longer sees the specified dashboard has the ID number #78. To check the ID number of the user go to the Admin menu, then Manage Users(in the left column) and hover over the edit button, you will see the user_id in the url. Also, this dashboard was shared by the user with the id #63. If this user no longer exists or if they deleted it then other users will not be able to access it as well since the dashboard was synced.

[dfaenza]

@npolovenko,
Both of those users still exist under manage users, however the original Nagios user that was our administrator for Nagios XI has been deleted. I was not aware that the user was deleted by one of our other techs, but likely explains why these dashboards are no longer accessible. Based on this information I believe I will need to recreate these dashboards.

I believe that we can close this thread.

As an aside, is there a log that would indicate what user deleted the aforementioned user account? I can start a different thread if this cannot be answered here.

[lmiltchev]

Most of the activity is logged into the audit log, such as add, delete, modify, change, security, etc.

Admin > System Information > Audit Log

Note: You are running an old version of XI. There are some improvements to the audit log in newer versions. You can review the changes here:
https://www.nagios.com/downloads/nagios-xi/change-log/

Hope this helps. Thank you!