Database monitor remote server

[Itzik Harel]

Hi
I'm new to Zabbix.
Have the latest 2.4.0 intsalled on CentOS 6.5.i386, and I want to Database monitor a remote server (running mysql).
I have /etc/odbc.ini file setup OK, testing with isql works, I am able to connect to remote database via isql or manually with mysql.
For some reason when creating a Database monitor item for that host in Zabbix, I get the next error:

item "server_lab:db.odbc.select[calls1,currentcalls1]" became not supported: Cannot connect to ODBC DSN:[SQL_ERROR]:[HY000][2003][[unixODBC][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'a.b.c.d' (4)]|

Anyone can share some light on this issue?
Went over many google results but no luck...

[Ostry]

Hello,

I have similar problem:

Cannot connect to ODBC DSN:[SQL_ERROR]:[HY000][2003][[unixODBC][MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'a.b.c.d' (4)]|

* CentOS 6.6 (Final)
* Zabbix 2.4 installed by yum according to this: https://www.zabbix.com/documentation..._from_packages

isql DSN is working well, tried some SELECT, working... also with system user zabbix... but in Zabbix frontend I see error message above in item configuration... how could I check if unixODBC support is installed correctly?

Thanks in advance.

Jano

[mark.chan]

i got the same problem too......