企业实战（8）CentOS 6.8安装Zabbix-agent 5.0监控主机性能与Mysql数据库

[root@localhost ~]# getenforce
Enforcing

[root@localhost ~]# setenforce 0

[root@localhost ~]# getenforce
Permissive

[root@localhost ~]# vim /etc/sysconfig/selinux
SELINUX=disabled

[root@localhost ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     all  --  anywhere             anywhere            state RELATED,ESTABLISHED
ACCEPT     icmp --  anywhere             anywhere
ACCEPT     all  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:ssh
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

[root@localhost ~]# iptables -I INPUT -p tcp --dport 10050 -j ACCEPT
----放行zabbix端口10050

[root@localhost ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere            tcp dpt:zabbix-agent
ACCEPT     all  --  anywhere             anywhere            state RELATED,ESTABLISHED
ACCEPT     icmp --  anywhere             anywhere
ACCEPT     all  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere            state NEW tcp dpt:ssh
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination
REJECT     all  --  anywhere             anywhere            reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination

[root@localhost ~]# rpm -Uvh https://repo.zabbix.com/zabbix/5.0/rhel/6/x86_64/zabbix-release-5.0-1.el6.noarch.rpm
Retrieving https://repo.zabbix.com/zabbix/5.0/rhel/6/x86_64/zabbix-release-5.0-1.el6.noarch.rpm
warning: /var/tmp/rpm-tmp.8Lm2y3: Header V4 RSA/SHA512 Signature, key ID a14fe591: NOKEY
Preparing...                ########################################### [100%]
   1:zabbix-release         ########################################### [100%]

[root@localhost ~]# yum clean all
已加载插件：fastestmirror
Cleaning repos: base extras updates zabbix zabbix-non-supported
清理一切
Cleaning up list of fastest mirrors

[root@localhost ~]# yum -y install zabbix-agent
已加载插件：fastestmirror
设置安装进程
Loading mirror speeds from cached hostfile
 * base: mirrors.bfsu.edu.cn
 * extras: mirrors.bfsu.edu.cn
 * updates: mirrors.bfsu.edu.cn
解决依赖关系
--> 执行事务检查
---> Package zabbix-agent.x86_64 0:5.0.0-1.el6 will be 安装
--> 完成依赖关系计算

依赖关系解决

===============================================================================================================================
 软件包                           架构                       版本                             仓库                        大小
===============================================================================================================================
正在安装:
 zabbix-agent                     x86_64                     5.0.0-1.el6                      zabbix                     435 k

事务概要
===============================================================================================================================
Install       1 Package(s)

总下载量：435 k
Installed size: 1.7 M
下载软件包：
http://repo.zabbix.com/zabbix/5.0/rhel/6/x86_64/^H^H^H^Hzabbix-agent-5.0.0-1.el6.x86_64.rpm              18% [=======          zabbix-agent-5.0.0-1.el6.x86_64.rpm                                                                     | 435 kB     00:08
warning: rpmts_HdrFromFdno: Header V4 RSA/SHA512 Signature, key ID a14fe591: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591
Importing GPG key 0xA14FE591:
 Userid : Zabbix LLC <packager@zabbix.com>
 Package: zabbix-release-5.0-1.el6.noarch (installed)
 From   : /etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591
运行 rpm_check_debug
执行事务测试
事务测试成功
执行事务
Warning: RPMDB altered outside of yum.
  正在安装   : zabbix-agent-5.0.0-1.el6.x86_64                                                                             1/1
  Verifying  : zabbix-agent-5.0.0-1.el6.x86_64                                                                             1/1

已安装:
  zabbix-agent.x86_64 0:5.0.0-1.el6

完毕！

[root@localhost ~]# vim /etc/zabbix/zabbix_agentd.conf
119 Server=127.0.0.1,192.168.2.128
160 ServerActive=192.168.2.128
171 Hostname=192.168.2.131

[root@localhost ~]# service zabbix-agent start
Starting Zabbix agent:                                     [确定]

[root@localhost ~]# service zabbix-agent enable
用法: /etc/init.d/zabbix-agent {start|stop|status|restart|try-restart|force-reload}

[root@localhost ~]# ss -antulp | grep :10050
tcp    LISTEN     0      128                   :::10050                :::*      users:(("zabbix_agentd",2963,5),("zabbix_agentd",2965,5),("zabbix_agentd",2966,5),("zabbix_agentd",2967,5),("zabbix_agentd",2968,5),("zabbix_agentd",2969,5))
tcp    LISTEN     0      128                    *:10050                 *:*      users:(("zabbix_agentd",2963,4),("zabbix_agentd",2965,4),("zabbix_agentd",2966,4),("zabbix_agentd",2967,4),("zabbix_agentd",2968,4),("zabbix_agentd",2969,4))

[root@localhost ~]# yum install tree net-tool net-snmp vim ntpdate  wget                 #安装部分基础软件包

[root@localhost ~]# cd /etc/yum.repos.d/         #修改yum源 更改为阿里云 

[root@localhost ~]# mv CentOS-Base.repo CentOS-Base.repo.bak    #备份文件    

[root@localhost ~]# wget -O CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo            #下载阿里云镜像仓库

[root@localhost ~]# wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-6.repo     #下载epel仓库

[root@localhost ~]# yum clean all    #清理缓存            

[root@localhost ~]# yum makecache   #重新生成缓存 

[root@localhost ~]# wget https://repo.mysql.com//mysql57-community-release-el6-9.noarch.rpm     //下载Mysql5.7 Yum源

[root@localhost ~]# ls mysql57-community-release-el6-9.noarch.rpm
mysql57-community-release-el6-9.noarch.rpm

[root@localhost ~]# rpm -ivh mysql57-community-release-el6-9.noarch.rpm      //安装Mysql5.7 Yum源

[root@localhost ~]# yum -y install mysql-server    //安装Mysql
...
已安装:
  mysql-community-libs.x86_64 0:5.7.30-1.el6                  mysql-community-libs-compat.x86_64 0:5.7.30-1.el6
  mysql-community-server.x86_64 0:5.7.30-1.el6

作为依赖被安装:
  mysql-community-client.x86_64 0:5.7.30-1.el6   mysql-community-common.x86_64 0:5.7.30-1.el6   numactl.x86_64 0:2.0.9-2.el6

作为依赖被升级:
  postfix.x86_64 2:2.6.6-8.el6

完毕！

[root@localhost ~]# service mysqld start    //启动Mysqld服务
初始化 MySQL 数据库：                                      [确定]
正在启动 mysqld：                                          [确定]

[root@localhost ~]# service mysqld enable    //开机自启mysql
用法：/etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}

[root@localhost ~]# ss -antulp | grep :3306
tcp    LISTEN     0      80                    :::3306                 :::*      users:(("mysqld",23473,21))

[root@localhost ~]# grep 'root@localhost:' /var/log/mysqld.log   //查看初始密码
2020-05-26T21:29:44.571409Z 1 [Note] A temporary password is generated for root@localhost: haiwhAT<g1O+

[root@localhost ~]# mysql -hlocalhost -uroot -p'haiwhAT<g1O+'  //使用初始密码登陆
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.30
...
mysql>

mysql> alter user root@"localhost" identified by "123qqq...A";   修改登陆密码

[root@localhost ~]# mysql -uroot -p123qqq...A    //使用新密码登陆

[root@localhost ~]# mysql -uroot -p123qqq...A
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.30 MySQL Community Server (GPL)
...
mysql> grant all on *.* to zabbix@"localhost" identified by "123qqq...A";
Query OK, 0 rows affected, 1 warning (0.06 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

[root@localhost ~]# mysql -uzabbix -p123qqq...A
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.30 MySQL Community Server (GPL)
...
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> select user();
+------------------+
| user()           |
+------------------+
| zabbix@localhost |
+------------------+
1 row in set (0.01 sec)

[root@localhost ~]# find / -name mysql.sock
/var/lib/mysql/mysql.sock

[root@localhost ~]# find / -name user*_mysql.conf
/usr/share/doc/zabbix-agent-5.0.0/userparameter_mysql.conf

[root@localhost ~]# cp /usr/share/doc/zabbix-agent-5.0.0/userparameter_mysql.conf /etc/zabbix/zabbix_agentd.d/

[root@localhost ~]# id zabbix
uid=498(zabbix) gid=498(zabbix) 组=498(zabbix)

[root@localhost ~]# chown -R zabbix:zabbix /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf   //设置模板文件归属

[root@localhost ~]# ll /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
-rw-r--r--. 1 zabbix zabbix 1081 5月  27 06:07 /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf

[root@localhost ~]# cat /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
#template_db_mysql.conf created by Zabbix for "Template DB MySQL" and Zabbix 4.2
#For OS Linux: You need create .my.cnf in zabbix-agent home directory (/var/lib/zabbix by default)
#For OS Windows: You need add PATH to mysql and mysqladmin and create my.cnf in %WINDIR%\my.cnf,C:\my.cnf,BASEDIR\my.cnf https://dev.mysql.com/doc/refman/5.7/en/option-files.html
#The file must have three strings:
#[client]
#user=zbx_monitor
#password=<password>
#
UserParameter=mysql.ping[*], mysqladmin -h"$1" -P"$2" ping
UserParameter=mysql.get_status_variables[*], mysql -h"$1" -P"$2" -sNX -e "show global status"
UserParameter=mysql.version[*], mysqladmin -s -h"$1" -P"$2" version
UserParameter=mysql.db.discovery[*], mysql -h"$1" -P"$2" -sN -e "show databases"
UserParameter=mysql.dbsize[*], mysql -h"$1" -P"$2" -sN -e "SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='$3'"
UserParameter=mysql.replication.discovery[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"
UserParameter=mysql.slave_status[*], mysql -h"$1" -P"$2" -sNX -e "show slave status"

[root@localhost ~]# mkdir /var/lib/zabbix

[root@localhost ~]# vim /var/lib/zabbix/.my.cnf
[mysql]
host=localhost
user=zabbix           //数据库中授权的zabbix用户
password=123qqq...A     //授权用户密码
socket=/var/lib/mysql/mysql.sock   

[mysqladmin]
host=localhost
user=zabbix
password=123qqq...A
socket=/vsr/lib/mysql/mysql.sock

[root@localhost ~]# service zabbix-agent restart    //重启Zabbix-agent服务
Shutting down Zabbix agent:                                [确定]
Starting Zabbix agent:                                     [确定]