Ad Widget

Collapse

Database monitoring (unixODBC)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aquadalti
    Junior Member
    • Nov 2011
    • 13

    #1

    Database monitoring (unixODBC)

    Hello,

    I'm trying to monitor through ODBC a MS SQL Server database and I have the following problem.
    I have two servers (Zabbix Server and Zabbix Proxy) and a host with a SQL Server that is monitored by the proxy.
    If I start zabbix_server and zabbix_proxy processes on their machines, and I have enabled a check with any Database Monitor (ODBC) item, the process zabbix_server crashes after a few seconds.

    I found a condition similar to mine (http://www.zabbix.com/forum/showthread.php?t=23664).

    Configuration:
    Zabbix Server + Zabbix Proxy
    Zabbix version: 2.0.0
    Platforms: CentOS 6.2 x86_64
    Zabbix database: MySQL
    ODBC Libraries: unixODBC + FreeTDS

    I have successfully configured the proxy connection and ODBC System DSN, the user Zabbix can successfully make connections to SQL and query the database object (when I perform a "isql-v <DSN>" I establish the connection successfully).
    In the proxy logs I don't see any error.

    My next step is to repeat the test without the proxy but my feeling is that I will get the same problem.

    Any ideas?

    Thanks in advance

    Alberto
  • aquadalti
    Junior Member
    • Nov 2011
    • 13

    #2
    There's a news!

    If I monitor the SQL Server directly from the Zabbix Server all works.
    If I use instead the Zabbix Proxy to monitor the database the process zabbix_server crashes.

    What's wrong???

    Comment

    • nail
      Member
      • Jun 2012
      • 32

      #3
      I've got similar to this error, but instead of crashing server, my zabbix server just puts odbc item in unsupported state.

      Comment

      Working...