学习笔记0610----监控软件zabbix

[root@linux-001 ~]# rpm -Uvh https://repo.zabbix.com/zabbix/4.2/rhel/7/x86_64/zabbix-release-4.2-1.el7.noarch.rpm
获取https://repo.zabbix.com/zabbix/4.2/rhel/7/x86_64/zabbix-release-4.2-1.el7.noarch.rpm
警告：/var/tmp/rpm-tmp.z8bUCY: 头V4 RSA/SHA512 Signature, 密钥 ID a14fe591: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:zabbix-release-4.2-1.el7         ################################# [100%]

[root@linux-001 ~]# yum install -y  zabbix-server zabbix-server-mysql zabbix-web zabbix-web-mysql  zabbix-agent 

安装省略

[root@linux-001 ~]# mysql -uroot -plinux002
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.6.43-log MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database zabbix;
Query OK, 1 row affected (0.01 sec)

mysql> grant all on zabbix.* to zabbix@'localhost' identified  by '123456';
Query OK, 0 rows affected (0.00 sec)

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


mysql> quit
Bye

[root@linux-001 ~]# cd /usr/share/doc/zabbix-server-mysql-4.2.3/
[root@linux-001 zabbix-server-mysql-4.2.3]# ls
AUTHORS  ChangeLog  COPYING  create.sql.gz  NEWS  README
[root@linux-001 zabbix-server-mysql-4.2.3]# zcat create.sql.gz | mysql -uroot -plinux002 zabbix
Warning: Using a password on the command line interface can be insecure.
[root@linux-001 zabbix-server-mysql-4.2.3]# 

[root@linux-001 ~]# vim /etc/zabbix/zabbix_server.conf 

DBName=zabbix

DBUser=zabbix

DBPassword=123456

DBSocket=/tmp/mysql.sock

[root@linux-001 ~]# vim /etc/zabbix/zabbix_agentd.conf

Server=127.0.0.1

ServerActive=127.0.0.1

[root@linux-001 ~]# vim /etc/php.ini

date.timezone = Asia/Shanghai

[root@linux-001 ~]# systemctl start zabbix-server
[root@linux-001 ~]# systemctl start zabbix-agent   
[root@linux-001 ~]# systemctl start httpd.service 
[root@linux-001 ~]# 

[root@linux-02 ~]# rpm -Uvh https://repo.zabbix.com/zabbix/4.2/rhel/7/x86_64/zabbix-release-4.2-1.el7.noarch.rpm
获取https://repo.zabbix.com/zabbix/4.2/rhel/7/x86_64/zabbix-release-4.2-1.el7.noarch.rpm
警告：/var/tmp/rpm-tmp.Y9bgOq: 头V4 RSA/SHA512 Signature, 密钥 ID a14fe591: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:zabbix-release-4.2-1.el7         ################################# [100%]
[root@linux-02 ~]# yum install -y zabbix-agent
已加载插件：fastestmirror, langpacks
Determining fastest mirrors
 * base: mirrors.cn99.com
 * extras: mirrors.cn99.com
 * updates: mirrors.cn99.com
base                                                                                                                       | 3.6 kB  00:00:00     
extras                                                                                                                     | 3.4 kB  00:00:00     
updates                                                                                                                    | 3.4 kB  00:00:00     
zabbix                                                                                                                     | 2.9 kB  00:00:00     
zabbix-non-supported                                                                                                       |  951 B  00:00:00     
(1/3): extras/7/x86_64/primary_db                                                                                          | 200 kB  00:00:02     
(2/3): zabbix/x86_64/primary_db                                                                                            |  39 kB  00:00:06     
(3/3): updates/7/x86_64/primary_db                                                                                         | 5.0 MB  00:00:06     
zabbix-non-supported/x86_64/primary                                                                                        | 1.6 kB  00:00:02     
zabbix-non-supported                                                                                                                          4/4
正在解决依赖关系
--> 正在检查事务
---> 软件包 zabbix-agent.x86_64.0.4.2.3-2.el7 将被 安装
--> 解决依赖关系完成

依赖关系解决

==================================================================================================================================================
 Package                               架构                            版本                                 源                               大小
==================================================================================================================================================
正在安装:
 zabbix-agent                          x86_64                          4.2.3-2.el7                          zabbix                          400 k

事务概要
==================================================================================================================================================
安装  1 软件包

总下载量：400 k
安装大小：1.6 M
Downloading packages:
警告：/var/cache/yum/x86_64/7/zabbix/packages/zabbix-agent-4.2.3-2.el7.x86_64.rpm: 头V4 RSA/SHA512 Signature, 密钥 ID a14fe591: NOKEY00:00:00 ETA 
zabbix-agent-4.2.3-2.el7.x86_64.rpm 的公钥尚未安装
zabbix-agent-4.2.3-2.el7.x86_64.rpm                                                                                        | 400 kB  00:01:15     
从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591 检索密钥
导入 GPG key 0xA14FE591:
 用户ID     : "Zabbix LLC <packager@zabbix.com>"
 指纹       : a184 8f53 52d0 22b9 471d 83d0 082a b56b a14f e591
 软件包     : zabbix-release-4.2-1.el7.noarch (installed)
 来自       : /etc/pki/rpm-gpg/RPM-GPG-KEY-ZABBIX-A14FE591
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
警告：RPM 数据库已被非 yum 程序修改。
  正在安装    : zabbix-agent-4.2.3-2.el7.x86_64                                                                                               1/1 
  验证中      : zabbix-agent-4.2.3-2.el7.x86_64                                                                                               1/1 

已安装:
  zabbix-agent.x86_64 0:4.2.3-2.el7                                                                                                               

完毕！
[root@linux-02 ~]# 

[root@linux-001 ~]# vim /etc/zabbix/zabbix_agentd.conf

Server=192.168.141.128

ServerActive=192.168.141.128

[root@linux-02 ~]# systemctl start zabbix-agent.service 

[root@linux-001 ~]# mysql -uroot -plinux002 zabbix
Warning: Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 792
Server version: 5.6.43-log MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use zabbix
Database changed


mysql> show create table triggers\G;
*************************** 1. row ***************************
       Table: triggers
Create Table: CREATE TABLE `triggers` (
  `triggerid` bigint(20) unsigned NOT NULL,
  `expression` varchar(2048) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT '0',
  `value` int(11) NOT NULL DEFAULT '0',
  `priority` int(11) NOT NULL DEFAULT '0',
  `lastchange` int(11) NOT NULL DEFAULT '0',
  `comments` text NOT NULL,
  `error` varchar(2048) NOT NULL DEFAULT '',
  `templateid` bigint(20) unsigned DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `state` int(11) NOT NULL DEFAULT '0',
  `flags` int(11) NOT NULL DEFAULT '0',
  `recovery_mode` int(11) NOT NULL DEFAULT '0',
  `recovery_expression` varchar(2048) NOT NULL DEFAULT '',
  `correlation_mode` int(11) NOT NULL DEFAULT '0',
  `correlation_tag` varchar(255) NOT NULL DEFAULT '',
  `manual_close` int(11) NOT NULL DEFAULT '0',
  `details` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`triggerid`),
  KEY `triggers_1` (`status`),
  KEY `triggers_2` (`value`,`lastchange`),
  KEY `triggers_3` (`templateid`),
  CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> show variaables like 'character%' ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'variaables like 'character%'' at line 1
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/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> exit
Bye
[root@linux-001 ~]# mysqldump -uroot -plinux002   --default-character-set=utf8  zabbix > zabbix.sql 
Warning: Using a password on the command line interface can be insecure.
[root@linux-001 ~]#  

[root@linux-001 ~]# vim zabbix.sql 

一般命令模式输入  :1,$s/latin1/utf8/g  可查看以上图片

[root@linux-001 ~]# mysql -uroot -plinux002   --default-character-set=utf8  zabbix < zabbix.sql 
Warning: Using a password on the command line interface can be insecure.

[root@linux-001 ~]# mysql -uroot -plinux002 
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 902
Server version: 5.6.43-log MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
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/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> show create table interface\G;
*************************** 1. row ***************************
       Table: interface
Create Table: CREATE TABLE `interface` (
  `interfaceid` bigint(20) unsigned NOT NULL,
  `hostid` bigint(20) unsigned NOT NULL,
  `main` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `useip` int(11) NOT NULL DEFAULT '1',
  `ip` varchar(64) NOT NULL DEFAULT '127.0.0.1',
  `dns` varchar(255) NOT NULL DEFAULT '',
  `port` varchar(64) NOT NULL DEFAULT '10050',
  `bulk` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`interfaceid`),
  KEY `interface_1` (`hostid`,`type`),
  KEY `interface_2` (`ip`,`dns`),
  CONSTRAINT `c_interface_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> exit
Bye

[root@linux-001 ~]# vim mail.py

#!/usr/bin/python
#coding:utf-8
import smtplib
from email.mime.text import MIMEText
import sys
mail_host = 'smtpdm.aliyun.com'
mail_user = 'admin@xiaoqiblog.top'
mail_pass = '5cn3yYVzim'
mail_postfix = 'aliyun.com'
def send_mail(to_list,subject,content):
    me = "zabbix 监控告警平台"+"<"+mail_user+"@"+mail_postfix+">"
    msg = MIMEText(content, 'plain', 'utf-8')
    msg['Subject'] = subject
    msg['From'] = me
    msg['to'] = to_list
    try:
        s = smtplib.SMTP()
        s.connect(mail_host)
        s.login(mail_user,mail_pass)
        s.sendmail(me,to_list,msg.as_string())
        s.close()
        return True
    except Exception,e:
        print str(e)
        return False
if __name__ == "__main__":
    send_mail(sys.argv[1], sys.argv[2], sys.argv[3])

[root@linux-001 ~]# chmod 755 mail.py 

[root@linux-001 ~]# mv mail.py  /usr/lib/zabbix/alertscripts
[root@linux-001 alertscripts]# ls
mail.py
[root@linux-001 alertscripts]# ./mail.py   whdong007@163.com 'ceshi'  '`echo $HOSTNAME`'

[root@linux-02 ~]# cd /usr/local/src/nginx-1.16.0
[root@linux-02 nginx-1.16.0]# ./configure --prefix=/usr/local/nginx  --with-http_stub_status_module
省略
[root@linux-02 nginx-1.16.0]#  make && make install
省略
[root@linux-02 nginx-1.16.0]# cd /usr/local/nginx/conf/vhost
[root@linux-02 vhost]# vim test.com.conf

## 在行末添加以下内容 ## 
 location /nginx_status
    {
        stub_status on;
        access_log   off;
        allow 127.0.0.1;
        deny all;
    }   

[root@linux-02 vhost]# ./../../sbin/nginx -t
nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
[root@linux-02 vhost]# /etc/init.d/nginx start
Starting nginx (via systemctl):                            [  确定  ]
[root@linux-02 vhost]# ps aux | grep nginx
root      12851  0.0  0.0  20680   736 ?        Ss   08:50   0:00 nginx: master process /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
nobody    12852  0.0  0.4  23168  3572 ?        S    08:50   0:00 nginx: worker process
nobody    12853  0.0  0.3  23168  3316 ?        S    08:50   0:00 nginx: worker process
root      12855  0.0  0.1 112724   988 pts/0    R+   08:50   0:00 grep --color=auto nginx

[root@linux-02 vhost]# curl 127.0.0.1/nginx_status
Active connections: 1 
server accepts handled requests
 1 1 1 
Reading: 0 Writing: 1 Waiting: 0 
[root@linux-02 vhost]# curl 127.0.0.1/nginx_status
Active connections: 1 
server accepts handled requests
 2 2 2 
Reading: 0 Writing: 1 Waiting: 0 
[root@linux-02 vhost]# curl 127.0.0.1/nginx_status
Active connections: 1 
server accepts handled requests
 3 3 3 
Reading: 0 Writing: 1 Waiting: 0 

[root@linux-02 ~]# vim /usr/local/sbin/ngx_status.sh 

#!/bin/bash
url="http://127.0.0.1/nginx_status"
curl=/usr/bin/curl

# 检测nginx进程是否存在
function ping {
    /sbin/pidof nginx | wc -l 
}
# 检测nginx性能
function active {
    $curl $url 2>/dev/null| grep 'Active' | awk '{print $NF}'
}
function reading {
    $curl $url 2>/dev/null| grep 'Reading' | awk '{print $2}'
}
function writing {
    $curl $url 2>/dev/null| grep 'Writing' | awk '{print $4}'
}
function waiting {
    $curl $url 2>/dev/null| grep 'Waiting' | awk '{print $6}'
}
function accepts {
    $curl $url 2>/dev/null| awk NR==3 | awk '{print $1}'
}
function handled {
    $curl $url 2>/dev/null| awk NR==3 | awk '{print $2}'
}
function requests {
    $curl $url 2>/dev/null| awk NR==3 | awk '{print $3}'
}
$1


[root@linux-02 ~]# chmod  755 /usr/local/sbin/ngx_status.sh

[root@linux-02 ~]# vim /etc/zabbix/zabbix_agentd.conf

UserParameter=nginx.status[*],/usr/local/sbin/ngx_status.sh $1

[root@linux-02 ~]# yum install -y zabbix_java_gateway
安装省略


[root@linux-02 ~]# vim /etc/zabbix/zabbix_java_gateway.conf
 LISTEN_IP="0.0.0.0"

 LISTEN_PORT=10052

 START_POLLERS=5

[root@linux-02 ~]# systemctl start zabbix-java-gateway

[root@linux-02 ~]# ps aux | grep zabbix-java
zabbix     7685 10.8  4.3 2226548 36104 ?       Sl   20:31   0:01 java -server -Dlogback.configurationFile=/etc/zabbix/zabbix_java_gateway_logback.xml -classpath lib:lib/android-json-4.3_r3.1.jar:lib/logback-classic-0.9.27.jar:lib/logback-core-0.9.27.jar:lib/slf4j-api-1.6.1.jar:bin/zabbix-java-gateway-4.2.3.jar -Dzabbix.pidFile=/var/run/zabbix/zabbix_java.pid -Dzabbix.listenIP=192.168.141.129 -Dzabbix.listenPort=10052 -Dzabbix.startPollers=5 -Dsun.rmi.transport.tcp.responseTimeout=3000 com.zabbix.gateway.JavaGateway
root       7698  0.0  0.1 112724   988 pts/0    R+   20:31   0:00 grep --color=auto zabbix-java

[root@linux-02 ~]# netstat -lntp | grep 10052
tcp6       0      0 192.168.141.129:10052   :::*                    LISTEN      7685/java 

[root@linux-02 ~]# vim  /usr/local/tomcat/bin/catalina.sh
#在#!/bin/sh下增加
export CATALINA_OPTS="$CATALINA_OPTS -Dcom.sun.management.jmxremote
-Djava.rmi.server.hostname=192.168.141.129
-Dcom.sun.management.jmxremote.port=9999
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.authenticate=false"

[root@linux-02 ~]# /usr/local/tomcat/bin/startup.sh 
Using CATALINA_BASE:   /usr/local/tomcat
Using CATALINA_HOME:   /usr/local/tomcat
Using CATALINA_TMPDIR: /usr/local/tomcat/temp
Using JRE_HOME:        /usr/local/jdk1.8/jre
Using CLASSPATH:       /usr/local/tomcat/bin/bootstrap.jar:/usr/local/tomcat/bin/tomcat-juli.jar

[root@linux-001 ~]# vim /etc/zabbix/zabbix_server.conf

JavaGateway=192.168.141.129
JavaGatewayPort=10052
StartJavaPollers=5


[root@linux-001 ~]# systemctl restart zabbix-server

[root@linux-02 ~]# mysql -uroot -plinux002
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.6.43 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant usage, process, replication client on *.* to 'mmm'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.02 sec)

mysql> 
mysql> quit
Bye

[root@linux-02 ~]# mkdir /var/lib/zabbix

[root@linux-02 ~]# vi /var/lib/zabbix/.my.cnf

[mysql]
host=localhost
user=mmm
password='123456'
socket=/tmp/mysql.sock

[mysqladmin]
host=localhost
user=mmm
password='123456'
socket=/tmp/mysql.sock