Skip to content

Instantly share code, notes, and snippets.

Avatar

Allan Beaufour beaufour

View GitHub Profile
@beaufour
beaufour / connection_status.sql
Last active Sep 29, 2020
Postgresql: List connections and their SSL status
View connection_status.sql
select pg_stat_ssl.pid, client_addr, datname, usename, application_name, ssl
from pg_stat_activity
join pg_stat_ssl
on pg_stat_activity.pid = pg_stat_ssl.pid;
@beaufour
beaufour / awsauth.sh
Last active Sep 28, 2020
AWS STS authenticator script
View awsauth.sh
#!/bin/bash
#
# Gets a temporary token from STS and stores it in the default AWS profile.
#
# The script needs two environment variables set:
# * AWS_MFA_ARN: ARN of your MFA device (look up in IAM)
# * AWS_STS_PROFILE: aws cli user profile that allows you to call STS
#
# To use it, you also need to have two profiles in your ~/.aws/credentials file. The default and the
# one that contains your permanent access tokens. Like this for example:
@beaufour
beaufour / requirements.txt
Last active Sep 11, 2019
Save Speedtest.net data to InfluxDB
View requirements.txt
delegator.py==0.1.1
requests==2.22.0
@beaufour
beaufour / elb_cloudwatch.py
Created Feb 15, 2012
Get CloudWatch metrics for an Amazon ELB
View elb_cloudwatch.py
#!/usr/bin/python
#
# Get Cloudwatch metrics for an ELB
#
# Inspired by http://onemoredigit.com/post/3263274796/single-instance-cloudwatch-stats-with-boto
#
import datetime
import sys
@beaufour
beaufour / ebs_stats.py
Created Feb 16, 2012
Get CloudWatch metrics for Amazon EBS volumes
View ebs_stats.py
#!/usr/bin/python
#
# Get Cloudwatch metrics for the EBS volumes attached to an instance
#
import datetime
import logging
import sys
import urllib
@beaufour
beaufour / todo-check.py
Created Apr 2, 2013
Git commit hook to check for lines with "TODO" in them
View todo-check.py
#!/usr/bin/python
import logging
import re
import sys
import envoy
def _exec_git(cmd, args=''):
cmd = 'git {0} --color=never {1}'.format(cmd, args)
@beaufour
beaufour / language.py
Created Nov 30, 2012
Django Middleware to choose language based on subdomain
View language.py
import logging
from django.utils import translation
class SubdomainLanguageMiddleware(object):
"""
Set the language for the site based on the subdomain the request
is being served on. For example, serving on 'fr.domain.com' would
make the language French (fr).
@beaufour
beaufour / gzipinputstream.py
Created Dec 4, 2012
Python: Streaming Gzip reader
View gzipinputstream.py
import zlib
import string
BLOCK_SIZE = 16384
"""Read block size"""
WINDOW_BUFFER_SIZE = 16 + zlib.MAX_WBITS
"""zlib window buffer size, set to gzip's format"""
@beaufour
beaufour / keybase.md
Last active Feb 25, 2017
Keybase verification
View keybase.md

Keybase proof

I hereby claim:

  • I am beaufour on github.
  • I am beaufour (https://keybase.io/beaufour) on keybase.
  • I have a public key whose fingerprint is 96CC B7F1 EDDF 85F1 6263 6DF9 B449 C455 BB2F 12A7

To claim this, I am signing this object:

View hubot_run.sh
#!/bin/bash
# Core
export HUBOT_HIPCHAT_JID="XXXXX"
export HUBOT_HIPCHAT_PASSWORD="YYYYY"
export HUBOT_AUTH_ADMIN=ZZZZZ
export HUBOT_DIR=/home/ubuntu/ponce
# Plugins
export HUBOT_DARK_SKY_API_KEY="XXXXXX"