Hi
I use zabbix-server 3.4.13-1+bionic and get Autoregistration issue:
When I set rule link to template for autoregistration, I get this error:
31150:20180831:130320.731 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at end of input
LINE 1: ...rid=f.triggerid and f.itemid=i.itemid and i.hostid=10256 and
^
[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=10256 and]
If I remove rule link to tempalte and just auto add new host, I can manual link this host to template without any problem
Looks like zabbix server have bug with sql statement:
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=10256 and
Must be:
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=10256;
I use zabbix-server 3.4.13-1+bionic and get Autoregistration issue:
When I set rule link to template for autoregistration, I get this error:
31150:20180831:130320.731 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: syntax error at end of input
LINE 1: ...rid=f.triggerid and f.itemid=i.itemid and i.hostid=10256 and
^
[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=10256 and]
If I remove rule link to tempalte and just auto add new host, I can manual link this host to template without any problem
Looks like zabbix server have bug with sql statement:
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=10256 and
Must be:
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=10256;
Comment