加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 百科 > 正文

[monitoring] how to create script to monitoring the status o

发布时间：2020-12-12 16:09:11 所属栏目：百科 来源：网络整理
导读：The purpose is to make a graph like this. 650) this.width=650;" src="http://img.jb51.cc/vcimg/static/loading.png" title="E3ANQ[~]84AZYW{9LUVRH6K.png" width="152" height="110" border="0" hspace="0" vspace="0" style="width:152px;height:110px

The purpose is to make a graph like this.


wKiom1en_eCBDp-zAABf-5a_pTA270.png


wKioL1en_Zjyc7saAACYelsuJko396.png-wh_50






Then,let's begin.


  1. Install oracle support

    "oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm" -- basic lib

    "oracle-instantclient11.2-devel-11.2.0.3.0-1.x86_64.rpm" -- support lib for part

    "oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm"

  2. Install python_oracle support "cx_Oracle-5.1.2-11g-py26-1.x86_64.rpm"

  3. add the following configuration to the profile.


    export PATH=/usr/lib/oracle/11.2/client64/bin:$PATH

    export ORACLE_HOME=/usr/lib/oracle/11.2/client64/

    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

    export TNS_ADMIN=$ORACLE_HOME



4.Create script "/usr/local/bin/query_busdb4mo.py" or "/usr/local/bin/query_busdb4mo.sh" to collect the data from database.



#!/usr/bin/python
#encoding:UTF-8
#Author:Eric.zhang
#Email:Eric.zhangtj@homecredit.cn
#Usage:query_busdb4mo.py[seller_code][state_code]
#Seller_codeistheuniquecodefortheseller
#state_codeisthestatusoftheorder,likethis:
#ID	STATE_CODE	STATE_NAME	DESCRIPTION
#1	INITIAL	INITIAL	Ordercreated

importcx_Oracle
importsys
importos
importdatetime

try:
	seller_code=str(sys.argv[1])
	state_code=str(sys.argv[2])
except	Exception:
	print"Usagequery_busdb4mo.py[seller_code][state_code]"
	exit()

#Inputseller_code

#Timeformatislikethis"10/24/201516:54:32"
time_now=str(datetime.datetime.now().strftime("%m/%d/%Y%H:%M:%S"))
time_pass=str(((datetime.datetime.now()-datetime.timedelta(minutes=20)).strftime("%m/%d/%Y%H:%M:%S")))

#Connecttodatabaseusingtns
con=cx_Oracle.connect("APP_MO_RO/XXXXXXXX@10.26.14.206:1521/cfcdb06")

#Openacursor
cursor=con.cursor()
cursor.execute("withtbas(selecto.id_seller,os.idasid_order_state,os.state_code,count(*)asorder_countfromapp_mo.t_ordero,app_mo.t_order_stateoswhereo.id_state=os.idando.c
date>=to_date(:v_time_pass,'MM/DD/YYYYHH24:MI:SS')ando.cdate<=to_date(:v_time_now,'MM/DD/YYYYHH24:MI:SS')groupbyos.id,o.id_seller)selecttb.order_countfromtb,owner_int.vh_hom_sellerswheretb.id_seller=s.IDands.seller_code=:v_seller_codeandid_order_state=:v_id_order_state",v_time_pass=time_pass,v_time_now=time_now,v_seller_code=seller_code,v_id_order_state=state_code)
result=cursor.fetchall()

foriinresult:
	printi[0]


#Closethecursorandtheconnection
cursor.close()
con.close()
#!/bin/bash
#Author:Eric.zhang
#Email:Eric.zhangtj@homecredit.cn
#Usage:query_busdb4mo.sh[seller_code][state_code]

source/etc/profile

#argvs
seller_code=$1
id_order_state=$2

#times
time_now=`date"+%m/%d/%Y%H:%M:%S"`
time_pass=`date-d"20minutesago""+%m/%d/%Y%H:%M:%S"`

#echo$time_now
#echo$time_pass
#echo$seller_code
#echo$id_order_state

result=`/usr/lib/oracle/11.2/client64/bin/sqlplus-silentAPP_MO_RO/XXXXXXXX@cfcdb06<<END
setpagesize0feedbackoffverifyoffheadingoffechooff;
--setserveroutputon;
varv_seller_codevarchar2(10);
exec:v_seller_code:='$seller_code';
--execDBMS_OUTPUT.put_line(:v_seller_code);
varv_id_order_statevarchar2(10);
exec:v_id_order_state:='$id_order_state';
--execDBMS_OUTPUT.put_line(:v_id_order_state);
withtbas(selecto.id_seller,app_mo.t_order_stateoswhereo.id_state=os.idando.cdate>=to_date
('$time_pass','MM/DD/YYYYHH24:MI:SS')ando.cdate<=to_date('$time_now',owner_int.vh_hom_sellerswheretb.id_seller=s.IDands.seller_code=:v_seller_codeandid_order_state=:v_id_order_state;
exit;
END`

[[-z"$result"]]&&exit0

echo$result


The result is like this:

[root@zabbixzabbix_agentd.conf.d]#/usr/local/bin/query_busdb4mo.sh0625281
535
[root@zabbixzabbix_agentd.conf.d]#/usr/local/bin/query_busdb4mo.py0625281
538
[root@zabbixzabbix_agentd.conf.d]#

5. create bash to collect the data.

[root@zabbixzabbix]#cat$(pwd)/check_hcc_online.sh
#!/bin/bash

functionORDER_CREATED{
/usr/local/bin/query_busdb4mo.py0625281
}

functionELIGIBILITY_CHECK_PASSED{
/usr/local/bin/query_busdb4mo.py0625282
	}

functionELIGIBILITY_CHECK_FAILED{
/usr/local/bin/query_busdb4mo.py0625283
	}

functionIDENTITY_CHECK_PASSED{
/usr/local/bin/query_busdb4mo.py0625284
	}

functionIDENTITY_CHECK_FAILED{
/usr/local/bin/query_busdb4mo.py0625285
	}

functionCONTRACT_APPROVED{
/usr/local/bin/query_busdb4mo.py0625286
	}

functionNOTIFY_VENDOR_TO_DELIVER_GOODS{
/usr/local/bin/query_busdb4mo.py0625287
	}

functionVENDOR_FEED_BACK_THAT_GOODS_WAS_SHIPPED{
/usr/local/bin/query_busdb4mo.py0625288
	}

functionDISBURSEMENT_TO_VENDOR{
/usr/local/bin/query_busdb4mo.py0625289
	}

functionCUSTOMER_RECEIVED_THE_GOODS{
/usr/local/bin/query_busdb4mo.py06252810
	}

functionORDER_CANCELLED_BY_CUSTOMER{
/usr/local/bin/query_busdb4mo.py06252811
	}

functionCONTRACT_CANCELLED{
/usr/local/bin/query_busdb4mo.py06252812
	}

functionORDER_REJECTED{
/usr/local/bin/query_busdb4mo.py06252813
	}

functionSMS_CHECK_SUCCESS{
/usr/local/bin/query_busdb4mo.py06252814
	}

functionSMS_CHECK_FAILED{
/usr/local/bin/query_busdb4mo.py06252815
	}

functionCONTRACT_CREATE_SUCCESS{
/usr/local/bin/query_busdb4mo.py06252816
	}

functionCONTRACT_CREATE_FAILED{
/usr/local/bin/query_busdb4mo.py06252817
	}

functionNOTIFIED_SHIPMENT_TO_HOMER{
/usr/local/bin/query_busdb4mo.py06252818
	}

functionNOTIFIED_DELIVERY_TO_HOMER{
/usr/local/bin/query_busdb4mo.py06252819
	}

functionNOTIFIED_CANCELLATION_TO_HOMER{
/usr/local/bin/query_busdb4mo.py06252820
	}

functionNOTIFIED_GOODS_RETURN_TO_HOMER{
/usr/local/bin/query_busdb4mo.py06252821
	}

functionORDER_PARTIALLY_CANCELLED_BY_CUSTOMER{
/usr/local/bin/query_busdb4mo.py06252822
	}

functionVERIFICATION_CALL_FOR_CUSTOMER{
/usr/local/bin/query_busdb4mo.py06252823
	}

functionORDER_TERMINATE_BY_CUSTOMER_IN_HCC{
/usr/local/bin/query_busdb4mo.py06252824
	}

$1
[root@zabbixzabbix]#

6. create configure file for this custom define.

[root@zabbixzabbix_agentd.conf.d]#cat$(pwd)/hcc_online.conf
UserParameter=hcc.initial,/home/zabbix/check_hcc_online.shORDER_CREATED
UserParameter=hcc.eligible,/home/zabbix/check_hcc_online.shELIGIBILITY_CHECK_PASSED
UserParameter=hcc.not_eligible,/home/zabbix/check_hcc_online.shELIGIBILITY_CHECK_FAILED
UserParameter=hcc.identity_valid,/home/zabbix/check_hcc_online.shIDENTITY_CHECK_PASSED
UserParameter=hcc.identity_invalid,/home/zabbix/check_hcc_online.shIDENTITY_CHECK_FAILED
UserParameter=hcc.contract_approved,/home/zabbix/check_hcc_online.shCONTRACT_APPROVED
UserParameter=hcc.shipment_notified,/home/zabbix/check_hcc_online.shNOTIFY_VENDOR_TO_DELIVER_GOODS
UserParameter=hcc.shipped,/home/zabbix/check_hcc_online.shVENDOR_FEED_BACK_THAT_GOODS_WAS_SHIPPED
UserParameter=hcc.disbursed,/home/zabbix/check_hcc_online.shDISBURSEMENT_TO_VENDOR
UserParameter=hcc.delivered,/home/zabbix/check_hcc_online.shCUSTOMER_RECEIVED_THE_GOODS
UserParameter=hcc.cancelled,/home/zabbix/check_hcc_online.shORDER_CANCELLED_BY_CUSTOMER
UserParameter=hcc.contract_cancelled,/home/zabbix/check_hcc_online.shCONTRACT_CANCELLED
UserParameter=hcc.rejected,/home/zabbix/check_hcc_online.shORDER_REJECTED
UserParameter=hcc.sms_check_success,/home/zabbix/check_hcc_online.shSMS_CHECK_SUCCESS
UserParameter=hcc.sms_check_failed,/home/zabbix/check_hcc_online.shSMS_CHECK_FAILED
UserParameter=hcc.contract_create_success,/home/zabbix/check_hcc_online.shCONTRACT_CREATE_SUCCESS
UserParameter=hcc.contract_create_failed,/home/zabbix/check_hcc_online.shCONTRACT_CREATE_FAILED
UserParameter=hcc.shipment_notified_homer,/home/zabbix/check_hcc_online.shNOTIFIED_SHIPMENT_TO_HOMER
UserParameter=hcc.delivery_notified_homer,/home/zabbix/check_hcc_online.shNOTIFIED_DELIVERY_TO_HOMER
UserParameter=hcc.cancellation_notified_homer,/home/zabbix/check_hcc_online.shNOTIFIED_CANCELLATION_TO_HOMER
UserParameter=hcc.goods_return_notified_homer,/home/zabbix/check_hcc_online.shNOTIFIED_GOODS_RETURN_TO_HOMER
UserParameter=hcc.partially_cancelled,/home/zabbix/check_hcc_online.shORDER_PARTIALLY_CANCELLED_BY_CUSTOMER
UserParameter=hcc.verification_call,/home/zabbix/check_hcc_online.shVERIFICATION_CALL_FOR_CUSTOMER
UserParameter=hcc.terminate,/home/zabbix/check_hcc_online.shORDER_TERMINATE_BY_CUSTOMER_IN_HCC
[root@zabbixzabbix_agentd.conf.d]#

7. test with zabbix_get

[root@zabbix zabbix_agentd.conf.d]# zabbix_get -s 127.0.0.1 -p 10050 -k 'hcc.initial'

545

[root@zabbix zabbix_agentd.conf.d]#


8.define the custom graph on zabbix surface.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同