Wir nutzen Cookies, um Ihnen eine optimale Nutzung dieser Webseite zu ermöglichen. Mehr Informationen finden Sie im Datenschutzhinweis. Wir nehmen an, dass Sie damit einverstanden sind, falls Sie diese Webseite weiter besuchen.

Ihre Cookie-Einstellungen
Ihre Einstellungen wurden aktualisiert.
Damit die Änderungen wirksam werden, löschen Sie bitte Ihre Browser-Cookies und den Cache und laden dann die Seite neu.

Check manual page of check_sql

Checkmk Manual

Auf dieser Seite

Suche im Handbuch

SQL Database Request Check

Distribution: check_mk
License: GPL
Supported Agents: ACTIVE

This is an active check that connects to a database server, sends an SQL statement to that server, and checks for the following result:

The query must return three columns, a number, a text, and optional performance data in the third column. The columns are comma-separated. Performance data must be in the standard format of nagios performance data. If upper and lower levels are given, the number is checked against these levels and the according state is being computed. Otherwise the number ist treated as a Nagios state (0,1,2,3). State, text and the performance data are being returned.

The check works with MySQL, Postgresql, MSSQL and Oracle databases using the python drivers MySQLdb, psycopg2, pymssql and cx_Oracle. For cx_Oracle the Oracle instantclient needs to be installed as well, and the LD_LIBRARY_PATH needs to be modified to point to the libclntsh.so of that package.

The oracle check supports procedure calls. It must return excactly one output variable. The value of the variable must be in the same format as the return value of the sql statement described above.

This check can be configured by WATO.

See the usage page of the check for details about the invocation on the command line.


The name of the active service


No discovery supported.