Munin contributed plugins

=begin

netstat_bsd_m revision 1 (Feb 2012)

This plugin shows various statistics from 'netstat -m'

Required privileges: none

OS:

	Supposed: BSD

	Tested:   FreeBSD 8.2

Author: Artem Sheremet <dot.doom@gmail.com>

=end

  def escape

    self.gsub /[^\w]/, '_'

  end

  unless method_defined? :start_with?

    def start_with?(str)

      self[0...str.size] == str

    end

  end

  Hash[`netstat -m`.split($/).map { |line|

    if line =~ /^([\d\/K]+) (.*) \(([\w\/+]+)\)$/

      # 7891K/22385K/30276K bytes allocated to network (current/cache/total)

      values, desc, names = $1, $2, $3

      [desc, names.split('/').zip(values.split '/')] if filter.nil? or desc.escape == filter

    elsif line =~ /^(\d+) (.*)$/

      # 12327 requests for I/O initiated by sendfile

      value, desc = $1, $2

      [desc, [[:value, value]]] if filter.nil? or desc.escape == filter

    end

  }.compact]

  puts `uname -s`.include?('FreeBSD') ? 'yes' : 'no'

  puts netstat_m.keys.map(&:escape).join $/

  data = netstat_m(stat_name)

  if data.empty?

    warn "no data for <#{stat_name}>. Try running with 'suggest'"

  else

    desc, values = data.first

    stack = values.size > 1

    first = true

    puts <<~CONFIG

      graph_title Netstat: #{desc}

      graph_category network

      graph_vlabel current

      graph_order #{values.map { |name, _| name.to_s.escape }.join ' '}

    CONFIG

    puts values.map { |name, _|

      esc_name = name.to_s.escape

      "#{esc_name}.draw " + if %w(total max).include? name

                              'LINE'

                            elsif stack

                              if first

                                first = false

                                'AREA'

                              else

                                'STACK'

                              end

                            else

                              'LINE2'

      end + "\n#{esc_name}.label #{name}"

    }.join $/

  end

  data = netstat_m(stat_name)

  unless data.empty?

    puts data.first.last.map { |name, value|

      value = value.to_i * 1024 if value.end_with? 'K'

      "#{name.to_s.escape}.value #{value}"

    }.join $/

  end

  warn "unrecognized argument <#{ARGV.first}>"

  log_info = DEFAULT_CACHE

  begin

    log_info = YAML.load IO.read(CACHE_FILE)

  rescue

    log_info = DEFAULT_CACHE

  end

  if File.size(LOG_FILE) < log_info[:start]

    # logrotate?

    log_info = DEFAULT_CACHE

  end

  log_info = { :start => File.size(LOG_FILE) - 1 }

  puts 'Log reset'

  flog.seek(log_info[:start])

  new_data = flog.read

  # each element is an instance of Array. 1st item: error description, others: text to search log for

  ['EJAB-1482 Crash when waiting for item',

   ['wait_for_']],

  ['EJAB-1483 ODBC sup failure (wrong PID?)',

   ['ejabberd_odbc_sup']],

  ['EJAB-1483 ODBC sup wrong PID failure echo',

   ["mod_pubsub_odbc,'-unsubscribe"]],

  ['DNS failure',

   ['You should check your DNS configuration']],

  ['Database unavailable/too slow',

   ['Database was not available or too slow']],

  ['State machine terminated: timeout',

   ['State machine',

    'terminating',

    'Reason for',

    'timeout']],

  ['The auth module returned an error',

   ['The authentication module',

    'returned an error']],

  ['MySQL disconnected',

   ['mysql',

    'Received unknown signal, exiting']],

  ['Connecting to MySQL: failed',

   ['mysql',

    'Failed connecting to']],

  ['Timeout while running a hook',

   ['ejabberd_hooks',

    'timeout']],

  ['SQL transaction restarts exceeded',

   ['SQL transaction restarts exceeded']],

  ['Unexpected info',

   ['nexpected info']],

  ['Other sql_cmd timeout',

   ['sql_cmd']],

  ['System limit hit: ports', # check with length(erlang:ports())., set in ejabberdctl config file

   ['system_limit',

    'open_port']],

  ['Other system limit hit', # processes? check with erlang:system_info(process_count)., erlang:system_info(process_limit)., set in ejabberdctl cfg

   ['system_limit']],

  ['Generic server terminating',

   ['Generic server',

    'terminating']],

  ['Mnesia table shrinked',

   ['shrinking table']],

  ['Admin access failed',

   ['Access of',

    'failed with error']],

  ['MySQL sock timedout',

   ['mysql_',

    ': Socket',

    'timedout']],

  ['Configuration error',

   ['{badrecord,config}']],

  ['Strange vCard error (vhost)',

   ['error found when trying to get the vCard']],

  ['Mnesia is overloaded',

   ['Mnesia is overloaded']],

  ['MySQL: init failed recv data',

   ['mysql_conn: init failed receiving data']],

  ['TCP Error',

   ['Failed TCP']]

  KNOWN_LOG_TYPES.find_index { |entry|

    entry[1].all? { |substr| text.include? substr }

  }

  next if report.empty?

  report =~ /\A(\w+) REPORT==== (.*) ===\n(.*)\z/m

  type, time, text = $1, $2, $3

  next unless type and time and text

  log_info[type] = (log_info[type] || 0) + 1

  if sub_type = log_type(text)

    log_info[sub_type] = (log_info[sub_type] || 0) + 1

  elsif $debug_mode

    warn "Unparsed log entry #{type}: #{text} at #{time}"

  end

  puts <<~CONFIG

    graph_title Ejabberd Log

    graph_vlabel total

    graph_category chat

    graph_args -l 0

  CONFIG

  label, index = if log_type.is_a? Array

                   [log_type.first, index]

                 else

                   [log_type, log_type]

           end

  if ARGV.first == 'config'

    puts "T#{index}.label #{label}"

    puts "T#{index}.draw LINE"

  else

    puts "T#{index}.value #{log_info[index] or 0}"

  end

=begin

mongrel_memory - A munin plugin for OpenSolaris to monitor memory size of

                 each individual mongrel process

Copyright (C) 2009 Matthias Marschall - mm@agileweboperations.com

Based on:

mongrel_process_memory - A munin plugin to monitor memory size of

                         each individual mongrel process

Copyright (C) 2007 Ben VandenBos and Avvo, Inc.

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Author: Ben VandenBos

Contributors: Adam Jacob (<adam@hjksolutions.com>)

              Ryan Woodrum

              Matthias Marschall (mm@agileweboperations.com)

=end

        l =~ /-p (\d+)/

        h[pid] = $1 if $1

=begin

mongrel_process_memory - A munin plugin to monitor memory size of

                         each individual mongrel process

Copyright (C) 2007 Ben VandenBos and Avvo, Inc.

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Author: Ben VandenBos

Contributors: Adam Jacob (<adam@hjksolutions.com>)

              Ryan Woodrum

=end

      # I have no doubt that this is a terrible way of doing this.

        l =~ /-p (\d+)/

        h[p] = $1

  conf = { :host => '127.0.0.1', :port => 8000,

           :username => 'admin', :password => 'hackme' }

                        :http_basic_authentication => [conf[:username],

                                                       conf[:password]]))

    elem = data / key

  puts "graph_title Connected players"

  puts "graph_vlabel players"

  puts "players.label players"

  puts "graph_info Number of players connected to Minecraft"

  puts "graph_category games"

  exit

=begin

Plugin to monitor the number of connections blocked by moblock.

Requirements:

      Moblock up and running with generated log files going to /var/log/moblock

Parameters supported:

      config

      autoconf

Configurable variables

      logfile  - Override default moblock logfile

Magic markers

=end

def fetch(debug = false)

when 'config'

  config

when 'debug'

  fetch true

when 'autoconf'

  autoconf

else

  fetch

=begin

Munin Plugin for MSSQL - transaction monitoring

Author: Wilfred Chau <openapp.developer@gmail.com>

Date: 2011-05-18

Version: 1.0

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Prerequistes:

	1) /etc/odbc.ini and /etc/freetds.conf

	2) rubygems

	3) ruby-dbi

Usage:

	1) copy this script to the munin install plugins directory (e.g. /usr/share/munin/plugins)

	2) chmod to allow executable to others

	3) create symbolic link in /etc/munin/plugins

          ln -s /usr/share/munin/plugins/mssql_transaction.rb /etc/munin/plugins/mssql_transaction.rb

Parameters:

	autoconf

	config (required)

Config variables:

	sqluser : mssql user who has view server state privilege

	sqlpass : password for the mssql user

	dsn     : datasource name as defined in /etc/odbc.ini

	instance: instance to monitor

=end

dbh = DBI.connect("DBI:ODBC:#{dsn}", sqluser, sqlpass)

all_instance_names = Array.new

  all_instance_names.push(row[0].strip)

  if all_instance_names.length > 1 && sqluser.length > 1 && sqlpass.length > 1

    puts "yes"

  else

    puts "no"

    puts "Usage: #{__FILE__} autoconf|conf"

  end

  exit 0

  puts "graph_args --base 1000 -r --lower-limit 0"

  puts "graph_title MSSQL Transactions/s"

  puts "graph_category db"

  puts "graph_info This graph shows transactions/s"

  puts "graph_vlabel transactions/s"

  puts "graph_scale no"

  puts "graph_period second"

  all_instance_names.sort.each do |s|

    puts "#{s}.label #{s}"

    puts "#{s}.info INSTANCE: #{s}"

    puts "#{s}.type DERIVE"

    puts "#{s}.draw LINE1"

  end

  exit 0

  sth.execute(k)

  sth.fetch do |row|

    # since type is DERIVE, need to convert value to integer then to string

    puts "#{k.to_s}.value #{row[0].to_i.to_s}"

  end

=begin

Munin Plugin for MSSQL - Buffer cache hit ratio monitoring

Author: Wilfred Chau <openapp.developer@gmail.com>

Date: 2011-05-19

Version: 1.0

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Prerequistes:

	1) /etc/odbc.ini and /etc/freetds.conf

	2) rubygems

	3) ruby-dbi

Usage:

	1) copy this script to the munin install plugins directory (e.g. /usr/share/munin/plugins)

	2) chmod to allow executable to others

	3) create symbolic link in /etc/munin/plugins

           ln -s /usr/share/munin/plugins/mssql_buffercachehitratio.rb /etc/munin/plugins/mssql_buffercachehitratio.rb

Parameters:

	autoconf

	config (required)

Config variables:

	sqluser : mssql user who has view server state privilege

	sqlpass : password for the mssql user

	dsn     : datasource name as defined in /etc/odbc.ini

=end

dbh = DBI.connect("DBI:ODBC:#{dsn}", sqluser, sqlpass)

  if all_instance_names.length > 1 && sqluser.length > 1 && sqlpass.length > 1

    puts "yes"

  else

    puts "no"

    puts "Usage: #{__FILE__} autoconf|conf"

  end

  exit 0

  puts "graph_args --base 1000 -r --lower-limit 0"

  puts "graph_title MSSQL Buffer Cache Hit Ratio "

  puts "graph_category db"

  puts "graph_info This graph shows Buffer Cache Hit Ratio"

  puts "graph_vlabel %"

  puts "graph_scale no"

  puts "graph_period second"

  puts "bc_hitratio.label BufferCacheHitRatio"

  puts "bc_hitratio.info BufferCacheHitRatio"

  puts "bc_hitratio.type GAUGE"

  puts "bc_hitratio.draw LINE1"

  exit 0

  puts "bc_hitratio.value #{row[0].strip.to_s}"

=begin

Munin Plugin for MSSQL - Data file size monitoring

Author: Wilfred Chau <openapp.developer@gmail.com>

Date: 2011-05-19

Version: 1.0

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Prerequistes:

	1) /etc/odbc.ini and /etc/freetds.conf

	2) rubygems

	3) ruby-dbi

Usage:

	1) copy this script to the munin install plugins directory (e.g. /usr/share/munin/plugins)

	2) chmod to allow executable to others

	3) create symbolic link in /etc/munin/plugins

           ln -s /usr/share/munin/plugins/mssql_datafilesizes.rb /etc/munin/plugins/mssql_datafilesizes.rb

Parameters:

	autoconf

	config (required)

Config variables:

	sqluser : mssql user who has view server state privilege

	sqlpass : password for the mssql user

	dsn     : datasource name as defined in /etc/odbc.ini

	instance: instance to monitor

=end

dbh = DBI.connect("DBI:ODBC:#{dsn}", sqluser, sqlpass)

all_instance_names = Array.new

  all_instance_names.push(row[0].strip)

  if all_instance_names.length > 1 && sqluser.length > 1 && sqlpass.length > 1

    puts "yes"

  else

    puts "no"

    puts "Usage: #{__FILE__} autoconf|conf"

  end

  exit 0

  puts "graph_args --base 1024k -r --lower-limit 0"

  puts "graph_title MSSQL DB File Sizes"

  puts "graph_category db"

  puts "graph_info This graph shows DB File Sizes (MB)"

  puts "graph_vlabel MB"

  puts "graph_scale no"

  puts "graph_period second"

  all_instance_names.sort.each do |s|

    puts "#{s}.label #{s}"

    puts "#{s}.info INSTANCE: #{s}"

    puts "#{s}.type GAUGE"

    puts "#{s}.draw LINE1"

  end

  exit 0

  sth.execute(k)

  sth.fetch do |row|

    puts "#{k.to_s}.value #{row[0].to_s}"

  end

=begin

Munin Plugin for MSSQL - log files monitoring

Author: Wilfred Chau <openapp.developer@gmail.com>

Date: 2011-05-19

Version: 1.0

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License version 2

as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License along

with this program; if not, write to the Free Software Foundation, Inc.,

51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

Prerequistes:

	1) /etc/odbc.ini and /etc/freetds.conf

	2) rubygems

	3) ruby-dbi

Usage:

	1) copy this script to the munin install plugins directory (e.g. /usr/share/munin/plugins)

	2) chmod to allow executable to others

	3) create symbolic link in /etc/munin/plugins

           ln -s /usr/share/munin/plugins/mssql_logfilesizes.rb /etc/munin/plugins/mssql_logfilesizes.rb

Parameters:

	autoconf

	config (required)

Config variables:

	sqluser : mssql user who has view server state privilege

	sqlpass : password for the mssql user

	dsn     : datasource name as defined in /etc/odbc.ini

	instance: instance to monitor

=end

dbh = DBI.connect("DBI:ODBC:#{dsn}", sqluser, sqlpass)

all_instance_names = Array.new

  all_instance_names.push(row[0].strip)

  if all_instance_names.length > 1 && sqluser.length > 1 && sqlpass.length > 1

    puts "yes"

  else

    puts "no"

    puts "Usage: #{__FILE__} autoconf|conf"

  end

  exit 0

  puts "graph_args --base 1024k -r --lower-limit 0"

  puts "graph_title MSSQL DB Log File Sizes"

  puts "graph_category db"

  puts "graph_info This graph shows DB Log File Sizes (MB)"

  puts "graph_vlabel MB"

  puts "graph_scale no"

  puts "graph_period second"

  all_instance_names.sort.each do |s|

    puts "#{s}.label #{s}"

    puts "#{s}.info INSTANCE: #{s}"

    puts "#{s}.type GAUGE"

    puts "#{s}.draw LINE1"

  end

  exit 0

  sth.execute(k)