danfaizer

#!/usr/bin/env ruby

# gem install aws-sdk
require 'aws-sdk'

access_key_id = ""
secret_access_key = ""

regions = ["eu-west-1", "sa-east-1", "us-east-1", "ap-northeast-1", "us-west-2", "us-west-1", "ap-southeast-1","sa-east-1"]
avoid_vpcs = ["vpc-51d9693a", "vpc-7784a01f", "vpc-4963702b", "vpc-d4e797bc", "vpc-8ff2eded", "vpc-c8845fad"]

danfaizer

import simplejson as json
import urllib
import urllib2
import base64
import sys

if len(sys.argv) == 6:
  url = 'http://'+sys.argv[1]+':2000/data/scsitarget/mappings/json_create_mapping'
  params = {"zvol": sys.argv[4], "igroup":"ABQ_INI", "tgroup":"ABQ_TG", "lun":int(sys.argv[5]) }
  data = urllib.urlencode(params)

danfaizer

#!/usr/bin/env ruby

require 'aws-sdk'

access_key_id = ""
secret_access_key = ""

iam = AWS::IAM.new(:access_key_id => access_key_id, :secret_access_key => secret_access_key )

STDOUT.write ("Disabling AWS API key: "+access_key_id+"  ...\n")

danfaizer

#!/usr/bin/ruby
#
# Authors: Abiquo Support Team
# Version: 1.0
# Last moodify: 2014-09-01
#
# Access dependencies:
# This script requires access to Abiquo API
#
# Dependencies:

danfaizer

# DD with progress bar (pv package required)
pv -tpreb myimage.img | sudo dd of=/dev/diskX bs=1m

# SSH port forwarding/tunneling
ssh -f -L local_port:destination_server:destination_port user@intermediate_server -N

# MySQL - Size per DB query
SELECT table_schema "DB name", sum( data_length + index_length ) / 1024 / 1024 "DB size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

# MySQL - Size per Table query

danfaizer

#!/bin/bash

echo "PSQL host:"
read host
echo $host
echo "PSQL user:"
read user
echo "PSQL pass:"
read pass
echo "PSQL db:"

danfaizer

#!/usr/bin/env python

import json
import time
import argparse

import boto.sqs
from termcolor import cprint