简单的话就这么配。然后add
5.17 解决中文名称不能写数据库的问题
1107 2[root@test01 ~]# mysql -uroot -pchampin zabbix 3Reading table information for completion of table and column names 4You can turn off this feature to get a quicker startup with -A 5 6Welcome to the MariaDB monitor. Commands end with ; or \g. 7Your MariaDB connection id is 2757 8Server version: 10.3.12-MariaDB-log MariaDB Server 9 10Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. 11 12Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 13 14MariaDB [zabbix]> show create table triggers\G 15*************************** 1. row *************************** 16 Table: triggers 17Create Table: CREATE TABLE `triggers` ( 18 `triggerid` bigint(20) unsigned NOT NULL, 19 `expression` varchar(2048) NOT NULL DEFAULT '', 20 `description` varchar(255) NOT NULL DEFAULT '', 21 `url` varchar(255) NOT NULL DEFAULT '', 22 `status` int(11) NOT NULL DEFAULT 0, 23 `value` int(11) NOT NULL DEFAULT 0, 24 `priority` int(11) NOT NULL DEFAULT 0, 25 `lastchange` int(11) NOT NULL DEFAULT 0, 26 `comments` text NOT NULL, 27 `error` varchar(2048) NOT NULL DEFAULT '', 28 `templateid` bigint(20) unsigned DEFAULT NULL, 29 `type` int(11) NOT NULL DEFAULT 0, 30 `state` int(11) NOT NULL DEFAULT 0, 31 `flags` int(11) NOT NULL DEFAULT 0, 32 `recovery_mode` int(11) NOT NULL DEFAULT 0, 33 `recovery_expression` varchar(2048) NOT NULL DEFAULT '', 34 `correlation_mode` int(11) NOT NULL DEFAULT 0, 35 `correlation_tag` varchar(255) NOT NULL DEFAULT '', 36 `manual_close` int(11) NOT NULL DEFAULT 0, 37 PRIMARY KEY (`triggerid`), 38 KEY `triggers_1` (`status`), 39 KEY `triggers_2` (`value`,`lastchange`), 40 KEY `triggers_3` (`templateid`), 41 CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE 42) ENGINE=InnoDB DEFAULT CHARSET=latin1 431 row in set (0.002 sec) 44 45MariaDB [zabbix]> 46 47MariaDB [zabbix]> show variables like 'character%'; 48+--------------------------+----------------------------------+ 49| Variable_name | Value | 50+--------------------------+----------------------------------+ 51| character_set_client | utf8 | 52| character_set_connection | utf8 | 53| character_set_database | latin1 | 54| character_set_filesystem | binary | 55| character_set_results | utf8 | 56| character_set_server | latin1 | 57| character_set_system | utf8 | 58| character_sets_dir | /usr/local/mysql/share/charsets/ | 59+--------------------------+----------------------------------+ 608 rows in set (0.002 sec) 61 62要设定这一行参数 63| character_set_database | latin1 改成utf8 64 65MariaDB [zabbix]> quit 66Bye 67 68用这条命令导出 69[root@test01 ~]# mysqldump -uroot -pchampin --default-character-set=utf8 zabbix > zabbix.sql 70 71[root@test01 ~]# vim !$ 72vim zabbix.sql 73 74在vim普通模式下查找替换,latin1替换成utf8 75 76:1,$s/latin1/utf8/g 77 78导入“其实这也是mysql的备份和恢复” 79[root@test01 ~]# mysql -uroot -pchampin --default-character-set=utf8 zabbix < zabbix.sql 80[root@test01 ~]# 81 82[root@test01 ~]# mysql -uroot -pchampin zabbix 83Reading table information for completion of table and column names 84You can turn off this feature to get a quicker startup with -A 85 86Welcome to the MariaDB monitor. Commands end with ; or \g. 87Your MariaDB connection id is 2830 88Server version: 10.3.12-MariaDB-log MariaDB Server 89 90Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. 91 92Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 93 94MariaDB [zabbix]> show create table items\G 95*************************** 1. row *************************** 96 Table: items 97Create Table: CREATE TABLE `items` ( 98 `itemid` bigint(20) unsigned NOT NULL, 99 `type` int(11) NOT NULL DEFAULT 0, 100 `snmp_community` varchar(64) NOT NULL DEFAULT '', 101 `snmp_oid` varchar(512) NOT NULL DEFAULT '', 102 `hostid` bigint(20) unsigned NOT NULL, 103 `name` varchar(255) NOT NULL DEFAULT '', 104 `key_` varchar(255) NOT NULL DEFAULT '', 105 `delay` varchar(1024) NOT NULL DEFAULT '0', 106 `history` varchar(255) NOT NULL DEFAULT '90d', 107 `trends` varchar(255) NOT NULL DEFAULT '365d', 108 `status` int(11) NOT NULL DEFAULT 0, 109 `value_type` int(11) NOT NULL DEFAULT 0, 110 `trapper_hosts` varchar(255) NOT NULL DEFAULT '', 111 `units` varchar(255) NOT NULL DEFAULT '', 112 `snmpv3_securityname` varchar(64) NOT NULL DEFAULT '', 113 `snmpv3_securitylevel` int(11) NOT NULL DEFAULT 0, 114 `snmpv3_authpassphrase` varchar(64) NOT NULL DEFAULT '', 115 `snmpv3_privpassphrase` varchar(64) NOT NULL DEFAULT '', 116 `formula` varchar(255) NOT NULL DEFAULT '', 117 `error` varchar(2048) NOT NULL DEFAULT '', 118 `lastlogsize` bigint(20) unsigned NOT NULL DEFAULT 0, 119 `logtimefmt` varchar(64) NOT NULL DEFAULT '', 120 `templateid` bigint(20) unsigned DEFAULT NULL, 121 `valuemapid` bigint(20) unsigned DEFAULT NULL, 122 `params` text NOT NULL, 123 `ipmi_sensor` varchar(128) NOT NULL DEFAULT '', 124 `authtype` int(11) NOT NULL DEFAULT 0, 125 `username` varchar(64) NOT NULL DEFAULT '', 126 `password` varchar(64) NOT NULL DEFAULT '', 127 `publickey` varchar(64) NOT NULL DEFAULT '', 128 `privatekey` varchar(64) NOT NULL DEFAULT '', 129 `mtime` int(11) NOT NULL DEFAULT 0, 130 `flags` int(11) NOT NULL DEFAULT 0, 131 `interfaceid` bigint(20) unsigned DEFAULT NULL, 132 `port` varchar(64) NOT NULL DEFAULT '', 133 `description` text NOT NULL, 134 `inventory_link` int(11) NOT NULL DEFAULT 0, 135 `lifetime` varchar(255) NOT NULL DEFAULT '30d', 136 `snmpv3_authprotocol` int(11) NOT NULL DEFAULT 0, 137 `snmpv3_privprotocol` int(11) NOT NULL DEFAULT 0, 138 `state` int(11) NOT NULL DEFAULT 0, 139 `snmpv3_contextname` varchar(255) NOT NULL DEFAULT '', 140 `evaltype` int(11) NOT NULL DEFAULT 0, 141 `jmx_endpoint` varchar(255) NOT NULL DEFAULT '', 142 `master_itemid` bigint(20) unsigned DEFAULT NULL, 143 `timeout` varchar(255) NOT NULL DEFAULT '3s', 144 `url` varchar(2048) NOT NULL DEFAULT '', 145 `query_fields` varchar(2048) NOT NULL DEFAULT '', 146 `posts` text NOT NULL, 147 `status_codes` varchar(255) NOT NULL DEFAULT '200', 148 `follow_redirects` int(11) NOT NULL DEFAULT 1, 149 `post_type` int(11) NOT NULL DEFAULT 0, 150 `http_proxy` varchar(255) NOT NULL DEFAULT '', 151 `headers` text NOT NULL, 152 `retrieve_mode` int(11) NOT NULL DEFAULT 0, 153 `request_method` int(11) NOT NULL DEFAULT 0, 154 `output_format` int(11) NOT NULL DEFAULT 0, 155 `ssl_cert_file` varchar(255) NOT NULL DEFAULT '', 156 `ssl_key_file` varchar(255) NOT NULL DEFAULT '', 157 `ssl_key_password` varchar(64) NOT NULL DEFAULT '', 158 `verify_peer` int(11) NOT NULL DEFAULT 0, 159 `verify_host` int(11) NOT NULL DEFAULT 0, 160 `allow_traps` int(11) NOT NULL DEFAULT 0, 161 PRIMARY KEY (`itemid`), 162 UNIQUE KEY `items_1` (`hostid`,`key_`), 163 KEY `items_3` (`status`), 164 KEY `items_4` (`templateid`), 165 KEY `items_5` (`valuemapid`), 166 KEY `items_6` (`interfaceid`), 167 KEY `items_7` (`master_itemid`), 168 CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, 169 CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE, 170 CONSTRAINT `c_items_3` FOREIGN KEY (`valuemapid`) REFERENCES `valuemaps` (`valuemapid`), 171 CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`), 172 CONSTRAINT `c_items_5` FOREIGN KEY (`master_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE 173) ENGINE=InnoDB DEFAULT CHARSET=utf8 变成了utf8 1741 row in set (0.001 sec) 175 176MariaDB [zabbix]> 177 178MariaDB [zabbix]> show create table triggers\G 179*************************** 1. row *************************** 180 Table: triggers 181Create Table: CREATE TABLE `triggers` ( 182 `triggerid` bigint(20) unsigned NOT NULL, 183 `expression` varchar(2048) NOT NULL DEFAULT '', 184 `description` varchar(255) NOT NULL DEFAULT '', 185 `url` varchar(255) NOT NULL DEFAULT '', 186 `status` int(11) NOT NULL DEFAULT 0, 187 `value` int(11) NOT NULL DEFAULT 0, 188 `priority` int(11) NOT NULL DEFAULT 0, 189 `lastchange` int(11) NOT NULL DEFAULT 0, 190 `comments` text NOT NULL, 191 `error` varchar(2048) NOT NULL DEFAULT '', 192 `templateid` bigint(20) unsigned DEFAULT NULL, 193 `type` int(11) NOT NULL DEFAULT 0, 194 `state` int(11) NOT NULL DEFAULT 0, 195 `flags` int(11) NOT NULL DEFAULT 0, 196 `recovery_mode` int(11) NOT NULL DEFAULT 0, 197 `recovery_expression` varchar(2048) NOT NULL DEFAULT '', 198 `correlation_mode` int(11) NOT NULL DEFAULT 0, 199 `correlation_tag` varchar(255) NOT NULL DEFAULT '', 200 `manual_close` int(11) NOT NULL DEFAULT 0, 201 PRIMARY KEY (`triggerid`), 202 KEY `triggers_1` (`status`), 203 KEY `triggers_2` (`value`,`lastchange`), 204 KEY `triggers_3` (`templateid`), 205 CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE 206) ENGINE=InnoDB DEFAULT CHARSET=utf8 变成了utf8 2071 row in set (0.000 sec) 208 209
现在我们再来试试中文 update
包括很多地方都可以改成中文，
5.18 解决图形中文乱码
但还有个问题就是图形中如果存在中文的话，还是会显示乱码，因为没有支持中文文字的字体，这个问题就要处理一下字体，把windows的字体搞过来，
在windows下找到宋体字体。最简单的方法是用rz命令上传到linux系统里
1通过配置文件找到字体以及所在的路径 2[root@test01 zabbix]# vim include/defines.inc.php 3 4字体上传到linux进来后 5[root@test01 zabbix]# mv simsun.ttc fonts/ 6[root@test01 zabbix]# cd fonts/ 7[root@test01 fonts]# ls 8graphfont.ttf simsun.ttc 9[root@test01 fonts]# mv graphfont.ttf graphfont.ttf.bak; ln ./simsun.ttc graphfont.ttf 10[root@test01 fonts]# ls 11graphfont.ttf graphfont.ttf.bak simsun.ttc 12[root@test01 fonts]# rm -f graphfont.ttf 13[root@test01 fonts]# ls 14graphfont.ttf.bak simsun.ttc 15[root@test01 fonts]# ln -s ./simsun.ttc graphfont.ttf 16[root@test01 fonts]# ls 17graphfont.ttf graphfont.ttf.bak simsun.ttc 18[root@test01 fonts]# ls -l 19总用量 17788 20lrwxrwxrwx. 1 root root 12 4月 15 13:30 graphfont.ttf -> ./simsun.ttc 21lrwxrwxrwx. 1 root root 33 3月 21 13:36 graphfont.ttf.bak -> /etc/alternatives/zabbix-web-font 22-rw-r--r--. 1 root root 18214472 9月 15 2018 simsun.ttc 23[root@test01 fonts]#