Status Information cut off at 256 characters

[Box293]

I've been writing a plugin for which some of the returned Status Information is longer than 256 characters.

I've observed in the Nagios XI interface, the Status Information shown for a service stops at 256 characters (anything after is cut off). When I look at the service in Nagios Core I can see the entire Status Information.

Is there an option in Nagios XI GUI to increase the amount of characters displayed for the Status Information?

This is in Nagios XI 2012R2.3.

[scottwilkerson]

You would need to resize the output column in the following tables in the nagios DB
nagios_servicestatus
nagios_hoststatus
nagios_servicechecks
nagios_hostchecks

[Box293]

Cheers Scott, I'll have a play.

[abrist]

Let us know if you have issues with these php/css edits. Stay warm!

[Box293]

I finally got around to sorting this out.

The commands I needed to perform were as follows:

To check the current size:

Code: Select all

echo "use nagios;desc nagios_servicestatus" | mysql -pnagiosxi | grep "output\|perfdata"
echo "use nagios;desc nagios_hoststatus" | mysql -pnagiosxi | grep "output\|perfdata"
echo "use nagios;desc nagios_servicechecks" | mysql -pnagiosxi | grep "output\|perfdata"
echo "use nagios;desc nagios_hostchecks" | mysql -pnagiosxi | grep "output\|perfdata"

To alter the size:

Code: Select all

echo "use nagios;alter table nagios_servicestatus modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_hoststatus modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_servicechecks modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_hostchecks modify output varchar(65535) not null;alter table nagios_servicestatus modify long_output varchar(65535) not null;alter table nagios_servicestatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi

As soon as the check was next executed the output showed correctly in the XI interface (not cut off).