emails.sagews

%auto
import json
import os

# Create a settings.json file with:
# {"pem_file": ".pem", "host": "", "user": ""}

# TODO: limit chances of man in the middle vuln
#if [ -z `ssh-keygen -F $IP` ]; then
#  ssh-keyscan -H $IP >> ~/.ssh/known_hosts
#fi

def mount_remote_fs():
    with open('settings.json', 'r') as f:
        settings = json.loads(f.read())
    os.system('mkdir ~/remote_fs')
    os.system('fusermount -uz remote_fs')
    cmd = 'sshfs -o reconnect,ServerAliveInterval=15,ServerAliveCountMax=3,nonempty,IdentityFile=~/%s %s@%s:/home/%s/ ~/remote_fs > /dev/null 2>&1 &' % (settings["pem_file"], settings["user"], settings["host"], settings["user"])
    #print cmd
    os.system(cmd)

mount_remote_fs()

def sshpy(code):
    with open('settings.json', 'r') as f:
        settings = json.loads(f.read())
    os.system('chmod 400 %s' % (settings["pem_file"]))
    with open('code_to_run_from_sagews.py', 'w') as f:
        f.write(code)
    cmd = "scp -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -i %s code_to_run_from_sagews.py %s@%s:~/" % (settings["pem_file"], settings["user"], settings["host"])
    #print cmd
    os.system(cmd)
    cmd = "ssh -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -i %s %s@%s 'python code_to_run_from_sagews.py'" % (settings["pem_file"], settings["user"], settings["host"])
    #print cmd
    t = os.popen4(cmd)
    for part in t:
        try:
            print part.read()
        except:
            pass

def sshsh(code):
    with open('settings.json', 'r') as f:
        settings = json.loads(f.read())
    os.system('chmod 400 %s' % (settings["pem_file"]))
    with open('code_to_run_from_sagews.sh', 'w') as f:
        f.write(code)
    cmd = "scp -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -i %s code_to_run_from_sagews.sh %s@%s:~/" % (settings["pem_file"], settings["user"], settings["host"])
    #print cmd
    os.system(cmd)
    cmd = "ssh -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no -i %s %s@%s 'sh code_to_run_from_sagews.sh'" % (settings["pem_file"], settings["user"], settings["host"])
    #print cmd
    t = os.popen4(cmd)
    for part in t:
        try:
            print '\n'.join([line for line in part.read().split('\n') if not 'Warning: Permanently added' in line])
        except:
            pass

def psql(code):
    with open('settings.json', 'r') as f:
        settings = json.loads(f.read())
    with open('psql_code.txt', 'w') as f:
        f.write(code)
    cmd = "export PGPASSWORD=%s; psql --host=%s --port=%s --username=%s --dbname=%s < psql_code.txt" % (settings["psql_password"], settings["psql_host"], settings["psql_port"], settings["psql_username"], settings["psql_dbname"])
    #print cmd
    t = os.popen4(cmd)
    for part in t:
        try:
            print '\n'.join([line for line in part.read().split('\n') if not 'Warning: Permanently added' in line])
        except:
            pass
        
%default_mode sshsh

sudo chown nobody:nogroup /home/ubuntu/efs-emails; sudo umount efs-emails; sudo mount -t nfs4 -o nfsvers=4.1 $(curl -s http://169.254.169.254/latest/meta-data/placement/availability-zone).fs-a6bf480f.efs.us-west-2.amazonaws.com:/ efs-emails; sudo chmod 777 efs-emails; mkdir efs-emails/test

sudo curl -L https://yt-dl.org/downloads/latest/youtube-dl -o /usr/local/bin/youtube-dl; sudo chmod 777 /usr/local/bin/youtube-dl

% Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 3 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 3 0 0 0 0 0 0 --:--:-- 0:00:01 --:--:-- 0 0 0 0 582 0 0 316 0 --:--:-- 0:00:01 --:--:-- 316 100 1286k 100 1286k 0 0 399k 0 0:00:03 0:00:03 --:--:-- 1731k

youtube-dl https://www.youtube.com/watch?v=n92zfXkRdnk

[youtube] n92zfXkRdnk: Downloading webpage [youtube] n92zfXkRdnk: Downloading video info webpage [youtube] n92zfXkRdnk: Extracting video information [youtube] n92zfXkRdnk: Downloading MPD manifest WARNING: Requested formats are incompatible for merge and will be merged into mkv. [download] Destination: Seattle Police Arrest William Wingate-n92zfXkRdnk.f135.mp4 [download] 100% of 103.04MiB in 00:0430MiB/s ETA 00:002 [download] Destination: Seattle Police Arrest William Wingate-n92zfXkRdnk.f251.webm [download] 100% of 25.76MiB in 00:0140MiB/s ETA 00:001 [ffmpeg] Merging formats into "Seattle Police Arrest William Wingate-n92zfXkRdnk.mkv" Deleting original file Seattle Police Arrest William Wingate-n92zfXkRdnk.f135.mp4 (pass -k to keep) Deleting original file Seattle Police Arrest William Wingate-n92zfXkRdnk.f251.webm (pass -k to keep)

df -h

Filesystem Size Used Avail Use% Mounted on udev 492M 12K 492M 1% /dev tmpfs 100M 368K 99M 1% /run /dev/xvda1 7.8G 2.0G 5.4G 27% / none 4.0K 0 4.0K 0% /sys/fs/cgroup none 5.0M 0 5.0M 0% /run/lock none 497M 0 497M 0% /run/shm none 100M 0 100M 0% /run/user us-west-2a.fs-a6bf480f.efs.us-west-2.amazonaws.com:/ 8.0E 0 8.0E 0% /home/ubuntu/efs-emails

sh recordscontrol/install.sh

Install FFMPEG --2016-08-16 17:42:05-- http://johnvansickle.com/ffmpeg/builds/ffmpeg-git-64bit-static.tar.xz Resolving johnvansickle.com (johnvansickle.com)... 199.79.62.21 Connecting to johnvansickle.com (johnvansickle.com)|199.79.62.21|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 17955732 (17M) [application/x-tar] Saving to: ‘ffmpeg-git-64bit-static.tar.xz’ 0K .......... .......... .......... .......... .......... 0% 310K 56s 50K .......... .......... .......... .......... .......... 0% 614K 42s 100K .......... .......... .......... .......... .......... 0% 624K 37s 150K .......... .......... .......... .......... .......... 1% 25.0M 28s 200K .......... .......... .......... .......... .......... 1% 631K 28s 250K .......... .......... .......... .......... .......... 1% 30.2M 23s 300K .......... .......... .......... .......... .......... 1% 26.4M 20s 350K .......... .......... .......... .......... .......... 2% 640K 21s 400K .......... .......... .......... .......... .......... 2% 27.0M 19s 450K .......... .......... .......... .......... .......... 2% 25.7M 17s 500K .......... .......... .......... .......... .......... 3% 24.9M 15s 550K .......... .......... .......... .......... .......... 3% 671K 16s 600K .......... .......... .......... .......... .......... 3% 27.9M 15s 650K .......... .......... .......... .......... .......... 3% 24.8M 14s 700K .......... .......... .......... .......... .......... 4% 26.3M 13s 750K .......... .......... .......... .......... .......... 4% 24.4M 12s 800K .......... .......... .......... .......... .......... 4% 707K 13s 850K .......... .......... .......... .......... .......... 5% 17.3M 12s 900K .......... .......... .......... .......... .......... 5% 19.5M 11s 950K .......... .......... .......... .......... .......... 5% 47.1M 11s 1000K .......... .......... .......... .......... .......... 5% 21.8M 10s 1050K .......... .......... .......... .......... .......... 6% 22.8M 10s 1100K .......... .......... .......... .......... .......... 6% 23.5M 9s 1150K .......... .......... .......... .......... .......... 6% 26.7M 9s 1200K .......... .......... .......... .......... .......... 7% 22.7M 9s 1250K .......... .......... .......... .......... .......... 7% 2.12M 9s 1300K .......... .......... .......... .......... .......... 7% 1.11M 9s 1350K .......... .......... .......... .......... .......... 7% 16.6M 8s 1400K .......... .......... .......... .......... .......... 8% 33.1M 8s 1450K .......... .......... .......... .......... .......... 8% 25.4M 8s 1500K .......... .......... .......... .......... .......... 8% 22.8M 8s 1550K .......... .......... .......... .......... .......... 9% 26.0M 7s 1600K .......... .......... .......... .......... .......... 9% 23.8M 7s 1650K .......... .......... .......... .......... .......... 9% 24.4M 7s 1700K .......... .......... .......... .......... .......... 9% 24.8M 7s 1750K .......... .......... .......... .......... .......... 10% 24.7M 7s 1800K .......... .......... .......... .......... .......... 10% 24.3M 6s 1850K .......... .......... .......... .......... .......... 10% 27.2M 6s 1900K .......... .......... .......... .......... .......... 11% 3.30M 6s 1950K .......... .......... .......... .......... .......... 11% 1.12M 6s 2000K .......... .......... .......... .......... .......... 11% 14.3M 6s 2050K .......... .......... .......... .......... .......... 11% 27.3M 6s 2100K .......... .......... .......... .......... .......... 12% 24.1M 6s 2150K .......... .......... .......... .......... .......... 12% 25.5M 6s 2200K .......... .......... .......... .......... .......... 12% 26.3M 6s 2250K .......... .......... .......... .......... .......... 13% 24.6M 5s 2300K .......... .......... .......... .......... .......... 13% 1.87M 5s 2350K .......... .......... .......... .......... .......... 13% 98.9M 5s 2400K .......... .......... .......... .......... .......... 13% 99.0M 5s 2450K .......... .......... .......... .......... .......... 14% 304M 5s 2500K .......... .......... .......... .......... .......... 14% 494M 5s 2550K .......... .......... .......... .......... .......... 14% 552M 5s 2600K .......... .......... .......... .......... .......... 15% 511M 5s 2650K .......... .......... .......... .......... .......... 15% 550M 5s 2700K .......... .......... .......... .......... .......... 15% 494M 5s 2750K .......... .......... .......... .......... .......... 15% 561M 4s 2800K .......... .......... .......... .......... .......... 16% 567M 4s 2850K .......... .......... .......... .......... .......... 16% 607M 4s 2900K .......... .......... .......... .......... .......... 16% 1.26M 4s 2950K .......... .......... .......... .......... .......... 17% 13.6M 4s 3000K .......... .......... .......... .......... .......... 17% 23.3M 4s 3050K .......... .......... .......... .......... .......... 17% 29.8M 4s 3100K .......... .......... .......... .......... .......... 17% 25.7M 4s 3150K .......... .......... .......... .......... .......... 18% 20.7M 4s 3200K .......... .......... .......... .......... .......... 18% 15.3M 4s 3250K .......... .......... .......... .......... .......... 18% 15.4M 4s 3300K .......... .......... .......... .......... .......... 19% 28.9M 4s 3350K .......... .......... .......... .......... .......... 19% 24.9M 4s 3400K .......... .......... .......... .......... .......... 19% 24.6M 4s 3450K .......... .......... .......... .......... .......... 19% 23.7M 4s 3500K .......... .......... .......... .......... .......... 20% 19.7M 4s 3550K .......... .......... .......... .......... .......... 20% 24.6M 4s 3600K .......... .......... .......... .......... .......... 20% 25.4M 4s 3650K .......... .......... .......... .......... .......... 21% 23.1M 3s 3700K .......... .......... .......... .......... .......... 21% 24.9M 3s 3750K .......... .......... .......... .......... .......... 21% 22.3M 3s 3800K .......... .......... .......... .......... .......... 21% 27.1M 3s 3850K .......... .......... .......... .......... .......... 22% 26.3M 3s 3900K .......... .......... .......... .......... .......... 22% 21.6M 3s 3950K .......... .......... .......... .......... .......... 22% 22.4M 3s 4000K .......... .......... .......... .......... .......... 23% 21.6M 3s 4050K .......... .......... .......... .......... .......... 23% 26.0M 3s 4100K .......... .......... .......... .......... .......... 23% 23.1M 3s 4150K .......... .......... .......... .......... .......... 23% 1.92M 3s 4200K .......... .......... .......... .......... .......... 24% 13.2M 3s 4250K .......... .......... .......... .......... .......... 24% 13.1M 3s 4300K .......... .......... .......... .......... .......... 24% 21.8M 3s 4350K .......... .......... .......... .......... .......... 25% 23.7M 3s 4400K .......... .......... .......... .......... .......... 25% 26.3M 3s 4450K .......... .......... .......... .......... .......... 25% 25.9M 3s 4500K .......... .......... .......... .......... .......... 25% 25.6M 3s 4550K .......... .......... .......... .......... .......... 26% 22.0M 3s 4600K .......... .......... .......... .......... .......... 26% 22.5M 3s 4650K .......... .......... .......... .......... .......... 26% 26.4M 3s 4700K .......... .......... .......... .......... .......... 27% 24.7M 3s 4750K .......... .......... .......... .......... .......... 27% 24.6M 3s 4800K .......... .......... .......... .......... .......... 27% 25.4M 3s 4850K .......... .......... .......... .......... .......... 27% 25.5M 3s 4900K .......... .......... .......... .......... .......... 28% 21.2M 3s 4950K .......... .......... .......... .......... .......... 28% 23.5M 3s 5000K .......... .......... .......... .......... .......... 28% 25.8M 2s 5050K .......... .......... .......... .......... .......... 29% 15.3M 2s 5100K .......... .......... .......... .......... .......... 29% 59.5M 2s 5150K .......... .......... .......... .......... .......... 29% 25.1M 2s 5200K .......... .......... .......... .......... .......... 29% 24.5M 2s 5250K .......... .......... .......... .......... .......... 30% 24.6M 2s 5300K .......... .......... .......... .......... .......... 30% 25.2M 2s 5350K .......... .......... .......... .......... .......... 30% 24.8M 2s 5400K .......... .......... .......... .......... .......... 31% 23.8M 2s 5450K .......... .......... .......... .......... .......... 31% 23.6M 2s 5500K .......... .......... .......... .......... .......... 31% 21.5M 2s 5550K .......... .......... .......... .......... .......... 31% 15.4M 2s 5600K .......... .......... .......... .......... .......... 32% 14.8M 2s 5650K .......... .......... .......... .......... .......... 32% 14.1M 2s 5700K .......... .......... .......... .......... .......... 32% 3.41M 2s 5750K .......... .......... .......... .......... .......... 33% 9.11M 2s 5800K .......... .......... .......... .......... .......... 33% 23.2M 2s 5850K .......... .......... .......... .......... .......... 33% 25.4M 2s 5900K .......... .......... .......... .......... .......... 33% 23.8M 2s 5950K .......... .......... .......... .......... .......... 34% 22.8M 2s 6000K .......... .......... .......... .......... .......... 34% 26.0M 2s 6050K .......... .......... .......... .......... .......... 34% 21.4M 2s 6100K .......... .......... .......... .......... .......... 35% 30.6M 2s 6150K .......... .......... .......... .......... .......... 35% 25.9M 2s 6200K .......... .......... .......... .......... .......... 35% 23.6M 2s 6250K .......... .......... .......... .......... .......... 35% 22.6M 2s 6300K .......... .......... .......... .......... .......... 36% 19.6M 2s 6350K .......... .......... .......... .......... .......... 36% 16.5M 2s 6400K .......... .......... .......... .......... .......... 36% 14.4M 2s 6450K .......... .......... .......... .......... .......... 37% 19.4M 2s 6500K .......... .......... .......... .......... .......... 37% 17.1M 2s 6550K .......... .......... .......... .......... .......... 37% 18.2M 2s 6600K .......... .......... .......... .......... .......... 37% 25.4M 2s 6650K .......... .......... .......... .......... .......... 38% 24.9M 2s 6700K .......... .......... .......... .......... .......... 38% 24.2M 2s 6750K .......... .......... .......... .......... .......... 38% 21.6M 2s 6800K .......... .......... .......... .......... .......... 39% 23.7M 2s 6850K .......... .......... .......... .......... .......... 39% 18.0M 2s 6900K .......... .......... .......... .......... .......... 39% 16.8M 2s 6950K .......... .......... .......... .......... .......... 39% 19.5M 2s 7000K .......... .......... .......... .......... .......... 40% 16.7M 2s 7050K .......... .......... .......... .......... .......... 40% 12.9M 2s 7100K .......... .......... .......... .......... .......... 40% 12.3M 2s 7150K .......... .......... .......... .......... .......... 41% 12.6M 2s 7200K .......... .......... .......... .......... .......... 41% 13.0M 2s 7250K .......... .......... .......... .......... .......... 41% 10.5M 2s 7300K .......... .......... .......... .......... .......... 41% 12.9M 2s 7350K .......... .......... .......... .......... .......... 42% 18.2M 2s 7400K .......... .......... .......... .......... .......... 42% 18.2M 2s 7450K .......... .......... .......... .......... .......... 42% 20.6M 2s 7500K .......... .......... .......... .......... .......... 43% 29.6M 2s 7550K .......... .......... .......... .......... .......... 43% 24.8M 1s 7600K .......... .......... .......... .......... .......... 43% 24.8M 1s 7650K .......... .......... .......... .......... .......... 43% 25.9M 1s 7700K .......... .......... .......... .......... .......... 44% 22.9M 1s 7750K .......... .......... .......... .......... .......... 44% 21.2M 1s 7800K .......... .......... .......... .......... .......... 44% 19.2M 1s 7850K .......... .......... .......... .......... .......... 45% 19.8M 1s 7900K .......... .......... .......... .......... .......... 45% 15.3M 1s 7950K .......... .......... .......... .......... .......... 45% 19.8M 1s 8000K .......... .......... .......... .......... .......... 45% 13.5M 1s 8050K .......... .......... .......... .......... .......... 46% 15.3M 1s 8100K .......... .......... .......... .......... .......... 46% 16.6M 1s 8150K .......... .......... .......... .......... .......... 46% 16.3M 1s 8200K .......... .......... .......... .......... .......... 47% 15.2M 1s 8250K .......... .......... .......... .......... .......... 47% 20.4M 1s 8300K .......... .......... .......... .......... .......... 47% 14.8M 1s 8350K .......... .......... .......... .......... .......... 47% 19.9M 1s 8400K .......... .......... .......... .......... .......... 48% 14.3M 1s 8450K .......... .......... .......... .......... .......... 48% 14.0M 1s 8500K .......... .......... .......... .......... .......... 48% 14.2M 1s 8550K .......... .......... .......... .......... .......... 49% 14.1M 1s 8600K .......... .......... .......... .......... .......... 49% 22.0M 1s 8650K .......... .......... .......... .......... .......... 49% 23.0M 1s 8700K .......... .......... .......... .......... .......... 49% 21.5M 1s 8750K .......... .......... .......... .......... .......... 50% 12.0M 1s 8800K .......... .......... .......... .......... .......... 50% 15.3M 1s 8850K .......... .......... .......... .......... .......... 50% 16.4M 1s 8900K .......... .......... .......... .......... .......... 51% 16.2M 1s 8950K .......... .......... .......... .......... .......... 51% 15.7M 1s 9000K .......... .......... .......... .......... .......... 51% 18.9M 1s 9050K .......... .......... .......... .......... .......... 51% 18.6M 1s 9100K .......... .......... .......... .......... .......... 52% 19.6M 1s 9150K .......... .......... .......... .......... .......... 52% 17.9M 1s 9200K .......... .......... .......... .......... .......... 52% 18.7M 1s 9250K .......... .......... .......... .......... .......... 53% 21.9M 1s 9300K .......... .......... .......... .......... .......... 53% 17.4M 1s 9350K .......... .......... .......... .......... .......... 53% 19.0M 1s 9400K .......... .......... .......... .......... .......... 53% 15.5M 1s 9450K .......... .......... .......... .......... .......... 54% 15.4M 1s 9500K .......... .......... .......... .......... .......... 54% 14.2M 1s 9550K .......... .......... .......... .......... .......... 54% 18.5M 1s 9600K .......... .......... .......... .......... .......... 55% 14.2M 1s 9650K .......... .......... .......... .......... .......... 55% 22.4M 1s 9700K .......... .......... .......... .......... .......... 55% 20.4M 1s 9750K .......... .......... .......... .......... .......... 55% 17.2M 1s 9800K .......... .......... .......... .......... .......... 56% 15.4M 1s 9850K .......... .......... .......... .......... .......... 56% 13.4M 1s 9900K .......... .......... .......... .......... .......... 56% 19.1M 1s 9950K .......... .......... .......... .......... .......... 57% 11.2M 1s 10000K .......... .......... .......... .......... .......... 57% 13.8M 1s 10050K .......... .......... .......... .......... .......... 57% 18.9M 1s 10100K .......... .......... .......... .......... .......... 57% 17.7M 1s 10150K .......... .......... .......... .......... .......... 58% 20.8M 1s 10200K .......... .......... .......... .......... .......... 58% 18.2M 1s 10250K .......... .......... .......... .......... .......... 58% 19.9M 1s 10300K .......... .......... .......... .......... .......... 59% 16.0M 1s 10350K .......... .......... .......... .......... .......... 59% 15.5M 1s 10400K .......... .......... .......... .......... .......... 59% 15.7M 1s 10450K .......... .......... .......... .......... .......... 59% 18.1M 1s 10500K .......... .......... .......... .......... .......... 60% 14.6M 1s 10550K .......... .......... .......... .......... .......... 60% 18.7M 1s 10600K .......... .......... .......... .......... .......... 60% 16.9M 1s 10650K .......... .......... .......... .......... .......... 61% 26.4M 1s 10700K .......... .......... .......... .......... .......... 61% 19.8M 1s 10750K .......... .......... .......... .......... .......... 61% 15.8M 1s 10800K .......... .......... .......... .......... .......... 61% 16.7M 1s 10850K .......... .......... .......... .......... .......... 62% 14.5M 1s 10900K .......... .......... .......... .......... .......... 62% 15.7M 1s 10950K .......... .......... .......... .......... .......... 62% 11.5M 1s 11000K .......... .......... .......... .......... .......... 63% 17.0M 1s 11050K .......... .......... .......... .......... .......... 63% 16.0M 1s 11100K .......... .......... .......... .......... .......... 63% 16.0M 1s 11150K .......... .......... .......... .......... .......... 63% 21.2M 1s 11200K .......... .......... .......... .......... .......... 64% 19.5M 1s 11250K .......... .......... .......... .......... .......... 64% 15.9M 1s 11300K .......... .......... .......... .......... .......... 64% 19.0M 1s 11350K .......... .......... .......... .......... .......... 65% 15.2M 1s 11400K .......... .......... .......... .......... .......... 65% 14.2M 1s 11450K .......... .......... .......... .......... .......... 65% 13.6M 1s 11500K .......... .......... .......... .......... .......... 65% 11.9M 1s 11550K .......... .......... .......... .......... .......... 66% 17.2M 1s 11600K .......... .......... .......... .......... .......... 66% 17.5M 1s 11650K .......... .......... .......... .......... .......... 66% 17.9M 1s 11700K .......... .......... .......... .......... .......... 67% 17.5M 1s 11750K .......... .......... .......... .......... .......... 67% 18.4M 1s 11800K .......... .......... .......... .......... .......... 67% 14.6M 1s 11850K .......... .......... .......... .......... .......... 67% 17.9M 1s 11900K .......... .......... .......... .......... .......... 68% 15.9M 1s 11950K .......... .......... .......... .......... .......... 68% 16.3M 1s 12000K .......... .......... .......... .......... .......... 68% 14.7M 1s 12050K .......... .......... .......... .......... .......... 69% 16.4M 1s 12100K .......... .......... .......... .......... .......... 69% 14.7M 1s 12150K .......... .......... .......... .......... .......... 69% 17.7M 1s 12200K .......... .......... .......... .......... .......... 69% 18.5M 1s 12250K .......... .......... .......... .......... .......... 70% 18.6M 1s 12300K .......... .......... .......... .......... .......... 70% 17.0M 1s 12350K .......... .......... .......... .......... .......... 70% 11.5M 1s 12400K .......... .......... .......... .......... .......... 71% 17.3M 1s 12450K .......... .......... .......... .......... .......... 71% 13.8M 1s 12500K .......... .......... .......... .......... .......... 71% 12.8M 1s 12550K .......... .......... .......... .......... .......... 71% 15.9M 1s 12600K .......... .......... .......... .......... .......... 72% 11.6M 1s 12650K .......... .......... .......... .......... .......... 72% 15.1M 1s 12700K .......... .......... .......... .......... .......... 72% 16.9M 1s 12750K .......... .......... .......... .......... .......... 72% 15.9M 1s 12800K .......... .......... .......... .......... .......... 73% 16.9M 1s 12850K .......... .......... .......... .......... .......... 73% 14.3M 1s 12900K .......... .......... .......... .......... .......... 73% 14.3M 1s 12950K .......... .......... .......... .......... .......... 74% 16.2M 1s 13000K .......... .......... .......... .......... .......... 74% 15.1M 1s 13050K .......... .......... .......... .......... .......... 74% 13.9M 0s 13100K .......... .......... .......... .......... .......... 74% 16.8M 0s 13150K .......... .......... .......... .......... .......... 75% 14.8M 0s 13200K .......... .......... .......... .......... .......... 75% 23.2M 0s 13250K .......... .......... .......... .......... .......... 75% 15.9M 0s 13300K .......... .......... .......... .......... .......... 76% 17.3M 0s 13350K .......... .......... .......... .......... .......... 76% 16.2M 0s 13400K .......... .......... .......... .......... .......... 76% 15.3M 0s 13450K .......... .......... .......... .......... .......... 76% 14.6M 0s 13500K .......... .......... .......... .......... .......... 77% 14.4M 0s 13550K .......... .......... .......... .......... .......... 77% 14.3M 0s 13600K .......... .......... .......... .......... .......... 77% 15.1M 0s 13650K .......... .......... .......... .......... .......... 78% 14.5M 0s 13700K .......... .......... .......... .......... .......... 78% 17.9M 0s 13750K .......... .......... .......... .......... .......... 78% 16.7M 0s 13800K .......... .......... .......... .......... .......... 78% 23.0M 0s 13850K .......... .......... .......... .......... .......... 79% 13.5M 0s 13900K .......... .......... .......... .......... .......... 79% 15.5M 0s 13950K .......... .......... .......... .......... .......... 79% 13.3M 0s 14000K .......... .......... .......... .......... .......... 80% 12.7M 0s 14050K .......... .......... .......... .......... .......... 80% 13.7M 0s 14100K .......... .......... .......... .......... .......... 80% 13.8M 0s 14150K .......... .......... .......... .......... .......... 80% 15.7M 0s 14200K .......... .......... .......... .......... .......... 81% 15.9M 0s 14250K .......... .......... .......... .......... .......... 81% 21.0M 0s 14300K .......... .......... .......... .......... .......... 81% 17.4M 0s 14350K .......... .......... .......... .......... .......... 82% 19.8M 0s 14400K .......... .......... .......... .......... .......... 82% 12.5M 0s 14450K .......... .......... .......... .......... .......... 82% 13.1M 0s 14500K .......... .......... .......... .......... .......... 82% 14.5M 0s 14550K .......... .......... .......... .......... .......... 83% 12.7M 0s 14600K .......... .......... .......... .......... .......... 83% 16.9M 0s 14650K .......... .......... .......... .......... .......... 83% 13.8M 0s 14700K .......... .......... .......... .......... .......... 84% 15.4M 0s 14750K .......... .......... .......... .......... .......... 84% 17.7M 0s 14800K .......... .......... .......... .......... .......... 84% 18.2M 0s 14850K .......... .......... .......... .......... .......... 84% 23.7M 0s 14900K .......... .......... .......... .......... .......... 85% 12.9M 0s 14950K .......... .......... .......... .......... .......... 85% 13.3M 0s 15000K .......... .......... .......... .......... .......... 85% 15.5M 0s 15050K .......... .......... .......... .......... .......... 86% 14.0M 0s 15100K .......... .......... .......... .......... .......... 86% 12.7M 0s 15150K .......... .......... .......... .......... .......... 86% 13.1M 0s 15200K .......... .......... .......... .......... .......... 86% 13.4M 0s 15250K .......... .......... .......... .......... .......... 87% 14.1M 0s 15300K .......... .......... .......... .......... .......... 87% 24.1M 0s 15350K .......... .......... .......... .......... .......... 87% 13.9M 0s 15400K .......... .......... .......... .......... .......... 88% 15.3M 0s 15450K .......... .......... .......... .......... .......... 88% 17.9M 0s 15500K .......... .......... .......... .......... .......... 88% 12.5M 0s 15550K .......... .......... .......... .......... .......... 88% 11.9M 0s 15600K .......... .......... .......... .......... .......... 89% 15.9M 0s 15650K .......... .......... .......... .......... .......... 89% 12.6M 0s 15700K .......... .......... .......... .......... .......... 89% 13.5M 0s 15750K .......... .......... .......... .......... .......... 90% 16.8M 0s 15800K .......... .......... .......... .......... .......... 90% 16.0M 0s 15850K .......... .......... .......... .......... .......... 90% 17.1M 0s 15900K .......... .......... .......... .......... .......... 90% 22.3M 0s 15950K .......... .......... .......... .......... .......... 91% 11.3M 0s 16000K .......... .......... .......... .......... .......... 91% 12.0M 0s 16050K .......... .......... .......... .......... .......... 91% 14.6M 0s 16100K .......... .......... .......... .......... .......... 92% 13.1M 0s 16150K .......... .......... .......... .......... .......... 92% 16.5M 0s 16200K .......... .......... .......... .......... .......... 92% 18.6M 0s 16250K .......... .......... .......... .......... .......... 92% 14.4M 0s 16300K .......... .......... .......... .......... .......... 93% 14.2M 0s 16350K .......... .......... .......... .......... .......... 93% 15.7M 0s 16400K .......... .......... .......... .......... .......... 93% 13.4M 0s 16450K .......... .......... .......... .......... .......... 94% 16.3M 0s 16500K .......... .......... .......... .......... .......... 94% 14.7M 0s 16550K .......... .......... .......... .......... .......... 94% 13.9M 0s 16600K .......... .......... .......... .......... .......... 94% 13.3M 0s 16650K .......... .......... .......... .......... .......... 95% 13.2M 0s 16700K .......... .......... .......... .......... .......... 95% 13.2M 0s 16750K .......... .......... .......... .......... .......... 95% 13.2M 0s 16800K .......... .......... .......... .......... .......... 96% 11.7M 0s 16850K .......... .......... .......... .......... .......... 96% 16.3M 0s 16900K .......... .......... .......... .......... .......... 96% 14.6M 0s 16950K .......... .......... .......... .......... .......... 96% 16.2M 0s 17000K .......... .......... .......... .......... .......... 97% 16.6M 0s 17050K .......... .......... .......... .......... .......... 97% 12.8M 0s 17100K .......... .......... .......... .......... .......... 97% 12.9M 0s 17150K .......... .......... .......... .......... .......... 98% 13.9M 0s 17200K .......... .......... .......... .......... .......... 98% 11.9M 0s 17250K .......... .......... .......... .......... .......... 98% 13.1M 0s 17300K .......... .......... .......... .......... .......... 98% 15.4M 0s 17350K .......... .......... .......... .......... .......... 99% 16.2M 0s 17400K .......... .......... .......... .......... .......... 99% 14.2M 0s 17450K .......... .......... .......... .......... .......... 99% 17.0M 0s 17500K .......... .......... .......... .... 100% 12.0M=1.8s 2016-08-16 17:42:07 (9.70 MB/s) - ‘ffmpeg-git-64bit-static.tar.xz’ saved [17955732/17955732] ffmpeg-git-20160813-64bit-static/ ffmpeg-git-20160813-64bit-static/ffserver ffmpeg-git-20160813-64bit-static/GPLv3.txt ffmpeg-git-20160813-64bit-static/ffmpeg-10bit ffmpeg-git-20160813-64bit-static/manpages/ ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-all.txt ffmpeg-git-20160813-64bit-static/manpages/ffserver.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-bitstream-filters.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-scaler.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-resampler.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-devices.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-filters.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-protocols.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-scaler.pdf ffmpeg-git-20160813-64bit-static/manpages/ffprobe.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-devices.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-formats.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-codecs.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-utils.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-resampler.pdf ffmpeg-git-20160813-64bit-static/manpages/ffprobe.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-utils.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-protocols.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-codecs.txt ffmpeg-git-20160813-64bit-static/manpages/ffserver.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-filters.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-bitstream-filters.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-all.pdf ffmpeg-git-20160813-64bit-static/manpages/ffmpeg.txt ffmpeg-git-20160813-64bit-static/manpages/ffmpeg-formats.txt ffmpeg-git-20160813-64bit-static/ffprobe ffmpeg-git-20160813-64bit-static/qt-faststart ffmpeg-git-20160813-64bit-static/readme.txt ffmpeg-git-20160813-64bit-static/ffmpeg

%sshpy
print "hi"

hi

%sshsh
sudo apt-get -y install nfs-common
sudo apt-get -y install python-dev
sudo apt-get -y install python-pip
sudo pip install --upgrade google-api-python-client
sudo apt-get -y install git
sudo pip install pytz

Reading package lists... Building dependency tree... Reading state information... nfs-common is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded. Reading package lists... Building dependency tree... Reading state information... python-dev is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded. Reading package lists... Building dependency tree... Reading state information... python-pip is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded. Requirement already up-to-date: google-api-python-client in /usr/local/lib/python2.7/dist-packages Cleaning up... Reading package lists... Building dependency tree... Reading state information... git is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded. Requirement already satisfied (use --upgrade to upgrade): pytz in /usr/local/lib/python2.7/dist-packages Cleaning up...

ls

code_to_run_from_sagews.py code_to_run_from_sagews.sh test.py

python test.py

hi

sudo mount -t nfs4 -o nfsvers=4.1 $(curl -s http://169.254.169.254/latest/meta-data/placement/availability-zone).fs-a6bf480f.efs.us-west-2.amazonaws.com:/   ~/efs-emails > /dev/null 2>&1 &

ls emails

test.txt

sudo pip install got-your-back

Downloading/unpacking got-your-back Could not find any downloads that satisfy the requirement got-your-back Cleaning up... No distributions at all found for got-your-back Storing debug log for failure in /home/ubuntu/.pip/pip.log

git clone https://github.com/jay0lee/got-your-back.git

ls

code_to_run_from_sagews.py code_to_run_from_sagews.sh emails got-your-back test.py

sudo apt-get -y install git

Reading package lists... Building dependency tree... Reading state information... The following extra packages will be installed: git-man liberror-perl Suggested packages: git-daemon-run git-daemon-sysvinit git-doc git-el git-email git-gui gitk gitweb git-arch git-bzr git-cvs git-mediawiki git-svn The following NEW packages will be installed: git git-man liberror-perl 0 upgraded, 3 newly installed, 0 to remove and 85 not upgraded. Need to get 3,306 kB of archives. After this operation, 21.9 MB of additional disk space will be used. Get:1 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty/main liberror-perl all 0.17-1.1 [21.1 kB] Get:2 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main git-man all 1:1.9.1-1ubuntu0.3 [699 kB] Get:3 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main git amd64 1:1.9.1-1ubuntu0.3 [2,586 kB] Fetched 3,306 kB in 0s (22.7 MB/s) Selecting previously unselected package liberror-perl. (Reading database ... 56653 files and directories currently installed.) Preparing to unpack .../liberror-perl_0.17-1.1_all.deb ... Unpacking liberror-perl (0.17-1.1) ... Selecting previously unselected package git-man. Preparing to unpack .../git-man_1%3a1.9.1-1ubuntu0.3_all.deb ... Unpacking git-man (1:1.9.1-1ubuntu0.3) ... Selecting previously unselected package git. Preparing to unpack .../git_1%3a1.9.1-1ubuntu0.3_amd64.deb ... Unpacking git (1:1.9.1-1ubuntu0.3) ... Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Setting up liberror-perl (0.17-1.1) ... Setting up git-man (1:1.9.1-1ubuntu0.3) ... Setting up git (1:1.9.1-1ubuntu0.3) ...

cd got-your-back
python3.5 gyb.py --email [e-mail] --action estimate

sudo add-apt-repository ppa:fkrull/deadsnakes
sudo apt-get update
sudo apt-get -y install python3.5

This PPA has older and newer Python versions for Ubuntu. The packages in the official archives generally don't go back all that far, but people might still need to develop and test against these old Python interpreters. There also was a time when Google App Engine still ran on Python 2.5, but nobody likes to talk about that. A disclaimer first: I do not guarantee any kind of updates. In particular, I shed all responsibility for security issues in these packages. If you want to use them in a security-or-otherwise-critical environment (say, on a production server), you do so at your own risk. For Python 2.7 updates for supported Ubuntu releases, see my dedicated 2.7 PPA: https://launchpad.net/~fkrull/+archive/ubuntu/deadsnakes-python2.7 Reporting Issues ================ Issues can be reported in the master issue tracker at: https://bitbucket.org/fkpackaging/deadsnakes-issues Donations ========= If you like what I'm doing here, you can show your appreciation by donating: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=TTTFWBJ2DZK6E Supported Ubuntu Versions ========================= Supported — Precise, Trusty, Wily Generally, I try to support Ubuntu releases until their official End-of-Life. Supported Python Versions ========================= Currently supported releases — 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3, 3.4, 3.5 Basically, if an Ubuntu version doesn't have an official package for a specific major Python version (be it "any more" or "yet"), look for one in this PPA. However, for a given Python major release, don't expect to find newer point releases if there is already an older point release in the official Ubuntu repositories (i.e., if an Ubuntu release has a package for Python 2.6.4, I won't provide a package with 2.6.5 for that Ubuntu release): newer Python point releases shouldn't add new features or change behaviour, so they're rather pointless (no pun intended) for development and testing; conversely, if that Python point release has a bug that is fixed in a newer release, that's still an issue with the original package and should be taken up with the Ubuntu or Debian maintainer of the package. Besides, making these update packages externally to the original repositories is a bit of a pain. As an exception, I have updated Python 2.7 packages for several Ubuntu releases in a separate PPA: https://launchpad.net/~fkrull/+archive/ubuntu/deadsnakes-python2.7 Supported Python Packages ========================= Using third-party modules packaged for Debian or Ubuntu with the Python interpreters from this repository is a bit of a mixed bag. For Python 2, Python modules from the official repositories will not work, as a consequence of how Python packaging works in Debian. For Python 3 on the other hand, all pure-Python module packages at least should be available; compiled extension modules will not work however. In general, you're better off installing Python modules using the common Python packaging tools rather than the system package manager. For an introduction into the Python packaging ecosystem and its tools, refer to the Python Packaging User Guide [1]. [1] https://packaging.python.org More info: https://launchpad.net/~fkrull/+archive/ubuntu/deadsnakes gpg: keyring `/tmp/tmpehwawdod/secring.gpg' created gpg: keyring `/tmp/tmpehwawdod/pubring.gpg' created gpg: requesting key DB82666C from hkp server keyserver.ubuntu.com gpg: /tmp/tmpehwawdod/trustdb.gpg: trustdb created gpg: key DB82666C: public key "Launchpad Old Python Versions" imported gpg: Total number processed: 1 gpg: imported: 1 (RSA: 1) OK Ign http://us-west-2.ec2.archive.ubuntu.com trusty InRelease Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates InRelease Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports InRelease Hit http://us-west-2.ec2.archive.ubuntu.com trusty Release.gpg Hit http://us-west-2.ec2.archive.ubuntu.com trusty Release Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/main Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/restricted Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/universe Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/multiverse Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/main amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/restricted amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/universe amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/multiverse amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/main Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/multiverse Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/restricted Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-updates/universe Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/main Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/restricted Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/universe Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/multiverse Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/main amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/restricted amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/universe amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/multiverse amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/main Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/multiverse Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/restricted Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty-backports/universe Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty/main Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty/restricted Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty/universe Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty/multiverse Sources Hit http://us-west-2.ec2.archive.ubuntu.com trusty/main amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty/restricted amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty/universe amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty/multiverse amd64 Packages Hit http://us-west-2.ec2.archive.ubuntu.com trusty/main Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty/multiverse Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty/restricted Translation-en Hit http://us-west-2.ec2.archive.ubuntu.com trusty/universe Translation-en Ign http://us-west-2.ec2.archive.ubuntu.com trusty/main Translation-en_US Ign http://us-west-2.ec2.archive.ubuntu.com trusty/multiverse Translation-en_US Ign http://us-west-2.ec2.archive.ubuntu.com trusty/restricted Translation-en_US Ign http://us-west-2.ec2.archive.ubuntu.com trusty/universe Translation-en_US Hit http://ppa.launchpad.net trusty InRelease Hit http://security.ubuntu.com trusty-security InRelease Hit http://ppa.launchpad.net trusty/main amd64 Packages Hit http://security.ubuntu.com trusty-security/main Sources Hit http://ppa.launchpad.net trusty/main Translation-en Hit http://security.ubuntu.com trusty-security/universe Sources Hit http://security.ubuntu.com trusty-security/main amd64 Packages Hit http://security.ubuntu.com trusty-security/universe amd64 Packages Hit http://security.ubuntu.com trusty-security/main Translation-en Hit http://security.ubuntu.com trusty-security/universe Translation-en Reading package lists... Reading package lists... Building dependency tree... Reading state information... The following extra packages will be installed: libpython3.5-minimal libpython3.5-stdlib python3.5-minimal Suggested packages: python3.5-venv python3.5-doc binfmt-support The following NEW packages will be installed: libpython3.5-minimal libpython3.5-stdlib python3.5 python3.5-minimal 0 upgraded, 4 newly installed, 0 to remove and 4 not upgraded. Need to get 3,994 kB of archives. After this operation, 17.7 MB of additional disk space will be used. Get:1 http://ppa.launchpad.net/fkrull/deadsnakes/ubuntu/ trusty/main libpython3.5-minimal amd64 3.5.1-1+trusty1 [542 kB] Get:2 http://ppa.launchpad.net/fkrull/deadsnakes/ubuntu/ trusty/main python3.5-minimal amd64 3.5.1-1+trusty1 [1,195 kB] Get:3 http://ppa.launchpad.net/fkrull/deadsnakes/ubuntu/ trusty/main libpython3.5-stdlib amd64 3.5.1-1+trusty1 [2,075 kB] Get:4 http://ppa.launchpad.net/fkrull/deadsnakes/ubuntu/ trusty/main python3.5 amd64 3.5.1-1+trusty1 [182 kB] debconf: unable to initialize frontend: Dialog debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (This frontend requires a controlling tty.) debconf: falling back to frontend: Teletype dpkg-preconfigure: unable to re-open stdin: Fetched 3,994 kB in 6s (588 kB/s) Selecting previously unselected package libpython3.5-minimal:amd64. (Reading database ... 57416 files and directories currently installed.) Preparing to unpack .../libpython3.5-minimal_3.5.1-1+trusty1_amd64.deb ... Unpacking libpython3.5-minimal:amd64 (3.5.1-1+trusty1) ... Selecting previously unselected package python3.5-minimal. Preparing to unpack .../python3.5-minimal_3.5.1-1+trusty1_amd64.deb ... Unpacking python3.5-minimal (3.5.1-1+trusty1) ... Selecting previously unselected package libpython3.5-stdlib:amd64. Preparing to unpack .../libpython3.5-stdlib_3.5.1-1+trusty1_amd64.deb ... Unpacking libpython3.5-stdlib:amd64 (3.5.1-1+trusty1) ... Selecting previously unselected package python3.5. Preparing to unpack .../python3.5_3.5.1-1+trusty1_amd64.deb ... Unpacking python3.5 (3.5.1-1+trusty1) ... Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Processing triggers for mime-support (3.54ubuntu1.1) ... Setting up libpython3.5-minimal:amd64 (3.5.1-1+trusty1) ... Setting up python3.5-minimal (3.5.1-1+trusty1) ... Setting up libpython3.5-stdlib:amd64 (3.5.1-1+trusty1) ... Setting up python3.5 (3.5.1-1+trusty1) ...

sudo apt-get install --only-upgrade python3

Reading package lists... Building dependency tree... Reading state information... python3 is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 4 not upgraded.

%python
import os
os.popen?

File: 
Docstring :
popen(command [, mode='r' [, bufsize]]) -> pipe

Open a pipe to/from a command returning a file object.

%sshpy
import os
emails = [x for x in os.listdir('emails') if '@' in x]
for email in emails:
    print email

Warning: Permanently added 'ec2-52-27-227-5.us-west-2.compute.amazonaws.com,52.27.227.5' (ECDSA) to the list of known hosts. [email protected] [email protected] [email protected] [email protected] [email protected]

df -h

Filesystem Size Used Avail Use% Mounted on udev 492M 12K 492M 1% /dev tmpfs 100M 356K 99M 1% /run /dev/xvda1 7.8G 2.2G 5.2G 30% / none 4.0K 0 4.0K 0% /sys/fs/cgroup none 5.0M 0 5.0M 0% /run/lock none 497M 0 497M 0% /run/shm none 100M 0 100M 0% /run/user

du -sh emails

975M emails

%psql
DROP TABLE emails;
CREATE TABLE emails (FSLOCATION TEXT PRIMARY KEY, URL TEXT, DATETIME TIMESTAMP, EMAILTO JSON, CC JSON, BCC JSON, EMAILFROM TEXT, SUBJECT TEXT, RAW TEXT NOT NULL, ATTACHMENT_URLS JSON);
GRANT SELECT ON emails TO PUBLIC;

DROP TABLE CREATE TABLE GRANT

%psql
DROP TABLE emails;

DROP TABLE

%psql
CREATE INDEX datetime_index ON emails (DATETIME);

CREATE INDEX

%psql
INSERT INTO emails(FSLOCATION,DATETIME,EMAILTO,CC,BCC,EMAILFROM,SUBJECT,RAW,ATTACHMENT_URLS) VALUES('', TIMESTAMP '2016-07-05T14:49:03-07:00','["[email protected]"]', '[]', '[]', '[email protected]', 'test', 'test', '[]');

INSERT 0 1

%psql
SELECT * FROM EMAILS

fslocation | datetime | emailto | cc | bcc | emailfrom | subject | raw | attachment_urls -----------------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------------+----+-----+--------------------------------------------------------+----------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------- [email protected]/2016/3/28/153bf7e7dcaaa4a7.eml | 23:10:49 | "Tim Clemans <[email protected]>, \"Luck, Jolene\" <[email protected]>" | [] | [] | "Perry, Mary" <[email protected]> | RE: Coban Officer Notes Dataset | Delivered-To: [email protected]\r +| [] | | | | | | | Received: by 10.31.151.65 with SMTP id z62csp1726638vkd;\r +| | | | | | | | Mon, 28 Mar 2016 16:10:51 -0700 (PDT)\r +| | | | | | | | X-Received: by 10.202.190.87 with SMTP id o84mr13009398oif.109.1459206651296;\r +| | | | | | | | Mon, 28 Mar 2016 16:10:51 -0700 (PDT)\r +| | | | | | | | Return-Path: <[email protected]>\r +| | | | | | | | Received: from gcc01-dm2-obe.outbound.protection.outlook.com (mail-dm2gcc01on0053.outbound.protection.outlook.com. [23.103.201.53])\r +| | | | | | | | by mx.google.com with ESMTPS id y7si11047391obk.68.2016.03.28.16.10.51\r +| | | | | | | | for <[email protected]>\r +| | | | | | | | (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128);\r +| | | | | | | | Mon, 28 Mar 2016 16:10:51 -0700 (PDT)\r +| | | | | | | | Received-SPF: pass (google.com: domain of [email protected] designates 23.103.201.53 as permitted sender) client-ip=23.103.201.53;\r +| | | | | | | | Authentication-Results: mx.google.com;\r +| | | | | | | | dkim=pass [email protected];\r +| | | | | | | | spf=pass (google.com: domain of [email protected] designates 23.103.201.53 as permitted sender) [email protected]\r +| | | | | | | | DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;\r +| | | | | | | | d=seattlegov.onmicrosoft.com; s=selector1-seattle-gov;\r +| | | | | | | | h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version;\r +| | | | | | | | bh=au2ZLKVCipwvAduhIfaUT2TAEbByX8WlbsZZevhikdo=;\r +| | | | | | | | b=LA/zDkYpp7ipn8IA0BRLS2SAtbrBSnNYwMfrLyEIv9SOYI65Hfv5r5Nd2ARZ+pZ9Jom9RBf1CkOpz5N4/vOjF/k0k4Fuxq02uvg5DBsy+K4YP1jfbShJ9wR9C1Le3lo9/Mad1vUZPqiqvicJLkkugXfflZyL/OH03HIUqwLk+oY=\r +| | | | | | | | Received: from BN3PR09MB0627.namprd09.prod.outlook.com (10.160.120.142) by\r +| | | | | | | | SN1PR09MB0863.namprd09.prod.outlook.com (10.162.101.18) with Microsoft SMTP\r +| | | | | | | | Server (TLS) id 15.1.447.15; Mon, 28 Mar 2016 23:10:49 +0000\r +| | | | | | | | Received: from BN3PR09MB0627.namprd09.prod.outlook.com ([10.160.120.142]) by\r +| | | | | | | | BN3PR09MB0627.namprd09.prod.outlook.com ([10.160.120.142]) with mapi id\r +| | | | | | | | 15.01.0447.022; Mon, 28 Mar 2016 23:10:49 +0000\r +| | | | | | | | From: "Perry, Mary" <[email protected]>\r +| | | | | | | | To: Tim Clemans <[email protected]>, "Luck, Jolene" <[email protected]>\r +| | | | | | | | CC: "Baden, Toby" <[email protected]>\r [...]

%psql
create role publicapi with password 'publicapi1245' login;

CREATE ROLE

sudo pip install python-dateutil

Downloading/unpacking python-dateutil Requirement already satisfied (use --upgrade to upgrade): six>=1.5 in /usr/local/lib/python2.7/dist-packages (from python-dateutil) Installing collected packages: python-dateutil Successfully installed python-dateutil Cleaning up...

%sshpy
from dateutil.parser import parse
print parse('Tue, 5 Jul 2016 14:49:03 -0700').isoformat()

Warning: Permanently added 'ec2-52-27-227-5.us-west-2.compute.amazonaws.com,52.27.227.5' (ECDSA) to the list of known hosts. 2016-07-05T14:49:03-07:00

%python
-

f = open("remote_fs/emails/[email protected]/2016/7/5/155bd092e8924490.eml", "rb")
msg = extract(f, f.name)
f.close()

%python
msg.keys()

['from', 'text', 'parts', 'to', 'html', 'date', 'subject']

%python
import psycopg2
with open('settings.json', 'r') as f:
    settings = json.loads(f.read())
try:
    conn_string = "dbname='%s' user='%s' host='%s' password='%s' port='%s'" % (settings["psql_dbname"], settings["psql_username"], settings["psql_host"], settings["psql_password"], settings["psql_port"])
    conn = psycopg2.connect(conn_string)
    conn.autocommit = True
except:
    print "I am unable to connect to the database"

%psql
DROP TABLE emails;
CREATE TABLE emails (FSLOCATION TEXT PRIMARY KEY, DATETIME timestamp, EMAILTO JSON, CC JSON, BCC JSON, EMAILFROM TEXT, SUBJECT TEXT, RAW TEXT NOT NULL, ATTACHMENT_URLS JSON);

DROP TABLE CREATE TABLE

%psql

%psql
DROP TABLE testa;
DROP TABLE testb;
CREATE TABLE testa (ID serial PRIMARY KEY, DATETIME timestamp);
CREATE TABLE testb (ID serial PRIMARY KEY, start timestamp, stop timestamp);

DROP TABLE DROP TABLE CREATE TABLE CREATE TABLE

%psql
 INSERT INTO testa
 (DATETIME) 
 VALUES 
 (TIMESTAMP '2011-05-16 15:36:38');
 INSERT INTO testb
 (start, stop) 
 VALUES 
 (TIMESTAMP '2011-05-16 15:30:38', TIMESTAMP '2011-05-16 15:40:38');

INSERT 0 1 INSERT 0 1

%psql
SELECT * FROM testa;
SELECT * FROM testb;

id | datetime ----+--------------------- 1 | 2011-05-16 15:36:38 (1 row) id | start | stop ----+---------------------+--------------------- 1 | 2011-05-16 15:30:38 | 2011-05-16 15:40:38 (1 row)

%psql
SELECT A.*, B.* FROM testa as A JOIN testb as B ON A.datetime >= B.start AND A.datetime <= B.stop;

id | datetime | id | start | stop ----+---------------------+----+---------------------+--------------------- 1 | 2011-05-16 15:36:38 | 1 | 2011-05-16 15:30:38 | 2011-05-16 15:40:38 (1 row)

%python
import psycopg2
with open('settings.json', 'r') as f:
    settings = json.loads(f.read())
try:
    conn_string = "dbname='%s' user='%s' host='%s' password='%s' port='%s'" % (settings["psql_dbname"], settings["psql_username"], settings["psql_host"], settings["psql_password"], settings["psql_port"])
    conn = psycopg2.connect(conn_string)
    conn.autocommit = True
except:
    print "I am unable to connect to the database"
import os
import json
import email
from dateutil.parser import parse
for root, dirs, files in os.walk("remote_fs/emails", topdown=False):
    for name in files:
        if name.endswith('.eml'):
            path = os.path.join(root, name)
            f = open(path, "rb")
            msg = extract(f, f.name)
            f.close()
            with open(path, 'r') as f:
                raw = f.read()
            cur = conn.cursor()
            save_in_db = False
            for person in msg['to']:
                if 'seattle.gov' in person.lower() or 'kingcounty.gov' in person.lower() or 'mycusthelp.net' in person.lower():
                    save_in_db = True
            if 'seattle.gov' in msg['from'].lower() or 'kingcounty.gov' in msg['from'].lower() or 'mycusthelp.net' in msg['from'].lower():
                save_in_db = True
            to = email.utils.getaddresses([msg['to']])
            #print to
            if save_in_db:
                try:
                    cur.execute("""INSERT INTO emails(FSLOCATION,DATETIME,EMAILTO,CC,BCC,EMAILFROM,SUBJECT,RAW,ATTACHMENT_URLS) VALUES('%s', TIMESTAMP '%s','%s', '[]', '[]', '%s', '%s', '%s', '[]');""" % (path[len('remote_fs/emails/'):], parse(msg['date']).isoformat(), json.dumps(to).replace("'", "''"), msg['from'], msg['subject'].replace("'", "''"), raw.replace("'", "''")))
                except:
                    print json.dumps(to)

Error in lines 5-27 Traceback (most recent call last): File "/projects/sage/sage-6.10/local/lib/python2.7/site-packages/smc_sagews/sage_server.py", line 905, in execute exec compile(block+'\n', '', 'single') in namespace, locals File "", line 6, in <module> File "", line 10, in extract File "/projects/sage/sage-6.10/local/lib/python/email/__init__.py", line 66, in message_from_file return Parser(*args, **kws).parse(fp) File "/projects/sage/sage-6.10/local/lib/python/email/parser.py", line 68, in parse data = fp.read(8192) File "sage/ext/interrupt/interrupt.pyx", line 203, in sage.ext.interrupt.interrupt.sage_python_check_interrupt (/projects/sage/sage-6.10/src/build/cythonized/sage/ext/interrupt/interrupt.c:1890) sig_check() File "sage/ext/interrupt/interrupt.pyx", line 88, in sage.ext.interrupt.interrupt.sig_raise_exception (/projects/sage/sage-6.10/src/build/cythonized/sage/ext/interrupt/interrupt.c:924) raise KeyboardInterrupt KeyboardInterrupt

%python
cur = conn.cursor()
query = "SELECT * FROM emails ORDER BY DATETIME DESC LIMIT 1;"
cur.execute(query)

r = [dict((cur.description[i][0], value) \
           for i, value in enumerate(row)) for row in cur.fetchall()]
import pprint
pp = pprint.PrettyPrinter(indent=4)
pp.pprint(r)
print r[0]['raw']

[ { 'attachment_urls': [], 'bcc': [], 'cc': [], 'datetime': datetime.datetime(2016, 7, 6, 0, 54, 41), 'emailfrom': '"Lombardo, Kathy" <[email protected]>', 'emailto': [ [ u'Tim Clemans', u'[email protected]'], [ u'Flewelling, Deb', u'[email protected]']], 'fslocation': '[email protected]/2016/7/6/155bdb3459adbd95.eml', 'raw': 'Delivered-To: [email protected]\r\nReceived: by 10.159.54.171 with SMTP id p40csp574270uap;\r\n Tue, 5 Jul 2016 17:54:50 -0700 (PDT)\r\nX-Received: by 10.202.80.78 with SMTP id e75mr10150809oib.91.1467766490358;\r\n Tue, 05 Jul 2016 17:54:50 -0700 (PDT)\r\nReturn-Path: <[email protected]>\r\nReceived: from gcc01-CY1-obe.outbound.protection.outlook.com (mail-cy1gcc01on0132.outbound.protection.outlook.com. [23.103.200.132])\r\n by mx.google.com with ESMTPS id t18si316473oif.174.2016.07.05.17.54.50\r\n for <[email protected]>\r\n (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128);\r\n Tue, 05 Jul 2016 17:54:50 -0700 (PDT)\r\nReceived-SPF: pass (google.com: domain of [email protected] designates 23.103.200.132 as permitted sender) client-ip=23.103.200.132;\r\nAuthentication-Results: mx.google.com;\r\n dkim=pass [email protected];\r\n spf=pass (google.com: domain of [email protected] designates 23.103.200.132 as permitted sender) [email protected]\r\nDKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=KC1.onmicrosoft.com;\r\n s=selector1-kingcounty-gov;\r\n h=From:Date:Subject:Message-ID:Content-Type:MIME-Version;\r\n bh=xaquW84S5Nqvg5aCxTSDYaS35Anlk17E2Yovlktipjc=;\r\n b=ILwj4rDg+hLClGX7bAW8oLmeDshvfi3tXH6P+TMcq3xDGmnl0DyTlph0W4RHc1EpWquwaQw9w8NtHw979kX8MZtwVN4qfIRClb+L9gDhJeK4tPrWmh2xcZ54PyXZIpwAywQzPnVchSOmvTqztQFHlqFZMiRFBl3rCkomcji3TmE=\r\nReceived: from BN3PR09CA0038.namprd09.prod.outlook.com (10.160.111.176) by\r\n MWHPR09MB1293.namprd09.prod.outlook.com (10.172.50.135) with Microsoft SMTP\r\n Server (TLS) id 15.1.528.16; Wed, 6 Jul 2016 00:54:48 +0000\r\nReceived: from BY2FFO11FD015.protection.gbl (2a01:111:f400:7c0c::157) by\r\n BN3PR09CA0038.outlook.office365.com (2a01:111:e400:400b::48) with Microsoft\r\n SMTP Server (TLS) id 15.1.528.16 via Frontend Transport; Wed, 6 Jul 2016\r\n 00:54:48 +0000\r\nAuthentication-Results: spf=pass (sender IP is 146.129.239.99)\r\n smtp.mailfrom=kingcounty.gov; seattlepublicrecords.org; dkim=none (message\r\n not signed) header.d=none;seattlepublicrecords.org; dmarc=bestguesspass\r\n action=none header.from=kingcounty.gov;\r\nReceived-SPF: Pass (protection.outlook.com: domain of kingcounty.gov\r\n designates 146.129.239.99 as permitted sender)\r\n receiver=protection.outlook.com; client-ip=146.129.239.99;\r\n helo=MAILQDC1.kc.kingcounty.lcl;\r\nReceived: from MAILQDC1.kc.kingcounty.lcl (146.129.239.99) by\r\n BY2FFO11FD015.mail.protection.outlook.com (10.1.14.131) with Microsoft SMTP\r\n Server (TLS) id 15.1.534.7 via Frontend Transport; Wed, 6 Jul 2016 00:54:47\r\n +0000\r\nReceived: from MAILQDC2.kc.kingcounty.lcl ([fe80::45ee:bcae:d809:cb6]) by\r\n MAILQDC1.kc.kingcounty.lcl ([fe80::e0ed:d35e:468f:5921%20]) with mapi id\r\n 14.03.0301.000; Tue, 5 Jul 2016 17:54:42 -0700\r\nFrom: "Lombardo, Kathy" <[email protected]>\r\nTo: Tim Clemans <[email protected]>, "Flewelling, Deb"\r\n\t<[email protected]>\r\nSubject: Re: Texting to 911 Public records request\r\nThread-Topic: Texting to 911 Public records request\r\nThread-Index: AQHR1vYoZ3YOS6tDP02vRz90m03jWKAKlAiA\r\nDate: Wed, 6 Jul 2016 00:54:41 +0000\r\nMessage-ID: <[email protected]>\r\nReferences: <[e-mail]>\r\nIn-Reply-To: <[e-mail]>\r\nAccept-Language: en-US\r\nContent-Language: en-US\r\nX-MS-Has-Attach:\r\nX-MS-TNEF-Correlator:\r\nContent-Type: text/plain; charset="us-ascii"\r\nContent-Transfer-Encoding: quoted-printable\r\nMIME-Version: 1.0\r\nReturn-Path: [email protected]\r\nX-EOPAttributedMessage: 0\r\nX-MS-Office365-Filtering-HT: Tenant\r\nX-Forefront-Antispam-Report:\r\n\tCIP:146.129.239.99;IPV:NLI;CTRY:US;EFV:NLI;SFV:NSPM;SFS:(10019020)(6009001)(7916002)(2980300002)(438002)(199003)(24454002)(189002)(377454003)(8746002)(47776003)(9886003)(68736007)(8936002)(36756003)(450100001)(104016004)(6806005)(82746002)(19580405001)(107886002)(46406003)(305945005)(19580395003)(7846002)(50466002)(189998001)(5003630100001)(81156014)(86362001)(8676002)(586003)(81166006)(2906002)(5250100002)(4001450100002)(83716003)(106116001)(11100500001)(356003)(106466001)(97756001)(87936001)(5001770100001)(97736004)(33656002)(92566002)(76176999)(2950100001)(50986999)(102836003)(2900100001)(54356999)(23726003)(104396002);DIR:OUT;SFP:1102;SCL:1;SRVR:MWHPR09MB1293;H:MAILQDC1.kc.kingcounty.lcl;FPR:;SPF:Pass;PTR:InfoDomainNonexistent;A:1;MX:1;LANG:en;\r\nX-Microsoft-Exchange-Diagnostics: 1;BY2FFO11FD015;1:zE7PiFEK0/Ce1CpU7bxgXSPGMlEDd3fSVhccnCITuzfeZ8NIOKua6ukaTzGAPdqzzJA1eycbls7GN6a34o0k0uLLDjKF+JlPTqrjodL55TXkZ3MjM/B5DgcfQbN/oPJtBHZS1abQ/+zkFH4PMrpbISm8Dlu1QQ/LGYFj3cv5L8JAfSFHEBWH2DHE2+i/AQpyOunMj8EsC+I4tOljF6p0oPbpM+c5lFXITrDJT5NvlSMKhXB6TuHfyWPk6ktjOXUUZC7s4Z9a2N6D4U2/LqmEUr1d2BLvlNniM9VH4jIVghrO5dKdlbHr9enRj32FNf6uivjiCTahFt5WdYUEi0fIZ7xV//hfaX36PMNPWOt+z9JZF9AN8pLizbIGKumcDCovQoPVEDN1tLpY8hYULpPWdhzg8JoSsZjx+HEnxltTSTZHJHLwcpRChQcqb0lQh14Qt0mF1uMWntmkPISHpvw7YrsMb4vlp38VVvru1lBxTAQylx7T8PcC3AJPTvkwrMOvpZzgHgyF8ESdGl/gUagVUTYnpWRoFbCIrJhOVY/OgBU=\r\nX-MS-Office365-Filtering-Correlation-Id: a7696200-9549-4b83-240b-08d3a53820bc\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t1;MWHPR09MB1293;2:B+LZATb8N2JZtU+rcOuoGcJDREWp6sU3rqnqNyP8BW3ftpWaPRxazfi9GU3mj6e0regoaj0LS1BmFSTEkPIpf66kNj45T47wVSs6e89V3utPWQNO4mWQlWsJroXETPmeTSe5lR9HNmu11FDAQtLyyN1UqR77Wc8/4YsXjAmrx0W70u03ASW7qzgVuTx1JkeK;3:4CcPXjGyo3QmLy50wYd+qcdYu3qDwRhbeYCt4yAWx+TrTl57rlNcjckIttITd1/qqWez9g45FT1LZbU1Vgu1KLRhczGYCUW+m2xnbRhwerCGx2y4E0KNAgmEbct4HQtrZaN6pBC24L6esD4l0wCXIM0A3YoTXU/IbJvEoDOINoCgQveChnEsW2YVv8NbWAaly9MWolkFYD6En1ICON41EdVx6bKKEYjUuWgjRqYjMnRv6fJM2N3su695wxA6vL4Rqw925W8FGFrIMthp0C0Upg==\r\nX-Microsoft-Antispam:\r\n\tUriScan:;BCL:0;PCL:0;RULEID:(8251501002);SRVR:MWHPR09MB1293;\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t1;MWHPR09MB1293;25:AQimd+mAfG6ajcr9JPv7sVMT2ElHT5Lu6RhF+aXSgtceEsdnwjd1AZlNCy736N7yFeaydFVZ0RKKjD20r2dSsSDWtlgPCQjVdfVtLa+XGkIUQZGT9VVpDwswuu0Xe0/WxNSPFdOmQYFyqhHAodprpJ8jws1OmgK4Jhv1tKzAoJe4A6aEjzGvkGg6BDVRc/SZzVNwrZRP8xBvYnwpE3agYsOixDn4kUKDAqCd8SMWNvgHIu9Sp2hfFZZEr9r9j4GPs83zk9CsfepJpEppccrtfmzmDYCMH8rHaaQhEXCtgtoYYoLHDyS1VkzPCp8FAoiy5+E1pi/ZIzbMIdzXBCqFQnJP8ywPoLqxqIdyb03LC3EyO5lc12q5dT+NmIS9p2EdIHDdoTmK9BCElc1BrM3skCxir8+gQ7DtCkLMWoekcRGRnalj0s4nCzh4Pr0okIxc5DHS5nx8Tyf0l4KrzGtFpV2vPtO3CsYIC0yqkApNi7r0qbxCxwgjy3GGes9i4iXfKuA3do8E9rCAMCBNNGkHWktC6eMG0QEOAtNXpCo6eP/i2GvuRAzx0Nxi0iaanBmmeMmJ6wmDGxwbIFXay61iRGi2QW81KMc2wGqhfjOYQTMIuSYB+ut2jRAcZInHryMjUHH8mLSu1n+a9yoDiyfIhBJULn8mOovQpIzF/QE4z8lj44b7cVRJPzOnCwbVbE0tsGoB05HLG5kxuHr+73qbjvvLnZsT7tZvMEV/Kb27h1EhcgbPlGUY1ulV2VcLbcN6g9WsTr9MqgWkcbn1phVWrg==\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t1;MWHPR09MB1293;31:MacBT5V/V3ZDwh258D/ey46NMB31c1mD3utcwWcOV1NINme06PoCh+GeA/5/qOkvS7+qM5NhQBMiVqn2oHr2s80JAzwFXf7qFkSsadkupfNzHwMFalQv2iSmDtXI+jeVFb9IHm4sxZUH5zJjQHE/Xsj3wNL6gUM3wTDIwNhwpvgyRAS19/5XnDvHvaRfeawiwEGtqA5rMzuhZ7pgZi+8pg==;20:sWzs09vrcNF0fnaAFAmEzh8AFdmcWYHaAvytwq0Qc7xeAFzeu/AyWkSUPB08JQwY5+kSLVUuJxLk0yDfbj4KmBH+apDOsYSgxAmeK66QMwhfL4rXXAda6k4CLBqPpUHNlRkX3/Ht2GVSZpxqQxHP4amFa7QVWFsH314uo274t3mr+hf/+6FMLbJK2h2pLdiGvjH5aD/DMhk1RpXEi8YXd2yFE/tKu8+0TMvpeh2gTIiz4D4fZ5dNlHdoFmdRR3WYrYhGpSd/ekO07xEttVHALMPWxSCq6KECtSkZewx/xIi9wkcMlaUxIB159XWIBylNWPiGvvSWJ74t2l2kAwK0prG1pp4CUUbuG9us2NmJoo6f8Vszo1l36fEdP/p+0u+AWIPuobOW3zphWKAPnhfLye3RFna+Jm2GbQr8XwrdoR1ws73Vve5Q9Vs87jwdV/uUVOW+zSwJbzrCmeerYK+If8SB33R++vxV+5cljLY7kuSTejMCNYhdtjhcDCrnJS39\r\nX-Microsoft-Antispam-PRVS:\r\n\t<[e-mail]>\r\nX-Exchange-Antispam-Report-Test: UriScan:;\r\nX-Exchange-Antispam-Report-CFA-Test:\r\n\tBCL:0;PCL:0;RULEID:(601004)(2401047)(13024025)(13023025)(13017025)(13015025)(13018025)(5005006)(8121501046)(10201501046)(3002001)(6055026);SRVR:MWHPR09MB1293;BCL:0;PCL:0;RULEID:;SRVR:MWHPR09MB1293;\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t1;MWHPR09MB1293;4:MTz6aoC/ULhJpYVFFyze+C0JaJjhSOlRORnrm9A5Z1yvMKyYjB58ceWExPPUVHpzHW/6jImULkbd0utnvVzfUj6M6ekgcwVzJHmuoUdl/CRqX0Sp0Hrq4BehaEXk1tfwlxnnSnh+p9EQ73iWuEjnsgduhyE+cy7+Nl1h9rGks+BmVoUSud/P/UD0G0cHL36LlUCOYXp3tTlWsEvpX6+Dw9DUguxyZ+KVN/15x82l6dnh7+mC7Ex+qaqqwGylJY0Ed22pIbRgQQDScOy2rFrGZl9CE2GDswUCjazeJODlTnIZcYWfxBt5DJDJX9ZLB5c/zvqignpDy+Xkwiym2sDreIJsZNcdqKxRP4yJsd0Bn7Yqva++sqQvcu37o+D4IxTQcz/ocaX3s1+EeaEWMOlIriQ2JCV1PhqxXgmDZxDaWSAjXMYAQrNM+zyyMFVGJEIj6e/ut7riapRca0v2koWw9BnjhktTYUghX6JgkmT/hZM=\r\nX-Forefront-PRVS: 0995196AA2\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t=?us-ascii?Q?1;MWHPR09MB1293;23:Sa1Mfv8OHly29i6mRzXQPxN5QQCFbOrfr86gHhMjP?=\r\n =?us-ascii?Q?Ei0U4fE35gMhfd4hddwhF0hfOcet4nGkVn80GP16ImFjL/yAC8Ha6Rk3SSm8?=\r\n =?us-ascii?Q?eLvyVwx9b4TGXw6iAyrWabXgIXy7/FE38riT6yEdVvI/qQSAVQETg002xZ3t?=\r\n =?us-ascii?Q?mm4BETSW1Q0RxY0aKJAO94U5WFPqeEqg5ldD7JASxOC5i+DLF+Zic3n8MYRr?=\r\n =?us-ascii?Q?LddPj0QFdRqjNw/RvSpM27rFcGHn1oNNjMVLyR/M51VIX4foyKn9TCI7JwhV?=\r\n =?us-ascii?Q?FXF1JwV5Oow5kERcMddJ8k3mba8oiy7aNvUoimAVz7RJkmIoK1+ow8thC33N?=\r\n =?us-ascii?Q?BO3B5qTLgRSZvM7T52oie6ZvLyRL8dbcmCbjuLbqBUhCImAxc/p+V5E/0+4h?=\r\n =?us-ascii?Q?BbbnUoUznWcBtoMHJ/OpbXv1xuYzrM/CUWfUwbYXleGrILN4SRyeYoyUnUe8?=\r\n =?us-ascii?Q?m+yux6DmumaYnlwiBtgGCyPS1FCyuPjB6Tpb7mOPPfghCfLYR9Lei3fp9MA9?=\r\n =?us-ascii?Q?BnNt2MxQ+RzQGRzwjmOEQTMJAemKD+yDEJxnKh0ml8O2c6jC/mKpwHrWBmAH?=\r\n =?us-ascii?Q?HpJZobDrM4H+b+RvZc2YEqlWp1M3gJGDrOQODDYysNBXIHjUYDa0si2l0TeY?=\r\n =?us-ascii?Q?4eliFsTwqpsE50RmoGiLNgp7dxh+l0WjEpbOZ5nDSG0Sj1y15+57fMZyZIwY?=\r\n =?us-ascii?Q?1PLHw8qoQ/bmz8pUz+ZF0koHAWo9DzGphGbOou5AHnvxoUkN6rOY0Z+hgERJ?=\r\n =?us-ascii?Q?qwAdWjmJjwtAQv4u31CVY8Fr/0AosAMkJH4XxnR3t0RanU1RP6YM7rNdgP7m?=\r\n =?us-ascii?Q?g9HAmSIWH8ITx18+8jngGxlAqx1c3I7hdjba4bP7xv25uahR93M6Bn6ewqvn?=\r\n =?us-ascii?Q?5G65TJYRWXw4rwWhDBDO2/LIxyWeKsmaPExwxg2+4/OrIcxpi/vWg1jEuzW0?=\r\n =?us-ascii?Q?DqrA7nSVpiEq6JxfCHH4u/BrVHDRBC2aCxqwuChW2JWI9NizTOLlAbZoX7NM?=\r\n =?us-ascii?Q?ncx9Vv34sYvk9QqCEoEbbsf3q4RUw3eSJJGsQJ38UDkIUzXSxte5Zy2xJMj5?=\r\n =?us-ascii?Q?Td3NC6fpsyH+n0oGLBPO94ArIUk+axs9myGidRn1Txehytf+0wBQT7kmVFcy?=\r\n =?us-ascii?Q?gRxHntREJza9nAihQijyRRhm6mdjnWl/W6IGklBUQzyXP7WPrlytMFlcH4yo?=\r\n =?us-ascii?Q?YliY3CsyL8IDW5Da4WlPdDyI1JMOZjp5e8kWbC8sncm1eHLPqtMQP7PY49mN?=\r\n =?us-ascii?Q?NC4sSBZmP57WFpGB0Ft1kAZAW0cov9KwISMMOUBT7ZCe6FeAm24/n4aMjO1D?=\r\n =?us-ascii?Q?EU6hus9ZhzcL/GvSx0FTrd41kWJkfC/wDwgIw6QllWLoYO5cPTKIe9GoLxcx?=\r\n =?us-ascii?Q?Wawgg=3D=3D?=\r\nX-Microsoft-Exchange-Diagnostics:\r\n\t1;MWHPR09MB1293;6:2gysj0HyT6Zl45SjQy7nwSQDUpEwNGA3RMs0KCI+edji45Pom1eJTGwHGoIVUho+2Mc84hGC6myXDbONF/UJ/24Wqwy+QA1UBBsHyIeUdnlGVnd3djrOYfKa0dGsD8nQeHJjCrmH2zJqkcj1H5ONTjCcix12quPWo7facOcCvrrFWj5aLALPAJEqOL7/I9wivXW/v1zzZQBvBqFgF3Uqvh71P/MLtyWfvUGuQv9D1RNRI07jMwNsaCK/qiDrfbTIiDOz0crLt8UZSO3vGQOtNQLAPdF1yigeR/Zp/dyxKpueRKCNw4dcdpOhDDzF7uZ2WlkMlEPPkmIo0EfE3F4vHg==;5:B0Kj4WkvNFpEtB5hVGFa7AVAwaJJl64pibklpEvHCcvsIOy/Db/R7ulphltEchkEIbZR0XXn4UMkocr3dX35UhywN9hLXEIi2yvb5zWVeS6JGzLXeXMuITSlr5tgMVJk3+NGjgl5DrsHiEaJrr+RtA==;24:+ODYj1UnhGDCB3YOJ8cBYzLt/p2OjKo8745GOOl0VddxstgvvA44eIljv3fbKbQA7YCU042VzC2DbOETmxSovLFQ6PE4yov4I0xJmfzlaP4=;7:b3Ugdqm10tBERL2bTvS+g5vudH+vU+/tynqRoGp5Aqg01I/dQ9stMxUvXxhvzhTNrCP2YIc6yk67A+V888toxIYtpf/zrv572TC8H36KnRZHICc4ZPqXwILvtwHIVsDOXi2kTa7mvnHFvJsHFa49Ya4oj1IbillzrX5iVBWUorX3IEg+OfEziRvCS8HzjD2c6kw7gomM4G3XFvDq2uzZhyj0w5iw5OIOuJfgs+OrsCZfLRymKljc7YEaOnqD3H/+\r\nSpamDiagnosticOutput: 1:99\r\nSpamDiagnosticMetadata: NSPM\r\nX-OriginatorOrg: kingcounty.gov\r\nX-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Jul 2016 00:54:47.2828\r\n (UTC)\r\nX-MS-Exchange-CrossTenant-Id: bae5059a-76f0-49d7-9996-72dfe95d69c7\r\nX-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=bae5059a-76f0-49d7-9996-72dfe95d69c7;Ip=[146.129.239.99];Helo=[MAILQDC1.kc.kingcounty.lcl]\r\nX-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem\r\nX-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR09MB1293\r\n\r\nHi Tim,\r\nI have included Deb Flewelling on your email. I hope to speak with Deb tomo=\r\nrrow morning re: your request and \'the email\' request.\r\nThanks for your inquiry.\r\nKathy Lombardo\r\n\r\nSent from my iPhone\r\n\r\n> On Jul 5, 2016, at 12:48 PM, Tim Clemans <tim.clemans@seattlepublicrecord=\r\ns.org> wrote:\r\n>=20\r\n> Hi Kathy,\r\n>=20\r\n> This is a public records act request for the last email sent by anyone\r\n> who works in the Enhanced 911 Program Office discussing texting to\r\n> 911. Please email me that email. If you are not the correct person to\r\n> send this records request to please immediately tell me where to send\r\n> it. The purpose of the request to is find out what\'s holding up the\r\n> deployment of texting to 911 for Seattle Police and was told that the\r\n> county is in charge of texting to 911 deployment.\r\n>=20\r\n> Thank you,\r\n> Tim\r\n', 'subject': 'Re: Texting to 911 Public records request'}] Delivered-To: [email protected] Received: by 10.159.54.171 with SMTP id p40csp574270uap; Tue, 5 Jul 2016 17:54:50 -0700 (PDT) X-Received: by 10.202.80.78 with SMTP id e75mr10150809oib.91.1467766490358; Tue, 05 Jul 2016 17:54:50 -0700 (PDT) Return-Path: <[email protected]> Received: from gcc01-CY1-obe.outbound.protection.outlook.com (mail-cy1gcc01on0132.outbound.protection.outlook.com. [23.103.200.132]) by mx.google.com with ESMTPS id t18si316473oif.174.2016.07.05.17.54.50 for <[email protected]> (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Tue, 05 Jul 2016 17:54:50 -0700 (PDT) Received-SPF: pass (google.com: domain of [email protected] designates 23.103.200.132 as permitted sender) client-ip=23.103.200.132; Authentication-Results: mx.google.com; dkim=pass [email protected]; spf=pass (google.com: domain of [email protected] designates 23.103.200.132 as permitted sender) [email protected] DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=KC1.onmicrosoft.com; s=selector1-kingcounty-gov; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=xaquW84S5Nqvg5aCxTSDYaS35Anlk17E2Yovlktipjc=; b=ILwj4rDg+hLClGX7bAW8oLmeDshvfi3tXH6P+TMcq3xDGmnl0DyTlph0W4RHc1EpWquwaQw9w8NtHw979kX8MZtwVN4qfIRClb+L9gDhJeK4tPrWmh2xcZ54PyXZIpwAywQzPnVchSOmvTqztQFHlqFZMiRFBl3rCkomcji3TmE= Received: from BN3PR09CA0038.namprd09.prod.outlook.com (10.160.111.176) by MWHPR09MB1293.namprd09.prod.outlook.com (10.172.50.135) with Microsoft SMTP Server (TLS) id 15.1.528.16; Wed, 6 Jul 2016 00:54:48 +0000 Received: from BY2FFO11FD015.protection.gbl (2a01:111:f400:7c0c::157) by BN3PR09CA0038.outlook.office365.com (2a01:111:e400:400b::48) with Microsoft SMTP Server (TLS) id 15.1.528.16 via Frontend Transport; Wed, 6 Jul 2016 00:54:48 +0000 Authentication-Results: spf=pass (sender IP is 146.129.239.99) smtp.mailfrom=kingcounty.gov; seattlepublicrecords.org; dkim=none (message not signed) header.d=none;seattlepublicrecords.org; dmarc=bestguesspass action=none header.from=kingcounty.gov; Received-SPF: Pass (protection.outlook.com: domain of kingcounty.gov designates 146.129.239.99 as permitted sender) receiver=protection.outlook.com; client-ip=146.129.239.99; helo=MAILQDC1.kc.kingcounty.lcl; Received: from MAILQDC1.kc.kingcounty.lcl (146.129.239.99) by BY2FFO11FD015.mail.protection.outlook.com (10.1.14.131) with Microsoft SMTP Server (TLS) id 15.1.534.7 via Frontend Transport; Wed, 6 Jul 2016 00:54:47 +0000 Received: from MAILQDC2.kc.kingcounty.lcl ([fe80::45ee:bcae:d809:cb6]) by MAILQDC1.kc.kingcounty.lcl ([fe80::e0ed:d35e:468f:5921%20]) with mapi id 14.03.0301.000; Tue, 5 Jul 2016 17:54:42 -0700 From: "Lombardo, Kathy" <[email protected]> To: Tim Clemans <[email protected]>, "Flewelling, Deb" <[email protected]> Subject: Re: Texting to 911 Public records request Thread-Topic: Texting to 911 Public records request Thread-Index: AQHR1vYoZ3YOS6tDP02vRz90m03jWKAKlAiA Date: Wed, 6 Jul 2016 00:54:41 +0000 Message-ID: <[email protected]> References: <[e-mail]> In-Reply-To: <[e-mail]> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Return-Path: [email protected] X-EOPAttributedMessage: 0 X-MS-Office365-Filtering-HT: Tenant X-Forefront-Antispam-Report: CIP:146.129.239.99;IPV:NLI;CTRY:US;EFV:NLI;SFV:NSPM;SFS:(10019020)(6009001)(7916002)(2980300002)(438002)(199003)(24454002)(189002)(377454003)(8746002)(47776003)(9886003)(68736007)(8936002)(36756003)(450100001)(104016004)(6806005)(82746002)(19580405001)(107886002)(46406003)(305945005)(19580395003)(7846002)(50466002)(189998001)(5003630100001)(81156014)(86362001)(8676002)(586003)(81166006)(2906002)(5250100002)(4001450100002)(83716003)(106116001)(11100500001)(356003)(106466001)(97756001)(87936001)(5001770100001)(97736004)(33656002)(92566002)(76176999)(2950100001)(50986999)(102836003)(2900100001)(54356999)(23726003)(104396002);DIR:OUT;SFP:1102;SCL:1;SRVR:MWHPR09MB1293;H:MAILQDC1.kc.kingcounty.lcl;FPR:;SPF:Pass;PTR:InfoDomainNonexistent;A:1;MX:1;LANG:en; X-Microsoft-Exchange-Diagnostics: 1;BY2FFO11FD015;1:zE7PiFEK0/Ce1CpU7bxgXSPGMlEDd3fSVhccnCITuzfeZ8NIOKua6ukaTzGAPdqzzJA1eycbls7GN6a34o0k0uLLDjKF+JlPTqrjodL55TXkZ3MjM/B5DgcfQbN/oPJtBHZS1abQ/+zkFH4PMrpbISm8Dlu1QQ/LGYFj3cv5L8JAfSFHEBWH2DHE2+i/AQpyOunMj8EsC+I4tOljF6p0oPbpM+c5lFXITrDJT5NvlSMKhXB6TuHfyWPk6ktjOXUUZC7s4Z9a2N6D4U2/LqmEUr1d2BLvlNniM9VH4jIVghrO5dKdlbHr9enRj32FNf6uivjiCTahFt5WdYUEi0fIZ7xV//hfaX36PMNPWOt+z9JZF9AN8pLizbIGKumcDCovQoPVEDN1tLpY8hYULpPWdhzg8JoSsZjx+HEnxltTSTZHJHLwcpRChQcqb0lQh14Qt0mF1uMWntmkPISHpvw7YrsMb4vlp38VVvru1lBxTAQylx7T8PcC3AJPTvkwrMOvpZzgHgyF8ESdGl/gUagVUTYnpWRoFbCIrJhOVY/OgBU= X-MS-Office365-Filtering-Correlation-Id: a7696200-9549-4b83-240b-08d3a53820bc X-Microsoft-Exchange-Diagnostics: 1;MWHPR09MB1293;2:B+LZATb8N2JZtU+rcOuoGcJDREWp6sU3rqnqNyP8BW3ftpWaPRxazfi9GU3mj6e0regoaj0LS1BmFSTEkPIpf66kNj45T47wVSs6e89V3utPWQNO4mWQlWsJroXETPmeTSe5lR9HNmu11FDAQtLyyN1UqR77Wc8/4YsXjAmrx0W70u03ASW7qzgVuTx1JkeK;3:4CcPXjGyo3QmLy50wYd+qcdYu3qDwRhbeYCt4yAWx+TrTl57rlNcjckIttITd1/qqWez9g45FT1LZbU1Vgu1KLRhczGYCUW+m2xnbRhwerCGx2y4E0KNAgmEbct4HQtrZaN6pBC24L6esD4l0wCXIM0A3YoTXU/IbJvEoDOINoCgQveChnEsW2YVv8NbWAaly9MWolkFYD6En1ICON41EdVx6bKKEYjUuWgjRqYjMnRv6fJM2N3su695wxA6vL4Rqw925W8FGFrIMthp0C0Upg== X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(8251501002);SRVR:MWHPR09MB1293; X-Microsoft-Exchange-Diagnostics: 1;MWHPR09MB1293;25:AQimd+mAfG6ajcr9JPv7sVMT2ElHT5Lu6RhF+aXSgtceEsdnwjd1AZlNCy736N7yFeaydFVZ0RKKjD20r2dSsSDWtlgPCQjVdfVtLa+XGkIUQZGT9VVpDwswuu0Xe0/WxNSPFdOmQYFyqhHAodprpJ8jws1OmgK4Jhv1tKzAoJe4A6aEjzGvkGg6BDVRc/SZzVNwrZRP8xBvYnwpE3agYsOixDn4kUKDAqCd8SMWNvgHIu9Sp2hfFZZEr9r9j4GPs83zk9CsfepJpEppccrtfmzmDYCMH8rHaaQhEXCtgtoYYoLHDyS1VkzPCp8FAoiy5+E1pi/ZIzbMIdzXBCqFQnJP8ywPoLqxqIdyb03LC3EyO5lc12q5dT+NmIS9p2EdIHDdoTmK9BCElc1BrM3skCxir8+gQ7DtCkLMWoekcRGRnalj0s4nCzh4Pr0okIxc5DHS5nx8Tyf0l4KrzGtFpV2vPtO3CsYIC0yqkApNi7r0qbxCxwgjy3GGes9i4iXfKuA3do8E9rCAMCBNNGkHWktC6eMG0QEOAtNXpCo6eP/i2GvuRAzx0Nxi0iaanBmmeMmJ6wmDGxwbIFXay61iRGi2QW81KMc2wGqhfjOYQTMIuSYB+ut2jRAcZInHryMjUHH8mLSu1n+a9yoDiyfIhBJULn8mOovQpIzF/QE4z8lj44b7cVRJPzOnCwbVbE0tsGoB05HLG5kxuHr+73qbjvvLnZsT7tZvMEV/Kb27h1EhcgbPlGUY1ulV2VcLbcN6g9WsTr9MqgWkcbn1phVWrg== X-Microsoft-Exchange-Diagnostics: 1;MWHPR09MB1293;31:MacBT5V/V3ZDwh258D/ey46NMB31c1mD3utcwWcOV1NINme06PoCh+GeA/5/qOkvS7+qM5NhQBMiVqn2oHr2s80JAzwFXf7qFkSsadkupfNzHwMFalQv2iSmDtXI+jeVFb9IHm4sxZUH5zJjQHE/Xsj3wNL6gUM3wTDIwNhwpvgyRAS19/5XnDvHvaRfeawiwEGtqA5rMzuhZ7pgZi+8pg==;20:sWzs09vrcNF0fnaAFAmEzh8AFdmcWYHaAvytwq0Qc7xeAFzeu/AyWkSUPB08JQwY5+kSLVUuJxLk0yDfbj4KmBH+apDOsYSgxAmeK66QMwhfL4rXXAda6k4CLBqPpUHNlRkX3/Ht2GVSZpxqQxHP4amFa7QVWFsH314uo274t3mr+hf/+6FMLbJK2h2pLdiGvjH5aD/DMhk1RpXEi8YXd2yFE/tKu8+0TMvpeh2gTIiz4D4fZ5dNlHdoFmdRR3WYrYhGpSd/ekO07xEttVHALMPWxSCq6KECtSkZewx/xIi9wkcMlaUxIB159XWIBylNWPiGvvSWJ74t2l2kAwK0prG1pp4CUUbuG9us2NmJoo6f8Vszo1l36fEdP/p+0u+AWIPuobOW3zphWKAPnhfLye3RFna+Jm2GbQr8XwrdoR1ws73Vve5Q9Vs87jwdV/uUVOW+zSwJbzrCmeerYK+If8SB33R++vxV+5cljLY7kuSTejMCNYhdtjhcDCrnJS39 X-Microsoft-Antispam-PRVS: <[e-mail]> X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(601004)(2401047)(13024025)(13023025)(13017025)(13015025)(13018025)(5005006)(8121501046)(10201501046)(3002001)(6055026);SRVR:MWHPR09MB1293;BCL:0;PCL:0;RULEID:;SRVR:MWHPR09MB1293; X-Microsoft-Exchange-Diagnostics: 1;MWHPR09MB1293;4:MTz6aoC/ULhJpYVFFyze+C0JaJjhSOlRORnrm9A5Z1yvMKyYjB58ceWExPPUVHpzHW/6jImULkbd0utnvVzfUj6M6ekgcwVzJHmuoUdl/CRqX0Sp0Hrq4BehaEXk1tfwlxnnSnh+p9EQ73iWuEjnsgduhyE+cy7+Nl1h9rGks+BmVoUSud/P/UD0G0cHL36LlUCOYXp3tTlWsEvpX6+Dw9DUguxyZ+KVN/15x82l6dnh7+mC7Ex+qaqqwGylJY0Ed22pIbRgQQDScOy2rFrGZl9CE2GDswUCjazeJODlTnIZcYWfxBt5DJDJX9ZLB5c/zvqignpDy+Xkwiym2sDreIJsZNcdqKxRP4yJsd0Bn7Yqva++sqQvcu37o+D4IxTQcz/ocaX3s1+EeaEWMOlIriQ2JCV1PhqxXgmDZxDaWSAjXMYAQrNM+zyyMFVGJEIj6e/ut7riapRca0v2koWw9BnjhktTYUghX6JgkmT/hZM= X-Forefront-PRVS: 0995196AA2 X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1;MWHPR09MB1293;23:Sa1Mfv8OHly29i6mRzXQPxN5QQCFbOrfr86gHhMjP?= =?us-ascii?Q?Ei0U4fE35gMhfd4hddwhF0hfOcet4nGkVn80GP16ImFjL/yAC8Ha6Rk3SSm8?= =?us-ascii?Q?eLvyVwx9b4TGXw6iAyrWabXgIXy7/FE38riT6yEdVvI/qQSAVQETg002xZ3t?= =?us-ascii?Q?mm4BETSW1Q0RxY0aKJAO94U5WFPqeEqg5ldD7JASxOC5i+DLF+Zic3n8MYRr?= =?us-ascii?Q?LddPj0QFdRqjNw/RvSpM27rFcGHn1oNNjMVLyR/M51VIX4foyKn9TCI7JwhV?= =?us-ascii?Q?FXF1JwV5Oow5kERcMddJ8k3mba8oiy7aNvUoimAVz7RJkmIoK1+ow8thC33N?= =?us-ascii?Q?BO3B5qTLgRSZvM7T52oie6ZvLyRL8dbcmCbjuLbqBUhCImAxc/p+V5E/0+4h?= =?us-ascii?Q?BbbnUoUznWcBtoMHJ/OpbXv1xuYzrM/CUWfUwbYXleGrILN4SRyeYoyUnUe8?= =?us-ascii?Q?m+yux6DmumaYnlwiBtgGCyPS1FCyuPjB6Tpb7mOPPfghCfLYR9Lei3fp9MA9?= =?us-ascii?Q?BnNt2MxQ+RzQGRzwjmOEQTMJAemKD+yDEJxnKh0ml8O2c6jC/mKpwHrWBmAH?= =?us-ascii?Q?HpJZobDrM4H+b+RvZc2YEqlWp1M3gJGDrOQODDYysNBXIHjUYDa0si2l0TeY?= =?us-ascii?Q?4eliFsTwqpsE50RmoGiLNgp7dxh+l0WjEpbOZ5nDSG0Sj1y15+57fMZyZIwY?= =?us-ascii?Q?1PLHw8qoQ/bmz8pUz+ZF0koHAWo9DzGphGbOou5AHnvxoUkN6rOY0Z+hgERJ?= =?us-ascii?Q?qwAdWjmJjwtAQv4u31CVY8Fr/0AosAMkJH4XxnR3t0RanU1RP6YM7rNdgP7m?= =?us-ascii?Q?g9HAmSIWH8ITx18+8jngGxlAqx1c3I7hdjba4bP7xv25uahR93M6Bn6ewqvn?= =?us-ascii?Q?5G65TJYRWXw4rwWhDBDO2/LIxyWeKsmaPExwxg2+4/OrIcxpi/vWg1jEuzW0?= =?us-ascii?Q?DqrA7nSVpiEq6JxfCHH4u/BrVHDRBC2aCxqwuChW2JWI9NizTOLlAbZoX7NM?= =?us-ascii?Q?ncx9Vv34sYvk9QqCEoEbbsf3q4RUw3eSJJGsQJ38UDkIUzXSxte5Zy2xJMj5?= =?us-ascii?Q?Td3NC6fpsyH+n0oGLBPO94ArIUk+axs9myGidRn1Txehytf+0wBQT7kmVFcy?= =?us-ascii?Q?gRxHntREJza9nAihQijyRRhm6mdjnWl/W6IGklBUQzyXP7WPrlytMFlcH4yo?= =?us-ascii?Q?YliY3CsyL8IDW5Da4WlPdDyI1JMOZjp5e8kWbC8sncm1eHLPqtMQP7PY49mN?= =?us-ascii?Q?NC4sSBZmP57WFpGB0Ft1kAZAW0cov9KwISMMOUBT7ZCe6FeAm24/n4aMjO1D?= =?us-ascii?Q?EU6hus9ZhzcL/GvSx0FTrd41kWJkfC/wDwgIw6QllWLoYO5cPTKIe9GoLxcx?= =?us-ascii?Q?Wawgg=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR09MB1293;6:2gysj0HyT6Zl45SjQy7nwSQDUpEwNGA3RMs0KCI+edji45Pom1eJTGwHGoIVUho+2Mc84hGC6myXDbONF/UJ/24Wqwy+QA1UBBsHyIeUdnlGVnd3djrOYfKa0dGsD8nQeHJjCrmH2zJqkcj1H5ONTjCcix12quPWo7facOcCvrrFWj5aLALPAJEqOL7/I9wivXW/v1zzZQBvBqFgF3Uqvh71P/MLtyWfvUGuQv9D1RNRI07jMwNsaCK/qiDrfbTIiDOz0crLt8UZSO3vGQOtNQLAPdF1yigeR/Zp/dyxKpueRKCNw4dcdpOhDDzF7uZ2WlkMlEPPkmIo0EfE3F4vHg==;5:B0Kj4WkvNFpEtB5hVGFa7AVAwaJJl64pibklpEvHCcvsIOy/Db/R7ulphltEchkEIbZR0XXn4UMkocr3dX35UhywN9hLXEIi2yvb5zWVeS6JGzLXeXMuITSlr5tgMVJk3+NGjgl5DrsHiEaJrr+RtA==;24:+ODYj1UnhGDCB3YOJ8cBYzLt/p2OjKo8745GOOl0VddxstgvvA44eIljv3fbKbQA7YCU042VzC2DbOETmxSovLFQ6PE4yov4I0xJmfzlaP4=;7:b3Ugdqm10tBERL2bTvS+g5vudH+vU+/tynqRoGp5Aqg01I/dQ9stMxUvXxhvzhTNrCP2YIc6yk67A+V888toxIYtpf/zrv572TC8H36KnRZHICc4ZPqXwILvtwHIVsDOXi2kTa7mvnHFvJsHFa49Ya4oj1IbillzrX5iVBWUorX3IEg+OfEziRvCS8HzjD2c6kw7gomM4G3XFvDq2uzZhyj0w5iw5OIOuJfgs+OrsCZfLRymKljc7YEaOnqD3H/+ SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: kingcounty.gov X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Jul 2016 00:54:47.2828 (UTC) X-MS-Exchange-CrossTenant-Id: bae5059a-76f0-49d7-9996-72dfe95d69c7 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=bae5059a-76f0-49d7-9996-72dfe95d69c7;Ip=[146.129.239.99];Helo=[MAILQDC1.kc.kingcounty.lcl] X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR09MB1293 Hi Tim, I have included Deb Flewelling on your email. I hope to speak with Deb tomo= rrow morning re: your request and 'the email' request. Thanks for your inquiry. Kathy Lombardo Sent from my iPhone > On Jul 5, 2016, at 12:48 PM, Tim Clemans <tim.clemans@seattlepublicrecord= s.org> wrote: >=20 > Hi Kathy, >=20 > This is a public records act request for the last email sent by anyone > who works in the Enhanced 911 Program Office discussing texting to > 911. Please email me that email. If you are not the correct person to > send this records request to please immediately tell me where to send > it. The purpose of the request to is find out what's holding up the > deployment of texting to 911 for Seattle Police and was told that the > county is in charge of texting to 911 deployment. >=20 > Thank you, > Tim

%python
r

code_to_run_from_sagews.sh: 1: code_to_run_from_sagews.sh: r: not found

sudo pip install psycopg2

Downloading/unpacking psycopg2 Running setup.py (path:/tmp/pip_build_root/psycopg2/setup.py) egg_info for package psycopg2 Error: You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application. Complete output from command python setup.py egg_info: running egg_info creating pip-egg-info/psycopg2.egg-info writing pip-egg-info/psycopg2.egg-info/PKG-INFO writing top-level names to pip-egg-info/psycopg2.egg-info/top_level.txt writing dependency_links to pip-egg-info/psycopg2.egg-info/dependency_links.txt writing manifest file 'pip-egg-info/psycopg2.egg-info/SOURCES.txt' warning: manifest_maker: standard file '-c' not found Error: You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application. ---------------------------------------- Cleaning up... Command python setup.py egg_info failed with error code 1 in /tmp/pip_build_root/psycopg2 Storing debug log for failure in /home/ubuntu/.pip/pip.log

sudo apt-get -y install python-psycopg2; sudo apt-get -y install libpq-dev

Reading package lists... Building dependency tree... Reading state information... The following extra packages will be installed: python-egenix-mxdatetime python-egenix-mxtools Suggested packages: python-egenix-mxdatetime-dbg python-egenix-mxdatetime-doc python-egenix-mxtools-dbg python-egenix-mxtools-doc python-psycopg2-doc The following NEW packages will be installed: python-egenix-mxdatetime python-egenix-mxtools python-psycopg2 0 upgraded, 3 newly installed, 0 to remove and 4 not upgraded. Need to get 268 kB of archives. After this operation, 1,339 kB of additional disk space will be used. Get:1 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty/main python-egenix-mxtools amd64 3.2.7-1build1 [75.1 kB] Get:2 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty/main python-egenix-mxdatetime amd64 3.2.7-1build1 [66.7 kB] Get:3 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty/main python-psycopg2 amd64 2.4.5-1build5 [126 kB] debconf: unable to initialize frontend: Dialog debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (This frontend requires a controlling tty.) debconf: falling back to frontend: Teletype dpkg-preconfigure: unable to re-open stdin: Fetched 268 kB in 0s (9,975 kB/s) Selecting previously unselected package python-egenix-mxtools. (Reading database ... 58683 files and directories currently installed.) Preparing to unpack .../python-egenix-mxtools_3.2.7-1build1_amd64.deb ... Unpacking python-egenix-mxtools (3.2.7-1build1) ... Selecting previously unselected package python-egenix-mxdatetime. Preparing to unpack .../python-egenix-mxdatetime_3.2.7-1build1_amd64.deb ... Unpacking python-egenix-mxdatetime (3.2.7-1build1) ... Selecting previously unselected package python-psycopg2. Preparing to unpack .../python-psycopg2_2.4.5-1build5_amd64.deb ... Unpacking python-psycopg2 (2.4.5-1build5) ... Setting up python-egenix-mxtools (3.2.7-1build1) ... Setting up python-egenix-mxdatetime (3.2.7-1build1) ... Setting up python-psycopg2 (2.4.5-1build5) ... Reading package lists... Building dependency tree... Reading state information... The following extra packages will be installed: comerr-dev krb5-multidev libgssrpc4 libkadm5clnt-mit9 libkadm5srv-mit9 libkdb5-7 libssl-dev libssl-doc zlib1g-dev Suggested packages: doc-base krb5-doc krb5-user postgresql-doc-9.3 The following NEW packages will be installed: comerr-dev krb5-multidev libgssrpc4 libkadm5clnt-mit9 libkadm5srv-mit9 libkdb5-7 libpq-dev libssl-dev libssl-doc zlib1g-dev 0 upgraded, 10 newly installed, 0 to remove and 4 not upgraded. Need to get 2,693 kB of archives. After this operation, 10.9 MB of additional disk space will be used. Get:1 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libgssrpc4 amd64 1.12+dfsg-2ubuntu5.2 [53.1 kB] Get:2 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libkadm5clnt-mit9 amd64 1.12+dfsg-2ubuntu5.2 [36.2 kB] Get:3 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libkdb5-7 amd64 1.12+dfsg-2ubuntu5.2 [36.2 kB] Get:4 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libkadm5srv-mit9 amd64 1.12+dfsg-2ubuntu5.2 [50.4 kB] Get:5 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main comerr-dev amd64 2.1-1.42.9-3ubuntu1.3 [38.3 kB] Get:6 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main krb5-multidev amd64 1.12+dfsg-2ubuntu5.2 [111 kB] Get:7 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty/main zlib1g-dev amd64 1:1.2.8.dfsg-1ubuntu1 [183 kB] Get:8 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libssl-dev amd64 1.0.1f-1ubuntu2.19 [1,073 kB] Get:9 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libpq-dev amd64 9.3.13-0ubuntu0.14.04 [140 kB] Get:10 http://us-west-2.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main libssl-doc all 1.0.1f-1ubuntu2.19 [971 kB] debconf: unable to initialize frontend: Dialog debconf: (Dialog frontend will not work on a dumb terminal, an emacs shell buffer, or without a controlling terminal.) debconf: falling back to frontend: Readline debconf: unable to initialize frontend: Readline debconf: (This frontend requires a controlling tty.) debconf: falling back to frontend: Teletype dpkg-preconfigure: unable to re-open stdin: Fetched 2,693 kB in 0s (9,061 kB/s) Selecting previously unselected package libgssrpc4:amd64. (Reading database ... 58793 files and directories currently installed.) Preparing to unpack .../libgssrpc4_1.12+dfsg-2ubuntu5.2_amd64.deb ... Unpacking libgssrpc4:amd64 (1.12+dfsg-2ubuntu5.2) ... Selecting previously unselected package libkadm5clnt-mit9:amd64. Preparing to unpack .../libkadm5clnt-mit9_1.12+dfsg-2ubuntu5.2_amd64.deb ... Unpacking libkadm5clnt-mit9:amd64 (1.12+dfsg-2ubuntu5.2) ... Selecting previously unselected package libkdb5-7:amd64. Preparing to unpack .../libkdb5-7_1.12+dfsg-2ubuntu5.2_amd64.deb ... Unpacking libkdb5-7:amd64 (1.12+dfsg-2ubuntu5.2) ... Selecting previously unselected package libkadm5srv-mit9:amd64. Preparing to unpack .../libkadm5srv-mit9_1.12+dfsg-2ubuntu5.2_amd64.deb ... Unpacking libkadm5srv-mit9:amd64 (1.12+dfsg-2ubuntu5.2) ... Selecting previously unselected package comerr-dev. Preparing to unpack .../comerr-dev_2.1-1.42.9-3ubuntu1.3_amd64.deb ... Unpacking comerr-dev (2.1-1.42.9-3ubuntu1.3) ... Selecting previously unselected package krb5-multidev. Preparing to unpack .../krb5-multidev_1.12+dfsg-2ubuntu5.2_amd64.deb ... Unpacking krb5-multidev (1.12+dfsg-2ubuntu5.2) ... Selecting previously unselected package zlib1g-dev:amd64. Preparing to unpack .../zlib1g-dev_1%3a1.2.8.dfsg-1ubuntu1_amd64.deb ... Unpacking zlib1g-dev:amd64 (1:1.2.8.dfsg-1ubuntu1) ... Selecting previously unselected package libssl-dev:amd64. Preparing to unpack .../libssl-dev_1.0.1f-1ubuntu2.19_amd64.deb ... Unpacking libssl-dev:amd64 (1.0.1f-1ubuntu2.19) ... Selecting previously unselected package libpq-dev. Preparing to unpack .../libpq-dev_9.3.13-0ubuntu0.14.04_amd64.deb ... Unpacking libpq-dev (9.3.13-0ubuntu0.14.04) ... Selecting previously unselected package libssl-doc. Preparing to unpack .../libssl-doc_1.0.1f-1ubuntu2.19_all.deb ... Unpacking libssl-doc (1.0.1f-1ubuntu2.19) ... Processing triggers for install-info (5.2.0.dfsg.1-2) ... Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Setting up libgssrpc4:amd64 (1.12+dfsg-2ubuntu5.2) ... Setting up libkadm5clnt-mit9:amd64 (1.12+dfsg-2ubuntu5.2) ... Setting up libkdb5-7:amd64 (1.12+dfsg-2ubuntu5.2) ... Setting up libkadm5srv-mit9:amd64 (1.12+dfsg-2ubuntu5.2) ... Setting up comerr-dev (2.1-1.42.9-3ubuntu1.3) ... Setting up krb5-multidev (1.12+dfsg-2ubuntu5.2) ... Setting up zlib1g-dev:amd64 (1:1.2.8.dfsg-1ubuntu1) ... Setting up libssl-dev:amd64 (1.0.1f-1ubuntu2.19) ... Setting up libpq-dev (9.3.13-0ubuntu0.14.04) ... Setting up libssl-doc (1.0.1f-1ubuntu2.19) ... Processing triggers for libc-bin (2.19-0ubuntu6.9) ...

%psql
SELECT COUNT(*) FROM emails;

count ------- 8033 (1 row)

%psql

%sh
du -sh remote_fs/emails

983M remote_fs/emails

%sh
cd remote_fs/emails; find -maxdepth 1 -type d | while read -r dir; do printf "%s:\t" "$dir"; find "$dir" -type f | wc -l; done

.: 23704 ./[email protected]: 414 ./[email protected]: 36 ./[email protected]: 7165 ./[email protected]: 61 ./[email protected]: 16026

ruby -v

ruby 1.9.3p484 (2013-11-22 revision 43786) [x86_64-linux]