Related to this bud report: Zabbix 2.2.1 ODBC monitor crash - in "poller".
Hello,
I can't setup zabbix item to monitor some mysql data via ODBC.
It is not getting any data.
A the same time item for oracle odbc monitoring working just fine.
Setup:
CentOS 6.6 x64
unixODBC 2.2.14
zabbix 2.4.1
DB standalone srv: Percona 5.6
mysql_odbc: latest from mysql.com
key is:
db.odbc.select[test_odbc_mysql,zabbix_odbc]
sqlquery:
select count(*) from hosts
isql command working just fine connecting to specified resources and executing queries
[MysqlDriver]
Driver = /usr/lib64/libmyodbc5w.so
SETUP = /usr/lib64/libmyodbc5S.so
UsageCount = 1
[zabbix_odbc]
Description = Zabbix Database
Driver = MysqlDriver
Server = 192.168.119.103
Database = zabbix_dist
User = zabbix
Password = zabbix
Port = 3306
Hello,
I can't setup zabbix item to monitor some mysql data via ODBC.
It is not getting any data.
A the same time item for oracle odbc monitoring working just fine.
Setup:
CentOS 6.6 x64
unixODBC 2.2.14
zabbix 2.4.1
DB standalone srv: Percona 5.6
mysql_odbc: latest from mysql.com
key is:
db.odbc.select[test_odbc_mysql,zabbix_odbc]
sqlquery:
select count(*) from hosts
isql command working just fine connecting to specified resources and executing queries
[MysqlDriver]
Driver = /usr/lib64/libmyodbc5w.so
SETUP = /usr/lib64/libmyodbc5S.so
UsageCount = 1
[zabbix_odbc]
Description = Zabbix Database
Driver = MysqlDriver
Server = 192.168.119.103
Database = zabbix_dist
User = zabbix
Password = zabbix
Port = 3306
Comment