Ad Widget

Collapse

MySQL ODBC monitoring problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iDen
    Junior Member
    • Oct 2014
    • 4

    #1

    MySQL ODBC monitoring problem

    Related to this bud report: Zabbix 2.2.1 ODBC monitor crash - in "poller".

    Hello,
    I can't setup zabbix item to monitor some mysql data via ODBC.
    It is not getting any data.
    A the same time item for oracle odbc monitoring working just fine.

    Setup:
    CentOS 6.6 x64
    unixODBC 2.2.14
    zabbix 2.4.1
    DB standalone srv: Percona 5.6
    mysql_odbc: latest from mysql.com

    key is:
    db.odbc.select[test_odbc_mysql,zabbix_odbc]
    sqlquery:
    select count(*) from hosts

    isql command working just fine connecting to specified resources and executing queries

    [MysqlDriver]
    Driver = /usr/lib64/libmyodbc5w.so
    SETUP = /usr/lib64/libmyodbc5S.so
    UsageCount = 1

    [zabbix_odbc]
    Description = Zabbix Database
    Driver = MysqlDriver
    Server = 192.168.119.103
    Database = zabbix_dist
    User = zabbix
    Password = zabbix
    Port = 3306
    Last edited by iDen; 31-10-2014, 10:19.
  • serg_b
    Junior Member
    • Nov 2014
    • 1

    #2
    Hello,
    I resolve this problem by rebuilding mysql-connector-odbc-5.2.7-1.el6.src.rpm with unixODBC and libperconaserverclient.

    You can try my version of the mysql connector
    Last edited by serg_b; 05-11-2014, 13:47.

    Comment

    • iDen
      Junior Member
      • Oct 2014
      • 4

      #3
      Originally posted by serg_b
      Hello,
      I resolve this problem by rebuilding mysql-connector-odbc-5.2.7-1.el6.src.rpm with unixODBC and libperconaserverclient.

      You can try my version of the mysql connector
      http://store.faq.net.ua/store/zabbix...el6.x86_64.rpm

      Wow works! Really nice and thanks a lot!
      Can you please PM me?
      I've couple questions regarding compilation.

      Comment

      Working...