Skip to content

Instantly share code, notes, and snippets.

WSGISocketPrefix /var/run/httpd
<VirtualHost *:80>
ServerName graphite.test.com
DocumentRoot /opt/graphite/webapp
WSGIDaemonProcess graphite processes=5 threads=5 display-name='%{GROUP}' inactivity-timeout=120
WSGIProcessGroup graphite
WSGIApplicationGroup %{GLOBAL}
@cixelsyd
cixelsyd / restoredb.rb
Created December 17, 2011 21:03
"restoredb.rb" restores/refreshes MSSQL databases from data bag settings
#
# Cookbook Name:: smashrun
# Recdbe:: restoredb
#
# Copyright 2010, Smashrun, Inc.
# Author:: Steven Craig <support@smashrun.com>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
→ DEBUG=true sfn describe tc3-dr
ERROR: Miasma::Error::ApiError::RequestError: Forbidden
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-0.2.30/lib/miasma/types/api.rb:114:in `block in request'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/bogo-0.1.30/lib/bogo/retry.rb:65:in `call'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/bogo-0.1.30/lib/bogo/retry.rb:65:in `run!'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-0.2.30/lib/miasma/types/api.rb:136:in `retryable_request'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-0.2.30/lib/miasma/types/api.rb:111:in `request'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-aws-0.1.26/lib/miasma-aws/api/sts.rb:31:in `assume_role'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-aws-0.1.26/lib/miasma/contrib/aws.rb:474:in `sts_assume_role!'
/Users/craigs/.rvm/gems/ruby-2.0.0-p643/gems/miasma-aws-0.1.26/lib/miasma/contrib/aws.rb:405:in `custom_setup'
@cixelsyd
cixelsyd / backupdb-trans-backup.sql.erb
Created December 17, 2011 21:29
"backupdb.rb" recipe needs templated T-SQL script to backup database translogs
--
-- Author:: <%= @author_name %> / <%= @author_email %>
-- Cookbook Name:: smashrun
-- Templates:: <%= @basesql_template %>
--
-- Copyright 2010, Smashrun, Inc.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
@cixelsyd
cixelsyd / backupdb-full-backup.sql.erb
Created December 17, 2011 21:27
"backupdb.rb" recipe needs templated T-SQL scripts to backup databases
--
-- Author:: <%= @author_name %> / <%= @author_email %>
-- Cookbook Name:: smashrun
-- Templates:: <%= @basesql_template %>
--
-- Copyright 2010, Smashrun, Inc.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
@cixelsyd
cixelsyd / createdb-execute_sql.bat.erb
Created December 17, 2011 21:21
"createdb.rb" recipe needs a templated batch file to execute arbitrary T-SQL
:: chef template <%= @executesql_template %>
:: becomes "<%= @executesql_bat %>" on the server
:: generic execute sql wrapper - <%= @author_name %> / <%= @author_email %>
:: requires chef / internet connectivity to opsware git repo
:: initial version 2011:09:19 15:01:00 EST
:: pass SQL sa passwd as ARG1
:: pass SQL script as ARG2
:: pass SQL logfile as ARG3
@cixelsyd
cixelsyd / createdb-create.sql.erb
Created December 17, 2011 21:22
"createdb.rb" recipe needs a templated T-SQL script to create databases
--
-- Author:: <%= @author_name %> / <%= @author_email %>
-- Cookbook Name:: windows
-- Templates:: <%= @basesql_template %>
--
-- Copyright 2010, Smashrun, Inc.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
@cixelsyd
cixelsyd / restoredb.rb
Created December 17, 2011 21:06
"restoredb.rb" restores/refreshes MSSQL databases from data bag settings
#
# Cookbook Name:: smashrun
# Attributes:: restoredb
#
# Copyright 2010, Smashrun, Inc.
# Author:: Steven Craig <support@smashrun.com>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
@cixelsyd
cixelsyd / rsyncdb.rb
Created December 17, 2011 20:54
"rsyncdb.rb" zips and moves backups from settings inside data bags
#
# Cookbook Name:: smashrun
# Recipe:: rsyncdb
#
# Copyright 2010, Smashrun, Inc.
# Author:: Steven Craig <support@smashrun.com>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
@cixelsyd
cixelsyd / backupdb.rb
Created December 17, 2011 20:42
"backupdb.rb" is the main recipe inside of a larger "backupdb" role
#
# Cookbook Name:: smashrun
# Attributes:: backupdb
#
# Copyright 2010, Smashrun, Inc.
# Author:: Steven Craig <support@smashrun.com>
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at