apinar
commented
8 years ago Definitely, it was a Zabbix server issue. Xml import fails on 2.2.0, but it works on 2.4.7
Anyway, I'm facing another issue on 2.4.7. I've noticed that zabbix server cannot discover mqm or queue. It is failing with error:
"Value should be a JSON object"
Edit: Resolved executing discovering scripts manually.
Trying to import the xml template, I got the following errors:
mb_strlen() expects parameter 1 to be string, array given [conf.import.php:130 → CConfigurationImport->import() → CConfigurationImport->processDiscoveryRules() → CAPIObject->create() → CAPIObject->call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CDiscoveryRule->create() → CDiscoveryRule->createReal() → DB::insert() → DB::checkValueTypes() → zbx_strlen() → mb_strlen() in /usr/share/zabbix/include/func.inc.php:932] Array to string conversion [conf.import.php:130 → CConfigurationImport->import() → CConfigurationImport->processDiscoveryRules() → CAPIObject->create() → CAPIObject->call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CDiscoveryRule->create() → CDiscoveryRule->createReal() → DB::insert() → implode() in /usr/share/zabbix/include/classes/db/DB.php:443] Error in query [INSERT INTO items (name,type,snmp_community,snmp_oid,delay,status,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,delay_flex,params,ipmisensor,authtype,username,password,publickey,privatekey,port,filter,lifetime,description,key,trapper_hosts,hostid,flags,value_type,data_type,interfaceid,itemid) VALUES ('Discovery mqm','0','','','600','0','','','0','0','','0','','','','','0','','','','','',Array,'2','','mqm_discvr','','10138','1','4','0',NULL,'37658')] [Unknown column 'Array' in 'field list'] SQL statement execution has failed "INSERT INTO items (name,type,snmp_community,snmp_oid,delay,status,snmpv3_contextname,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authprotocol,snmpv3_authpassphrase,snmpv3_privprotocol,snmpv3_privpassphrase,delay_flex,params,ipmisensor,authtype,username,password,publickey,privatekey,port,filter,lifetime,description,key,trapper_hosts,hostid,flags,value_type,data_type,interfaceid,itemid) VALUES ('Discovery mqm','0','','','600','0','','','0','0','','0','','','','','0','','','','','',Array,'2','','mqm_discvr','','10138','1','4','0',NULL,'37658')".
Which is the minimum Zabbix version for this template?