Skip to content

Instantly share code, notes, and snippets.

@allenwyma
allenwyma / clean-requirements.py
Created August 23, 2016 03:03 — forked from temoto/clean-requirements.py
Helper to clean requirements.txt from unused dependencies
#!/usr/bin/env python
from __future__ import print_function
import argparse
import collections
import re
import subprocess
import sys
KNOWN_IMPORT_PACKAGE_MAP = {
@allenwyma
allenwyma / _readme.md
Created April 26, 2016 02:30 — forked from shime/_readme.md
installation script for tmux 1.9a

Having trouble installing the latest stable version of tmux?

I know, official package for your OS/distro is outdated and you just want the newest version of tmux.

Well, this script should save you some time with that.

Prerequisities

  • gcc
@allenwyma
allenwyma / vpn-status.sh
Created April 20, 2016 07:38 — forked from aelveborn/vpn-status.sh
Synology DSM 5 VPN reconnection script.Save file to /usr/openVPNreconnect then run chmod +x /usr/openVPNreconnect. Schedule by following http://forum.synology.com/enu/viewtopic.php?f=241&t=65444
# Replace o1234567890 with your OpenVPN id. To get your id, start the VPN and run ps|grep client_o
# Replace YOUR_VPN_NAME with the name of your VPN profile in DSM 5 admin panel.
if echo `ifconfig tun0` | grep -q "00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00"
then
echo "VPN is running"
else
echo conf_id=o1234567890 > /usr/syno/etc/synovpnclient/vpnc_connecting
echo conf_name=YOUR_VPN_NAME >> /usr/syno/etc/synovpnclient/vpnc_connecting
echo proto=openvpn >> /usr/syno/etc/synovpnclient/vpnc_connecting
@allenwyma
allenwyma / psqlfix.txt
Last active October 8, 2015 09:29
Change postgres default template0 to UTF8 encoding
mike@rbci:~$ psql -U postgres
psql (9.0.3)
Type "help" for help.
postgres=# update pg_database set datallowconn = TRUE where datname = 'template0';
UPDATE 1
postgres=# \c template0
You are now connected to database "template0".
template0=# update pg_database set datistemplate = FALSE where datname = 'template1';
UPDATE 1
@allenwyma
allenwyma / change_db_owner.sh
Created July 6, 2012 03:11 — forked from gingerlime/change_db_owner.sh
Postgresql - Changing ownership on all tables
#!/bin/bash
usage()
{
cat << EOF
usage: $0 options
This script set ownership for all table, sequence and views for a given database
Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto