Dashboards just all disappeared

[davidr]

Hi,

I had about 15 dashboards setup and was almost finished the last one while I was adding some graphs to it, then as I went to add the next graph I couldn't select any of my dashboards to place the graph into. I then went to the dashboards section and they were all gone.

Any ideas ?

[rkennedy]

What version of XI are you using?

Also, under Admin -> Manage Components -> What version of the 'Dashboard Deployment Tool' do you have?

[davidr]

Nagios Xi 5.2.9

Dashboard Deployment Tool 1.2.6

I reverted to a backup 1 hour prior and was able to get my dashboards back. I then tried to continue creating more dashboards but same thing happened again

[tgriep]

It could be a size of a MYSQL table that didn't get set right causing the issue. Can you run the following as root and post the output so we can check it?

Code: Select all

echo "desc xi_usermeta;" | mysql -uroot -pnagiosxi nagiosxi -t

[davidr]

The table wouldn't paste correctly into this window so I've attached a screen shot

[tgriep]

It's likely related to the size of the keyvalue field, please run this command to change the field size:
- Note: Since you are doing DB alterations, please make sure you have an XI/VM backup just in case. This should not have any impact on existing data.

Code: Select all

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

Try that and let us know if it fixes the issue.