I found more MYSQL tables that need to be increased. To increase them, run the following as root.
Code: Select all
echo "use nagios;alter table nagios_services modify display_name varchar(1023) not null;" | mysql -u root -pnagiosxi
echo "use nagios;alter table nagios_hosts modify alias varchar(1023) not null;" | mysql -u root -pnagiosxi
echo "use nagios;alter table nagios_services modify alias varchar(1023) not null;" | mysql -u root -pnagiosxi
echo "use nagios;alter table nagios_commands modify command_line varchar(1023) not null;" | mysql -u root -pnagiosxi
echo "use nagios;alter table nagios_configfilevariables modify varvalue varchar(1023) not null;" | mysql -u root -pnagiosxi
echo "use nagios;alter table nagios_conninfo modify bytes_processed int(12);" | mysql -u root -pnagiosxi
After running the above, lets stop / start these processes.
Code: Select all
service nagios stop
service ndo2db stop
service crond restart
service ndo2db start
service nagios start
Hopefully I did not miss any of the tables but if I did, I would have to get an updated messages file with just today's data.
Another thing I would do is to make sure the configs are in sync with the running config and to to that, follow this procedure.
Go to the Core Config Manager
Under "Tools", click "Write Config Files" or if you are running a newer versions of XI, The menu is called "Config File Management"
Click the click the "Write" button, then the "Delete" button then click the "Write" button and then the "Verify" button
If you get any errors, resolve them and click on the "Delete" button, "Write", "Verify" until all of the errors are resolved.
Click the Apply Configuration link and click the "Apply Configuration" button after all of the errors are resolved.
Let us know if this fixes the issue.