manuthu

# Get all running routers. Routers in cloudstack are prefixed with `r-DIGIT`
RUNNING_VMS=$(xe vm-list | grep -A2 -B2 'r-[0-9]' | grep uuid | awk -F':' '{print $2}')
SRID=8c269040-fc42-c12d-b091-8958784ec65e

for vm_id in $RUNNING_VMS
do
  xe vbd-list vm-uuid=$vm_id | grep vdi-uuid | awk -F':' '{print $2}' | xargs -I {} xe vdi-list uuid={} | grep $SRID  && echo $vm_id
done

manuthu

Install PostgreSQL 10 on Ubuntu

This is a quick guide to install PostgreSQL 10 - tested on Ubuntu 16.04 but likely can be used for Ubuntu 14.04 and 17.04 as well, with one minor modification detailed below.

(Optional) Uninstall other versions of postgres

To make life simple, remove all other versions of Postgres. Obviously not required, but again, makes life simple.

dpkg -l | grep postgres

manuthu

References

• have fun with them
• projections
• filters
• resource-keys
• scripting-gcloud
• gcloud alpha interactive
• https://medium.com/@Joachim8675309/getting-started-with-gcloud-sdk-part-1-114924737
• https://medium.com/@Joachim8675309/getting-started-with-gcloud-sdk-part-2-4d049a656f1a
• https://gist.github.com/bborysenko/97749fe0514b819a5a87611e6aea3db8

manuthu

#!/opt/venv/ipblock/env/bin/python
__author__ = 'Mike Manuthu <[email protected]>'
"""
A simple script to disable the number of connections to the server.
Uses IPTables to block the IPS with more than the threshold connections.

Uses Fail2Ban as the default IP Blocker.

usage: IP Blocker ::  [-h] [-i IP] [-I IPRANGE] [-c CONNECTIONS] [-B]
                      [-f FREQUENCY]

manuthu

#!/root/env/bin/python
import argparse
import iptc
import logging
import time

from bash import bash
from ipwhois import IPWhois

manuthu

import logging
import json

from flask import Flask, current_app, jsonify
from flask import request

logging.basicConfig(level=logging.DEBUG)

app = Flask(__name__)

manuthu

# Based on http://techspot.zzzeek.org/2011/01/14/the-enum-recipe/

import six
from sqlalchemy.dialects import postgresql
from sqlalchemy.types import SchemaType, TypeDecorator, Enum
from sqlalchemy import __version__, text, cast
import re

if __version__ < '0.6.5':
    raise NotImplementedError("Version 0.6.5 or higher of SQLAlchemy is required.")

manuthu

View running domains

➜  ~ virsh list --all
 Id    Name                           State
----------------------------------------------------
 15    compute.local                  running
 16    storage.local                  running

manuthu

~: vagrant ssh-config
Host webserver1
  HostName 127.0.0.1
  User vagrant
  Port 2222
  UserKnownHostsFile /dev/null
  StrictHostKeyChecking no
  PasswordAuthentication no
  IdentityFile /Users/Mike/projects/sandbox/haproxylab/.vagrant/machines/webserver1/virtualbox/private_key
  IdentitiesOnly yes

manuthu

"""
Generate a server.key and server.cert.
    
    >> mike:tmp$ openssl req  -nodes -new -x509  -keyout server.key -out server.cert

Combine the generated keys.

    >> mike:tmp$ cat server.key server.cert > server.pem

Now run the script