DuckCorp » DuckCorp Infrastructure » Zabbix Configs

UserParameter=vfs.dev.discovery,list= ;for disk in $(ls /dev/[hsv]d[a-z] 2>/dev/null); do list=$list',{"{#DISK}":"'$disk'"}'; done; echo '{"data":['${list#,}']}'

UserParameter=vfs.dev.sector_size[*],cat /sys/block/$$(echo "$1" | tr -d "/.")/queue/hw_sector_size

UserParameter=random.poolsize,cat /proc/sys/kernel/random/poolsize

UserParameter=random.entropy_available,cat /proc/sys/kernel/random/entropy_avail

UserParameter=smart.phydev.ata.discovery,list= ; while read line; do disk=$(echo $line | cut -d: -f1); list=$list',{"{#DISK}":"'$disk'"}'; done </etc/zabbix/smart_phydev_ata; echo '{"data":['${list#,}']}'

UserParameter=smart.phydev.ata.attr[*],sudo /usr/local/sbin/stat_smart_ata "$1" "$2"

UserParameter=smart.phydev.sas.discovery,list= ; while read line; do disk=$(echo $line | cut -d: -f1); list=$list',{"{#DISK}":"'$disk'"}'; done </etc/zabbix/smart_phydev_sas; echo '{"data":['${list#,}']}'

UserParameter=smart.phydev.sas.attr[*],sudo /usr/local/sbin/stat_smart_sas "$1" "$2"

UserParameter=3ware.units.disco,sudo /usr/local/sbin/stat_3ware_units_disco

UserParameter=3ware.unit.status[*],sudo /usr/local/sbin/stat_3ware_unit_status "$1"

UserParameter=bind9.stats[*],/usr/local/sbin/stat_bind9 "$1"

UserParameter=postfix.queue_size[*],sudo stat_postfix_queue_size $1

UserParameter=apache.status[*],/usr/local/sbin/stat_apache "$1"

UserParameter=mysql.status[*],/usr/local/sbin/stat_mysql_status "$1"

UserParameter=mysql.variables[*],/usr/local/sbin/stat_mysql_variables "$1"

UserParameter=mysql.ping,mysqladmin --defaults-file=/etc/mysql/debian.cnf ping | grep alive | wc -l

UserParameter=openldap.stats[*],sudo /usr/local/sbin/stat_openldap "$1"

UserParameter=proftpd.users.num,NB=$(ftpwho | grep -E 'users?$' | sed -r 's/^.*([0-9]+) users?/\1/'); echo ${NB:-0}

UserParameter=ntpd.stat[*],/usr/local/sbin/stat_ntpd $1

#!/bin/sh

UNIT=${1:-noexistent}

STATE=$(tw_cli "${UNIT}" show | grep -E "^u[0-9]+ " | awk '{print $3}')

if [ "${STATE}" = "OK" ]; then

echo 1

else

echo 0

fi

#!/bin/sh

list=

for CONTROLLER in $(tw_cli show | grep -E "^c[0-9]+" | cut -f1 -d" "); do

for UNIT in $(tw_cli /${CONTROLLER} show | grep -E "^u[0-9]+" | cut -f1 -d" "); do

list=$list',{"{#UNIT}":"'/${CONTROLLER}/${UNIT}'"}'

done

done

echo '{"data":['${list#,}']}'

#!/bin/bash

# Get list of Database Name which you want to monitor.

# The default settings are excepted template databases(template0/template1).

#

# :Example

#

# If you want to monitor "foo" and "bar" databases, you set the GETDB as

# GETDB="select datname from pg_database where datname in ('foo','bar');"

GETDB="select datname from pg_database where datistemplate = 'f';"

for dbname in $(psql -q -A -d $4 -t -c "${GETDB}"); do

dblist="$dblist,"'{"{#DBNAME}":"'$dbname'"}'

done

echo '{"data":['${dblist#,}' ]}'

#!/bin/bash

# This low level discovery rules are disabled by deafult.

# For using this rules, you set the status to enable from

# [Configuration]->[Hosts]->[Discovery]->[DB and Table Name List]

# at Zabbix WEB.

# Get list of Database Name which you want to monitor.

# The default settings are excepted template databases(template0/template1).

#

# :Customize Example

#

# For "foo" and "bar" databases, set the GETDB as

# GETDB="select datname from pg_database where datname in ('foo','bar');"

GETDB="select datname from pg_database where datistemplate = 'f';"

# Get List of Table Name

# Using the default setting, Zabbix make a discovery "ALL" user tables.

# If you want to specify the tables, you can change the $GETTABLE query.

#

# :Customize Example

#

# For pgbench tables, set the GETTABLE as

#GETTABLE="select \

# row_to_json(t) \

# from (

# select current_database() as "{#DBNAME}\",schemaname as \"{#SCHEMANAME}\",tablename as \"{#TABLENAME}\" \

# from \

# pg_tables \

# where \

# schemaname not in ('pg_catalog','information_schema') \

# and \

# tablename in ('pgbench_accounts','pgbench_branches','pgbench_history','pgbench_tellers') \

# ) as t"

GETTABLE="select row_to_json(t) from (select current_database() as \"{#DBNAME}\",schemaname as \"{#SCHEMANAME}\",tablename as \"{#TABLENAME}\" from pg_tables where schemaname not in ('pg_catalog','information_schema')) as t"

for dbname in $(psql -q -A -d $4 -t -c "${GETDB}"); do

for tablename in $(psql -q -A -d $dbname -t -c "${GETTABLE}"); do

dblist="$dblist,"$tablename

done

done

echo '{"data":['${dblist#,}' ]}'

#!/bin/sh

DEV=${1:-noexistent}

ATTR=${2:-noexistent}

opts=$(grep "^$1:" /etc/zabbix/smart_phydev_ata | cut -d: -s -f 2)

CACHE_FILE=/tmp/zbx-smart_ata_${DEV}

test -z `/usr/bin/find ${CACHE_FILE} -mmin -5 2>/dev/null` && \

smartctl -A $opts >"${CACHE_FILE}"

cat "${CACHE_FILE}" | awk -vval="${ATTR}" '{ if ($2 == val) { print $10 } }'

#!/bin/sh

DEV=${1:-noexistent}

ATTR=${2:-noexistent}

opts=$(grep "^$1:" /etc/zabbix/smart_phydev_sas | cut -d: -s -f 2)

CACHE_FILE=/tmp/zbx-smart_sas_${DEV}

test -z `/usr/bin/find ${CACHE_FILE} -mmin -5 2>/dev/null` && \

smartctl -A $opts >"${CACHE_FILE}"

cat "${CACHE_FILE}" | perl -ne "print \$1 if m/^${ATTR}:\s+([\d.]+)/"

<?xml version="1.0" encoding="UTF-8"?>

<zabbix_export>

<version>2.0</version>

<date>2015-02-12T23:37:39Z</date>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<templates>

<template>

<template>Template App Backup Bacula-Dir</template>

<name>Template App Backup Bacula-Dir</name>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<applications>

<application>

<name>Bacula</name>

</application>

</applications>

<items>

<item>

<name>Number of running processes bacula-dir</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>proc.num[bacula-dir]</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>Bacula</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

</items>

<discovery_rules/>

<macros/>

<templates/>

<screens/>

</template>

</templates>

<triggers>

<trigger>

<expression>{Template App Backup Bacula-Dir:proc.num[bacula-dir].last(0)}&lt;1</expression>

<name>Bacula-Dir is not running on {HOSTNAME}</name>

<url/>

<status>0</status>

<priority>4</priority>

<description/>

<type>0</type>

<dependencies/>

</trigger>

</triggers>

</zabbix_export>

<?xml version="1.0" encoding="UTF-8"?>

<zabbix_export>

<version>2.0</version>

<date>2015-02-12T23:40:12Z</date>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<templates>

<template>

<template>Template App Backup Bacula-FD</template>

<name>Template App Backup Bacula-FD</name>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<applications>

<application>

<name>Bacula</name>

</application>

</applications>

<items>

<item>

<name>Number of running processes bacula-fd</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>proc.num[bacula-fd]</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>Bacula</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

</items>

<discovery_rules/>

<macros/>

<templates/>

<screens/>

</template>

</templates>

<triggers>

<trigger>

<expression>{Template App Backup Bacula-FD:proc.num[bacula-fd].last(0)}&lt;1</expression>

<name>Bacula-FD is not running on {HOSTNAME}</name>

<url/>

<status>0</status>

<priority>4</priority>

<description/>

<type>0</type>

<dependencies/>

</trigger>

</triggers>

</zabbix_export>

<?xml version="1.0" encoding="UTF-8"?>

<zabbix_export>

<version>2.0</version>

<date>2015-02-12T23:40:44Z</date>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<templates>

<template>

<template>Template App Backup Bacula-SD</template>

<name>Template App Backup Bacula-SD</name>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<applications>

<application>

<name>Bacula</name>

</application>

</applications>

<items>

<item>

<name>Number of running processes bacula-sd</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>proc.num[bacula-sd]</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>Bacula</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

</items>

<discovery_rules/>

<macros/>

<templates/>

<screens/>

</template>

</templates>

<triggers>

<trigger>

<expression>{Template App Backup Bacula-SD:proc.num[bacula-sd].last(0)}&lt;1</expression>

<name>Bacula-SD is not running on {HOSTNAME}</name>

<url/>

<status>0</status>

<priority>4</priority>

<description/>

<type>0</type>

<dependencies/>

</trigger>

</triggers>

</zabbix_export>

<?xml version="1.0" encoding="UTF-8"?>

<zabbix_export>

<version>2.0</version>

<date>2015-02-12T23:45:35Z</date>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<templates>

<template>

<template>Template App DNS Bind9</template>

<name>Template App DNS Bind9</name>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<applications>

<application>

<name>Bind9</name>

</application>

</applications>

<items>

<item>

<name>Bind9 IPv4 requests</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[ipv4]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 IPv6 requests</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[ipv6]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 NXDOMAIN answers</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[nxdomain]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 NXRRSET answers</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[nxrrset]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 recursions</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[recursion]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 referrals</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[referral]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Bind9 successful answers</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>bind9.stats[success]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>Number of running processes named</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>proc.num[named]</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>Bind9</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

</items>

<discovery_rules/>

<macros/>

<templates/>

<screens>

<screen>

<name>Bind</name>

<hsize>2</hsize>

<vsize>1</vsize>

<screen_items>

<screen_item>

<resourcetype>0</resourcetype>

<width>500</width>

<height>100</height>

<x>0</x>

<y>0</y>

<colspan>1</colspan>

<rowspan>1</rowspan>

<elements>0</elements>

<valign>0</valign>

<halign>0</halign>

<style>0</style>

<url/>

<dynamic>0</dynamic>

<sort_triggers>0</sort_triggers>

<resource>

<name>Bind9 requests protocol</name>

<host>Template App DNS Bind9</host>

</resource>

<application/>

</screen_item>

<screen_item>

<resourcetype>0</resourcetype>

<width>500</width>

<height>100</height>

<x>1</x>

<y>0</y>

<colspan>1</colspan>

<rowspan>1</rowspan>

<elements>0</elements>

<valign>0</valign>

<halign>0</halign>

<style>0</style>

<url/>

<dynamic>0</dynamic>

<sort_triggers>0</sort_triggers>

<resource>

<name>Bind9 replies</name>

<host>Template App DNS Bind9</host>

</resource>

<application/>

</screen_item>

</screen_items>

</screen>

</screens>

</template>

</templates>

<triggers>

<trigger>

<expression>{Template App DNS Bind9:proc.num[named].last(0)}&lt;1</expression>

<name>Named is not running on {HOSTNAME}</name>

<url/>

<status>0</status>

<priority>4</priority>

<description/>

<type>0</type>

<dependencies/>

</trigger>

</triggers>

<graphs>

<graph>

<name>Bind9 replies</name>

<width>900</width>

<height>200</height>

<yaxismin>0.0000</yaxismin>

<yaxismax>100.0000</yaxismax>

<show_work_period>0</show_work_period>

<show_triggers>1</show_triggers>

<type>0</type>

<show_legend>1</show_legend>

<show_3d>0</show_3d>

<percent_left>0.0000</percent_left>

<percent_right>0.0000</percent_right>

<ymin_type_1>1</ymin_type_1>

<ymax_type_1>0</ymax_type_1>

<ymin_item_1>0</ymin_item_1>

<ymax_item_1>0</ymax_item_1>

<graph_items>

<graph_item>

<sortorder>2</sortorder>

<drawtype>0</drawtype>

<color>EE0000</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[nxdomain]</key>

</item>

</graph_item>

<graph_item>

<sortorder>3</sortorder>

<drawtype>0</drawtype>

<color>0000DD</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[recursion]</key>

</item>

</graph_item>

<graph_item>

<sortorder>0</sortorder>

<drawtype>0</drawtype>

<color>009900</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[success]</key>

</item>

</graph_item>

<graph_item>

<sortorder>1</sortorder>

<drawtype>0</drawtype>

<color>BB00BB</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[nxrrset]</key>

</item>

</graph_item>

<graph_item>

<sortorder>4</sortorder>

<drawtype>0</drawtype>

<color>9999FF</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[referral]</key>

</item>

</graph_item>

</graph_items>

</graph>

<graph>

<name>Bind9 requests protocol</name>

<width>900</width>

<height>200</height>

<yaxismin>0.0000</yaxismin>

<yaxismax>100.0000</yaxismax>

<show_work_period>0</show_work_period>

<show_triggers>0</show_triggers>

<type>1</type>

<show_legend>1</show_legend>

<show_3d>0</show_3d>

<percent_left>0.0000</percent_left>

<percent_right>0.0000</percent_right>

<ymin_type_1>1</ymin_type_1>

<ymax_type_1>0</ymax_type_1>

<ymin_item_1>0</ymin_item_1>

<ymax_item_1>0</ymax_item_1>

<graph_items>

<graph_item>

<sortorder>1</sortorder>

<drawtype>1</drawtype>

<color>0000EE</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[ipv4]</key>

</item>

</graph_item>

<graph_item>

<sortorder>0</sortorder>

<drawtype>1</drawtype>

<color>00DD00</color>

<yaxisside>0</yaxisside>

<calc_fnc>2</calc_fnc>

<type>0</type>

<item>

<host>Template App DNS Bind9</host>

<key>bind9.stats[ipv6]</key>

</item>

</graph_item>

</graph_items>

</graph>

</graphs>

</zabbix_export>

<?xml version="1.0" encoding="UTF-8"?>

<zabbix_export>

<version>2.0</version>

<date>2015-02-12T23:41:04Z</date>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<templates>

<template>

<template>Template App Database MySQL</template>

<name>Template App Database MySQL</name>

<groups>

<group>

<name>GNU/Linux servers</name>

</group>

<group>

<name>Servers</name>

</group>

<group>

<name>Templates</name>

</group>

</groups>

<applications>

<application>

<name>MySQL</name>

</application>

</applications>

<items>

<item>

<name>MySQL all queries</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Queries]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL connections aborted</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Aborted_clients]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL connections attempted</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Connections]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL connections failed</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Aborted_connects]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL DELETE statements</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Com_delete]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL INSERT statements</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Com_insert]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL INSERT…SELECT statements</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Com_insert_select]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL LOAD statements</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Com_load]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</allowed_hosts>

<units/>

<delta>1</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>0</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>MySQL</name>

</application>

</applications>

<valuemap/>

<logtimefmt/>

</item>

<item>

<name>MySQL max concurrent connections</name>

<type>0</type>

<snmp_community/>

<multiplier>0</multiplier>

<snmp_oid/>

<key>mysql.status[Max_used_connections]</key>

<delay>300</delay>

<history>7</history>

<trends>365</trends>

<status>0</status>

<value_type>3</value_type>

<allowed_hosts>localhost</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>0</formula>

<delay_flex/>

<params/>

<ipmi_sensor/>

<data_type>0</data_type>

<authtype>0</authtype>

<username/>

<password/>

<publickey/>

<privatekey/>