Support for Nagios products and services
https://support.nagios.com/forum/
Code: Select all
echo "use nagios;alter table nagios_statehistory modify output varchar(65535) not null;alter table nagios_statehistory modify long_output varchar(65535) not null;" | mysql -pnagiosxiAnd if you are a current customer, you should speak with [email protected] and make sure they add your forum username to the Customer group so you get access to that forum. Our SLA applies there, so it only makes sense to post there since you're paying for it!scottwilkerson wrote:This would not need to be changed between upgrades, it would stick.
Other implications could be a slight db performance decrease when searching in these fields. somewhat negligible as you would never find the info searched for if it was truncated...
Yes, 65535 would become the limit for each of these fields.
The default was 255.
I will say, however, there is a bug in the SQL that was posted, and it should read:Or slightly cleanerCode: 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 -pnagiosxiCode: Select all
echo " alter table nagios_servicestatus modify output varchar(65535) not null,modify long_output varchar(65535) not null,modify perfdata varchar(65535) not null; alter table nagios_hoststatus modify output varchar(65535) not null, modify long_output varchar(65535) not null,modify perfdata varchar(65535) not null; alter table nagios_servicechecks modify output varchar(65535) not null,modify long_output varchar(65535) not null,modify perfdata varchar(65535) not null; alter table nagios_hostchecks modify output varchar(65535) not null,modify long_output varchar(65535) not null,modify perfdata varchar(65535) not null; " | mysql -pnagiosxi nagios