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 |