zabbix安装记录

####安装

1. 准备zabbix源

rpm -Uvh https://repo.zabbix.com/zabbix/5.0/rhel/8/x86_64/zabbix-release-5.0-1.el8.noarch.rpm

yum repolist 可以查看是否安装源成功

1. 安装

yum -y install zabbix-server-mysql zabbix-agent

安装前端相关依赖

yum -y install zabbix-web-mysql.noarch zabbix-nginx-conf.noarch

1. 安装数据库相关依赖
2. 安装mysql

下载mysql源

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

# 安装mysql数据源

yum install mysql80-community-release-el8-1.noarch.rpm

# 检测mysql源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

# 禁用centos自带的mysql模块

yum module disable mysql

# 安装mysql

yum install mysql-community-server

service mysqld status

service mysqld start

# 查找随机密码

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

修改默认密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_21root'

查看密码策略

SHOW VARIABLES LIKE 'validate_password%';

修改密码长度

set global validate_password_length=1;

set global validate_password.length=1;

修改密码等级

set global validate_password_policy=0;

set global validate_password.policy=0;

设置自己想要的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx'

mysql 8以上需要修改配置文件 /etc/my.cnf

default_authentication_plugin=mysql_native_password

mysql允许远程连接

create user 'root'@'%' identified by 'zHAs3erVUnD0DkJz';

grant all privileges on . to 'root'@'%' with grant option;

FLUSH PRIVILEGES;

配置

1. mysql配置
2. 创建zabbix数据库

 	`create database zabbix character set utf8 collate utf8_bin;`

• 创建zabbix用户

 ` create user 'zabbix'@'%' identified by 'zabbix';`

 `grant all on zabbix.* to zabbix@'%';`

• 找到初始化数据库的sql

 ```shell

 rpm -ql zabbix-server-mysql

 zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz > zabbix.sql

 vim zabbix.sql

 #在第一行新增, 选择数据库, 就上面新创建的就行

 use zabbix;

 # 注入SQL

 Mysql -p < zabbix.sql

1. zabbix配置

vim /etc/zabbix/zabbix_server.conf

数据库名称

DBName=zabbix

DBUser=zabbix

DBPassword=zabbix

1. 配置前端应用

vim /etc/php-fpm.d/zabbix.conf 

listen.acl_users = apache,nginx

php_value[date.timezone] = Asia/Shanghai

vim /etc/nginx/conf.d/zabbix.conf 

				listen          80;

       server_name     10.122.1.79;

1. 检测安全项目

关闭防火墙

systemctl disable --now firewalld

selinux

setenforce 0

vim /etc/selinux/config

SELINUX=disable

启动

systemctl start zabbix-server.service  php-fpm.service nginx.service

此时可以访问该ip了

Screenshot 2021-11-30 at 21.18.18.png

1. 确认配置是否都是ok的

Screenshot 2021-11-30 at 21.19.22.png

1. 连接数据库

Screenshot 2021-11-30 at 21.21.06.png

3.. 输入名称

Screenshot 2021-11-30 at 23.58.08.png

1. 确认配置

Screenshot 2021-11-30 at 23.58.26.png

1. 配置成功

Screenshot 2021-11-30 at 23.59.09.png

1. 开始使用

Screenshot 2021-11-30 at 23.59.35.png

报错及解决方案

1. The server requested authentication method unknown to the client
2. 删除之前的用户delete from user where user='zabbix' and host='localhost';
3. 修改mysql配置文件 default_authentication_plugin=mysql_native_password
4. 重启mysql并创建用户 create user zabbix@localhost identified by 'zabbix1';``grant all privileges on zabbix.* to zabbix@localhost;
5. 设置远程连接 update user set host='%' where user='zabbix'; flush privileges;
6. 确认可以远程连接 select host, user, authentication_string, plugin from user; zabbix用户的host是% 表示成功
7. 重启mysql和php-fpm
8. Unsupported charset or collation for tables:

数据库字符集问题

• 删除原本的数据库 drop database zabbix;
• 创建新的数据库 create database zabbix character set utf8 collate utf8_bin;
• 注入表格等内容 mysql -p < zabbix.sql
• 数据库密码不符规定

查看密码策略

SHOW VARIABLES LIKE 'validate_password%';

修改密码长度

set global validate_password_length=1;

set global validate_password.length=1;

修改密码等级

set global validate_password_policy=0;

set global validate_password.policy=0;

设置自己想要的密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx'