Dashboard Keyvalue Field in 5.2.7

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
bdouglass
Posts: 28
Joined: Tue Apr 24, 2012 9:27 am

Dashboard Keyvalue Field in 5.2.7

Post by bdouglass »

I was able to resolve (with Tech Support's excellent help) an issue with dashboards overflowing the keyvalue field in the xi_usermeta table. The resolution was to execute the following code:

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

We are currently running NagiosXI 5.2.5. I'd like to upgrade to 5.2.7, but I don't know if this fix has been applied to the production code. Can anyone tell if xi_usermeta.keyvalue has been updated to a LONGTEXT field?

Thanks,

Bill Douglass
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Dashboard Keyvalue Field in 5.2.7

Post by ssax »

I've conversed with the devs and it should not be reverted on an upgrade. That being said, you should always take an XI backup/VM snapshot before any upgrade just in case.

That change is scheduled to go out in the next minor release - 5.3.0
bdouglass
Posts: 28
Joined: Tue Apr 24, 2012 9:27 am

Re: Dashboard Keyvalue Field in 5.2.7

Post by bdouglass »

Much appreciated. You can close this thread now.

Bill
Locked