utdrmac

/* 
 * guider 1.0
 * Matthew Boehm <mboehm@paypal.com> <matthew@matthewboehm.com>
 *
 * GUIDer reads in a file of global identifiers (GUIDs) and retrieves
 * obfuscated data out of databases. This is done using pipe() to create
 * a producer/consumer set-up. We create a pool of mysql connections
 * and pthread out user-supplied number of threads to handle data.
 * Each thread waits and reads 1 GUID off the front of the pipe() and processes
 * it, outputting results to stdout. Once done with that set of queries, this

utdrmac

SELECT t.table_schema, t.engine, t.table_name, c.column_name, c.column_type
FROM information_schema.tables AS t 
INNER JOIN information_schema.columns AS c ON c.table_schema = t.table_schema 
AND c.table_name = t.table_name
LEFT OUTER JOIN information_schema.innodb_sys_tables AS ist 
ON ist.name = concat(t.table_schema,'/',t.table_name)
LEFT OUTER JOIN information_schema.innodb_sys_columns AS isc 
ON isc.table_id = ist.table_id AND isc.name = c.column_name 
WHERE c.column_type IN ('time','timestamp','datetime')
AND t.table_schema NOT IN ('mysql','information_schema','performance_schema')

utdrmac

  # Encrypt initially using
  # openssl rand -base64 32 >/etc/ssl/private/mykey.bin && chmod 600 /etc/ssl/private/mykey.bin
  # openssl aes-256-cbc -a -salt -in /usr/local/mysql/keyring -out /usr/local/mysql/keyring.asc -pass file:/etc/ssl/private/mykey.bin
  echo $echo_n "Decrypting Keyring..."
  rm -f /usr/local/mysql/keyring
  if [ ! -e /usr/local/mysql/keyring.asc -o ! -e /etc/ssl/private/mykey.bin ]
  then
      echo "Encrypted keyring and/or keyfile not found. Aborting MySQL startup."
      exit 1;
  fi

utdrmac

SELECT CONCAT((@@key_buffer_size + @@query_cache_size + (@@innodb_buffer_pool_size * 1.05 + 20*1024*1024) + @@innodb_additional_mem_pool_size + @@innodb_log_buffer_size 
+ @@max_connections * (@@read_buffer_size + @@read_rnd_buffer_size + @@sort_buffer_size + @@join_buffer_size + @@binlog_cache_size + @@tmp_table_size
+ @@thread_stack)) / 1024/1024/1024, ' GB') AS "POTENTIAL MEMORY USAGE";

utdrmac

#!/usr/bin/env php
<?php

include 'config.php';

/* This is the EC2 API Client object */
$sqs = Aws\Sqs\SqsClient::factory(array(
	'key' => $aws_key,
	'secret' => $aws_secret,
	'region' => 'us-west-2',

utdrmac

Keybase proof

I hereby claim:

• I am utdrmac on github.
• I am utdrmac (https://keybase.io/utdrmac) on keybase.
• I have a public key ASBe9_sYtgbqJWYn6uB5b2tkVuDEvqzD3zH8Y9uJ2qTcWAo

To claim this, I am signing this object:

utdrmac

#!/bin/bash

# Redirect STDOUT/STDERR to journalctl
# journalctl -f SYSLOG_IDENTIFIER=pushBulletSSH
exec > >(logger -t pushBulletSSH) 2> >(logger -t pushBulletSSH -p user.warn)

# Config
GASGIANT_ID="XXXXXX"
PORTFILE=/tmp/.sshport

utdrmac

#!/usr/bin/python

import time
import signal, sys, os, re
import rrdtool
import requests

# 
# Add data points every second (step)
# Keep:

utdrmac

#!/usr/bin/python

import os, sys
import random
import time
import string
import mysql.connector
import threading

from mysql.connector import errorcode

utdrmac

#!/bin/bash

MYSQL_CMDLINE="mysql -nNE --connect-timeout=5"
AVAILABLE_WHEN_DONOR=1

function getSession() {

    local retry=0
    local __dummy=""