Page 1 of 1
Dashboards just all disappeared
Posted: Wed Sep 07, 2016 8:47 pm
by 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 ?
Re: Dashboards just all disappeared
Posted: Thu Sep 08, 2016 10:28 am
by rkennedy
What version of XI are you using?
Also, under Admin -> Manage Components -> What version of the 'Dashboard Deployment Tool' do you have?
Re: Dashboards just all disappeared
Posted: Fri Sep 09, 2016 1:54 am
by 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
Re: Dashboards just all disappeared
Posted: Fri Sep 09, 2016 1:34 pm
by 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
Re: Dashboards just all disappeared
Posted: Mon Sep 12, 2016 2:10 am
by davidr
The table wouldn't paste correctly into this window so I've attached a screen shot
Re: Dashboards just all disappeared
Posted: Mon Sep 12, 2016 12:05 pm
by 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.