speculatrix
commented
3 years ago I think part of the problem is that I already have an itemid of 25204, if I amend the "name" value to be something else then I get this error:
ERROR 1062 (23000): Duplicate entry '25204' for key 'PRIMARY'
this is what is at itemid 25204:
mysql> select * from items where itemid=25204;
+--------+------+----------+--------+---------------------------+---------------------------+-------+---------+--------+--------+------------+---------------+-------+---------+------------+------------+------------+--------+-------------+----------+----------+----------+-----------+------------+-------+-------------+---------------------------------------------------------+----------------+----------+----------+--------------+---------------+---------+-----+--------------+-------+--------------+------------------+-----------+------------+---------+---------------+----------------+---------------+---------------+--------------+------------------+-------------+-------------+-------------+----------+------+
| itemid | type | snmp_oid | hostid | name | key_ | delay | history | trends | status | value_type | trapper_hosts | units | formula | logtimefmt | templateid | valuemapid | params | ipmi_sensor | authtype | username | password | publickey | privatekey | flags | interfaceid | description | inventory_link | lifetime | evaltype | jmx_endpoint | master_itemid | timeout | url | query_fields | posts | status_codes | follow_redirects | post_type | http_proxy | headers | retrieve_mode | request_method | output_format | ssl_cert_file | ssl_key_file | ssl_key_password | verify_peer | verify_host | allow_traps | discover | uuid |
+--------+------+----------+--------+---------------------------+---------------------------+-------+---------+--------+--------+------------+---------------+-------+---------+------------+------------+------------+--------+-------------+----------+----------+----------+-----------+------------+-------+-------------+---------------------------------------------------------+----------------+----------+----------+--------------+---------------+---------+-----+--------------+-------+--------------+------------------+-----------+------------+---------+---------------+----------------+---------------+---------------+--------------+------------------+-------------+-------------+-------------+----------+------+
| 25204 | 0 | | 10106 | dmidecode.system.prodname | dmidecode.system.prodname | 8h | 30d | 0 | 0 | 4 | | | | | 25057 | NULL | | | 0 | | | | | 0 | 3 | /usr/sbin/dmidecode -t system and grep for Product Name | 14 | 30d | 0 | | NULL | 3s | | | | 200 | 1 | 0 | | | 0 | 0 | 0 | | | | 0 | 0 | 0 | 0 | |
+--------+------+----------+--------+---------------------------+---------------------------+-------+---------+--------+--------+------------+---------------+-------+---------+------------+------------+------------+--------+-------------+----------+----------+----------+-----------+------------+-------+-------------+---------------------------------------------------------+----------------+----------+----------+--------------+---------------+---------+-----+--------------+-------+--------------+------------------+-----------+------------+---------+---------------+----------------+---------------+---------------+--------------+------------------+-------------+-------------+-------------+----------+------+
1 row in set (0.00 sec)
nikimaxim
I get this error on the zabbix console, I am logged in as admin when I try and import the XML template file into my Zabbix server running 5.4.4 on Ubuntu.