Nagios Support Forum

Posted: **Thu Mar 15, 2018 4:40 am**

Hi all,

i have successfully setup traps for a device. I can easily see these traps with it's full content in the Status information (I recall i had issued a query in the database to set a no character limitation).
However when viewing the View Service History it seems there is a limitation, hence the trap is not shown completely.
Is there also a no limitation that can be set even here?

Attached is an example.

Rgds,

Matthew

Posted: **Thu Mar 15, 2018 10:17 am**

Try updating the nagios_statehistory table in the DB, so that more data could be stored. You can run the following command from the command line:

Code: Select all

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

If you offloaded mysql on other server, this command needs to be executed on the offloaded server.

Important: Do all of the necessary backups, snapshots, etc. prior to executing this command!

After you've increased the limit in the db, try sending a new trap to the Nagios XI server, and check to see if the output is cut off under the State History report.

Let us know if this helped.

Posted: **Tue Mar 20, 2018 11:54 am**

Hi,

Yes it solved the problem!

Thank you
Matthew

Nagios Support Forum

Limitation of characters in View Service history

Limitation of characters in View Service history

Re: Limitation of characters in View Service history

Re: Limitation of characters in View Service history