menshatov
commented
4 years ago Hi.
Please try to download template again and import it.
Open durbanbr opened 4 years ago
menshatov
commented
4 years ago Hi.
Please try to download template again and import it.
wmorgue
commented
3 years ago Hi @durbanbr You steel need help with this issue?
Hi,
When I try to import the linux template, it displays the following error:
Error in query [INSERT INTO hosts (host,name,description,status,hostid) VALUES ('Template OS Linux Network by Zabbix agent active','Template OS Linux Network by Zabbix agent active','Name: Template OS Linux Network by Zabbix agent active\r\n\r\nDescription: Template for monitoring Linux Network\r\n\r\nHomepage: https://github.com/itmicus/zabbix\r\n\r\nIssues: https://github.com/itmicus/zabbix/issues\r\n\r\nAuthor: itmicus.ru\r\n\r\nVersion: 1.0\r\n\r\nChangelog:\r\nThe format is based on Keep a Changelog\r\n\r\n## [1.0.0] - 2019-09-03\r\n### Added\r\n- Separation of operating system monitoring into major components: cpu, memory, disk, network\r\n- Templates follow Zabbix template guidelines (https://www.zabbix.com/documentation/4.4/manual/appendix/templates/template_guidelines)\r\n- All triggers redesigned, only key triggers left that show real problems\r\n- All macros and regular expressions moved to templates\r\n\r\n### Changed\r\n\r\nFor explanation:\r\n\r\nnetwork: https://www.kernel.org/doc/Documentation/ABI/testing/sysfs-class-net\r\n\r\n# if ethtool installed UserParameter=custom.netif.ethtool[],ethtool $1 2>/dev/null || echo \"N/A\"\r\n#https://www.kernel.org/doc/Documentation/ABI/testing/sysfs-class-net\r\nUserParameter=custom.netif.speed[],cat /sys/class/net/$1/speed 2>/dev/null || echo 0\r\nUserParameter=custom.netif.carrier[],cat /sys/class/net/$1/carrier 2>/dev/null || echo 0\r\nUserParameter=custom.netif.operstate[],cat /sys/class/net/$1/operstate 2>/dev/null || echo -1\r\nUserParameter=custom.netif.name_assign_type[],cat /sys/class/net/$1/name_assign_type 2>/dev/null || echo 0\r\nUserParameter=custom.netif.addr_assign_type[],cat /sys/class/net/$1/addr_assign_type 2>/dev/null || echo 0\r\nUserParameter=custom.netif.address[],cat /sys/class/net/$1/address 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.dev_id[],cat /sys/class/net/$1/dev_id 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.duplex[],cat /sys/class/net/$1/duplex 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.type[],cat /sys/class/net/$1/type 2>/dev/null || echo -1 \r\n\r\n#Apache UserParameter=zapache[*],/etc/zabbix_itmicus/scripts/zapache \$1\r\nmemory based on https://access.redhat.com/solutions/406773 \r\n\r\nUserParameter=ip_conntrack_count,cat /proc/sys/net/ipv4/netfilter/ip_conntrack_count\r\nUserParameter=ip_conntrack_max,cat /proc/sys/net/ipv4/netfilter/ip_conntrack_max\r\n\r\nMonitoring of MD Soft RAID: https://github.com/krom/zabbix_template_md and https://github.com/q1x/zabbix-templates/tree/master/linux-md\r\n\r\ndisks (kernel 2.6+):\r\nwget https://raw.githubusercontent.com/krom/zabbix_template_md/master/userparameter_md.conf\r\nhttps://www.kernel.org/doc/Documentation/iostats.txt\r\n\r\nКоличество операций в секунду (ops)\r\nПропускная способность (throughput)\r\nВремя обработки запроса (latency или правильней svctime)\r\nУтилизация дисковой подсистемы (utilization)\r\n\r\n\r\nCPU:\r\nhttps://habr.com/ru/post/216827/','3','10287')] [Incorrect string value: '\xD0\x9A\xD0\xBE\xD0\xBB...' for column 'description' at row 1]
SQL statement execution has failed "INSERT INTO hosts (host,name,description,status,hostid) VALUES ('Template OS Linux Network by Zabbix agent active','Template OS Linux Network by Zabbix agent active','Name: Template OS Linux Network by Zabbix agent active\r\n\r\nDescription: Template for monitoring Linux Network\r\n\r\nHomepage: https://github.com/itmicus/zabbix\r\n\r\nIssues: https://github.com/itmicus/zabbix/issues\r\n\r\nAuthor: itmicus.ru\r\n\r\nVersion: 1.0\r\n\r\nChangelog:\r\nThe format is based on Keep a Changelog\r\n\r\n## [1.0.0] - 2019-09-03\r\n### Added\r\n- Separation of operating system monitoring into major components: cpu, memory, disk, network\r\n- Templates follow Zabbix template guidelines (https://www.zabbix.com/documentation/4.4/manual/appendix/templates/template_guidelines)\r\n- All triggers redesigned, only key triggers left that show real problems\r\n- All macros and regular expressions moved to templates\r\n\r\n### Changed\r\n\r\nFor explanation:\r\n\r\nnetwork: https://www.kernel.org/doc/Documentation/ABI/testing/sysfs-class-net\r\n\r\n# if ethtool installed UserParameter=custom.netif.ethtool[],ethtool $1 2>/dev/null || echo \"N/A\"\r\n#https://www.kernel.org/doc/Documentation/ABI/testing/sysfs-class-net\r\nUserParameter=custom.netif.speed[],cat /sys/class/net/$1/speed 2>/dev/null || echo 0\r\nUserParameter=custom.netif.carrier[],cat /sys/class/net/$1/carrier 2>/dev/null || echo 0\r\nUserParameter=custom.netif.operstate[],cat /sys/class/net/$1/operstate 2>/dev/null || echo -1\r\nUserParameter=custom.netif.name_assign_type[],cat /sys/class/net/$1/name_assign_type 2>/dev/null || echo 0\r\nUserParameter=custom.netif.addr_assign_type[],cat /sys/class/net/$1/addr_assign_type 2>/dev/null || echo 0\r\nUserParameter=custom.netif.address[],cat /sys/class/net/$1/address 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.dev_id[],cat /sys/class/net/$1/dev_id 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.duplex[],cat /sys/class/net/$1/duplex 2>/dev/null || echo "N/A"\r\nUserParameter=custom.netif.type[],cat /sys/class/net/$1/type 2>/dev/null || echo -1 \r\n\r\n#Apache UserParameter=zapache[*],/etc/zabbix_itmicus/scripts/zapache \$1\r\nmemory based on https://access.redhat.com/solutions/406773 \r\n\r\nUserParameter=ip_conntrack_count,cat /proc/sys/net/ipv4/netfilter/ip_conntrack_count\r\nUserParameter=ip_conntrack_max,cat /proc/sys/net/ipv4/netfilter/ip_conntrack_max\r\n\r\nMonitoring of MD Soft RAID: https://github.com/krom/zabbix_template_md and https://github.com/q1x/zabbix-templates/tree/master/linux-md\r\n\r\ndisks (kernel 2.6+):\r\nwget https://raw.githubusercontent.com/krom/zabbix_template_md/master/userparameter_md.conf\r\nhttps://www.kernel.org/doc/Documentation/iostats.txt\r\n\r\nКоличество операций в секунду (ops)\r\nПропускная способность (throughput)\r\nВремя обработки запроса (latency или правильней svctime)\r\nУтилизация дисковой подсистемы (utilization)\r\n\r\n\r\nCPU:\r\nhttps://habr.com/ru/post/216827/','3','10287')".
How can I fix it? I'm using Zabbix 4.4