Skip to content

Instantly share code, notes, and snippets.

View beaufour's full-sized avatar

Allan Beaufour beaufour

View GitHub Profile
@beaufour
beaufour / requirements.txt
Last active September 11, 2019 22:01
Save Speedtest.net data to InfluxDB
delegator.py==0.1.1
requests==2.22.0
@beaufour
beaufour / awsauth.sh
Last active September 28, 2020 19:16
AWS STS authenticator script
#!/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 / connection_status.sql
Last active September 29, 2020 15:12
Postgresql: List connections and their SSL status
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 / language.py
Created November 30, 2012 16:00
Django Middleware to choose language based on subdomain
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).