Werk #10671: mk_oracle: Support for Custom SQL with Remote Monitoring
| Component | Checks & agents | ||
| Title | mk_oracle: Support for Custom SQL with Remote Monitoring | ||
| Date | Jan 8, 2020 | ||
| Level | Trivial Change | ||
| Class | New Feature | ||
| Compatibility | Compatible - no manual interaction needed | ||
| Checkmk versions & editions |
|
The new feauture Custom SQL could be used with Remote Monitoring as well. Be aware that the configuration of Custom SQL and Remote Monitoring is not easy...
The SQLS_ITEM_SID is mandatory in this configuration. Otherwise the value from SQLS_SIDS is used in the service name during Discovery.
The following example shows only the needed parameter for a configuration. This is not complete for a whole mk_oracle.cfg!
Example mk_oracle.cfg:
REMOTE_INSTANCE_1_db1=c##cmk:cmkpass::dbhost:1524:piggybackhost:db191:19
SQLS_SECTIONS="invalid_objects"
SQLS_DIR=/etc/check_mk
SQLS_MAX_CACHE_AGE=10
invalid_objects () {
SQLS_SIDS=REMOTE_INSTANCE_1_db1
SQLS_ITEM_SID=db191
SQLS_SQL=invalid_objects.sql
}