-
Patch request
-
Resolution: Fixed
-
Major
-
4.0.4
-
None
-
Sprint 50 (Mar 2019), Sprint 51 (Apr 2019)
-
0.25
Steps to reproduce:
- Vanilla installation of zabbix-server-mysql using zabbix repositories (RHEL 7)
- Install and configure ODBC using Maria ODBC/Connector (tested 2.08, 3.0.8 & 3.1.0 RC versions
- 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
- 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)
