-
Incident report
-
Resolution: Unresolved
-
Trivial
-
None
-
6.4.11
-
RHEL 8
Steps to reproduce:
- 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)]
- 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};"] |
