Zabbix Documentation 3.0

2.23.04.04.2 (current)In development:4.4 (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/09/26 11:27]
sasha Links adapted because of a move operation
manual:config:items:itemtypes:odbc_checks [2018/11/01 06:05] (current)
martins-v sql needn't start with 'select'
Line 1: Line 1:
-==== - #15 ODBC monitoring ====+==== 15 ODBC monitoring ====
  
 === - Overview === === - Overview ===
Line 110: Line 110:
 === - Important notes === === - Important notes ===
  
-  * The query must not be executing longer than the [[:2.0/​manual/​appendix/​config/​zabbix_server|Timeout]] parameter on the serverStarting from Zabbix 2.0.8 the [[:2.0/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 timeIt 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 ===
Line 127: Line 128:
             `- Zabbix message ​ `- ODBC return code             `- Zabbix message ​ `- ODBC return code
 </​code>​ </​code>​
-Note that the error message length is limited to 128 bytes, so the message can be truncated. If there is more than one ODBC diagnostic record Zabbix tries to concatenate them as far as the length limit allows.+Note that the error message length is limited to 2048 bytes, so the message can be truncated. If there is more than one ODBC diagnostic record Zabbix tries to concatenate them as far as the length limit allows.