I got the error "OID [1.3.6.1.2.1.2.2.1.2.50] value #2 has unknow type [81]" in my server.log, so i tried to find out which item the OID belogs to.
- I clicked to [configuration] -> [items] -> [external filter]
- I put the name of my snmp template into field "from Host like"
- I set "with Type" to: "SNMPv1 agent"
- I set "with SNMP OID like" to: "1.3.6.1.2.1.2.2.1.14"
after clicking on [search], i got this error:
That error comes up no matter if i put the OID string in double or single quotes ( " / ' )
- I clicked to [configuration] -> [items] -> [external filter]
- I put the name of my snmp template into field "from Host like"
- I set "with Type" to: "SNMPv1 agent"
- I set "with SNMP OID like" to: "1.3.6.1.2.1.2.2.1.14"
after clicking on [search], i got this error:
Code:
* Error in query [select distinct th.host as template_host,th.hostid as template_hostid, h.host, i.* from hosts h,items i left join items ti on i.templateid=ti.itemid left join hosts th on ti.hostid=th.hostid where i.hostid=h.hostid and h.hostid in (10100,10063,10094,10029,10064,10065,10062,10067,10073,10088,10060,10061,10030,10106,10058,10043,10075,10044,10045,10017,10046,10047,10048,10090,10101,10049,10050,10033,10066,10051,10032,10095,10093,10038,10036,10086,10037,10035,10039,10040,10074,10041,10080,10078,10091,10089,10096,10052,10097,10053,10098,10054,10055,10056,10087,10069,10057,10076,10012,10020,10003,10023,10018,10022,10019,10024,10008,10013,10021,10099,10014,10011,10009,10016,10007,10015,10004,10010,10002,10072,10042,10034,10079,10084,10001,10031,10059,10085,10077,10082,10083,10070,10071,10102,10104,10103,10068,10105,10092) and h.host like '%tmpl_dell%' and i.type=1 and i.with_snmp_oid like '%1.3.6.1.2.1.2.2.1.14%' order by h.host,i.description,i.key_,i.itemid] [Unknown column 'i.with_snmp_oid' in 'where clause']
* mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix-v144-patched/include/db.inc.php:411]

