Zabbix - Monitoring MySQL using ODBC template, server keep crashing

[mantonik]

Hi

I setup latest version of zabbix server 5.2 2 on Linux Oracle server 8.

I want to monitor MySQL database.
I setup ODBC and configure host using template MySQL ODBC.

I have only
Zabbix Server
MySQLDB

Only two hosts

if MySQL DB host is disabled then Zabbix server is working, soon as I enable MySQL database Zabbix server keep crashing.

With Zabbix 4.x ( I am using this on another server) I set up a proxy server with Postgres to monitor the MySQL database. I read somewhere that the Zabbix server or proxy can't monitor MySQL when they using MYSQL as their own database.
Is this still a valid statement?


Log sample when it start crash

55976:20201210:210139.846 End of am_db_flush_results() flushed:0
55976:20201210:210139.846 zbx_setproctitle() title:'alert syncer [queued 0 alerts(s), flushed 0 result(s) in 0.001836 sec, idle 1 sec]'
55965:20201210:210139.846 End of am_flush_results()
55965:20201210:210139.846 In zbx_ipc_service_recv() timeout:1
55953:20201210:210139.847 Got signal [signal:11(SIGSEGV),reason:128,refaddrnil)]. Crashing ...
55953:20201210:210139.847 ====== Fatal information: ======
55953:20201210:210139.847 Program counter: 0x7fbd1516d64f
55953:20201210:210139.847 === Registers: ===
55953:20201210:210139.847 r8 = 559c5e568a00 = 94130085988864 = 94130085988864
55953:20201210:210139.847 r9 = 7fffb1c42718 = 140736175810328 = 140736175810328
55953:20201210:210139.847 r10 = f = 15 = 15

[mantonik]

I set up a proxy server using zabbix-proxy posgress and used that proxy server to monitor mysql db.
With proxy system is working as expected.

[Hamardaban]

Look at this - it says what your problem is
https://www.zabbix.com/documentation...es#odbc_checks

MySQL unixODBC driver should not be used with Zabbix server or Zabbix proxy compiled against MariaDB connector library and vice versa, if possible it is also better to avoid using the same connector as the driver