i tried to attach mssql server on windows 2016 . i m getting the attached screen error when i try to run the mssql.vbs .i try to install driver , but still error not gone , Download Microsoft OLE DB Driver for SQL Server - SQL Server | Microsoft Docs
can some body suggest ?
Hi,
did you check if an other process blocking the connection, or the plugin run more than once?
Cheers,
Christian
yes , even i reboot the machine , but still the same error
The latest plugin has a fix for the OLE driver. You could test that on your MS SQL host:
https://raw.githubusercontent.com/tribe29/checkmk/master/agents/windows/plugins/mssql.vbs
Hi r.sander
Thanks for your reply , this mssql.vbs works fine .
i m curious to know where can i get such a bug fixes if i face in future for this or some other tool ?
also i wanted to know is there any way by which i can write my own script locally on main checkmk server and the same can be then used to monitor different servers instead of deploying on different machine ?
Bugfixes are usually requested via a support contract with the vendor or a partner.
This specific bugfix is already documented and will be released with checkmk 2.0: MSSQL Agent Plugin: Use MSOLEDBSQL if available
Implementing your own plugins and extensions is also possible but currently not very well documented: Guidelines for developing check plug-in
Hi Sander
i just gone through Guidelines for developing check plug-in section ,
but the content are not clear.
can you please share if any example by which we can write small python or shell script and cover some inhouse daemon applications .
You could start with Local Checks: Extending an agent is simple
They are simple scripts on the monitoring host that get called by the agent.
Other examples are available in our github repo: GitHub - HeinleinSupport/check_mk_extensions: check_mk Plugins
HI Sander
thanks for the reply .
i have already tested the document mentioned for Extending an agent is simple
i understand the basic script of
#!/bin/sh
echo “0 myservice - OK: This is my custom output”
but not understood for below , what does the exact use of this ?
metricname=value;warn;crit;min;max
count=73;80;90;0;100
This is the syntax of metrics that the local check outputs. Metrics are returned in the 3rd part as shown in the example:
0 myservice myvalue=73;80;90 My output text which may contain spaces
PS: You do not need to prefix the status output with OK, WARN or CRIT.
Hi Sander
i just check
echo “0 myservice myvalue=73;80;90 My output text which may contain spaces” produce OK
echo “0 myservice myvalue=94;80;90 My output text which may contain spaces” produce OK
its all depended on initial value of 0 1 and 2 , its not auto dedtecting OK WARn or CRIT
if i remove 0 like below , in panel it shows as UNKNOW
echo “myservice myvalue=94;80;90 My output text which may contain spaces” produce OK
Do you really read the part about dynamic status calculation?
Thank you , thats really very helpful
