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

link zabbix agent windows template failes on autodiscovery end aut-registration

    Details

      Description

      Steps to reproduce:

      1. link windows OS template (zabbix agent) on autodiscovery or registration rule
      2. look in zabbix log for error Z3005

      Result:

      Autoregistration is not completed so host is not created.(if template link is in action)

      autodiscovery does not link the template if there are 'zabbix-agent' triggers in it.

      log file:

      [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 [select t.triggerid,t.templateid from triggers t,functions f,items i where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=10875 and]

      I also testen with latest 3.0 from centos repository. Failes

      Also tested with postgres sql backend.Failes

       

      At this moment there is no way for me to automatic link the Windows OS template (for zabbix agent). Other templates with triggers (like Windows OS SNMP template, or self cerated wmi templates) are no problem.

       

      When all triggers and trigger prototypes are removed, then it is possible to automatic link the template.

       

      The error ends wiht a 'and' without an argument. If there is a way to work around this problem I would like to know. A want to automatically link the wondows OS template (zabbix agent version).

       

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                haasje30 Peter Hazelaar
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: