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

Database monitoring with odbc and Oracle driver crashes

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 4.0.7
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      Ubuntu 18.04
      Zabbix Server 4.0.7
      UnixODBC 2.3.4-1.1ubuntu3
      oracle-instantclient-odbc-10.2.0.5-1.x86_64

      Description

      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.

       

        Attachments

        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

          Issue Links

            Activity

              People

              • Assignee:
                vladislavs.boborikins Vladislavs Boborikins
                Reporter:
                rblancop Roger
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: