Increase NRPE Buffer Size
Posted: Thu Dec 15, 2016 11:51 am
nagiosXI 5.3.2
Centos 7.2
I use the following commands to increase the nrpe buffer size-
However, I am now operating on a nagiosxi instance that stores the database on a seperate server- and when I try those commands I get 'Access Denied' even while using the root account.
I have a login to MariaDB but obviously the syntax of those commands above need to be changed...
Can you guys help?
Centos 7.2
I use the following commands to increase the nrpe buffer size-
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
I have a login to MariaDB but obviously the syntax of those commands above need to be changed...
Can you guys help?