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
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...
We do not support direct manipulation of the Nagios XI database. As a warning, altering tables that Nagios XI relies on can make your system un-supported in some cases.
Assuming the passwords are the same on the offloaded database, you will need to add the -h argument to your mysql call to include the remote server's hostname.
