Page 1 of 1
Error Check_odbc
Posted: Thu Jan 02, 2020 10:21 am
by becerra.felipe12
Dear Good Day,
I have a check_odbc monitoring which is alerted and I have checked the permissions of the SPQJPRMONI account based on BD_Operaciones and everything is fine.
The error is: CRITICAL: Could not connect to 10.220.6.28:1433 as SPQJPRMONI.
It is a SQL Server 2003.
Please help to solve the problem.
Re: Error Check_odbc
Posted: Thu Jan 02, 2020 2:52 pm
by mbellerue
Hi
@becerra.felipe12, welcome to the forums!
Can you post the full check command that you run against this SQL Server?
Re: Error Check_odbc
Posted: Fri Jan 03, 2020 8:54 am
by becerra.felipe12
Hi,
check_command check_odbc!SPQJPRMONI!xxxxxxx!BD_Operaciones!1000!1000
greetings and thanks!
Re: Error Check_odbc
Posted: Fri Jan 03, 2020 1:13 pm
by mbellerue
Okay, that looks good. Can you show me the command definition for check_odbc?
Re: Error Check_odbc
Posted: Mon Jan 06, 2020 1:46 pm
by becerra.felipe12
sorry
What do you mean by definition?
Re: Error Check_odbc
Posted: Mon Jan 06, 2020 2:10 pm
by lmiltchev
This means how your command is configured (defined). The configurations of commands are usually found in the "/usr/local/nagios/etc/objects/commands.cfg" file in Nagios Core. An "example" configuration of the 'check_ping' command would look something like this:
Code: Select all
# 'check_ping' command definition
define command{
command_name check_ping
command_line $USER1$/check_ping -H $HOSTADDRESS$ -w $ARG1$ -c $ARG2$ -p 5
}
You should have one for the 'check_odbc' command as well. @mbellerue wanted to see that.