Werk #7107: mk_oracle: Support for custom credentials in custom_sqls

Component

Checks & agents

Title

mk_oracle: Support for custom credentials in custom_sqls

Date

Mar 4, 2019

Level

Trivial Change

Class

New Feature

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

1.6.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

Dedicated credentials for each section in custom_sqls could be configured. The following parameters are valid:

my_custom_sql () {
SQLS_DBUSER=customuser
SQLS_DBPASSWORD=secretpwd
SQLS_DBSYSCONNECT=SYSDBA
SQLS_TNSALIAS=testdb123

These are the new parameters. SQLS_DBSYSCONNECT needs be set only if the user is sysdba or sysoper. Otherwise just skip this line.