ffeast

# a handy one-liner to print out sql queries if you wouldn't like to enable
# queries logging in mysql server itself
tcpdump -i lo -s 0 -l -w - dst port 3306 | strings | perl -e '
while(<>) { chomp; next if /^[^ ]+[ ]*$/;
  if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) {
    if (defined $q) { print "$q\n\n"; }
    $q=$_;
  } else {
    $_ =~ s/^[ \t]+//; $q.=" $_";
  }

ffeast

 redis-benchmark -n 1000000 -r 1000000 -q -P 32 zadd zset __rand_int__ __rand_int__

ffeast

# https://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection
SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'database_name'

ffeast

# https://stackoverflow.com/questions/10175812/how-to-create-a-self-signed-certificate-with-openssl
openssl req -x509 -nodes -newkey rsa:4096 -keyout key.pem -out cert.pem -days 365

ffeast

import logging
import sys

# Traces what's updating the logging configuration
# https://stackoverflow.com/questions/28694540/python-default-logger-disabled

def get_disabled(self):
    return self._disabled

def set_disabled(self, disabled):

ffeast

	 	 	 	
nginx version: nginx/1.4.6 (Ubuntu)

# 1. passwords
both password are ‘123’ passed through openssl passwd
# cat /etc/nginx/default.htpasswd
# default:ZE3exsFczUZUY

# cat /etc/nginx/test.htpasswd
# test:ZE3exsFczUZUY

ffeast

from suds.sudsobject import Object as SudsObject

obj = SudsObject()
obj.Title = "My title"
obj.JustAList = [1, 2, 3]
obj.Child = SudsObject()
obj.Child.Title = "Child title"
obj.Child.AnotherList = ["4", "5", "6"]

child_obj = SudsObject()

ffeast

echo '{"json":"obj"}' | python -m json.tool

ffeast

/* run \. /tmp/mysql_victims.txt after executing this query */
SELECT
  concat('KILL ', id, ';') 
FROM
  information_schema.processlist
WHERE
  user='victim' AND time > 60
INTO OUTFILE '/tmp/mysql_victims.txt';

ffeast

# borrowed from http://stackoverflow.com/questions/32324120/arbitrary-host-name-resolution-in-ansible
# might be used as {{ lookup('ip', 'www.google.com') }}
import socket
import ansible.errors as errors


class LookupModule(object):

    def __init__(self, basedir=None, **kwargs):
        self.basedir = basedir