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

DM-fix for zabbix server with oracle database

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Won't fix
    • Affects Version/s: 2.0.4
    • Fix Version/s: None
    • Component/s: Server (S)
    • Environment:
      Zabbix 2.0.4
      Oracle Database 11g Enterprise Edition (v11.2.0.3.0)
      Linux RedHat 6.2, Kernel 2.6.32, VM

      Description

      For the synchronization between master and child in distributed monitoring two SQL-functions are used (md5 and cast number to char). Unfortunately Oracle has no built-in md5 function and also a cast from number to char is not possible.

      That resulted in the following errors:

      [Z3005] query failed: [-1] ORA-00904: "MD5": invalid identifier [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'maintenances',maintenanceid,1,md5(name)||','||maintenance_type||','||md5(description)||','||active_since||','||active_till from maintenances where 1=1 and maintenanceid between 200000000000000 and 299999999999999]

      [Z3005] query failed: [-1] ORA-25137: Data value out of range [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'screens',screenid,1,md5(name)||','||hsize||','||vsize||','||case when templateid is null then 'NULL' else cast(templateid as char) end from screens where 1=1 and screenid between 200000000000000 and 299999999999999]

      Therefore I created a patch for the Oracle DB as well as the Zabbix server.
      The SQL patch creates a package with two overloaded md5 functions (for varchar and blob). These functions use the dbms_crypto interface from Oracle (information about granting the rights is also in the file).
      The nodesender.c file contains sections especially for Oracle where the md5 function from the SQL patch are used and the cast from number to char is replaced by a cast from number to varchar(25).

      Maybe this patch will be added to Zabbix to one of the next updates.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hagor Harry
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: