Home » Categories » Products » Nagios XI » Troubleshooting » Common Problems

Nagios XI - Status Information Cut Off At 256 Characters

Problem Description

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

 

Explanation

In Nagios XI, that data is stored in a database as opposed to Core. When XI stores it in the database, the database has a limit as to how much data can be stored.

 

Resolving The Problem

The database can be updated so that it can store more information.

Open an SSH session to your XI server and execute the following commands:

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_hoststatus modify long_output varchar(65535) not null;alter table nagios_hoststatus modify perfdata varchar(65535) not null;" | mysql -pnagiosxi

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

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

 

Note:

  • These are long commands

  • The commands end with -pnagiosxi where nagiosxi is the default password. If you have changed your database password you'll need to change the command to reflect this.

  • If our have offloaded MySQL to another server, these commands need to be executed on the offloaded server.

 

Final Thoughts

For any support related questions please visit the Nagios Support Forums at:

http://support.nagios.com/forum/

5 (1)
Article Rating (1 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - STRICT_TRANS_TABLES
Viewed 749 times since Thu, Nov 16, 2017
XI 5.4 monitoring engine not running
Viewed 1151 times since Mon, Feb 6, 2017
Nagios XI - Apply Configuration Fails - Backend login to the Core Configuration failed
Viewed 1336 times since Tue, Aug 2, 2016
Nagios XI - Modifying The Contents Of /usr/local/nagios/etc
Viewed 587 times since Tue, Jan 26, 2016
Nagios XI - How To Test Check Commands From The Command-line
Viewed 4559 times since Tue, Jan 26, 2016
Nagios XI - CentOS 6 Installation Problems XI 2011R1.7 2011R1.8
Viewed 553 times since Tue, Feb 2, 2016
Nagios XI - MSSQL Query Wizard - Invalid characters in the username
Viewed 597 times since Thu, Aug 3, 2017
Nagios XI - Core 4 Load Spikes on 1.75 and 7 Hour Intervals
Viewed 496 times since Mon, Jan 25, 2016
Nagios XI - Apply Configuration Never Completes
Viewed 1970 times since Tue, Jan 27, 2015
Nagios XI - Configuration Applies, but still get "Configuration File Is Out Of Date" Error
Viewed 445 times since Tue, Jan 26, 2016