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

    XMLWordPrintable

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

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

              Dates

                Created:
                Updated:
                Resolved: