Zabbix5.0版本Docker-compose.yml

前言

鉴于网络中各个文章讲述的docker方式安装一套zabbix—server端都模糊不清及国内网络连接docker服务器拉取镜像一直无法成功的拉取完整镜像，遂分享自己经过测试和使用无异常的docker-compose文件，旨在让大家可以快速高效的部署一套即开即用的zabbix服务端。

docker-compose配置分享

以下为docker-compose.yml文件，请根据自己的情况更改mysql密码及zabbix管理密码：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
version: "3"
services:
  zabbix-db:
    image: mysql:5.7
    container_name: zabbix-db
    environment:
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zabbix123
      - MYSQL_ROOT_PASSWORD=Zabbix123
    volumes:
      - "${PWD}/mysql:/var/lib/mysql"

  zabbix-server-mysql:
    image: zabbix/zabbix-server-mysql:ubuntu-5.0-latest
    container_name: zabbix-server-mysql
    environment:
      - DB_SERVER_HOST=mysql
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zabbix123
      - MYSQL_ROOT_PASSWORD=Zabbix123
    volumes:
      - "${PWD}/zabbix/alertscripts:/usr/lib/zabbix/alertscripts"
    ports:
      - "10051:10051"
    links:
      - zabbix-db:mysql
    depends_on:
      - zabbix-db

  zabbix-web-nginx-mysql:
    image: zabbix/zabbix-web-nginx-mysql:ubuntu-5.0-latest
    container_name: zabbix-web-nginx-mysql
    environment:
      - DB_SERVER_HOST=mysql
      - MYSQL_DATABASE=zabbix
      - MYSQL_USER=zabbix
      - MYSQL_PASSWORD=zabbix123
      - MYSQL_ROOT_PASSWORD=Zabbix123
      - TZ=Asia/Shanghai
      - PHP_TZ=Asia/Shanghai

    ports:
      - "8082:8080"
    links:
      - zabbix-db:mysql
      - zabbix-server-mysql:zabbix-server
    depends_on:
      - zabbix-server-mysql

networks: 
  default:
    external: 
      name: zabbix

注：个人建议在启动前先docker pull下载对应docker镜像，因为在国内网络环境下有些惊喜无法正常下载
如遇无法下载或无法完整下载的镜像时，可以访问Zabbix Docker imagesZabbix官网镜像地址跳转至docker镜像库中，在tags中选择自己需要的版本并在本地使用docker pull xxx 进行测试是否可以正常下载镜像

分享一个yaml格式检查网站：YAMLlint - The YAML Validator

遇到的问题

Mysql字符集导致zabbix无法插入中文

1. 查看当前数据库支持的字符集

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
mysql> show character set ;  

+----------+---------------------------------+---------------------+--------+  

| Charset  | Description                     | Default collation   | Maxlen |  

+----------+---------------------------------+---------------------+--------+  

| big5     | Big5 Traditional Chinese        | big5_chinese_ci     |      2 |  

| dec8     | DEC West European               | dec8_swedish_ci     |      1 |  

| cp850    | DOS West European               | cp850_general_ci    |      1 |  

| hp8      | HP West European                | hp8_english_ci      |      1 |  

| koi8r    | KOI8-R Relcom Russian           | koi8r_general_ci    |      1 |  

| latin1   | cp1252 West European            | latin1_swedish_ci   |      1 |  

| latin2   | ISO 8859-2 Central European     | latin2_general_ci   |      1 |  

| swe7     | 7bit Swedish                    | swe7_swedish_ci     |      1 |  

| ascii    | US ASCII                        | ascii_general_ci    |      1 |  

| ujis     | EUC-JP Japanese                 | ujis_japanese_ci    |      3 |  

| sjis     | Shift-JIS Japanese              | sjis_japanese_ci    |      2 |  

| hebrew   | ISO 8859-8 Hebrew               | hebrew_general_ci   |      1 |  

| tis620   | TIS620 Thai                     | tis620_thai_ci      |      1 |  

| euckr    | EUC-KR Korean                   | euckr_korean_ci     |      2 |  

| koi8u    | KOI8-U Ukrainian                | koi8u_general_ci    |      1 |  

| gb2312   | GB2312 Simplified Chinese       | gb2312_chinese_ci   |      2 |  

| greek    | ISO 8859-7 Greek                | greek_general_ci    |      1 |  

| cp1250   | Windows Central European        | cp1250_general_ci   |      1 |  

| gbk      | GBK Simplified Chinese          | gbk_chinese_ci      |      2 |  

| latin5   | ISO 8859-9 Turkish              | latin5_turkish_ci   |      1 |  

| armscii8 | ARMSCII-8 Armenian              | armscii8_general_ci |      1 |  

| utf8     | UTF-8 Unicode                   | utf8_general_ci     |      3 |  

| ucs2     | UCS-2 Unicode                   | ucs2_general_ci     |      2 |  

| cp866    | DOS Russian                     | cp866_general_ci    |      1 |  

| keybcs2  | DOS Kamenicky Czech-Slovak      | keybcs2_general_ci  |      1 |  

| macce    | Mac Central European            | macce_general_ci    |      1 |  

| macroman | Mac West European               | macroman_general_ci |      1 |  

| cp852    | DOS Central European            | cp852_general_ci    |      1 |  

| latin7   | ISO 8859-13 Baltic              | latin7_general_ci   |      1 |  

| utf8mb4  | UTF-8 Unicode                   | utf8mb4_general_ci  |      4 |  

| cp1251   | Windows Cyrillic                | cp1251_general_ci   |      1 |  

| utf16    | UTF-16 Unicode                  | utf16_general_ci    |      4 |  

| utf16le  | UTF-16LE Unicode                | utf16le_general_ci  |      4 |  

| cp1256   | Windows Arabic                  | cp1256_general_ci   |      1 |  

| cp1257   | Windows Baltic                  | cp1257_general_ci   |      1 |  

| utf32    | UTF-32 Unicode                  | utf32_general_ci    |      4 |  

| binary   | Binary pseudo charset           | binary              |      1 |  

| geostd8  | GEOSTD8 Georgian                | geostd8_general_ci  |      1 |  

| cp932    | SJIS for Windows Japanese       | cp932_japanese_ci   |      2 |  

| eucjpms  | UJIS for Windows Japanese       | eucjpms_japanese_ci |      3 |  

| gb18030  | China National Standard GB18030 | gb18030_chinese_ci  |      4 |  

+----------+---------------------------------+---------------------+--------+  

41 rows in set (0.00 sec)

在支持列表中我们可以看到眼熟的ascii，gbk，utf8，utf8mb4等，以及下面会出现的latin1。

着重强调：utf8和utf8mb4，在列表可以看到Maxlen最大长度一栏，utf8最大长度为3字节，所以utf8有个别名叫utf8mb3，两者是一个意思。而utf8mb4最大长度4字节，可以理解为utf8mb4是utf8的扩展，毕竟多一个字节可以多存很多数据，比如特殊的字符或者emoji表情就需要utf8mb4字符集。在实际生产环境中也都是使用utf8mb4字符集。

1.1 查看当前数据库使用的字符集

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
mysql> show variables like '%character%' ;  

+--------------------------+----------------------------+  

| Variable_name            | Value                      |  

+--------------------------+----------------------------+  

| character_set_client     | utf8                       |  

| character_set_connection | utf8                       |  

| character_set_database   | latin1                     |  

| character_set_filesystem | binary                     |  

| character_set_results    | utf8                       |  

| character_set_server     | latin1                     |  

| character_set_system     | utf8                       |  

| character_sets_dir       | /usr/share/mysql/charsets/ |  

+--------------------------+----------------------------+  

8 rows in set (0.00 sec)

参数解释：

官方文档：

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

Rate tiers Pricing
character_set_client 客户端请求数据的字符集
character_set_connection 从客户端接收到数据，然后传输的字符集
character_set_database 默认数据库的字符集，无论默认数据库如何改变，都是这个字符集；如果没有默认数据库，那就使用 character_set_server指定的字符集，这个变量建议由系统自己管理，不要人为定义
character_set_filesystem 把os上文件名转化成此字符集，即把character_set_client转换character_set_filesystem，默认binary是不做任何转换的
character_set_results 结果集的字符集
character_set_server 数据库服务器的默认字符集
character_set_system 这个值总是utf8，不需要设置，是为存储系统元数据的字符集

通过以上可以看到数据库服务器默认的字符集是latin1，此数据集是ASCII的扩展，但是最大长度还是1字节，无法存储汉字，特殊符号等；需要将默认的latin1修改为常用的utf8mb4字符集。

注意：mysql在5.5.3版本之后才支持utf8mb4.

1.2 查看当前某个数据库使用的字符集

1
2
3
4
5
6
7
8
9
10
11
12
13
14
mysql> show create database test ;  

+----------+------------------------------------------------------------------+  

| Database | Create Database                                                  |  

+----------+------------------------------------------------------------------+  

| test     | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ |  

+----------+------------------------------------------------------------------+  

1 row in set (0.00 sec)

2. 字符集转换

1. 更改数据库默认字符集

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
[root@localhost ~]# cp /etc/my.cnf /etc/my.cnf.bak    //备份mysql配置文件my.cnf  

[root@localhost ~]# vim /etc/my.cnf
[mysqld]
character-set-server=utf8         //新增配置项
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid  

[client]                //新增配置项
default-character-set=utf8     //新增配置项  

[mysql]                     //新增配置项
default-character-set=utf8     //新增配置项  

[root@localhost ~]# service mysqld restart        //重启mysql服务
停止 mysqld：                                              [确定]
正在启动 mysqld：                                          [确定]  

[root@localhost ~]# mysql -uroot -p123qqq...A
...
mysql> show variables like '%char%';
+--------------------------------------+----------------------------+
| Variable_name                        | Value                      |
+--------------------------------------+----------------------------+
| character_set_client                 | utf8                       |
| character_set_connection             | utf8                       |
| character_set_database               | utf8                       |
| character_set_filesystem             | binary                     |
| character_set_results                | utf8                       |
| character_set_server                 | utf8                       |
| character_set_system                 | utf8                       |
| character_sets_dir                   | /usr/share/mysql/charsets/ |
| validate_password_special_char_count | 1                          |
+--------------------------------------+----------------------------+
9 rows in set (0.00 sec)

2. 导出数据（数据库已安装并配置了zabbix情况下）

1
mysqldump -uroot -p  库名 > zabbix.sql

3. 替换数据，查看sql文件中的内容，寻找默认的字符集并改为utf8

1
sed -i 's/latin1/utf8/g' zabbix.sql

4. 导入更换字符集和原有数据

1
Source zabbix.sql

5. 监控项字符集变更为utf8

1
ALTER TABLE items CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
运维
#监控 #Zabbix
Zabbix5.0版本Docker-compose.yml
https://johnnysxy.github.io/2023/04/23/Zabbix5-0版本Docker-compose-yml/
作者
Johnny Song
发布于
2023年4月23日
许可协议