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

db.odbc - Access denied for user when using Macros

XMLWordPrintable

      Steps to reproduce:

      1. Create an item with this a macro in Key, like this:
      db.odbc.select[get_status_variables2,,"Driver=MySQL;Database=zabbix;Server=teste.local;UID=svc_zabbix;PWD=\{$MYSQL.PASSWORD}"]

      Error:
      Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][1045][[MySQL][ODBC 8.0(w) Driver]Access denied for user 'svc_zabbix'@'teste.local' (using password: YES)]

      1. I tried to use 'User name' and 'Password', but happened other error
        db.odbc.select[get_status_variables2,,"Driver=MySQL;Database=zabbix;Server=teste.local;"]

                **          Error:

                Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][1045][[MySQL][ODBC 8.0(w) Driver]Access denied for user 'svc_zabbix'@'teste.local' (using password: NO)]

      Expected:
      db.odbc.select[get_status_variables2,,"Driver=MySQL;Database=zabbix;Server=test.local;UID=svc_zabbix;PWD=password"]

      With Oracle I didn't have this problem and I use the same user and password

      db.odbc.select[ora_ses_act,,"Driver=Oracle;DBQ=//\{HOST.CONN}:1521/\{$ORACLE_ODBC_DSN};"]

            pwegrzyn Piotr Wegrzyn
            matheusnunes Matheus Nunes
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: