Page 2 of 2
Re: NagioXI installation problem
Posted: Tue Jun 09, 2015 3:15 am
by 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.
Re: NagioXI installation problem
Posted: Tue Jun 09, 2015 10:37 am
by 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"
Re: NagioXI installation problem
Posted: Wed Jun 10, 2015 1:56 am
by 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.
Re: NagioXI installation problem
Posted: Wed Jun 10, 2015 9:56 am
by 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:
Check to see if the issue has been resolved.
Re: NagioXI installation problem
Posted: Thu Jun 11, 2015 3:24 am
by angurisudhakar
Thanks..for your input i will check nad let you know..
Re: NagioXI installation problem
Posted: Thu Jun 11, 2015 10:34 am
by abrist
Ok, let us know if this resolved your issue so we can close the thread.
Re: NagioXI installation problem
Posted: Wed Jun 17, 2015 7:16 am
by angurisudhakar
still we are working with different issue ,so once finished the issue we let know.
Re: NagioXI installation problem
Posted: Wed Jun 17, 2015 9:19 am
by tmcdonald
Alright, we'll keep this open for a while longer.