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

ODBC key does not use stored credentials (MariaDB ODBC/Connector)

XMLWordPrintable

    • Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
    • 0.25

      Steps to reproduce:

      1. Vanilla installation of zabbix-server-mysql using zabbix repositories (RHEL 7)
      2. Install and configure ODBC using Maria ODBC/Connector (tested 2.08, 3.0.8 & 3.1.0 RC versions
      3. Create an odbc entry for a server
        [myserver]
        Description           = zabbix
        Driver                = MariaDB
        Database              = zabbix
        Server                = 127.0.0.1
        User                  = tests
        Password              = tests
        Port                  = 3306
        
        
      1. Create a database monitor item like this:

      Result:

      It fails with

        5204:20190210:160003.410 In get_value() key:'db.odbc.select[odbc_test,myserver]'
        5204:20190210:160003.410 In get_value_db() key_orig:'db.odbc.select[odbc_test,myserver]' query:'select 1'
        5204:20190210:160003.410 In zbx_odbc_connect() dsn:'poc04.dev.bpm.crk.ot01.net' user:''
      
      

      Looking at ODBC trace:

      [ODBC][6655][1549817973.920999][SQLConnect.c][3700]
              Entry:
                  Connection = 0x557318b46330
                  Server Name = [myserver][length = 26 (SQL_NTS)]
                  User Name = [][length = 0 (SQL_NTS)]
                  Authentication = [][length = 0 (SQL_NTS)]
              UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
      
              DIAG [28000] [ma-3.0.8]Access denied for user 'zabbix'@'localhost' (using password: NO)
      
      

      Expected:
      Successful login (using stored odbc.ini credentials)

        1. image-2019-02-11-08-42-25-700.png
          21 kB
          Jose Deniz
        2. odbc-mariadb.patch
          0.7 kB
          Jose Deniz

            ak Andrejs Kozlovs
            jadeniz Jose Deniz
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: