Page 1 of 1

Host in check_mssql_sproc

Posted: Tue Feb 18, 2020 6:34 am
by Quim
Hello

We create a new SQL Server and we need to change host (we have some checks to monitoring Store Procedures) in checks.

In this example, Host is DBA6. Where does it define?

define service{
use generic-service
host_name empbrasrv01
service_description OutOfMemory ATS
check_command check_mssql_sproc_empbrasql04!-H DBA6 -d ATS -u sa -P 0ipshahto -p 'Exception_Manager_Monitor_OutOfMemory "empbrasrv01"' -c 1 -w 1
}

Our Nagios version is NagiosĀ® Coreā„¢ 4.4.5

Any help?
Thanks

Re: Host in check_mssql_sproc

Posted: Tue Feb 18, 2020 9:39 am
by Quim
Hi

we find the solution: modifying etc/odbc.ini. In this file you can edit odbc connections. Then you should change, thus is necessary, command and check.

I hope you userful.

thanks

Re: Host in check_mssql_sproc

Posted: Tue Feb 18, 2020 2:44 pm
by benjaminsmith
Hi Quim,

Thanks for posting your solution to the Nagios community.

We'll go ahead and mark this as resolved. Please open another thread if you have any new issues.