Nagios XI Dashboards disappearing

[operations_asavie]

We are having the same issue as described in the below thread:

https://support.nagios.com/forum/viewto ... 16&t=37053

Basically when I was working on the system, adding a performance graph from the graph explorer to an existing dashboard, something went wrong with the system and it removed all our listed dashboards.

We have checked the ‘dashboards’ row of the ‘xi_usermeta’ table in MySQL and can see that the dashboard configuration is still stored there, however on the live system when we click in to dashboards none are listed. If we reload a page that was previously open on one of our dashboards we get a message that the “dashboard is not valid” as can be seen in the attached.

We’re not exactly sure what went wrong. The issue occurred when adding a graph to a dashboard, in the same way as we have done many others previously.

This seems to be a known issue, is there a resolution? We have made a backup of the current MySQL database which we can send on if that will help.

[tmcdonald]

Just to confirm, this was reported against XI 5.2.3 in that other thread - what XI version are you running?

[operations_asavie]

Version Nagios XI 5.2.5 running here. Can you please get back to me on this ASAP?

[operations_asavie]

Can somebody get back to me on this ASAP. We need a resolution to this issue now.

[ssax]

Here is what that other resolution was for that other post you're referencing:

He had so much data in there that they were hitting the max byte limit of the DB field type.

First you need to delete what you have currently in the DB because it's broken:

Code: Select all

echo "delete from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi

Then you can change the field type so that it will support at least 4GB in that field:

Code: Select all

echo "alter table xi_usermeta modify keyvalue LONGTEXT;" | mysql -uroot -pnagiosxi nagiosxi

Now you should not experience the issue.

[operations_asavie]

As a last resort we can delete the content of the DB if absolutely necessary. We would like to avoid that if possible, we have the DB with all our dashboards saved so would we be able to expand to the 4GB and then restore the old DB?

[ssax]

The problem is that the data is serialized in the DB and it's not complete because it's been cut off, so you would have a very tough time unserializing it. I can take a look at it and see if there is anything I can do if you PM me the /tmp/dash_output.txt that this command generates:

Code: Select all

echo "select * from xi_usermeta where keyname like '%dash%';" | mysql -uroot -pnagiosxi nagiosxi > /tmp/dash_output.txt

[operations_asavie]

Please see attached.

[ssax]

It looks like the data is missing, not even the defaults are there. Do you have a backup of the SQL data from before it broke? You can check /store/backups/mysql/daily/nagiosxi or /store/backups/mysql/daily/weekly/nagiosxi as well.

If you don't, you can delete the current data and then login and it will rebuild the defaults.