Saphana db monitoring

SairamObili · September 27, 2023, 11:23am

i have copied the mkp_sap hana file to usr/lib/check_mk_agent/plugins . will agent pickit up from there? or do i need to use any other configuration here?
CMK version: Checkmk Raw Edition 2.2.0p8
OS version: sles 15 sp3

Error message:

Output of “cmk --debug -vvn hostname”: (If it is a problem with checks or plugins)

r.sander · September 27, 2023, 11:39am

Agent plugins often contain a comment section documenting their use. Here it is:

github.com

Checkmk/checkmk/blob/master/agents/plugins/mk_sap_hana#L18


      
          :
          
          # Disable unused variable error (needed to keep track of version)
          # shellcheck disable=SC2034
          CMK_VERSION="2.3.0b1"
          
          # SAP HANA Plugin for Checkmk Agent on Linux
          # Copyright Gerd Stolz - SVA - 2016
          # (c) 2017 Heinlein Support GmbH, Robert Sander <r.sander@heinlein-support.de>
          
          display_usage() {
              cat <<USAGE
          
          USAGE:
            mk_sap_hana [OPTIONS]
          
          DESCRIPTION:
            Check_MK agent plugin for monitoring SAP HANA databases.
            To make this plugin work you have to configure default credentials
            - USERSTOREKEY or
            - USER and PASSWORD

gstolz · September 27, 2023, 12:26pm

Hi Sairam,

the good guys at checkmk have a KB entry for sap hana: SAP HANA - Checkmk Knowledge Base - Checkmk Knowledge Base

SairamObili · September 27, 2023, 5:12pm

Hi @gstolz ,

i went through the link, tried to run the plugin manually using this command
MK_CONFDIR= /etc/check_mk /usr/lib/check_mk_agent/plugins/mk_sap_hana

and i m getting this error
hdbsql ERROR: * 10: authentication failed SQLSTATE: 28000.

However, the credentials thats been used here are valid and can able to login with those

gstolz · October 2, 2023, 7:37am

Hi @SairamObili,

can you run:

export MK_CONFDIR=/etc/check_mk
(no space after the =)

and then
bash -x /usr/lib/check_mk_agent/plugins/mk_sap_hana
this will show you exactly how the hdbsql command is called and that makes it easier to spot the credential issue.

system · October 1, 2024, 7:37am

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.