Page 3 of 4
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 8:56 am
by ednaldojta
Below is the output of the commands.
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 11:32 am
by tgriep
Thanks for the Screen captures. Everything looks good in them.
One thing that could cause this issue is if the check that you are running are returning data that it too large for the MYSQL table.
To fix this, you need to run the following commands on the XI server as root.
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_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
This will increase the size of all of the tables in MYSQL large enough for your checks to run without error.
Try it out and see if that resolves the issue.
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 1:54 pm
by ednaldojta
This causes some "collateral effect" in my bank?
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 2:24 pm
by rkennedy
ednaldojta wrote:This causes some "collateral effect" in my bank?
This will cause the fields to expand in SQL to handle a large output from your checks. Any checks moving forward will see the affect.
What exactly are you asking?
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 2:26 pm
by ednaldojta
If I perform this procedure, there was an effect that can ocosionar service interruption?
Re: connection loss of Nagios XI with mysql
Posted: Mon Mar 21, 2016 2:35 pm
by rkennedy
Nope, it will just expand the parameters in SQL. No service interruption.
Re: connection loss of Nagios XI with mysql
Posted: Tue Mar 22, 2016 6:40 am
by ednaldojta
Is there any root default password in mysql, and standard User?
Re: connection loss of Nagios XI with mysql
Posted: Tue Mar 22, 2016 2:13 pm
by scottwilkerson
ednaldojta wrote:Is there any root default password in mysql, and standard User?
On a default Nagios XI system:
User: root
Pass: nagiosxi
Re: connection loss of Nagios XI with mysql
Posted: Tue Mar 22, 2016 2:36 pm
by ednaldojta
Performed procedures, is now wait if the problem will occur!
: D
Re: connection loss of Nagios XI with mysql
Posted: Tue Mar 22, 2016 2:41 pm
by rkennedy
Sounds good - let us know how it goes!