Ad Widget

Collapse

Zabbix 5.2.4 is unable to connect to my MySQL AZURE database.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • thvillegas
    Junior Member
    • Aug 2015
    • 6

    #1

    Zabbix 5.2.4 is unable to connect to my MySQL AZURE database.

    I have an environment in Centos 8.3 and Zabbix 5.2.4 installed. When trying to monitor a mysql BASE in AZURE, I have the following error:

    Cannot connect to ODBC DSN: [SQL_ERROR]: [08001] [0] [[unixODBC] [MySQL] [ODBC 8.0 (w) Driver] Driver does not support server versions under 4.1.1]

    In tests with isql. the Bank connects


    As explained, my environment is a Centos 8.3 and the ODBC Mysql drive is 8.

    If I try to use a previous mysql ODBC drive, Zabbix keeps falling and coming back.

    Version drive mysqlOBDC : mysql-connector-odbc-5.3.14-1.el7.x86_64.rpm

    2557:20210216:183840.082 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x6e]. Crashing ...
    2557:20210216:183840.082 ====== Fatal information: ======
    2557:20210216:183840.082 Program counter: 0x7f834cf1bb3c
    2557:20210216:183840.082 === Registers: ===
    2557:20210216:183840.082 r8 = 1 = 1 = 1
    2557:20210216:183840.082 r9 = 0 = 0 = 0
    2557:20210216:183840.082 r10 = b = 11 = 11
    2557:20210216:183840.082 r11 = 7f834cf1bb2d = 140201908353837 = 140201908353837
    2557:20210216:183840.082 r12 = 5585d4298c10 = 94033278503952 = 94033278503952
    2557:20210216:183840.082 r13 = 0 = 0 = 0
    2557:20210216:183840.082 r14 = 0 = 0 = 0
    2557:20210216:183840.082 r15 = 7f834d0c52ea = 140201910096618 = 140201910096618
    2557:20210216:183840.082 rdi = 5585d4298c10 = 94033278503952 = 94033278503952
    2557:20210216:183840.082 rsi = 2 = 2 = 2
    2557:20210216:183840.082 rbp = 5585d4298c10 = 94033278503952 = 94033278503952
    2557:20210216:183840.082 rbx = 2 = 2 = 2
    2557:20210216:183840.082 rdx = 0 = 0 = 0
    2557:20210216:183840.082 rax = 0 = 0 = 0
    2557:20210216:183840.082 rcx = 0 = 0 = 0
    2557:20210216:183840.082 rsp = 7ffdcd39b3d0 = 140728046564304 = 140728046564304
    2557:20210216:183840.082 rip = 7f834cf1bb3c = 140201908353852 = 140201908353852
    2557:20210216:183840.082 efl = 10206 = 66054 = 66054
    2557:20210216:183840.082 csgsfs = 2b000000000033 = 12103423998558259 = 12103423998558259
    2557:20210216:183840.082 err = 4 = 4 = 4
    2557:20210216:183840.082 trapno = e = 14 = 14
    2557:20210216:183840.082 oldmask = 0 = 0 = 0
    2557:20210216:183840.082 cr2 = 6e = 110 = 110
    2557:20210216:183840.082 === Backtrace: ===
    2557:20210216:183840.083 21: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](zbx_backtrace+0x3f) [0x5585d3b5d192]
    2557:20210216:183840.083 20: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](zbx_log_fatal_info+0x141) [0x5585d3b5d3f0]
    2557:20210216:183840.083 19: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](+0x1dcc1c) [0x5585d3b5dc1c]
    2557:20210216:183840.083 18: /lib64/libpthread.so.0(+0x12b20) [0x7f8364d2fb20]
    2557:20210216:183840.083 17: /usr/lib64/libmyodbc5a.so(get_sql_data_type+0xf) [0x7f834cf1bb3c]
    2557:20210216:183840.083 16: /usr/lib64/libmyodbc5a.so(fix_result_types+0x87) [0x7f834cf1ca41]
    2557:20210216:183840.083 15: /usr/lib64/libmyodbc5a.so(do_query+0x4a9) [0x7f834cf0c9b1]
    2557:20210216:183840.083 14: /usr/lib64/libmyodbc5a.so(my_SQLExecute+0x4c0) [0x7f834cf0e549]
    2557:20210216:183840.083 13: /usr/lib64/libmyodbc5a.so(SQLExecDirect+0x1d) [0x7f834cf207bf]
    2557:20210216:183840.083 12: /lib64/libodbc.so.2(SQLExecDirect+0x1fa) [0x7f8363fe1baa]
    2557:20210216:183840.083 11: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](zbx_odbc_select+0x114) [0x5585d3a2ea77]
    2557:20210216:183840.083 10: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](get_value_db+0x2ba) [0x5585d39edbcb]
    2557:20210216:183840.083 9: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](+0x663dd) [0x5585d39e73dd]
    2557:20210216:183840.083 8: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](zbx_check_items+0xbc) [0x5585d39e9a30]
    2557:20210216:183840.083 7: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](+0x69593) [0x5585d39ea593]
    2557:20210216:183840.083 6: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](poller_thread+0x1dc) [0x5585d39eae0e]
    2557:20210216:183840.083 5: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](zbx_thread_start+0x37) [0x5585d3b6bf2e]
    2557:20210216:183840.083 4: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](MAIN_ZABBIX_ENTRY+0xb7a) [0x5585d39ccba5]
    2557:20210216:183840.083 3: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](daemon_start+0x2ff) [0x5585d3b5cd9e]
    2557:20210216:183840.083 2: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](main+0x2f5) [0x5585d39cbfe0]
    2557:20210216:183840.083 1: /lib64/libc.so.6(__libc_start_main+0xf3) [0x7f83623277b3]
    2557:20210216:183840.083 0: /usr/sbin/zabbix_server: poller #86 [got 0 values in 0.000044 sec, getting values](_start+0x2e) [0x5585d39cb05e]
    2557:20210216:183840.083 === Memory map: ===
    2557:20210216:183840.083 5585d3981000-5585d3cea000 r-xp 00000000 08:02 16872834 /usr/sbin/zabbix_server_mysql
    2557:20210216:183840.083 5585d3ee9000-5585d3f9e000 r--p 00368000 08:02 16872834 /usr/sbin/zabbix_server_mysql
    2557:20210216:183840.083 5585d3f9e000-5585d3fab000 rw-p 0041d000 08:02 16872834 /usr/sbin/zabbix_server_mysql
    2557:20210216:183840.083 5585d3fab000-5585d3fb6000 rw-p 00000000 00:00 0
    2557:20210216:183840.083 5585d40a6000-5585d40c7000 rw-p 00000000 00:00 0 [heap]
    2557:20210216:183840.083 5585d40c7000-5585d40e8000 rw-p 00000000 00:00 0 [heap]
    2557:20210216:183840.083 5585d40e8000-5585d42d5000 rw-p 00000000 00:00 0 [heap]
    2557:20210216:183840.083 7f834c65f000-7f834c664000 r-xp 00000000 08:02 16940216 /usr/lib64/libnss_dns-2.28.so
    2557:20210216:183840.083 7f834c664000-7f834c864000 ---p 00005000 08:02 16940216 /usr/lib64/libnss_dns-2.28.so
    2557:20210216:183840.083 7f834c864000-7f834c865000 r--p 00005000 08:02 16940216 /usr/lib64/libnss_dns-2.28.so
    2557:20210216:183840.083 7f834c865000-7f834c866000 rw-p 00006000 08:02 16940216 /usr/lib64/libnss_dns-2.28.so
    2557:20210216:183840.083 7f834c866000-7f834c9ec000 r-xp 00000000 08:02 16940304 /usr/lib64/libstdc++.so.6.0.25
    2557:20210216:183840.083 7f834c9ec000-7f834cbeb000 ---p 00186000 08:02 16940304 /usr/lib64/libstdc++.so.6.0.25
    2557:20210216:183840.083 7f834cbeb000-7f834cbf7000 r--p 00185000 08:02 16940304 /usr/lib64/libstdc++.so.6.0.25
    2557:20210216:183840.083 7f834cbf7000-7f834cbf8000 rw-p 00191000 08:02 16940304 /usr/lib64/libstdc++.so.6.0.25
    2557:20210216:183840.083 7f834cbf8000-7f834cbfb000 rw-p 00000000 00:00 0
    2557:20210216:183840.083 7f834cbfb000-7f834cc0d000 r-xp 00000000 08:02 17603689 /usr/lib64/libodbcinst.so.2.0.0
    2557:20210216:183840.083 7f834cc0d000-7f834ce0c000 ---p 00012000 08:02 17603689 /usr/lib64/libodbcinst.so.2.0.0
    2557:20210216:183840.083 7f834ce0c000-7f834ce0d000 r--p 00011000 08:02 17603689 /usr/lib64/libodbcinst.so.2.0.0
    2557:20210216:183840.083 7f834ce0d000-7f834ce11000 rw-p 00000000 00:00 0
    2557:20210216:183840.083 7f834ce11000-7f834d427000 r-xp 00000000 08:02 17070440 /usr/lib64/libmyodbc5a.so
    2557:20210216:183840.083 7f834d427000-7f834d626000 ---p 00616000 08:02 17070440 /usr/lib64/libmyodbc5a.so
    2557:20210216:183840.084 7f834d626000-7f834d65b000 r--p 00615000 08:02 17070440 /usr/lib64/libmyodbc5a.so
    2557:20210216:183840.084 7f834d65b000-7f834d6e8000 rw-p 0064a000 08:02 17070440 /usr/lib64/libmyodbc5a.so
    2557:20210216:183840.084 7f834d6e8000-7f834d6f1000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f834d6f1000-7f835a6a6000 r--p 00000000 08:02 34386428 /usr/lib/locale/locale-archive
    2557:20210216:183840.084 7f835a6a6000-7f835aea6000 rw-s 00000000 00:05 20 /SYSV00000000 (deleted)
    2557:20210216:183840.084 7f835aea6000-7f835b6a6000 rw-s 00000000 00:05 18 /SYSV00000000 (deleted)
    2557:20210216:183840.084 7f835b6a6000-7f835baa6000 rw-s 00000000 00:05 17 /SYSV00000000 (deleted)
    2557:20210216:183840.084 7f835baa6000-7f835bea6000 rw-s 00000000 00:05 16 /SYSV00000000 (deleted)
    2557:20210216:183840.084 7f835bea6000-7f835cea6000 rw-s 00000000 00:05 15 /SYSV00000000 (deleted)
    2557:20210216:183840.084 7f835cea6000-7f835ceac000 r-xp 00000000 08:02 16940300 /usr/lib64/libuuid.so.1.3.0
    2557:20210216:183840.084 7f835ceac000-7f835d0ac000 ---p 00006000 08:02 16940300 /usr/lib64/libuuid.so.1.3.0
    2557:20210216:183840.084 7f835d0ac000-7f835d0ad000 r--p 00006000 08:02 16940300 /usr/lib64/libuuid.so.1.3.0
    2557:20210216:183840.084 7f835d0ad000-7f835d0ae000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f835d0ae000-7f835d0fa000 r-xp 00000000 08:02 17045545 /usr/lib64/libblkid.so.1.1.0
    2557:20210216:183840.084 7f835d0fa000-7f835d2fa000 ---p 0004c000 08:02 17045545 /usr/lib64/libblkid.so.1.1.0
    2557:20210216:183840.084 7f835d2fa000-7f835d2ff000 r--p 0004c000 08:02 17045545 /usr/lib64/libblkid.so.1.1.0
    2557:20210216:183840.084 7f835d2ff000-7f835d300000 rw-p 00051000 08:02 17045545 /usr/lib64/libblkid.so.1.1.0
    2557:20210216:183840.084 7f835d300000-7f835d301000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f835d301000-7f835d318000 r-xp 00000000 08:02 17372134 /usr/lib64/libgcc_s-8-20191121.so.1
    2557:20210216:183840.084 7f835d318000-7f835d517000 ---p 00017000 08:02 17372134 /usr/lib64/libgcc_s-8-20191121.so.1
    2557:20210216:183840.084 7f835d517000-7f835d518000 r--p 00016000 08:02 17372134 /usr/lib64/libgcc_s-8-20191121.so.1
    2557:20210216:183840.084 7f835d518000-7f835d519000 rw-p 00017000 08:02 17372134 /usr/lib64/libgcc_s-8-20191121.so.1
    2557:20210216:183840.084 7f835d519000-7f835d56e000 r-xp 00000000 08:02 1940300 /usr/lib64/libuuid.so.1.3.0
    2557:20210216:183840.084 7f835d0ad000-7f835d0ae000 rw-p 00000000 00:00 0
    7093610 /usr/lib64/libmount.so.1.1.0
    2557:20210216:183840.084 7f835d56e000-7f835d76e000 ---p 00055000 08:02 17093610 /usr/lib64/libmount.so.1.1.0
    2557:20210216:183840.084 7f835d76e000-7f835d771000 r--p 00055000 08:02 17093610 /usr/lib64/libmount.so.1.1.0
    2557:20210216:183840.084 7f835d771000-7f835d772000 rw-p 00058000 08:02 17093610 /usr/lib64/libmount.so.1.1.0
    2557:20210216:183840.084 7f835d772000-7f835d773000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f835d773000-7f835d777000 r-xp 00000000 08:02 16940293 /usr/lib64/libcap.so.2.26
    2557:20210216:183840.084 7f835d777000-7f835d977000 ---p 00004000 08:02 16940293 /usr/lib64/libcap.so.2.26
    2557:20210216:183840.084 7f835d977000-7f835d978000 r--p 00004000 08:02 16940293 /usr/lib64/libcap.so.2.26
    2557:20210216:183840.084 7f835d978000-7f835d979000 rw-p 00005000 08:02 16940293 /usr/lib64/libcap.so.2.26
    2557:20210216:183840.084 7f835d979000-7f835da4b000 r-xp 00000000 08:02 17045569 /usr/lib64/libnss_systemd.so.2
    2557:20210216:183840.084 7f835da4b000-7f835dc4a000 ---p 000d2000 08:02 17045569 /usr/lib64/libnss_systemd.so.2
    2557:20210216:183840.084 7f835dc4a000-7f835dc4f000 r--p 000d1000 08:02 17045569 /usr/lib64/libnss_systemd.so.2
    2557:20210216:183840.084 7f835dc4f000-7f835dc50000 rw-p 000d6000 08:02 17045569 /usr/lib64/libnss_systemd.so.2
    2557:20210216:183840.084 7f835dc50000-7f835dc51000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f835dc51000-7f835dc5c000 r-xp 00000000 08:02 16940218 /usr/lib64/libnss_files-2.28.so
    2557:20210216:183840.084 7f835dc5c000-7f835de5b000 ---p 0000b000 08:02 16940218 /usr/lib64/libnss_files-2.28.so
    2557:20210216:183840.084 7f835de5b000-7f835de5c000 r--p 0000a000 08:02 16940218 /usr/lib64/libnss_files-2.28.so
    2557:20210216:183840.084 7f835de5c000-7f835de5d000 rw-p 0000b000 08:02 16940218 /usr/lib64/libnss_files-2.28.so
    2557:20210216:183840.084 7f835de5d000-7f835de63000 rw-p 00000000 00:00 0
    2557:20210216:183840.084 7f835de63000-7f835e96c000 r--s 00000000 08:02 34912623 /var/lib/sss/mc/initgroups
    2557:20210216:183840.084 7f835e96c000-7f835f240000 r--s 00000000 08:02 34918986 /var/lib/sss/mc/passwd
    2557:20210216:183840.084 7f835f240000-7f835f24a000 r-xp 00000000 08:02 17383095 /usr/lib64/libnss_sss.so.2
    2557:20210216:183840.084 7f835f24a000-7f835f449000 ---p 0000a000 08:02 17383095 /usr/lib64/libnss_sss.so.2
    2557:20210216:183840.084 7f835f449000-7f835f44a000 r--p 00009000 08:02 17383095 /usr/lib64/libnss_sss.so.2
    2557:20210216:183840.084 7f835f44a000-7f835f44b000 rw-p 0000a000 08:02 17383095 /usr/lib64/libnss_sss.so.2
    2557:20210216:183840.084 7f835f44b000-7f835f4ce000 r-xp 00000000 08:02 16930507 /usr/lib64/libpcre2-8.so.0.7.1
    2557:20210216:183840.084 7f835f4ce000-7f835f6cd000 ---p 00083000 08:02 16930507 /usr/lib64/libpcre2-8.so.0.7.1
    2557:20210216:183840.084 7f835f6cd000-7f835f6ce000 r--p 00082000 08:02 16930507 /usr/lib64/libpcre2-8.so.0.7.1
    2557:20210216:183840.084 7f835f6ce000-7f835f6cf000 rw-p 00083000 08:02 16930507 /usr/lib64/libpcre2-8.so.0.7.1
    2557:20210216:183840.084 7f835f6cf000-7f835f6f6000 r-xp 00000000 08:02 16940199 /usr/lib64/libselinux.so.1
    2557:20210216:183840.084 7f835f6f6000-7f835f8f5000 ---p 00027000 08:02 16940199 /usr/lib64/libselinux.so.1


    Has anyone ever experienced this ???
  • Hernandes Martins
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Apr 2011
    • 900

    #2
    Hello my friend,

    Try with mariadb-connector-odbc, is better then mysql-connector-odbc(have a issue with mysql-connector-driver/lib/blablablabla)

    Regards
    __

    Att.
    Hernandes Martins - Zabbix Trainer

    Zabbix Brazil Partner - www.luniobr.com

    Zabbix Brazil Community - www.zabbixbrasil.org

    Blog: hernandesmartins.blogspot.com.br

    Skype: hernandss
    Telegram: @MrHernandes

    Español
    Facebook: facebook.com/groups/zabbixlatam
    Telegram: https://t.me/ZabbixEspañol

    Português
    Facebook: facebook.com/groups/zabbixbrasil/
    Telegram: https://t.me/ZabbixBrasil

    Comment

    Working...