Zabbix Documentation 2.4

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 [2017/10/06 09:15] (current)
martins-v Zabbix does not limit the query execution time
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.
Line 116: Line 117:
   * The SQL command must begin with ''​select''​.   * The SQL command must begin with ''​select''​.
   * The SQL command mustn'​t contain any line breaks.   * 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 129:
             `- 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.