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

DM : Error in md5() call during checksum of host

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.3
    • Fix Version/s: 1.8.5
    • Component/s: None
    • Labels:
      None
    • Environment:
      1.8.3 from debian sid packages.

      Description

      I install 2 nodes with 1.8.3 zabbix-server-pgsql and frontend.
      I followed http://www.zabbix.com/documentation/1.8/manual/distributed_monitoring to setup DM .
      Master node correctly "see" slave node in the "node list" at top right of web interface.

      I then enable the zabbix agent on the slave node. data are sent and a few seconds after, related events appear on the master node (when I select "slave"), but I can't see the agent in the configuration section, neither their graphs.
      In the zabbix-agent log on slave node, I can see :

      11102:20101022:151408.810 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERREUR: la fonction md5(numeric) n'existe pas
      LINE 1: ...||status||','||md5(macros)||','||md5(agent)||','||md5(time)|...
      ^
      HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments.
      Vous devez ajouter des conversions explicites de type.
      [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 2,'httptest',httptestid,1,md5(name)||','||applicationid||','||lastcheck||','||nextcheck||','||curstate||','||curstep||','||lastfailedstep||','||delay||','||status||','||md5(macros)||','||md5(agent)||','||md5(time)||','||md5(error)||','||authentication||','||md5(http_user)||','||md5(http_password) from httptest where 1=1 and httptestid between 200000000000000 and 299999999999999]

      It seems the md5 is not made on a string but on an integer.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                maxenced Maxence Dunnewind
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: