保姆级zabbix-proxy代理监控

一、介绍

二、配置流程

 三、步骤

3.1  环境安装

yum install -y https://mirror.tuna.tsinghua.edu.cn/zabbix/zabbix/5.2/rhel/7/x86_64/zabbix-proxy-mysql-5.2.6-1.el7.x86_64.rpm

3.2 解决mysql秘钥问题

sudo curl -o /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023 https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
# 导入到 RPM 数据库sudo rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023

3.3 更新数据源

sudo yum clean all
sudo yum makecache

3.4 mysql安装

卸载旧版本

# 查看已安装的 MariaDB/MySQL 包
sudo rpm -qa | grep mariadb
sudo rpm -qa | grep mysql# 卸载相关包（根据实际查询结果替换包名）
sudo yum remove mariadb-libs-* mysql-*

添加 MySQL 8.0 Yum 仓库

sudo yum install -y wget
wget https://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm

安装仓库 RPM 包

sudo rpm -ivh mysql80-community-release-el7-6.noarch.rpm

验证仓库是否添加成功

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

安装 MySQL 服务

sudo yum install -y mysql-community-server
#验证版本
mysqld --version

！！注意：出现下面异常

获取 GPG 密钥失败：[Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"

 禁用秘钥

sudo yum install mysql-community-server --nogpgcheck#用后再次安装
sudo yum install -y mysql-community-server
#验证版本
mysqld --version

启动 MySQL 服务

sudo systemctl start mysqld        # 启动服务
sudo systemctl enable mysqld       # 设置开机自启
sudo systemctl status mysqld       # 检查服务状态

获取临时密码

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

 运行安全配置向导修改了密码为Passw@rd123，配置远程访问

CREATE USER 'root'@'%' IDENTIFIED BY 'Passw@rd123';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
USE MYSQL;
SELECT HOST,USER FROM USER;

重启

sudo systemctl restart mysqld

3.5 配置文件

在数据库里面执行下条命令

create database zabbix_proxy character set utf8 collate utf8_bin;

导入sql文件

zcat /usr/share/doc/zabbix-proxy-mysql*/schema.sql.gz | mysql -uroot -pPassw@rd123 zabbix_proxy

配置代理服务文件/etc/zabbix/zabbix_proxy.conf

vim /etc/zabbix/zabbix_proxy.confServer=192.168.157.141 
Hostname=nanji_server 
LogFile=/var/log/zabbix/zabbix_proxy.log 
LogFileSize=0 
PidFile=/var/run/zabbix/zabbix_proxy.pid 
SocketDir=/var/run/zabbix 
DBHost=localhost 
DBName=zabbix_proxy 
DBUser=root
DBPassword=123456
SNMPTrapperFile=/var/log/snmptrap/snmptrap.log 
Timeout=4 
ExternalScripts=/usr/lib/zabbix/externalscripts 
LogSlowQueries=3000 
StatsAllowedIP=127.0.0.1

 

注意！！出现：connection to database 'zabbix_proxy' failed: [2059] Authentication plugin 'caching_sha2_password'  修改mysql密码认证

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Passw@rd123';ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Passw@rd123';FLUSH PRIVILEGES;

重启

systemctl start zabbix-proxy.service 
systemctl enable zabbix-proxy.service

 3.6 配置web端

 

 

监控成功！