Zabbix Documentation 2.2

2.23.04.0 (current)In development:4.2 (devel)Unsupported:1.82.02.43.23.4

User Tools

Site Tools


manual:config:items:itemtypes:odbc_checks

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:config:items:itemtypes:odbc_checks [2014/12/31 12:32]
dotneft [15.7 Important notes]
manual:config:items:itemtypes:odbc_checks [2018/11/01 06:06] (current)
martins-v sql needn't start with 'select'
Line 110: Line 110:
 === - Important notes === === - Important notes ===
  
-  * The query must not be executing longer than the [[:​manual:​appendix:​config:​zabbix_server|Timeout]] parameter on the serverStarting from Zabbix 2.0.8 the [[:manual:appendix:config:zabbix_server|Timeout]] parameter value is also used as ODBC login timeout (note that depending on ODBC drivers the login timeout setting might be ignored).+  * Zabbix does not limit the query execution time. It is up to the user to choose queries that can be executed in a reasonable amount of time. 
 +  * The [[:manual/appendix/config/zabbix_server|Timeout]] parameter value from Zabbix server ​is used as the ODBC login timeout (note that depending on ODBC drivers the login timeout setting might be ignored).
   * The query must return one value only.   * The query must return one value only.
   * If a query returns more than one column, only the first column is read.   * If a query returns more than one column, only the first column is read.
   * If a query returns more than one line, only the first line is read.    * If a query returns more than one line, only the first line is read. 
-  * The SQL command must begin with ''​select''​. +  * The SQL command must return a result set like any query with ''​select ​...''​. The query syntax will depend on the RDBMS which will process them. The syntax of request to a storage procedure must be started with ''​call''​ keyword. 
-  * The SQL command mustn't contain any line breaks.+  * See also [[:​manual/​installation/​known_issues#​odbc_checks|known issues]] for ODBC checks
 === - Error messages === === - Error messages ===