Page 1 of 1

NAGIOS DB

Posted: Thu Jun 25, 2020 1:38 am
by manhuser
We are using nagios for host monitoring .We want to increase a table column size .As we are getting truncated response from one of the api of nagios :-


http://nagios-stage.logistics.com/nagio ... h&pretty=1

"check_command":"manh_check_file_ageing!/manh/share/integration/WebMethods/FilePolling/JSON/SC_PurchaseOrder/monitoring,/manh/share/integration/WebMethods/FilePolling/JSON/SC_LocationCount/monitoring,/manh/share/integration/WebMethods/FilePolling/JSON/SC_LocationMask/moni"

after hitting above url we are getting truncated data for check_command ,please let us now which table and column size we need to increase so that we will not get truncated result

Re: NAGIOS DB

Posted: Thu Jun 25, 2020 2:48 pm
by benjaminsmith
Hi @manhuser,

It looks like there is a really long check command, please run the following to SQL command and let me know if the issue is resolved.

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "ALTER TABLE nagios_servicestatus MODIFY check_command TEXT NOT NULL DEFAULT '';"
If the issue persists, please PM your system profile so we can review the logs. Thanks, Benjamin

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.