Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-16223

Database monitoring with odbc and Oracle driver crashes

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 4.0.7
    • Server (S)
    • Ubuntu 18.04
      Zabbix Server 4.0.7
      UnixODBC 2.3.4-1.1ubuntu3
      oracle-instantclient-odbc-10.2.0.5-1.x86_64

      I have installed Zabbix server with "--unix-odbc" option.

      I have installed the client for Oracle 10.2 databases with odbc, basic and sqlplus from https://www.oracle.com/technetwork/database/enterprise-edition/downloads/linuxx86-64soft-092277.html

      I have configured the enviroment variables on /etc/environment and systemd zabbix service (see zabbix-server.service).

      The file /etc/odbcinst.ini has the path to Oracle's driver (see odbcinst.ini).

      With Zabbix user, if i execute "isql" it connects to database:

      But on Zabbix, item of type "Database monitoring" with odbc does not work.

      Everytime it's checked Zabbix shows a backtrace on the log (see zabbix_server.log). Zabbix server process does not stops after crash, it keeps running normally.

       

        1. image-2019-06-06-15-45-16-992.png
          image-2019-06-06-15-45-16-992.png
          5 kB
        2. image-2019-06-06-15-52-52-308.png
          image-2019-06-06-15-52-52-308.png
          3 kB
        3. image-2019-06-06-18-12-49-953.png
          image-2019-06-06-18-12-49-953.png
          1 kB
        4. image-2019-06-06-18-34-24-765.png
          image-2019-06-06-18-34-24-765.png
          1 kB
        5. LD_log_isql.tar.gz
          68 kB
        6. LD_log_proxy.tar.gz
          65 kB
        7. libodbc.so.2.0.0.gz
          169 kB
        8. libpthread-2.27.so.gz
          54 kB
        9. libsqora.so.10.1.gz
          286 kB
        10. odbc.ini
          0.6 kB
        11. odbcinst.ini
          0.2 kB
        12. zabbix_proxy.gz
          1.53 MB
        13. zabbix_server.gz
          2.26 MB
        14. zabbix_server.log
          58 kB
        15. zabbix-server.service
          0.6 kB

            vladislavs.boborikins Vladislavs Boborikins (Inactive)
            rblancop Roger
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: