Skip to content
This repository has been archived by the owner on Jul 11, 2020. It is now read-only.

Commit

Permalink
Run postgres connectivity checks from the app servers
Browse files Browse the repository at this point in the history
Sam Kottler committed Sep 1, 2014

Verified

This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
1 parent 2e663e0 commit 67650ae
Showing 5 changed files with 17 additions and 6 deletions.
2 changes: 1 addition & 1 deletion cookbooks/rubygems-sensu/metadata.rb
Original file line number Diff line number Diff line change
@@ -1,7 +1,7 @@
name 'rubygems-sensu'
maintainer 'RubyGems.org ops team'

version '0.0.83'
version '0.0.95'

depends 'chef-vault'
depends 'cpan'
15 changes: 13 additions & 2 deletions cookbooks/rubygems-sensu/recipes/database.rb
Original file line number Diff line number Diff line change
@@ -2,6 +2,17 @@
# Cookbook Name:: rubygems-sensu
# Recipe:: database
#
if node.chef_environment == 'common'
search_environment = 'production'
else
search_environment = node.chef_environment
end

host = data_bag_item('hosts', 'database')['environments'][search_environment]
db_host = search('node', "name:#{host}.#{search_environment}.rubygems.org")[0]
secrets = chef_vault_item('rubygems', search_environment)

db_connection = "-H #{db_host['ipaddress']} --dbuser=#{secrets['rails_postgresql_user']} --dbpass=#{db_host['postgresql']['password']['postgres']} -db rubygems_#{search_environment}"

sensu_check 'check_postgres_proc' do
command "/opt/sensu/embedded/bin/ruby /etc/sensu/plugins/check-procs.rb -p 'postgres -D'"
@@ -12,9 +23,9 @@
end

sensu_check 'check_postgres_connection' do
command "perl /etc/sensu/plugins/check_postgres.pl --action connection -db rubygems_#{node.chef_environment}"
command "perl /etc/sensu/plugins/check_postgres.pl --action connection #{db_connection}"
handlers ['slack', 'pagerduty']
subscribers ['database']
subscribers ['app']
interval 30
additional(occurrences: 3)
end
2 changes: 1 addition & 1 deletion environments/common.json
Original file line number Diff line number Diff line change
@@ -25,7 +25,7 @@
"rubygems-people": "= 0.0.29",
"rubygems-redis": "= 0.0.5",
"rubygems-repo": "= 0.0.26",
"rubygems-sensu": "= 0.0.83",
"rubygems-sensu": "= 0.0.95",
"rubygems-ssh": "= 0.0.5",
"rubygems-utility": "= 0.0.4"
},
2 changes: 1 addition & 1 deletion environments/production.json
Original file line number Diff line number Diff line change
@@ -25,7 +25,7 @@
"rubygems-people": "= 0.0.29",
"rubygems-redis": "= 0.0.5",
"rubygems-repo": "= 0.0.26",
"rubygems-sensu": "= 0.0.83",
"rubygems-sensu": "= 0.0.95",
"rubygems-ssh": "= 0.0.5",
"rubygems-utility": "= 0.0.4"
},
2 changes: 1 addition & 1 deletion environments/staging.json
Original file line number Diff line number Diff line change
@@ -25,7 +25,7 @@
"rubygems-people": "= 0.0.29",
"rubygems-redis": "= 0.0.5",
"rubygems-repo": "= 0.0.26",
"rubygems-sensu": "= 0.0.83",
"rubygems-sensu": "= 0.0.95",
"rubygems-ssh": "= 0.0.5",
"rubygems-utility": "= 0.0.4"
},

0 comments on commit 67650ae

Please sign in to comment.