NagioXI installation problem

[angurisudhakar]

Thanks for your responce.one more problem.

In Web page GUI NagiosXI displaying status information half.

Explample below:

This notification is sent for trace notifications OptionSbb Options Received hence no need to raise alaram javax.slee.management.trace.sbb 58186 1433771406686 [100] SbbNotification[service=ServiceID[name=Option,vendor=BT,version=4.1],sbb=SbbID[name=Option

How to adjust settings for displaying full text information..?



Thanks,
Sudhakar Anguri.

[lmiltchev]

You may need to increase the column sizes in the database. What is the output of the following commands?

Code: Select all

echo "desc nagios.nagios_hoststatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"

[angurisudhakar]

Please find the below..
root@nms-hp1-12-sm ~]# echo "desc nagios.nagios_hoststatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
| output | varchar(255) | NO | | | |
| long_output | varchar(8192) | NO | | | |
| perfdata | varchar(255) | NO | | | |
[root@nms-hp1-12-sm ~]# echo "desc nagios.nagios_servicestatus" | mysql -t -pnagiosxi | grep "output\|perfdata"
| output | varchar(255) | NO | | | |
| long_output | varchar(8192) | NO | | | |
| perfdata | varchar(255) | NO | | | |
[root@nms-hp1-12-sm ~]#


how to increase, is there any command for that..?
Please let me know.

[lmiltchev]

Backup your Nagios XI instance. If this is a VM, create a snapshot. Run the following commands:

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

Restart mysqld:

Code: Select all

service mysqld restart

Check to see if the issue has been resolved.

[angurisudhakar]

Thanks..for your input i will check nad let you know..

[abrist]

Ok, let us know if this resolved your issue so we can close the thread.

[angurisudhakar]

still we are working with different issue ,so once finished the issue we let know.

[tmcdonald]

Alright, we'll keep this open for a while longer.