Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main
import memcache | |
import sys | |
from datetime import datetime, timedelta | |
import pymysql | |
def banner(message): | |
print("=" * len(message)) | |
print(message) | |
print ("=" * len(message)) |
CREATE TABLE IF NOT EXISTS user (usr_id VARCHAR(20) NOT NULL COMMENT 'User ID', | |
usr_surveyoff CHAR(1) NOT NULL DEFAULT '0' COMMENT 'If True, this user should not see any survey', | |
usr_createdon VARCHAR(19) NOT NULL COMMENT 'When the user was created', | |
usr_gatheringoff CHAR(1) DEFAULT '0', | |
flags INT, cas BIGINT UNSIGNED, expiry INT, primary key(usr_id)) | |
ENGINE = INNODB; | |
INSERT INTO `innodb_memcache`.`containers` ( `name`, `db_schema`, `db_table`, `key_columns`, `value_columns`, | |
`flags`, `cas_column`, `expire_time_column`, `unique_idx_name_on_key`) | |
VALUES ('mobience', 'test', 'user', 'usr_id', 'usr_surveyoff|usr_createdon|usr_gatheringoff', 'flags','cas','expiry','PRIMARY'); |
<?xml version="1.0" encoding="UTF-8"?> | |
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
<plist version="1.0"> | |
<dict> | |
<key>ANSIBlackColor</key> | |
<data> | |
YnBsaXN0MDDUAQIDBAUGFRZYJHZlcnNpb25YJG9iamVjdHNZJGFyY2hpdmVyVCR0b3AS | |
AAGGoKMHCA9VJG51bGzTCQoLDA0OVU5TUkdCXE5TQ29sb3JTcGFjZVYkY2xhc3NGMCAw | |
IDAAEAKAAtIQERITWiRjbGFzc25hbWVYJGNsYXNzZXNXTlNDb2xvcqISFFhOU09iamVj | |
dF8QD05TS2V5ZWRBcmNoaXZlctEXGFRyb290gAEIERojLTI3O0FITltiaWttcn2GjpGa |
# -*- mode: ruby -*- | |
# vi: set ft=ruby : | |
Vagrant.configure(2) do |config| | |
config.vm.box = "ubuntu/xenial64" | |
config.vm.hostname = "ubuntu-xenial" | |
config.vm.network "public_network", ip: "192.168.0.131" | |
config.vm.synced_folder "/Volumes/Data/Shares", "/home/ubuntu/Shares", create: true | |
config.vm.provider "virtualbox" do |vb| | |
vb.name = "ubuntu-xenial64" |
Install Postgres 9.5, and then:
sudo pg_dropcluster 9.5 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main
#!/bin/sh | |
## | |
## Usage: ./ovpn-writer.sh SERVER CA_CERT CLIENT_CERT CLIENT_KEY SHARED_SECRET > client.ovpn | |
## | |
server=${1?"The server address is required"} | |
cacert=${2?"The path to the ca certificate file is required"} | |
client_cert=${3?"The path to the client certificate file is required"} | |
client_key=${4?"The path to the client private key file is required"} |
# -*- mode: ruby -*- | |
# vi: set ft=ruby : | |
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing! | |
VAGRANTFILE_API_VERSION = "2" | |
$INSTALL_REDIS = <<SCRIPT | |
sudo apt-get update | |
sudo apt-get upgrade | |
sudo apt-get install -y redis-server |