Zabbix 4.2 Debian 10 ODBC

[Derroy]

Hi Guys!
I've Zabbix-server version: 4.2.6, Debian 10 and I want a monitore data in database (MariaDB Ver 15.1 10.3.17) on remote server, so I used ODBC mysql. This is my configure:

1. I install unixodbc and unixodbc-dev
2. Set 2 file's odbc.ini and odbcinst.ini

odbc.ini

[ODBC Data Sources]
myodbc8w = MyODBC 8.0 UNICODE Driver DSN
myodbc8a = MyODBC 8.0 ANSI Driver DSN

[myodbc8w]
Driver = /usr/local/lib/libmyodbc8w.so
Description = Connector/ODBC 8.0 UNICODE Driver DSN
SERVER = 192.168.59.154
PORT = 3306
USER = ocs
Password = ocs
Database = ocsweb
OPTION = 3
#SOCKET =

#[myodbc8a]
#Driver = /usr/local/lib/libmyodbc8a.so
#Description = Connector/ODBC 8.0 ANSI Driver DSN
#SERVER = localhost
#PORT =
#USER = root
#Password =
#Database = test
#OPTION = 3
#SOCKET =

odbcinst.ini

[MySQL ODBC 8.0 Driver]
Driver=/usr/local/lib/libmyodbc8w.so
UsageCount=1

[MySQL ODBC 8.0]
Driver=/usr/local/lib/libmyodbc8a.so
UsageCount=1

3. I will check my settings using

isql -v myodbc8w ocs ocs

and it's working! I can check all the tables, but when I create item in Zabbix-Server. My Zabbix-Server is no running and I don't know why.

This is item in zabbix, no matter what I write in sql query zabbix-server is going down.




This is log for Zabbix-Server.

 38826:20190930:223509.954 ================================
 38826:20190930:223509.954 Please consider attaching a disassembly listing to your bug report.
 38826:20190930:223509.954 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
 38826:20190930:223509.954 ================================
 38809:20190930:223509.955 One child process died (PID:38826,exitcode/signal:1). Exiting ...
 38809:20190930:223509.955 zbx_on_exit() called
zabbix_server [38809]: Error waiting for process with PID 38826: [10] No child processes
 38809:20190930:223509.958 In DBconnect() flag:1
 38809:20190930:223509.959 End of DBconnect():0
 38809:20190930:223509.959 In free_database_cache()
 38809:20190930:223509.959 In DCsync_all()
 38809:20190930:223509.959 In sync_history_cache_full() history_num:1
 38809:20190930:223509.959 syncing history data...
 38809:20190930:223509.959 In DCmass_prepare_history() history_num:1
 38809:20190930:223509.959 End of DCmass_prepare_history()
 38809:20190930:223509.959 In DBmass_add_history()
 38809:20190930:223509.959 In zbx_history_add_values()
 38809:20190930:223509.959 query [txnlev:1] [begin;]
 38809:20190930:223509.960 query [txnlev:1] [insert into history (itemid,clock,ns,value) values (28629,1569875709,952177033,0.000000);
 38809:20190930:223509.960 query [txnlev:1] [commit;]
 38809:20190930:223509.961 End of zbx_history_add_values()
 38809:20190930:223509.961 End of DBmass_add_history()
 38809:20190930:223509.961 In DCmass_update_trends()
 38809:20190930:223509.961 End of DCmass_update_trends()
 38809:20190930:223509.961 query [txnlev:1] [begin;]
 38809:20190930:223509.961 In DBmass_update_items()
 38809:20190930:223509.961 End of DBmass_update_items()
 38809:20190930:223509.961 In zbx_process_events() events_num:0
 38809:20190930:223509.961 End of zbx_process_events() processed:0
 38809:20190930:223509.961 query [txnlev:1] [commit;]
 38809:20190930:223509.961 In DCupdate_trends()
 38809:20190930:223509.961 End of DCupdate_trends()
 38809:20190930:223509.961 query [txnlev:1] [begin;]
 38809:20190930:223509.961 In recalculate_triggers()
 38809:20190930:223509.961 In zbx_link_triggers_with_functions() trigger_order_num:0
 38809:20190930:223509.961 End of zbx_link_triggers_with_functions() triggers_func_pos_num:0
 38809:20190930:223509.961 In evaluate_expressions() tr_num:0
 38809:20190930:223509.961 In substitute_functions()
 38809:20190930:223509.961 In zbx_extract_functionids() tr_num:0
 38809:20190930:223509.961 End of zbx_extract_functionids() functionids_num:0
 38809:20190930:223509.961 End of substitute_functions()
 38809:20190930:223509.961 End of evaluate_expressions()
 38809:20190930:223509.962 In zbx_process_triggers() values_num:0
 38809:20190930:223509.962 End of zbx_process_triggers()
 38809:20190930:223509.962 End of recalculate_triggers()
 38809:20190930:223509.962 In zbx_process_events() events_num:0
 38809:20190930:223509.962 End of zbx_process_events() processed:0
 38809:20190930:223509.962 query [txnlev:1] [commit;]
 38809:20190930:223509.962 In DBupdate_itservices()
 38809:20190930:223509.962 End of DBupdate_itservices():SUCCEED
 38809:20190930:223509.962 syncing history data... 100.000000%
 38809:20190930:223509.962 syncing history data done
 38809:20190930:223509.962 End of sync_history_cache_full()
 38809:20190930:223509.962 In DCsync_trends() trends_num:0
 38809:20190930:223509.962 syncing trend data...
 38809:20190930:223509.962 query [txnlev:1] [begin;]
 38809:20190930:223509.962 In DBflush_trends() trends_num:28
 38809:20190930:223509.962 query [txnlev:1] [select distinct itemid from trends_uint where clock>=1569873600 and itemid in (23272,23287,28625,28636,28637,28671,28685,28688)]
 38809:20190930:223509.962 query [txnlev:1] [select itemid,num,value_min,value_avg,value_max from trends_uint where clock=1569873600 and itemid in (23272,23287,28625,28636,28637,28671,28685,28688)]
 38809:20190930:223509.962 query [txnlev:1] [update trends_uint set num=35,value_min=0,value_avg=0,value_max=0 where itemid=23272 and clock=1569873600;
update trends_uint set num=36,value_min=1,value_avg=1,value_max=1 where itemid=23287 and clock=1569873600;
 38809:20190930:223509.963 End of DBflush_trends()
 38809:20190930:223509.963 In DBflush_trends() trends_num:20
 38809:20190930:223509.964 End of DBflush_trends()
 38809:20190930:223509.964 query [txnlev:1] [commit;]
 38809:20190930:223509.965 syncing trend data done
 38809:20190930:223509.965 End of DCsync_trends()
 38809:20190930:223509.965 End of DCsync_all()
 38809:20190930:223509.965 End of free_database_cache()
 38809:20190930:223509.965 In free_configuration_cache()
 38809:20190930:223509.965 End of free_configuration_cache()
 38809:20190930:223509.965 In zbx_vc_destroy()
 38809:20190930:223509.965 End of zbx_vc_destroy()
 38809:20190930:223509.965 In free_selfmon_collector() collector:0x7f42ac2c1000
 38809:20190930:223509.965 End of free_selfmon_collector()
 38809:20190930:223509.965 In zbx_unload_modules()
 38809:20190930:223509.965 End of zbx_unload_modules()
 38809:20190930:223509.965 Zabbix Server stopped. Zabbix 4.2.6 (revision d3bb18bbc4).

Guys do you've idea what's going on? Maybe you've a solution.
Rob

[Derroy]

OK, Guys i resolved my problem. I was install DBforBIX and monitor data in my database, if someone want to install DBforBIX please look at this webpage -> https://www.vos.cn/os/329.html