Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-27107

MyODBC needs at least version: 40100

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • 6.0.42
    • Appliance (L)

      Steps to reproduce:

      1. Deploy zabbix-agent 5.2
      2. Install ODBC client unixODBC 2.3.11 in Zabbix Server
      3. Configure driver mysql
      4. Apply template in host, but don´t work

      Result:

      when trying to connect to the mysql database via the web interface, it returns an error.

      • Cannot connect to ODBC DSN: [SQL_ERROR]:[IM005][0][[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed]|[HY000][517][[unixODBC][MySQL][ODBC 9.0(a) Driver]Wrong libmysqlclient library version: 30317. MyODBC needs at least version: 40100]

      it connects from the server console without any problems

       odbcinst -j
      unixODBC 2.3.11
      DRIVERS............: /etc/odbcinst.ini
      SYSTEM DATA SOURCES: /etc/odbc.ini
      FILE DATA SOURCES..: /etc/ODBCDataSources
      USER DATA SOURCES..: /root/.odbc.ini
      SQLULEN Size.......: 8
      SQLLEN Size........: 8
      SQLSETPOSIROW Size.: 8

      isql -v test
      ---------------------------------------

      Connected!                            
                                           
      sql-statement                        
      help [tablename]                      
      echo [string]                        
      quit                                  
                                           

      ---------------------------------------
      SQL>

       

      The MSSQL Server it´s in a windows Server, 

      Please, What can I do to resolver this problem?

      Thanks.

        1. zabbix_1.jpg
          zabbix_1.jpg
          47 kB
        2. zabbix_2.jpg
          zabbix_2.jpg
          32 kB

            Unassigned Unassigned
            datsen Denis Tyaglo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: