revisiting the Service Status display character limits

[SteveBeauchemin]

In the setup of a new server I get the default size for the Status column display. To change that in the past we had been given specific sql syntax to increase the size of the DB field for storing longer text. A new clean install has different DB construction from the old server. As such, I would like to verify some new syntax.

To have the Nagios XI Status Information column display more text, is this the 'new' way to get that done properly?

Code: Select all

mysql -u root -p
use nagios;
alter table nagios_hostchecks modify output text CHARACTER SET latin1 NOT NULL;
alter table nagios_hoststatus modify output text CHARACTER SET latin1 NOT NULL;
alter table nagios_servicechecks modify output text CHARACTER SET latin1 NOT NULL;
alter table nagios_servicestatus modify output text CHARACTER SET latin1 NOT NULL;
exit

Please let me know if this is how we expand that field on a new 5.x Nagios XI installation.

Thanks

Steve B

[ssax]

These should be what you're looking for, but yes, text is the same size as varchar(65535):

Code: Select all

echo "use nagios;alter table nagios_servicestatus modify output text not null;alter table nagios_servicestatus modify long_output text not null;alter table nagios_servicestatus modify perfdata text not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_hoststatus modify output text not null;alter table nagios_hoststatus modify long_output text not null;alter table nagios_hoststatus modify perfdata text not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_servicechecks modify output text not null;alter table nagios_servicechecks modify long_output text not null;alter table nagios_servicechecks modify perfdata text not null;" | mysql -pnagiosxi

echo "use nagios;alter table nagios_hostchecks modify output text not null;alter table nagios_hostchecks modify long_output text not null;alter table nagios_hostchecks modify perfdata text not null;" | mysql -pnagiosxi

Or per your method:

Code: Select all

mysql -u root -p
use nagios;
alter table nagios_servicestatus modify output text not null;
alter table nagios_servicestatus modify long_output text not null;
alter table nagios_servicestatus modify perfdata text not null;
alter table nagios_hoststatus modify output text not null;
alter table nagios_hoststatus modify long_output text not null;
alter table nagios_hoststatus modify perfdata text not null;
alter table nagios_servicechecks modify output text not null;
alter table nagios_servicechecks modify long_output text not null;
alter table nagios_servicechecks modify perfdata text not null;
alter table nagios_hostchecks modify output text not null;
alter table nagios_hostchecks modify long_output text not null;
alter table nagios_hostchecks modify perfdata text not null;
exit

[SteveBeauchemin]

Aren't the long_output and perfdata already text? Why change them again?

Steve B

[ssax]

I just updated the commands from this KB article:

https://support.nagios.com/kb/article/n ... s-478.html

It doesn't matter as long as it's not shorter than the current setting, at that point you lose information.