I use odbc to monitor remote mysql database.I have problem.
This my zabbix_server.log:
4189:20110622:103045.229 End of DCconfig_get_poller_items():1
4189:20110622:103045.229 In substitute_simple_macros (data:'db.odbc.select[mysql]')
4189:20110622:103045.229 In get_value() key:'db.odbc.select[mysql]'
4189:20110622:103045.229 In database monitor: db.odbc.select[mysql]
4189:20110622:103045.229 ODBC connect [mysql] [123456]
4189:20110622:103045.473 ODBC select [show status like 'Aborted_clients';]
4189:20110622:103045.474 selected 0 cols
4189:20110622:103045.474 ODBC fetch
4185:20110622:103045.475 One child process died (PID:4189). Exiting ...
4185:20110622:103047.493 Connect to the database
4185:20110622:103047.493 Query [txnlev:0] [SET CHARACTER SET GB2312]
Why I can't get the query result set??? The selected is 0.
This my zabbix_server.log:
4189:20110622:103045.229 End of DCconfig_get_poller_items():1
4189:20110622:103045.229 In substitute_simple_macros (data:'db.odbc.select[mysql]')
4189:20110622:103045.229 In get_value() key:'db.odbc.select[mysql]'
4189:20110622:103045.229 In database monitor: db.odbc.select[mysql]
4189:20110622:103045.229 ODBC connect [mysql] [123456]
4189:20110622:103045.473 ODBC select [show status like 'Aborted_clients';]
4189:20110622:103045.474 selected 0 cols
4189:20110622:103045.474 ODBC fetch
4185:20110622:103045.475 One child process died (PID:4189). Exiting ...
4185:20110622:103047.493 Connect to the database
4185:20110622:103047.493 Query [txnlev:0] [SET CHARACTER SET GB2312]
Why I can't get the query result set??? The selected is 0.