connection loss of Nagios XI with mysql

[ednaldojta]

Below is the output of the commands.

[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.

[ednaldojta]

This causes some "collateral effect" in my bank?

[rkennedy]

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?

[ednaldojta]

If I perform this procedure, there was an effect that can ocosionar service interruption?

[rkennedy]

Nope, it will just expand the parameters in SQL. No service interruption.

[ednaldojta]

Is there any root default password in mysql, and standard User?

[scottwilkerson]

Is there any root default password in mysql, and standard User?

On a default Nagios XI system:
User: root
Pass: nagiosxi

[ednaldojta]

Performed procedures, is now wait if the problem will occur!
: D

[rkennedy]

Sounds good - let us know how it goes!