好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

Centos7.9 部署 Zabbix5.2.2,数据库mysql8.0

环境准备: 系统镜像:CentOS-7-x86_64-DVD-2009.iso Zabbix源码包:zabbix-5.2.2.tar.gz 官方网址:https://www.zabbix.com/cn/download_sources 直接使用迅雷下载:http://192.168.1.9/zabbix-5.2.2.tar.gz?fid=8SzoZHHht0OP1q5RQkkdo87-RQtNSS0BAAAAAIyzXQLokJXECQHtLl0k68rN6Pxe&mid=666&threshold=150&tid=84A8E541DCB05E3575BE9F8D12BBE5CC&srcid=119&verno=1

系统安装完成后,关闭selinux [root@Zabbix-Server ~]# sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/‘ /etc/selinux/config

关闭防火墙 [root@Zabbix-Server ~]# systemctl disable --now firewalld

重启 [root@Zabbix-Server ~]# reboot

查看seliunx状态 [root@Zabbix-Server ~]# sestatus

查看防火墙状态 [root@Zabbix-Server ~]# systemctl status firewalld.service

##查看系统是否已经安装了mysql和mariadb数据库, [root@Zabbix-Server ~]# rpm -qa | grep mysql [root@Zabbix-Server ~]# rpm -pa | grep mariadb

访问mysql官网查看源下载地址 https://dev.mysql.com/downloads/repo/yum/

[root@Zabbix-Server ~]# wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

安装rpm源 [root@Zabbix-Server ~]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm

安装mysql,等安装完成 [root@Zabbix-Server ~]# yum install -y mysql-community-server

开启mysql服务,并设置开机自动启动 [root@Zabbix-Server ~]# systemctl start mysqld.service && systemctl enable mysqld.service

查看mysql服务状态 [root@Zabbix-Server ~]# systemctl status mysqld.service 查看mysql版本 [root@Zabbix-Server ~]# mysqld -V [root@Zabbix-Server ~]# mysql -V

重启验证mysql是否开机自动启动

通过rpm安装的MySQL会生成默认登录密码,使用如下命令查询指定路径文件即可获取 [root@Zabbix-Server ~]# grep "A temporary password" /var/log/mysqld.log 复制查询到的临时密码

初始化数据库,输入刚才得到的临时密码登录 [root@Zabbix-Server ~]# mysql_secure_installation

按照提示初始化数据库

使用刚才设置的新密码登录数据库 [root@Zabbix-Server ~]# mysql -uroot -p

创建zabbix数据库 mysql> create database zabbix character set utf8 collate utf8_bin; Query OK, 1 row affected, 2 warnings (0.02 sec)

创建zabbix用户并设置密码 mysql> create user zabbix@localhost identified by ‘Start123!‘; Query OK, 0 rows affected (0.01 sec)

给zabbix用户授权 mysql> grant all privileges on zabbix.* to zabbix@localhost; Query OK, 0 rows affected (0.00 sec) mysql> ALTER USER ‘zabbix‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY -> ‘Start123!‘; Query OK, 0 rows affected (0.01 sec)

[root@Zabbix-Server ~]# groupadd --system zabbix [root@Zabbix-Server ~]# useradd --system -g zabbix -d /usr/lib/zabbix -s /sbin/nologin -c "Zabbix Monitoring System" zabbix 添加文件夹 [root@Zabbix-Server ~]# mkdir -m u=rwx,g=rwx,o= -p /usr/lib/zabbix 给用户授权文件夹权限 [root@Zabbix-Server ~]# chown zabbix:zabbix /usr/lib/zabbix

安装依赖 [root@Zabbix-Server ~]# yum -y install gcc gcc-c++ unixODBC-devel httpd mysql-devel libcurl libcurl-devel libevent libevent-devel fping curl-devel libxml2 libxml2-devel snmpd net-snmp-devel net-snmp

下载zabbix源码包 https://cdn.zabbix.com/zabbix/sources/stable/5.2/zabbix-5.2.2.tar.gz

上传zabbix源码包到/tmp文件夹下 [root@Zabbix-Server ~]# rz [root@Zabbix-Server ~]# cp zabbix-5.2.2.tar.gz /tmp/

解压zabbix文件包 [root@Zabbix-Server ~]# cd /tmp/ [root@Zabbix-Server tmp]# tar zxvf zabbix-5.2.2.tar.gz

进入zabbix文件夹 [root@Zabbix-Server tmp]# cd zabbix-5.2.2/

在zabbix-5.2.2文件夹下编译 [root@Zabbix-Server zabbix-5.2.2]# ./configure --enable-server --enable-agent --with-mysql --enable-ipv6 --with-net-snmp --with-libcurl --with-libxml2

没有报错出现no make install时安装 [root@Zabbix-Server zabbix-5.2.2]# make install

退回到根目录 [root@Zabbix-Server zabbix-5.2.2]# cd ~ 登录数据库 [root@Zabbix-Server ~]# mysql -uroot -p 进入zabbix数据库 mysql> use zabbix; 导入zabbix的三个数据库 mysql> source /tmp/zabbix-5.2.2/database/mysql/schema.sql; mysql> source /tmp/zabbix-5.2.2/database/mysql/images.sql; mysql> source /tmp/zabbix-5.2.2/database/mysql/data.sql;

安装PHP [root@Zabbix-Server ~]# yum -y install epel-release yum-utils [root@Zabbix-Server ~]# rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/remi/enterprise/remi-release-7.rpm

[root@Zabbix-Server ~]# yum-config-manager --enable remi-php72

[root@Zabbix-Server ~]# yum -y install httpd php php-fpm php-json [root@Zabbix-Server ~]# yum -y install php-gd php-bcmath php-mbstring php-xmlwriter php-xmlreader php-mysqli php-ldap

进入/var/www/html文件夹,创建文件夹

复制Zabbix前端文件到/var/www/html/zabbix目录下,并授权 [root@Zabbix-Server ~]# cp /tmp/zabbix-5.2.2/ui/* /var/www/html/zabbix/ -R [root@Zabbix-Server ~]# chown apache:apache /var/www/html/zabbix/ -R

开启httpd和php服务,并设置开机自启 [root@Zabbix-Server ~]# systemctl start httpd php-fpm && systemctl enable httpd php-fpm

通过网页访问 http://ip/zabbix

下一步时有报错,修改php.ini文件中对应参数到要求的值 php.ini文件位于/etc目录下

修改完成后重启一下服务 [root@Zabbix-Server ~]# systemctl restart httpd php-fpm 重启完成后,刷新网页所有必要条件不再报错

填写数据库密码,如果连接报错,查看数据库权限,可以访问数据库授权 [root@Zabbix-Server ~]# systemctl restart httpd php-fpm [root@Zabbix-Server ~]# mysql -uroot -p mysql> use zabbix; Database changed mysql> ALTER USER ‘zabbix‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘Start123!‘; 使用用户名Admin 密码zabbix登录

登录后发现zabbix服务器端未运行,还需要再做配置

修改zabbix_server.conf配置文件中DBPassword的值为zabbix数据库的密码 [root@Zabbix-Server ~]# find / -name zabbix_server.conf /tmp/zabbix-5.2.2/conf/zabbix_server.conf /usr/local/etc/zabbix_server.conf [root@Zabbix-Server ~]# vi /usr/local/etc/zabbix_server.conf

[root@Zabbix-Server ~]# vim /usr/lib/systemd/system/zabbix-server.service

[Unit] Description=Zabbix Server After=syslog.target After=network.target After=mysql.service After=mysqld.service After=mariadb.service After=postgresql.service After=pgbouncer.service After=postgresql-9.4.service After=postgresql-9.5.service After=postgresql-9.6.service After=postgresql-10.service After=postgresql-11.service After=postgresql-12.service

[Service] Environment="CONFFILE=/usr/local/etc/zabbix_server.conf" Type=forking Restart=on-failure PIDFile=/tmp/zabbix_server.pid KillMode=control-group ExecStart=/usr/local/sbin/zabbix_server -c $CONFFILE ExecStop=/bin/kill -SIGTERM $MAINPID RestartSec=10s TimeoutSec=0

[Install] WantedBy=multi-user.target

[root@Zabbix-Server ~]# vim /usr/lib/systemd/system/zabbix-agent.service

[Unit] Description=Zabbix Agent After=syslog.target After=network.target [Service] Environment="CONFFILE=/usr/local/etc/zabbix_agentd.conf" Type=forking Restart=on-failure PIDFile=/tmp/zabbix_agentd.pid KillMode=control-group ExecStart=/usr/local/sbin/zabbix_agentd -c $CONFFILE ExecStop=/bin/kill -SIGTERM $MAINPID RestartSec=10s User=zabbix Group=zabbix [Install] WantedBy=multi-user.target

[root@Zabbix-Server ~]# systemctl start zabbix-server zabbix-agent &&systemctl enable zabbix-server zabbix-agent

重启zabbix服务或者重启系统后再次访问发现一切正常 [root@Zabbix-Server ~]# systemctl restart httpd php-fpm [root@Zabbix-Server ~]# systemctl restart zabbix-server zabbix-agent

解决中文乱码

到windows系统中拷贝简体中文字体文件并上传到/var/www/html/zabbix/assets/fonts目录下

修改/var/www/html/zabbix/include/defines.inc.php文件中的将ZBX_GRAPH_FONT_NAME的值修改为simhei [root@Zabbix-Server ~]# vi /var/www/html/zabbix/include/defines.inc.php

Centos7.9 部署 Zabbix5.2.2,数据库mysql8.0

标签:官方   wan   数据库   unity   log   localhost   pidfile   访问   monitor   

查看更多关于Centos7.9 部署 Zabbix5.2.2,数据库mysql8.0的详细内容...

  阅读:31次

上一篇: JDBC用户登录案例

下一篇:MongoDB Java