Page 1 of 1

Dashboard Keyvalue Field in 5.2.7

Posted: Mon May 23, 2016 2:21 pm
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

Re: Dashboard Keyvalue Field in 5.2.7

Posted: Mon May 23, 2016 2:43 pm
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

Re: Dashboard Keyvalue Field in 5.2.7

Posted: Mon May 23, 2016 3:26 pm
by bdouglass
Much appreciated. You can close this thread now.

Bill