Issue 1:
Cannot connect to the database.
Unsupported charset or collation for tables: acknowledges, actions, alerts, application_discovery, application_prototype, applications, auditlog, auditlog_details, autoreg_host, conditions, config, config_autoreg_tls, corr_condition_tag, corr_condition_tagpair, corr_condition_tagvalue, correlation, dashboard, dchecks, drules, dservices, event_tag, events, expressions, functions, globalmacro, graph_theme, graphs, graphs_items, group_discovery, group_prototype, history_log, history_str, history_text, host_discovery, host_inventory, host_tag, hostmacro, hosts, housekeeper, hstgrp, httpstep, httpstep_field, httptest, httptest_field, icon_map, icon_mapping, ids, images, interface, item_condition, item_discovery, item_preproc, item_rtdata, items, lld_macro_path, maintenance_tag, maintenances, mappings, media, media_type, media_type_param, opcommand, opconditions, operations, opmessage, problem, problem_tag, profiles, proxy_autoreg_host, proxy_dhistory, proxy_history, regexps, screens, screens_items, scripts, services, services_times, sessions, slides, slideshows, sysmap_element_url, sysmap_shape, sysmap_url, sysmaps, sysmaps_elements, sysmaps_link_triggers, sysmaps_links, tag_filter, task_remote_command, task_remote_command_result, trigger_tag, triggers, users, usrgrp, valuemaps, widget, widget_field.
Issue 2:
zabbix proxy报错：
31668:20200726:193900.091 failed to update local proxy configuration copy: database error
31668:20200726:194000.115 received configuration data from server at "****", datalen 34298
31668:20200726:194000.117 [Z3005] query failed: [1366] Incorrect string value: 'xE5xA4xA7xE5x8CxBA...' for column 'name' at row 5 [insert into hosts (hostid,host,status,available,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,ipmi_available,snmp_available,jmx_available,name,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk,description) values (10001,'template-os-linux',3,0,0,2,'','',0,0,0,'template-os-linux',1,1,'','','','',''),(10050,'template*****',3,0,0,2,'','',0,0,0,'template*****',1,1,'','','','',''),(10073,'template-******',3,0,0,2,'','',0,0,0,'template-mysql',1,1,'','','','',''),(10106,'Template***',3,0,0,2,'','',0,0,0,'Template******',1,1,'','','','',''),(14053,'10.116.207.249',0,0,-1,2,'','',0,0,0,'8大区备机_10.116.207.249',1,1,'','','','','');
]
Resolve:
删了数据库重新创建数据库:
create database zabbix character set utf8 collate utf8_bin;
将zabbix提供的数据库 也修改掉
cd /data/tools/init/zabbix/zabbix-4.0.19/database/mysql
sed -i "s/CHARSET=utf8/CHARSET=utf8 COLLATE=utf8_bin/" schema.sql
sed -i "s/CHARSET=utf8/CHARSET=utf8 COLLATE=utf8_bin/" images.sql
sed -i "s/CHARSET=utf8/CHARSET=utf8 COLLATE=utf8_bin/" data.sql
重新导入即可