Zabbix监控apache与MySQL
来源：互联网 发布：淘宝买完东西店铺没了 编辑：程序博客网 时间：2024/06/14 11:54
Zabbix监控apache与MySQL
Apache
1. 上传check_apache/conf-apache.conf
#!/bin/bash## Name: zapache## Checks Apache activity.## Author: Alejandro Michavila# Modified for Scoreboard Values: Murat Koc, murat@profelis.com.tr# Modified for using also as external script: Murat Koc, murat@profelis.com.tr# Modified for outputting usage or ZBX_NOTSUPPORTED: Alejandro Michavila## Version: 1.4# zapachever="1.4"rval=0 function usage(){ echo "zapache version: $zapachever" echo "usage:" echo " $0 TotalAccesses -- Check total accesses." echo " $0 TotalKBytes -- Check total KBytes." echo " $0 Uptime -- Check uptime." echo " $0 ReqPerSec -- Check requests per second." echo " $0 BytesPerSec -- Check Bytes per second." echo " $0 BytesPerReq -- Check Bytes per request." echo " $0 BusyWorkers -- Check busy workers." echo " $0 IdleWorkers -- Check idle workers." echo " $0 version -- Version of this script." echo " $0 WaitingForConnection -- Check Waiting for Connection processess." echo " $0 StartingUp -- Check Starting Up processess." echo " $0 ReadingRequest -- Check Reading Request processess." echo " $0 SendingReply -- Check Sending Reply processess." echo " $0 KeepAlive -- Check KeepAlive Processess." echo " $0 DNSLookup -- Check DNSLookup Processess." echo " $0 ClosingConnection -- Check Closing Connection Processess." echo " $0 Logging -- Check Logging Processess." echo " $0 GracefullyFinishing -- Check Gracefully Finishing Processess." echo " $0 IdleCleanupOfWorker -- Check Idle Cleanup of Worker Processess." echo " $0 OpenSlotWithNoCurrentProcess -- Check Open Slots with No Current Process."} ######### Main ######### if [[ $# == 1 ]];then #Agent Mode VAR=$(wget --quiet -O - http://localhost/server-status?auto) CASE_VALUE=$1elif [[ $# == 2 ]];then #External Script Mode VAR=$(wget --quiet -O - http://$1/server-status?auto) CASE_VALUE=$2else #No Parameterusage exit 0fi if [[ -z $VAR ]]; thenecho "ZBX_NOTSUPPORTED" exit 1fi case $CASE_VALUE in'TotalAccesses') echo "$VAR"|grep "Total Accesses:"|awk '{print $3}' rval=$?;;'TotalKBytes') VER=$(echo "$VAR"|grep "Total kBytes:"|awk '{print $3}') MULT=$(($VER * 1024)) echo "$MULT" rval=$?;;'Uptime') echo "$VAR"|grep "Uptime:"|awk '{print $2}' rval=$?;;'ReqPerSec') echo "$VAR"|grep "ReqPerSec:"|awk '{print $2}' rval=$?;;'BytesPerSec') echo "$VAR"|grep "BytesPerSec:"|awk '{print $2}' rval=$?;;'BytesPerReq') echo "$VAR"|grep "BytesPerReq:"|awk '{print $2}' rval=$?;;'BusyWorkers') echo "$VAR"|grep "BusyWorkers:"|awk '{print $2}' rval=$?;;'IdleWorkers') echo "$VAR"|grep "IdleWorkers:"|awk '{print $2}'rval=$?;;'WaitingForConnection') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "_" } ; { print NF-1 }' rval=$?;;'StartingUp') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "S" } ; { print NF-1 }' rval=$?;;'ReadingRequest') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "R" } ; { print NF-1 }' rval=$?;;'SendingReply') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "W" } ; { print NF-1 }' rval=$?;;'KeepAlive') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "K" } ; { print NF-1 }' rval=$?;;'DNSLookup') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "D" } ; { print NF-1 }' rval=$?;;'ClosingConnection') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "C" } ; { print NF-1 }' rval=$?;;'Logging') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "L" } ; { print NF-1 }' rval=$?;;'GracefullyFinishing') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "G" } ; { print NF-1 }' rval=$?;;'IdleCleanupOfWorker') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "I" } ; { print NF-1 }' rval=$?;;'OpenSlotWithNoCurrentProcess') echo "$VAR"|grep "Scoreboard:"| awk '{print $2}'| awk 'BEGIN { FS = "." } ; {data_type>0 print NF-1 }' rval=$?;;'version') ApacheVersion=$(/usr/sbin/apachectl -v 2> /dev/null | head -n 1 | awk '{print $3}' | cut -d '/' -f 2 | tail -n 1) echo "$ApacheVersion" exit $rval;;*)usage exit $rval;;esac if [ "$rval" -ne 0 ]; then echo "ZBX_NOTSUPPORTED"fi exit $rvalUserParameter=apache[*],/usr/local/bin/zapache.sh \$1
2. #mvcheck_apache /usr/local/zabbix/bin
3. #chmod+x /usr/local/zabbix/bin/check_apache #授权可执行权限
4. 修改脚本#vim–n check_apache
按键128
Apacheversion=…修改正确的apache安装路径
5. 修改配置文件#vim/etc/zabbix_agentd.cof
启用并修改正确的zabbix路径：include=/usr/local/zabbix/etc/zabbix_agent.conf.d/*.conf
移动配置文件conf-apache.conf到zabbix_agent配置目录下#mv conf-apache.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/
修改此文件#vim /usr/local/zabix/etc/zabbix_agent.conf.d/conf-apache.conf
UserParameter=apache[*],/usr/local/zabbix/bin/check_apache \$1 //修改成正确路径
6. 配置httpd文件
#vim /etc/httpd/conf/httpd.conf
末尾添加
<IfModulemod_status.c>
#
# Allow server statusreports generated by mod_status,
# with the URL ofhttp://servername/server-status
# Uncomment and changethe "192.0.2.0/24" to allow access from other hosts.
#
<Location/server-status>
SetHandlerserver-status
Order deny,allow
Deny from all
Allow from127.0.0.1 ::1
Allow from192.168.0.0/24
</Location>
# Keep track ofextended status information for each request
ExtendedStatus On
# Determine ifmod_status displays the first 63 characters of a request or
# the last 63, assumingthe request itself is greater than 63 chars.
# Default: Off
#SeeRequestTail On
<IfModulemod_proxy.c>
# Show ProxyLoadBalancer status in mod_status
ProxyStatus On
</IfModule>
</IfModule>
重启服务#service httpd restart
7. 测试脚本是否正常#./check_apache –h
8. Zabbix前端界面操作
导入模版；配置-模版-选择模版-导入
<?xml version="1.0" encoding="UTF-8"?><zabbix_export> <version>2.0</version> <date>2015-03-19T15:46:48Z</date> <groups> <group> <name>Templates</name> </group> </groups> <templates> <template> <template>Template App Apache Service</template> <name>Template App Apache Service</name> <description/> <groups> <group> <name>Templates</name> </group> </groups> <applications> <application> <name>Apache</name> </application> </applications> <items> <item> <name>Apache: BytesPerReq.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[BytesPerReq]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>B</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: BytesPerSec.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[BytesPerSec]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>B</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: ClosingConnection.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[ClosingConnection]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: DNSLookup.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[DNSLookup]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: GracefullyFinishing.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[GracefullyFinishing]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: IdleCleanupOfWorker.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[IdleCleanupOfWorker]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: IdleWorkers.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[IdleWorkers]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: KeepAlive.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[KeepAlive]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: Logging.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[Logging]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: Number of running processes $1</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>proc.num[{$APACHE}]</key> <delay>30</delay> <history>90</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: OpenSlotWithNoCurrentProcess.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[OpenSlotWithNoCurrentProcess]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>1</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: ReadingRequest.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[ReadingRequest]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: ReqPerSec.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[ReqPerSec]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: SendingReply.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[SendingReply]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: StartingUp.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[StartingUp]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: TotalAccesses.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[TotalAccesses]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: TotalKBytes.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[TotalKBytes]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>B</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: Uptime.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[Uptime]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units>s</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: Used memory of $1</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>proc.mem[{$APACHE}]</key> <delay>30</delay> <history>90</history> <trends>365</trends> <status>0</status> <value_type>3</value_type> <allowed_hosts/> <units>B</units> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: Version.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[version]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>4</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> <item> <name>Apache: WaitingForConnection.</name> <type>0</type> <snmp_community/> <multiplier>0</multiplier> <snmp_oid/> <key>apache[WaitingForConnection]</key> <delay>60</delay> <history>7</history> <trends>365</trends> <status>0</status> <value_type>0</value_type> <allowed_hosts/> <units/> <delta>0</delta> <snmpv3_contextname/> <snmpv3_securityname/> <snmpv3_securitylevel>0</snmpv3_securitylevel> <snmpv3_authprotocol>0</snmpv3_authprotocol> <snmpv3_authpassphrase/> <snmpv3_privprotocol>0</snmpv3_privprotocol> <snmpv3_privpassphrase/> <formula>1</formula> <delay_flex/> <params/> <ipmi_sensor/> <data_type>0</data_type> <authtype>0</authtype> <username/> <password/> <publickey/> <privatekey/> <port/> <description/> <inventory_link>0</inventory_link> <applications> <application> <name>Apache</name> </application> </applications> <valuemap/> <logtimefmt/> </item> </items> <discovery_rules/> <macros> <macro> <macro>{$APACHE}</macro> <value>apache2</value> </macro> <macro> <macro>{$APACHE_PORT}</macro> <value>80</value> </macro> </macros> <templates/> <screens/> </template> </templates> <triggers> <trigger> <expression>{Template App Apache Service:proc.num[{$APACHE}].last(0)}=0</expression> <name>Apache: Process not running</name> <url/> <status>0</status> <priority>4</priority> <description/> <type>0</type> <dependencies/> </trigger> </triggers></zabbix_export>主机关联模版：点击对应的主机-添加-更新
MySQL
1. 进入MySQL数据库创建用户zabbix，并且给权限
Mysql>grant all on *.* to “zabbix-monitor”@”%” identified by ‘123456’
Mysql>flush privileges
Mysql>quit
2. 我使用的是zabbix自带的MySQL监控脚本
复制#cp/usr/local/src/zabbix-3.0.5/conf/zabbix_agentd/userparameter_mysl.conf /usr/local/zabbix/etc/zabbix_agentd.conf.d/
修改#vim /usr/local/zabbix/etc/zabbix_agentd.conf
启用并修改正确的路径
Include=/usr/local/zabbix/etc/zabbix_agentd.conf.d/*.conf
3. 建立数据库和zabbix的链接信息#vim /usr/local/zabbix/etc/.my.cnf
#Zabbix Agent
[mysql]
host=localhost
user=zabbix-monitor
password=123456
socket=/var/lib/mysql/mysql.sock
[mysqladmin]
host=localhost
user=zabbix-monitor
password=123456
socket= /var/lib/mysql/mysql.sock
:wq
4. 修改#vim/usr/local/zabbix/etc/zabbix_agentd.conf.d/userparameter_mysql.conf
将home=/var/lib/zabbix全部改成home=/usr/local/zabbix/etc/
5. 重启zabbix_agent服务#service zabbix_agentd restart
6. Zabbix前端配置
配置-模版-添加-更新
阅读全文
1 0
- Zabbix监控apache与MySQL
- zabbix监控mysql和apache
- zabbix监控Apache状态
- [Zabbix] Apache 监控
- Zabbix分布式监控(3)添加模版(Apache mysql)
- zabbix全面监控mysql
- MySQL监控软件zabbix
- Zabbix 2.4 监控 MySQL
- zabbix 监控 mysql
- ZABBIX监控MYSQL
- zabbix监控mysql客户端
- zabbix监控mysql
- 用zabbix监控mysql
- zabbix 监控 mysql
- zabbix监控mysql
- zabbix 配置mysql监控
- [Zabbix] MySQL 监控
- Zabbix配置mysql监控
- div垂直居中的方法！！
- XlistView展示
- 结合使用位置实参和任意数量实参
- 求两个字符串的（连续的）最长公共子串
- AtCoder Beginner Contest 071 D
- Zabbix监控apache与MySQL
- FZU
- [js]01semantic&vue&reqwest实现数据的展示
- Mysql 基础知识
- PHP编程实现阳历转换为阴历的方法实例
- JavaScript进阶：JS的全局变量和全局函数
- 定时任务quartz
- Qt5开发学习之文本编辑功能（七）
- 相对路径、绝对路径、mysql及jdbc基础
