Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-1050

SQL_LOGIN_TIMEOUT configuration

    XMLWordPrintable

Details

    • Change Request
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.8.8
    • None
    • Frontend (F), Server (S)

    Description

      When the connection between zabbix server and a remote host is a bit slow, database monitor item is not working, because the SQL_LOGIN_TIMEOUT used to connect is fixed in 5 (five) seconds. Shouldn't be useful for the login timeout be some kind of parameter to configure it without recompiliing?

      The change I made to make it work was in ./src/libs/zbxdbhigh/odbc.c the SQL_LOGIN_TIMEOUT (I fixed in 15 and recompile to get it working in my installation).

      SQLSetConnectAttr(pdbh->hdbc, (SQLINTEGER)SQL_LOGIN_TIMEOUT, (SQLPOINTER)15, (SQLINTEGER)0);

      There are also two more odbc parameters, SQL_ATTR_QUERY_TIMEOUT, SQL_ATTR_CONNECTION_TIMEOUT but in my case I didn't need to change them.

      Zabbix forum thred reference
      http://www.zabbix.com/forum/showthread.php?t=24029

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ninguno Ninguno
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: