search

mysociety / alaveteli

Provide a Freedom of Information request system for your jurisdiction
https://alaveteli.org
Other
389 stars 196 forks source link

Problems Encountered in Installing and Running Alaveteli #3868

Closed Keerti-Gautam closed 7 years ago

Keerti-Gautam commented 7 years ago

Hi, I was trying to install Alaveteli on ubuntu 16 but I encountered a lot of issues in the documentation.

This is becoming a serious issue as I was trying to get righttoknow.org.au up and running so that I could participate in this round of Outreachy. @equivalentideas can you help me?

garethrees commented 7 years ago

Hey @Keerti-Gautam.

I've just fixed the typos on the documentation.

I've just run through the steps as provided in the documentation, and successfully booted the rails server.

Looking at your errors, it looks like the provision step didn't run or complete successfully. This should happen automatically when running vagrant up.

I'm not sure what to suggest here, as I can't see any output from that part of the process.

Maybe try destroying the VM and re-creating it:

vagrant destroy -f
vagrant --no-color up

Here's what the output looked like for me when running vagrant --no-color up:

$ vagrant --no-color up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Importing base box 'precise64'...
==> default: Matching MAC address for NAT networking...
==> default: Setting the name of the VM: alaveteli_default_1490806774464_56699
==> default: Clearing any previously set forwarded ports...
==> default: Fixed port collision for 22 => 2222. Now on port 2200.
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
    default: Adapter 2: hostonly
==> default: Forwarding ports...
    default: 22 (guest) => 2200 (host) (adapter 1)
==> default: Running 'pre-boot' VM customizations...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2200
    default: SSH username: vagrant
    default: SSH auth method: private key
    default:
    default: Vagrant insecure key detected. Vagrant will automatically replace
    default: this with a newly generated keypair for better security.
    default:
    default: Inserting generated public key within guest...
    default: Removing insecure key from the guest if it's present...
    default: Key inserted! Disconnecting and reconnecting using new SSH key...
==> default: Machine booted and ready!
[default] GuestAdditions versions on your host (5.1.16) and guest (4.1.12) do not match.
stdin: is not a tty
 * Stopping VirtualBox Additions
   ...done.
ERROR: Module vboxsf does not exist in /proc/modules
stdin: is not a tty
Reading package lists...
Building dependency tree...
Reading state information...
The following packages were automatically installed and are no longer required:
  libxfixes3 libxcomposite1 xfonts-encodings x11-xkb-utils xserver-xorg-core
  xserver-common libgl1-mesa-dri xfonts-utils libxfont1 xfonts-base dkms
  libfontenc1 libxdamage1 libxrandr2 libxkbfile1 libllvm3.0
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
  virtualbox-guest-dkms* virtualbox-guest-utils* virtualbox-guest-x11*
0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded.
After this operation, 10.4 MB disk space will be freed.
(Reading database ... 66225 files and directories currently installed.)
Removing virtualbox-guest-dkms ...

-------- Uninstall Beginning --------
Module:  virtualbox-guest
Version: 4.1.12
Kernel:  3.2.0-90-generic (x86_64)
-------------------------------------

Status: Before uninstall, this module version was ACTIVE on this kernel.

vboxguest.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-generic/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

vboxsf.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-generic/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

vboxvideo.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-generic/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

depmod....

DKMS: uninstall completed.

-------- Uninstall Beginning --------
Module:  virtualbox-guest
Version: 4.1.12
Kernel:  3.2.0-90-virtual (x86_64)
-------------------------------------

Status: Before uninstall, this module version was ACTIVE on this kernel.

vboxguest.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-virtual/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

vboxsf.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-virtual/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

vboxvideo.ko:
 - Uninstallation
   - Deleting from: /lib/modules/3.2.0-90-virtual/updates/dkms/
 - Original module
   - No original module was found for this module on this kernel.
   - Use the dkms install command to reinstall any previous module version.

depmod....

DKMS: uninstall completed.

------------------------------
Deleting module version: 4.1.12
completely from the DKMS tree.
------------------------------
Done.
Removing virtualbox-guest-x11 ...
Purging configuration files for virtualbox-guest-x11 ...
Removing virtualbox-guest-utils ...
Purging configuration files for virtualbox-guest-utils ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
stdin: is not a tty
Reading package lists...
Building dependency tree...
Reading state information...
dkms is already the newest version.
dkms set to manually installed.
linux-headers-3.2.0-90-virtual is already the newest version.
linux-headers-3.2.0-90-virtual set to manually installed.
The following packages were automatically installed and are no longer required:
  libxfixes3 libxcomposite1 xfonts-encodings x11-xkb-utils xserver-xorg-core
  xserver-common libgl1-mesa-dri xfonts-utils libxfont1 xfonts-base
  libfontenc1 libxdamage1 libxrandr2 libxkbfile1 libllvm3.0
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Copy iso file /Applications/VirtualBox.app/Contents/MacOS/VBoxGuestAdditions.iso into the box /tmp/VBoxGuestAdditions.iso
stdin: is not a tty
mount: block device /tmp/VBoxGuestAdditions.iso is write-protected, mounting read-only
Installing Virtualbox Guest Additions 5.1.16 - guest version is 4.1.12
stdin: is not a tty
Verifying archive integrity... All good.
Uncompressing VirtualBox 5.1.16 Guest Additions for Linux...........
VirtualBox Guest Additions installer
Copying additional installer modules ...
Installing additional modules ...
vboxadd.sh: Building Guest Additions kernel modules.
vboxadd.sh: Starting the VirtualBox Guest Additions.

Could not find the X.Org or XFree86 Window System, skipping.
stdin: is not a tty

Got different reports about installed GuestAdditions version:
Virtualbox on your host claims:   4.1.12
VBoxService inside the vm claims: 5.1.16
Going on, assuming VBoxService is correct...
Got different reports about installed GuestAdditions version:
Virtualbox on your host claims:   4.1.12
VBoxService inside the vm claims: 5.1.16
Going on, assuming VBoxService is correct...
==> default: Checking for guest additions in VM...
    default: The guest additions on this VM do not match the installed version of
    default: VirtualBox! In most cases this is fine, but in rare cases it can
    default: prevent things such as shared folders from working properly. If you see
    default: shared folder errors, please make sure the guest additions within the
    default: virtual machine match the version of VirtualBox you have installed on
    default: your host and reload your VM.
    default:
    default: Guest Additions Version: 4.1.12
    default: VirtualBox Version: 5.1
==> default: Configuring and enabling network interfaces...
==> default: Mounting shared folders...
    default: /home/vagrant/alaveteli => /private/tmp/alaveteli
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: Reading package lists...
==> default: Building dependency tree...
==> default:
==> default: Reading state information...
==> default: curl is already the newest version.
==> default: The following packages were automatically installed and are no longer required:
==> default:   libxfixes3 libxcomposite1 xfonts-encodings x11-xkb-utils xserver-xorg-core
==> default:   xserver-common libgl1-mesa-dri xfonts-utils libxfont1 xfonts-base
==> default:   libfontenc1 libxdamage1 libxrandr2 libxkbfile1 libllvm3.0
==> default: Use 'apt-get autoremove' to remove them.
==> default: 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default:   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
==> default:                                  Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
==> default: 1
==> default: 0
==> default: 0
==> default:
==> default: 1
==> default: 9
==> default: 6
==> default: 7
==> default: 6
==> default:
==> default:
==> default: 1
==> default: 0
==> default: 0
==> default:
==> default: 1
==> default: 9
==> default: 6
==> default: 7
==> default: 6
==> default:
==> default:
==> default:   0     0  91763      0 --:--:-- --:--:-- --:--:--  114k
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: DEVELOPMENT INSTALL
==> default: ==== Installing alaveteli
==> default: Updating package lists...
==> default: done
==> default: Installing some core packages...
==> default:   git...
==> default: dpkg-preconfigure: unable to re-open stdin: No such file or directory
==> default: done
==> default:   lockfile-progs...
==> default: done
==> default:   curl...
==> default: dpkg-preconfigure: unable to re-open stdin: No such file or directory
==> default: done
==> default:   dnsutils...
==> default: dpkg-preconfigure: unable to re-open stdin: No such file or directory
==> default: done
==> default:   lsb-release...
==> default: done
==> default: Testing for being on EC2...
==> default: done
==> default: Testing alaveteli.10.10.10.30.xip.io's IP address...
==> default: done
==> default: Generating locales...
==> default: dpkg-preconfigure: unable to re-open stdin: No such file or directory
==> default: Generating locale en_GB...
==> default: already
==> default: done
==> default: done
==> default: Adding unix user...
==> default: already
==> default: done
==> default: Updating APT sources...
==> default: done
==> default: Cloning or updating repository...
==> default: skipping as development install...
==> default: done
==> default: Updating mySociety APT source...
==> default: OK
==> default: done
==> default: Reading package lists...
==> default: Building dependency tree...
==> default: Reading state information...
==> default: python-software-properties is already the newest version.
==> default: The following packages were automatically installed and are no longer required:
==> default:   libxfixes3 libxcomposite1 xfonts-encodings x11-xkb-utils xserver-xorg-core
==> default:   xserver-common libgl1-mesa-dri xfonts-utils libxfont1 xfonts-base
==> default:   libfontenc1 libxdamage1 libxrandr2 libxkbfile1 libllvm3.0
==> default: Use 'apt-get autoremove' to remove them.
==> default: 0 to upgrade, 0 to newly install, 0 to remove and 104 not to upgrade.
==> default: gpg: keyring `/tmp/tmpj3REox/secring.gpg' created
==> default: gpg: keyring `/tmp/tmpj3REox/pubring.gpg' created
==> default: gpg:
==> default: requesting key D9E84310 from hkp server keyserver.ubuntu.com
==> default: gpg: /tmp/tmpj3REox/trustdb.gpg: trustdb created
==> default: gpg: key D9E84310: public key "Launchpad PPA for mySociety" imported
==> default: gpg: Total number processed: 1
==> default: gpg:               imported: 1  (RSA: 1)
==> default: OK
==> default: Hit http://ppa.launchpad.net precise Release.gpg
==> default: Hit http://security.ubuntu.com precise-security Release.gpg
==> default: Hit http://archive.ubuntu.com precise Release.gpg
==> default: Hit http://ppa.launchpad.net precise Release
==> default: Hit http://debian.mysociety.org wheezy Release.gpg
==> default: Hit http://archive.ubuntu.com precise-updates Release.gpg
==> default: Hit http://security.ubuntu.com precise-security Release
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise Release.gpg
==> default: Hit http://archive.ubuntu.com trusty Release.gpg
==> default: Hit http://ppa.launchpad.net precise/main Sources
==> default: Hit http://archive.ubuntu.com precise Release
==> default: Hit http://archive.ubuntu.com precise-updates Release
==> default: Hit http://security.ubuntu.com precise-security/main Sources
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates Release.gpg
==> default: Hit http://debian.mysociety.org wheezy Release
==> default: Hit http://ppa.launchpad.net precise/main amd64 Packages
==> default: Hit http://security.ubuntu.com precise-security/universe Sources
==> default: Hit http://archive.ubuntu.com trusty Release
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise Release
==> default: Hit http://ppa.launchpad.net precise/main i386 Packages
==> default: Hit http://security.ubuntu.com precise-security/main amd64 Packages
==> default: Hit http://archive.ubuntu.com precise/main Sources
==> default: Hit http://archive.ubuntu.com precise/universe Sources
==> default: Hit http://security.ubuntu.com precise-security/universe amd64 Packages
==> default: Ign http://ppa.launchpad.net precise/main TranslationIndex
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates Release
==> default: Hit http://security.ubuntu.com precise-security/main i386 Packages
==> default: Hit http://archive.ubuntu.com precise/main amd64 Packages
==> default: Hit http://debian.mysociety.org wheezy/main amd64 Packages
==> default: Hit http://security.ubuntu.com precise-security/universe i386 Packages
==> default: Hit http://archive.ubuntu.com precise/universe amd64 Packages
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse Sources
==> default: Hit http://security.ubuntu.com precise-security/main TranslationIndex
==> default: Hit http://archive.ubuntu.com precise/main i386 Packages
==> default: Hit http://security.ubuntu.com precise-security/universe TranslationIndex
==> default: Hit http://archive.ubuntu.com precise/universe i386 Packages
==> default: Hit http://security.ubuntu.com precise-security/main Translation-en
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse amd64 Packages
==> default: Hit http://debian.mysociety.org wheezy/main i386 Packages
==> default: Hit http://archive.ubuntu.com precise/main TranslationIndex
==> default: Hit http://security.ubuntu.com precise-security/universe Translation-en
==> default: Hit http://archive.ubuntu.com precise/universe TranslationIndex
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse i386 Packages
==> default: Hit http://archive.ubuntu.com precise-updates/main Sources
==> default: Hit http://archive.ubuntu.com precise-updates/universe Sources
==> default: Ign http://debian.mysociety.org wheezy/main TranslationIndex
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse TranslationIndex
==> default: Ign http://ppa.launchpad.net precise/main Translation-en_GB
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates/multiverse Sources
==> default: Ign http://ppa.launchpad.net precise/main Translation-en
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates/multiverse amd64 Packages
==> default: Hit http://archive.ubuntu.com precise-updates/main amd64 Packages
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates/multiverse i386 Packages
==> default: Hit http://archive.ubuntu.com precise-updates/universe amd64 Packages
==> default: Hit http://archive.ubuntu.com precise-updates/main i386 Packages
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates/multiverse TranslationIndex
==> default: Hit http://archive.ubuntu.com precise-updates/universe i386 Packages
==> default: Hit http://archive.ubuntu.com precise-updates/main TranslationIndex
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse Translation-en_GB
==> default: Hit http://archive.ubuntu.com precise-updates/universe TranslationIndex
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise/multiverse Translation-en
==> default: Hit http://archive.ubuntu.com trusty/universe Sources
==> default: Hit http://archive.ubuntu.com trusty/universe amd64 Packages
==> default: Hit http://eu-west-1.ec2.archive.ubuntu.com precise-updates/multiverse Translation-en
==> default: Hit http://archive.ubuntu.com trusty/universe i386 Packages
==> default: Hit http://archive.ubuntu.com trusty/universe TranslationIndex
==> default: Ign http://debian.mysociety.org wheezy/main Translation-en_GB
==> default: Hit http://archive.ubuntu.com precise/main Translation-en_GB
==> default: Hit http://archive.ubuntu.com precise/main Translation-en
==> default: Ign http://debian.mysociety.org wheezy/main Translation-en
==> default: Hit http://archive.ubuntu.com precise/universe Translation-en_GB
==> default: Hit http://archive.ubuntu.com precise/universe Translation-en
==> default: Hit http://archive.ubuntu.com precise-updates/main Translation-en
==> default: Hit http://archive.ubuntu.com precise-updates/universe Translation-en
==> default: Hit http://archive.ubuntu.com trusty/universe Translation-en_GB
==> default: Hit http://archive.ubuntu.com trusty/universe Translation-en
==> default: Reading package lists...
==> default: Installing postfix...
==> default: Adding group `postfix' (GID 114) ...
==> default: Done.
==> default: Adding system user `postfix' (UID 108) ...
==> default: Adding new user `postfix' (UID 108) with group `postfix' ...
==> default: Not creating home directory `/var/spool/postfix'.
==> default: Creating /etc/postfix/dynamicmaps.cf
==> default: Adding tcp map entry to /etc/postfix/dynamicmaps.cf
==> default: Adding sqlite map entry to /etc/postfix/dynamicmaps.cf
==> default: Adding group `postdrop' (GID 115) ...
==> default: Done.
==> default: setting myhostname: vagrant-ubuntu-precise-64
==> default: setting alias maps
==> default: setting alias database
==> default: mailname is not a fully qualified domain name.  Not changing /etc/mailname.
==> default: setting destinations: vagrant-ubuntu-precise-64, localhost.localdomain, , localhost
==> default: setting relayhost:
==> default: setting mynetworks: 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
==> default: setting mailbox_size_limit: 0
==> default: setting recipient_delimiter: +
==> default: setting inet_interfaces: all
==> default: setting inet_protocols: all
==> default: /etc/aliases does not exist, creating it.
==> default: WARNING: /etc/aliases exists, but does not have a root alias.
==> default:
==> default: Postfix is now set up with a default configuration.  If you need to make
==> default: changes, edit
==> default: /etc/postfix/main.cf (and others) as needed.  To view Postfix configuration
==> default: values, see postconf(1).
==> default:
==> default: After modifying main.cf, be sure to run '/etc/init.d/postfix reload'.
==> default: Running newaliases
==> default:  * Stopping Postfix Mail Transport Agent postfix
==> default:    ...done.
==> default:  * Starting Postfix Mail Transport Agent postfix
==> default:    ...done.
==> default: done
==> default: Rather than invoking init scripts through /etc/init.d, use the service(8)
==> default: utility, e.g. service rsyslog restart
==> default:
==> default: Since the script you are attempting to invoke has been converted to an
==> default: Upstart job, you may also use the stop(8) and then start(8) utilities,
==> default: e.g. stop rsyslog ; start rsyslog. The restart(8) utility is also available.
==> default: rsyslog stop/waiting
==> default: rsyslog start/running, process 10377
==> default: Installing packages from repository packages file...
Extract templates from packages: 12%
Extract templates from packages: 25%
Extract templates from packages: 37%
Extract templates from packages: 50%
Extract templates from packages: 63%
Extract templates from packages: 75%
Extract templates from packages: 88%
Extract templates from packages: 100%
==> default: Creating config file /etc/papersize with new version
==> default: Creating config file /etc/php5/cli/php.ini with new version
==> default: Adding user postgres to group ssl-cert
==> default: Building PostgreSQL dictionaries from installed myspell/hunspell packages...
==> default:   done
==> default: update-alternatives: using /usr/bin/ruby1.9.1 to provide /usr/bin/ruby (ruby) in manual mode.
==> default: update-alternatives: using /usr/bin/gem1.9.1 to provide /usr/bin/gem (gem) in manual mode.
==> default: Checking for postgres template_utf8 database...
==> default: Created.
==> default: done
==> default: + '[' 3 -ne 3 ']'
==> default: + UNIX_USER=vagrant
==> default: + HOST=alaveteli.10.10.10.30.xip.io
==> default: + DIRECTORY=/home/vagrant
==> default: + DB_NAME=alaveteli
==> default: ++ dig +short alaveteli.10.10.10.30.xip.io
==> default: + IP_ADDRESS_FOR_HOST=10.10.10.30
==> default: + '[' x = x10.10.10.30 ']'
==> default: + id vagrant
==> default: ++ whoami
==> default: + '[' vagrant '!=' vagrant ']'
==> default: + REPOSITORY=/home/vagrant/alaveteli
==> default: + LINK_DESTINATION=/home/vagrant/alaveteli
==> default: + ln -sfn /home/vagrant/alaveteli /home/vagrant/alaveteli
==> default: + cd /home/vagrant/alaveteli
==> default: + BASHRC=/home/vagrant/.bashrc
==> default: + BASHRC_GEM_COMMENT='Set up local gem directory for Alaveteli'
==> default: + BASHRC_START='# START Set up local gem directory for Alaveteli'
==> default: + BASHRC_END='# END Set up local gem directory for Alaveteli'
==> default: + sed -ibackup '/# START Set up local gem directory for Alaveteli/,/# END Set up local gem directory for Alaveteli/d' /home/vagrant/.bashrc
==> default: ++ mktemp /home/vagrant/.bashrc.XXXXXXX
==> default: + TMP_BASHRC=/home/vagrant/.bashrc.3XSTYaK
==> default: + cat
==> default: + cat /home/vagrant/.bashrc
==> default: + mv /home/vagrant/.bashrc.3XSTYaK /home/vagrant/.bashrc
==> default: + source /home/vagrant/.bashrc
==> default: ++ export GEM_HOME=/home/vagrant/gems
==> default: ++ GEM_HOME=/home/vagrant/gems
==> default: ++ mkdir -p /home/vagrant/gems
==> default: ++ export GEM_PATH=
==> default: ++ GEM_PATH=
==> default: ++ export PATH=/home/vagrant/gems/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
==> default: ++ PATH=/home/vagrant/gems/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
==> default: ++ '[' -z '' ']'
==> default: ++ return
==> default: + echo 'gem: --no-ri --no-rdoc'
==> default: ++ random_alphanumerics 32
==> default: ++ tr -dc A-Za-z0-9
==> default: ++ head -c32
==> default: + RANDOM_EMAIL_SECRET=9dqC9AxpaOUkT1tZBAqDhkFJ8bYAYCTO
==> default: ++ random_alphanumerics 10
==> default: ++ tr -dc A-Za-z0-9
==> default: ++ head -c10
==> default: + RANDOM_EMERGENCY_PASSWORD=o3gxxWfi0C
==> default: ++ random_alphanumerics 100
==> default: ++ head -c100
==> default: ++ tr -dc A-Za-z0-9
==> default: + RANDOM_COOKIE_SECRET=YhLWvEvC48w6Fxs3LPkzdzGSEH8gRDsxSTJuJersgxa7vFcMezFRGsHDxiltHPXZbg2EcnjQjD7ghGpscWvQSleCTAJr0qPtaEIk
==> default: + '[' -f config/general.yml ']'
==> default: + sed -r -e 's,^( *DOMAIN:).*,\1 '\''alaveteli.10.10.10.30.xip.io'\'',' -e 's,^( *FORCE_SSL:).*,\1 false,' -e 's,^( *TIME_ZONE:).*,\1 '\''Europe/London'\'',' -e 's,^( *BLOG_FEED:).*,\1 '\'''\'',' -e 's,^( *TWITTER_USERNAME:).*,\1 '\'''\'',' -e 's,^( *INCLUDE_DEFAULT_LOCALE_IN_URLS:).*,\1 false,' -e 's,^( *INCOMING_EMAIL_DOMAIN:).*,\1 '\''alaveteli.10.10.10.30.xip.io'\'',' -e 's,^( *INCOMING_EMAIL_PREFIX:).*,\1 '\''foi+'\'',' -e 's,^( *INCOMING_EMAIL_SECRET:).*,\1 '\''9dqC9AxpaOUkT1tZBAqDhkFJ8bYAYCTO'\'',' -e 's,^( *ADMIN_USERNAME:).*,\1 '\''emergency'\'',' -e 's,^( *ADMIN_PASSWORD:).*,\1 '\''o3gxxWfi0C'\'',' -e 's,^( *CONTACT_EMAIL:).*,\1 '\''postmaster@alaveteli.10.10.10.30.xip.io'\'',' -e 's,^( *TRACK_SENDER_EMAIL:).*,\1 '\''postmaster@alaveteli.10.10.10.30.xip.io'\'',' -e 's,^( *COOKIE_STORE_SESSION_SECRET:).*,\1 '\''YhLWvEvC48w6Fxs3LPkzdzGSEH8gRDsxSTJuJersgxa7vFcMezFRGsHDxiltHPXZbg2EcnjQjD7ghGpscWvQSleCTAJr0qPtaEIk'\'',' -e 's,^( *FORWARD_NONBOUNCE_RESPONSES_TO:).*,\1 '\''user-support@alaveteli.10.10.10.30.xip.io'\'',' -e 's,^( *HTML_TO_PDF_COMMAND:).*,\1 '\''/usr/bin/wkhtmltopdf-static'\'',' -e 's,^( *EXCEPTION_NOTIFICATIONS_FROM:).*,\1 '\''do-not-reply-to-this-address@alaveteli.10.10.10.30.xip.io'\'',' -e '/EXCEPTION_NOTIFICATIONS_TO:/,/^$/c EXCEPTION_NOTIFICATIONS_TO:\n - team@alaveteli.10.10.10.30.xip.io\n' -e 's,^( *VARNISH_HOST:).*,\1 null,' -e 's,^( *MTA_LOG_PATH:).*,\1 '\''/var/log/mail/mail.log-*'\'',' -e 's,^( *MTA_LOG_TYPE:).*,\1 '\''postfix'\'',' -e 's,^( *DONATION_URL:).*,\1 null,' -e 's,^( *THEME_BRANCH:).*,\1 '\''develop'\'',' -e 's,^( *USE_MAILCATCHER_IN_DEVELOPMENT:).*,\1 false,' -e 's,^( *BUNDLE_PATH:).*,\1 /home/vagrant/bundle/,' config/general.yml-example
==> default: + sed -r -e 's,^( *database: *)foi_(.*),\1alaveteli_\2,' -e 's,^( *username: *).*,\1vagrant,' -e 's,^( *password: *).*,\1null,' -e 's,^( *host: *).*,\1/var/run/postgresql/,' -e 's,# constraint_disabling: false,  constraint_disabling: false,' config/database.yml-example
==> default: + for SUFFIX in production test development
==> default: + REAL_DB_NAME=alaveteli_production
==> default: Creating the database alaveteli_production
==> default: + echo Creating the database alaveteli_production
==> default: + psql -l
==> default: + egrep '^ *alaveteli_production *\|'
==> default: + createdb -T template_utf8 --owner vagrant alaveteli_production
==> default: + for SUFFIX in production test development
==> default: + REAL_DB_NAME=alaveteli_test
==> default: Creating the database alaveteli_test
==> default: + echo Creating the database alaveteli_test
==> default: + psql -l
==> default: + egrep '^ *alaveteli_test *\|'
==> default: + createdb -T template_utf8 --owner vagrant alaveteli_test
==> default: + for SUFFIX in production test development
==> default: + REAL_DB_NAME=alaveteli_development
==> default: + echo Creating the database alaveteli_development
==> default: Creating the database alaveteli_development
==> default: + psql -l
==> default: + egrep '^ *alaveteli_development *\|'
==> default: + createdb -T template_utf8 --owner vagrant alaveteli_development
==> default: + echo Running rails-post-deploy
==> default: Running rails-post-deploy
==> default: + script/rails-post-deploy
==> default: Running bundle install with options: --path /home/vagrant/bundle/
==> default: Fetching https://github.com/technoweenie/acts_as_versioned.git
==> default: Fetching https://github.com/heapsource/active_model_otp.git
==> default: Fetching https://github.com/mysociety/ruby-msg.git
==> default: Fetching https://github.com/mysociety/strip_attributes.git
==> default: Fetching https://github.com/mikel/mail
==> default: Fetching gem metadata from https://rubygems.org/
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: .
==> default: Fetching gem metadata from https://rubygems.org/
==> default: .
==> default: .
==> default: Resolving dependencies...
==> default: Installing rake (11.3.0)
==> default: Installing i18n (0.8.0)
==> default: Installing minitest (4.7.5)
==> default: Installing multi_json (1.12.1)
==> default: Installing thread_safe (0.3.5)
==> default: Installing tzinfo (0.3.52)
==> default: Installing activesupport (4.0.13)
==> default: Installing builder (3.1.4)
==> default: Installing erubis (2.7.0)
==> default: Installing rack (1.5.5)
==> default: Installing rack-test (0.6.3)
==> default: Installing actionpack (4.0.13)
==> default: Installing mime-types (2.99.2)
==> default: Using mail (2.6.5.edge) from https://github.com/mikel/mail (at 2-6-stable)
==> default: Installing actionmailer (4.0.13)
==> default: Installing activemodel (4.0.13)
==> default: Installing rotp (3.3.0)
==> default: Using active_model_otp (1.2.0) from https://github.com/heapsource/active_model_otp.git (at c342283)
==> default: Installing activerecord-deprecated_finders (1.0.4)
==> default: Installing arel (4.0.2)
==> default: Installing activerecord (4.0.13)
==> default: Using acts_as_versioned (0.6.0) from https://github.com/technoweenie/acts_as_versioned.git (at 63b1fc8)
==> default: Installing addressable (2.4.0)
==> default: Installing flipper (0.10.2)
==> default: Installing flipper-active_record (0.10.2)
==> default: Using bundler (1.3.5)
==> default: Installing thor (0.19.4)
==> default: Installing railties (4.0.13)
==> default: Installing concurrent-ruby (1.0.2)
==> default: Installing sprockets (3.7.0)
==> default: Installing sprockets-rails (2.3.3)
==> default: Installing rails (4.0.13)
==> default: Using alaveteli_features (0.0.1) from source at gems/alaveteli_features
==> default: Installing annotate (2.7.1)
==> default: Installing sass (3.4.21)
==> default: Installing bootstrap-sass (2.3.2.2)
==> default: Installing uniform_notifier (1.10.0)
==> default: Installing bullet (5.1.1)
==> default: Installing cancancan (1.12.0)
==> default: Installing highline (1.7.8)
==> default: Installing net-ssh (2.9.4)
==> default: Installing net-scp (1.2.1)
==> default: Installing net-sftp (2.1.2)
==> default: Installing net-ssh-gateway (1.3.0)
==> default: Installing capistrano (2.15.9)
==> default: Installing mini_portile2 (2.1.0)
==> default: Installing nokogiri (1.6.8.1)
==> default: Installing xpath (2.0.0)
==> default: Installing capybara (2.7.1)
==> default: Installing charlock_holmes (0.7.3)
==> default: Installing chronic (0.10.2)
==> default: Installing chunky_png (1.3.8)
==> default: Installing coderay (1.1.1)
==> default: Installing coffee-script-source (1.12.2)
==> default: Installing execjs (2.7.0)
==> default: Installing coffee-script (2.4.1)
==> default: Installing coffee-rails (4.0.1)
==> default: Installing columnize (0.9.0)
==> default: Installing compass-core (1.0.3)
==> default: Installing compass-import-once (1.0.5)
==> default: Installing rb-fsevent (0.9.8)
==> default: Installing ffi (1.9.17)
==> default: Installing rb-inotify (0.9.8)
==> default: Installing compass (1.0.3)
==> default: Installing tilt (2.0.5)
==> default: Installing sass-rails (5.0.6)
==> default: Installing compass-rails (3.0.2)
==> default: Installing json (1.8.6)
==> default: Installing unf_ext (0.0.7.2)
==> default: Installing unf (0.1.4)
==> default: Installing domain_name (0.5.20161129)
==> default: Installing http-cookie (1.0.3)
==> default: Installing netrc (0.11.0)
==> default: Installing rest-client (1.8.0)
==> default: Installing docile (1.1.5)
==> default: Installing simplecov-html (0.10.0)
==> default: Installing simplecov (0.10.0)
==> default: Installing tins (1.3.0)
==> default: Installing term-ansicolor (1.3.2)
==> default: Installing coveralls (0.8.3)
==> default: Installing daemons (1.2.4)
==> default: Installing dalli (2.7.6)
==> default: Installing debugger-linecache (1.2.0)
==> default: Installing debugger-ruby_core_source (1.3.8)
==> default: Installing debugger (1.6.8)
==> default: Installing delorean (2.1.0)
==> default: Installing diff-lcs (1.3)
==> default: Installing dynamic_form (1.1.4)
==> default: Installing eventmachine (1.0.9.1)
==> default: Installing exception_notification (4.0.1)
==> default: Installing factory_girl (4.7.0)
==> default: Installing factory_girl_rails (4.7.0)
==> default: Installing fakeweb (1.3.0)
==> default: Installing fancybox-rails (0.3.1)
==> default: Installing fast_gettext (1.1.0)
==> default: Installing foundation-rails (5.5.3.2)
==> default: Installing gender_detector (1.0.0)
==> default: Installing geoip (1.6.3)
==> default: Installing locale (2.0.9)
==> default: Installing text (1.3.1)
==> default: Installing gettext (2.3.9)
==> default: Installing gettext_i18n_rails (0.9.4)
==> default: Installing globalize (4.0.3)
==> default: Installing gnuplot (2.6.2)
==> default: Installing holidays (2.2.0)
==> default: Installing htmlentities (4.3.4)
==> default: Installing icalendar (2.3.0)
==> default: Installing iso_country_codes (0.7.6)
==> default: Installing jquery-rails (3.1.4)
==> default: Installing jquery-ui-rails (5.0.5)
==> default: Installing launchy (2.4.3)
==> default: Installing libv8 (3.16.14.17)
==> default: Installing mahoro (0.4)
==> default: Installing rack-protection (1.5.3)
==> default: Installing sinatra (1.4.7)
==> default: Installing thin (1.5.1)
==> default: Installing skinny (0.2.4)
==> default: Installing sqlite3 (1.3.13)
==> default: Installing mailcatcher (0.6.4)
==> default: Installing method_source (0.8.2)
==> default: Installing net-http-local (0.1.2)
==> default: Installing net-purge (0.1.0)
==> default: Installing newrelic_rpm (3.18.1.330)
==> default: Installing open4 (1.3.4)
==> default: Installing pg (0.18.4)
==> default: Installing slop (3.6.0)
==> default: Installing pry (0.10.4)
==> default: Installing pry-debugger (0.2.3)
==> default: Installing public_suffix (1.4.6)
==> default: Installing quiet_assets (1.1.0)
==> default: Installing rack-ssl (1.3.4)
==> default: Installing rack-utf8_sanitizer (1.3.2)
==> default: Installing rails-i18n (4.0.9)
==> default: Installing rdoc (3.12.2)
==> default: Installing recaptcha (0.4.0)
==> default: Installing ref (2.0.0)
==> default: Installing rmagick (2.15.4)
==> default: Installing rolify (5.1.0)
==> default: Installing routing-filter (0.4.0.1)
==> default: Installing rspec-support (3.4.1)
==> default: Installing rspec-mocks (3.4.1)
==> default: Installing rspec-activemodel-mocks (1.0.3)
==> default: Installing rspec-core (3.4.4)
==> default: Installing rspec-expectations (3.4.0)
==> default: Installing rspec-rails (3.4.2)
==> default: Installing ruby-ole (1.2.12)
==> default: Installing vpim (13.11.11)
==> default: Using ruby-msg (1.5.2) from https://github.com/mysociety/ruby-msg.git (at ascii-encoding)
==> default: Installing useragent (0.16.8)
==> default: Installing secure_headers (3.1.2)
==> default: Installing statistics2 (0.54)
==> default: Using strip_attributes (1.7.0) from https://github.com/mysociety/strip_attributes.git (at globalize3)
==> default: Installing syslog_protocol (0.9.2)
==> default: Installing therubyracer (0.12.3)
==> default: Installing uglifier (2.7.2)
==> default: Installing unicode (0.4.4.2)
==> default: Installing unidecoder (1.1.2)
==> default: Installing will_paginate (3.1.0)
==> default: Installing xapian-full-alaveteli (1.2.21.1)
==> default: Installing xml-simple (1.1.5)
==> default: Installing zip (2.0.2)
==> default: Your bundle is complete!
==> default: It was installed into /home/vagrant/bundle
==> default: Post-install message from compass:
==> default:     Compass is charityware. If you love it, please donate on our behalf at http://umdf.org/compass Thanks!
==> default: Post-install message from gender_detector:
==> default: For unicode support you'll need to also install the unicode_utils or activesupport gem
==> default: Post-install message from globalize:
==> default:
==> default: Globalize has extracted versioning support to a separate gem named
==> default: globalize-versioning. If you are using versioning (with paper_trail
==> default: or any other versioning gem), please add the line
==> default: "gem 'globalize-versioning'" to your Gemfile and go to the github
==> default: page at globalize/globalize-versioning if you encounter any problems.
==> default:
==> default: Note that the globalize-versioning gem does not delegate versions to
==> default: the translation table, so you will have to update your syntax to
==> default: the form: `post.translation.versions`. See the globalize-versioning
==> default: readme for details.
==> default: Post-install message from icalendar:
==> default: HEADS UP! iCalendar 2.0 is not backwards-compatible with 1.x. Please see the README for the new syntax
==> default:
==> default: HEADS UP! icalendar 2.2.0 switches to non-strict parsing as default. Please see the README if you
==> default: rely on strict parsing for information on how to enable it.
==> default:
==> default: ActiveSupport is required for TimeWithZone support, but not required for general use.
==> default: Post-install message from rdoc:
==> default: Depending on your version of ruby, you may need to install ruby rdoc/ri data:
==> default:
==> default: <= 1.8.6 : unsupported
==> default:  = 1.8.7 : gem install rdoc-data; rdoc-data --install
==> default:  = 1.9.1 : gem install rdoc-data; rdoc-data --install
==> default: >= 1.9.2 : nothing to do! Yay!
==> default: Installing theme alavetelitheme from git://github.com/mysociety/alavetelitheme.git
==> default: Cloning into '/home/vagrant/alaveteli/lib/themes/alavetelitheme'...
==> default: 30f48c5d6c9b2f800e21eebb5a1dd56ff5241446
==> default: Checking out origin/develop
==> default: Note: checking out 'origin/develop'.
==> default:
==> default: You are in 'detached HEAD' state. You can look around, make experimental
==> default: changes and commit them, and you can discard any commits you make in this
==> default: state without impacting any branches by performing another checkout.
==> default:
==> default: If you want to create a new branch to retain commits you create, you may
==> default: do so (now or later) by using -b with the checkout command again. Example:
==> default:
==> default:   git checkout -b new_branch_name
==> default: HEAD is now at 30f48c5... Merge branch 'master' into develop
==> default: Running install hook in /home/vagrant/alaveteli/lib/themes/alavetelitheme
==> default: Running post_install hook in /home/vagrant/alaveteli/lib/themes/alavetelitheme
==> default: alavetelitheme successfully installed in: /home/vagrant/alaveteli/lib/themes/alavetelitheme
==> default: == 1 CreateUsers: migrating ===================================================
==> default: -- create_table(:users)
==> default:    -> 0.0128s
==> default: == 1 CreateUsers: migrated (0.0137s) ==========================================
==> default: == 2 AddSessions: migrating ===================================================
==> default: -- create_table(:sessions)
==> default:    -> 0.0054s
==> default: -- add_index(:sessions, :session_id)
==> default:    -> 0.0042s
==> default: -- add_index(:sessions, :updated_at)
==> default:    -> 0.0052s
==> default: == 2 AddSessions: migrated (0.0173s) ==========================================
==> default: == 4 CreateInfoRequests: migrating ============================================
==> default: -- create_table(:info_requests)
==> default:    -> 0.0057s
==> default: == 4 CreateInfoRequests: migrated (0.0068s) ===================================
==> default: == 5 CreatePublicBodies: migrating ============================================
==> default: -- create_table(:public_bodies)
==> default:    -> 0.0053s
==> default: == 5 CreatePublicBodies: migrated (0.0064s) ===================================
==> default: == 6 VersionPublicBody: migrating =============================================
==> default: -- add_timestamps(:public_body_versions, {:null=>false})
==> default:    -> 0.0019s
==> default: == 6 VersionPublicBody: migrated (0.4023s) ====================================
==> default: == 7 AddPublicBodyEditorNotes: migrating ======================================
==> default: -- add_column(:public_bodies, :last_edit_editor, :string)
==> default:    -> 0.0016s
==> default: -- add_column(:public_bodies, :last_edit_comment, :string)
==> default:    -> 0.0013s
==> default: -- add_column(:public_body_versions, :last_edit_editor, :string)
==> default:    -> 0.0013s
==> default: -- add_column(:public_body_versions, :last_edit_comment, :string)
==> default:    -> 0.0011s
==> default: == 7 AddPublicBodyEditorNotes: migrated (0.0090s) =============================
==> default: == 8 RequestHasPublicBody: migrating ==========================================
==> default: -- add_column(:info_requests, :public_body_id, :integer)
==> default:    -> 0.0018s
==> default: == 8 RequestHasPublicBody: migrated (0.0036s) =================================
==> default: == 9 CreateOutgoingMessages: migrating ========================================
==> default: -- create_table(:outgoing_messages)
==> default:    -> 0.0142s
==> default: == 9 CreateOutgoingMessages: migrated (0.0172s) ===============================
==> default:
==> default: == 10 RemovePublicBodyIdFromOutgoingMessages: migrating =======================
==> default: -- remove_column(:outgoing_messages, :public_body_id)
==> default:    -> 0.0036s
==> default: == 10 RemovePublicBodyIdFromOutgoingMessages: migrated (0.0051s) ==============
==> default: == 11 AddCreatedUpdatedFields: migrating ======================================
==> default: -- add_column(:info_requests, :created_at, :datetime)
==> default:    -> 0.0015s
==> default: -- add_column(:info_requests, :updated_at, :datetime)
==> default:    -> 0.0062s
==> default: -- add_column(:public_bodies, :created_at, :datetime)
==> default:    -> 0.0049s
==> default: -- add_column(:public_bodies, :updated_at, :datetime)
==> default:    -> 0.0038s
==> default: -- add_column(:sessions, :created_at, :datetime)
==> default:    -> 0.0029s
==> default: -- add_column(:users, :created_at, :datetime)
==> default:    -> 0.0029s
==> default: -- add_column(:users, :updated_at, :datetime)
==> default:    -> 0.0021s
==> default: == 11 AddCreatedUpdatedFields: migrated (0.0359s) =============================
==> default: == 12 AddSentOutgoingMessage: migrating =======================================
==> default: -- add_column(:outgoing_messages, :sent_at, :datetime)
==> default:    -> 0.0105s
==> default: == 12 AddSentOutgoingMessage: migrated (0.0135s) ==============================
==> default: == 13 CreateIncomingMessages: migrating =======================================
==> default: -- create_table(:incoming_messages)
==> default:    -> 0.0085s
==> default: == 13 CreateIncomingMessages: migrated (0.0099s) ==============================
==> default: == 14 CreatePostRedirects: migrating ==========================================
==> default: -- create_table(:post_redirects)
==> default:    -> 0.0075s
==> default: == 14 CreatePostRedirects: migrated (0.0087s) =================================
==> default: == 15 AddEmailTokenToPostRedirects: migrating =================================
==> default: -- add_column(:post_redirects, :email_token, :text)
==> default:    -> 0.0013s
==> default: == 15 AddEmailTokenToPostRedirects: migrated (0.0022s) ========================
==> default: == 16 AddReasonsToPostRedirects: migrating ====================================
==> default: -- add_column(:post_redirects, :reason_params_yaml, :text)
==> default:    -> 0.0021s
==> default: -- add_column(:post_redirects, :user_id, :integer)
==> default:    -> 0.0016s
==> default: == 16 AddReasonsToPostRedirects: migrated (0.0057s) ===========================
==> default: == 17 AddEmailConfirmedToUsers: migrating =====================================
==> default: -- add_column(:users, :email_confirmed, :boolean, {:default=>false})
==> default:    -> 0.0271s
==> default: == 17 AddEmailConfirmedToUsers: migrated (0.0284s) ============================
==> default: == 18 AddResponseTypeToIncomingMessage: migrating =============================
==> default: -- add_column(:incoming_messages, :user_classified, :boolean, {:default=>false})
==> default:    -> 0.0059s
==> default: -- add_column(:incoming_messages, :contains_information, :boolean, {:default=>false})
==> default:    -> 0.0061s
==> default: -- create_table(:rejection_reasons)
==> default:    -> 0.0070s
==> default: == 18 AddResponseTypeToIncomingMessage: migrated (0.0225s) ====================
==> default: == 21 RemoveContainsInformationDefault: migrating =============================
==> default: -- change_column(:incoming_messages, :contains_information, :boolean, {:default=>nil})
==> default:    -> 0.0078s
==> default: -- drop_table(:rejection_reasons)
==> default:    -> 0.0043s
==> default: == 21 RemoveContainsInformationDefault: migrated (0.0162s) ====================
==> default: == 22 CreateInfoRequestEvents: migrating ======================================
==> default: -- create_table(:info_request_events)
==> default:    -> 0.0060s
==> default: == 22 CreateInfoRequestEvents: migrated (0.3512s) =============================
==> default: == 23 OutgoingMessageLastSentAt: migrating ====================================
==> default: -- rename_column(:outgoing_messages, :sent_at, :last_sent_at)
==> default:    -> 0.0030s
==> default: == 23 OutgoingMessageLastSentAt: migrated (0.0038s) ===========================
==> default: == 24 AddIsBounceToIncomingMessages: migrating ================================
==> default: -- add_column(:incoming_messages, :is_bounce, :boolean, {:default=>false})
==> default:    -> 0.0065s
==> default: == 24 AddIsBounceToIncomingMessages: migrated (0.1729s) =======================
==> default: == 25 AddFollowupToOutgoingMessage: migrating =================================
==> default: -- add_column(:outgoing_messages, :incoming_message_followup_id, :integer)
==> default:    -> 0.0013s
==> default: == 25 AddFollowupToOutgoingMessage: migrated (0.0022s) ========================
==> default: == 26 AddManyNullConstraints: migrating =======================================
==> default: -- change_column(:users, :email, :string, {:null=>false})
==> default:    -> 0.0022s
==> default: -- change_column(:users, :name, :string, {:null=>false})
==> default:    -> 0.0030s
==> default: -- change_column(:users, :hashed_password, :string, {:null=>false})
==> default:    -> 0.0040s
==> default: -- change_column(:users, :salt, :string, {:null=>false})
==> default:    -> 0.0035s
==> default: -- change_column(:users, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0027s
==> default: -- change_column(:users, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0025s
==> default: -- change_column(:users, :email_confirmed, :boolean, {:null=>false, :default=>false})
==> default:    -> 0.0057s
==> default: -- change_column(:public_bodies, :name, :text, {:null=>false})
==> default:    -> 0.0022s
==> default: -- change_column(:public_bodies, :short_name, :text, {:null=>false})
==> default:    -> 0.0020s
==> default: -- change_column(:public_bodies, :request_email, :text, {:null=>false})
==> default:    -> 0.0017s
==> default: -- change_column(:public_bodies, :version, :integer, {:null=>false})
==> default:    -> 0.0016s
==> default: -- change_column(:public_bodies, :last_edit_editor, :string, {:null=>false})
==> default:    -> 0.0057s
==> default: -- change_column(:public_bodies, :last_edit_comment, :text, {:null=>false})
==> default:    -> 0.0059s
==> default: -- change_column(:public_bodies, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0033s
==> default: -- change_column(:public_bodies, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0033s
==> default: -- change_column(:post_redirects, :token, :text, {:null=>false})
==> default:    -> 0.0026s
==> default: -- change_column(:post_redirects, :uri, :text, {:null=>false})
==> default:    -> 0.0017s
==> default: -- change_column(:post_redirects, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0020s
==> default: -- change_column(:post_redirects, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0019s
==> default: -- change_column(:post_redirects, :email_token, :text, {:null=>false})
==> default:    -> 0.0067s
==> default: -- change_column(:outgoing_messages, :info_request_id, :integer, {:null=>false})
==> default:    -> 0.0021s
==> default: -- change_column(:outgoing_messages, :body, :text, {:null=>false})
==> default:    -> 0.0052s
==> default: -- change_column(:outgoing_messages, :status, :string, {:null=>false})
==> default:    -> 0.0062s
==> default: -- change_column(:outgoing_messages, :message_type, :string, {:null=>false})
==> default:    -> 0.0044s
==> default: -- change_column(:outgoing_messages, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0031s
==> default: -- change_column(:outgoing_messages, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0023s
==> default: -- change_column(:info_requests, :title, :text, {:null=>false})
==> default:    -> 0.0022s
==> default: -- change_column(:info_requests, :user_id, :integer, {:null=>false})
==> default:    -> 0.0021s
==> default: -- change_column(:info_requests, :public_body_id, :integer, {:null=>false})
==> default:    -> 0.0018s
==> default: -- change_column(:info_requests, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0063s
==> default: -- change_column(:info_requests, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0017s
==> default: -- change_column(:info_request_events, :info_request_id, :integer, {:null=>false})
==> default:    -> 0.0019s
==> default: -- change_column(:info_request_events, :event_type, :text, {:null=>false})
==> default:    -> 0.0023s
==> default: -- change_column(:info_request_events, :params_yaml, :text, {:null=>false})
==> default:    -> 0.0164s
==> default: -- change_column(:info_request_events, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0022s
==> default: -- change_column(:incoming_messages, :info_request_id, :integer, {:null=>false})
==> default:    -> 0.0028s
==> default: -- change_column(:incoming_messages, :raw_data, :text, {:null=>false})
==> default:    -> 0.0023s
==> default: -- change_column(:incoming_messages, :created_at, :datetime, {:null=>false})
==> default:    -> 0.0017s
==> default: -- change_column(:incoming_messages, :updated_at, :datetime, {:null=>false})
==> default:    -> 0.0023s
==> default: -- change_column(:incoming_messages, :user_classified, :boolean, {:null=>false, :default=>false})
==> default:    -> 0.0097s
==> default: -- change_column(:incoming_messages, :is_bounce, :boolean, {:null=>false, :default=>false})
==> default:    -> 0.0173s
==> default: == 26 AddManyNullConstraints: migrated (0.2223s) ==============================
==> default: == 27 ChangeClassificationSystem: migrating ===================================
==> default: -- remove_column(:incoming_messages, :contains_information)
==> default:    -> 0.0012s
==> default: -- remove_column(:incoming_messages, :user_classified)
==> default:    -> 0.0026s
==> default: -- add_column(:info_requests, :described_state, :string)
==> default:    -> 0.0088s
==> default: -- change_column(:info_requests, :described_state, :string, {:null=>false})
==> default:    -> 0.0028s
==> default: -- add_column(:info_requests, :awaiting_description, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0055s
==> default: -- add_column(:info_requests, :described_last_incoming_message_id, :integer)
==> default:    -> 0.0011s
==> default: == 27 ChangeClassificationSystem: migrated (0.0381s) ==========================
==> default: == 28 GiveIncomingMessagesEvents: migrating ===================================
==> default: == 28 GiveIncomingMessagesEvents: migrated (0.0131s) ==========================
==> default: == 29 AddDescribeStatusHistory: migrating =====================================
==> default: -- add_column(:info_request_events, :described_state, :string)
==> default:    -> 0.0013s
==> default: -- remove_column(:info_requests, :described_last_incoming_message_id)
==> default:    -> 0.0013s
==> default: == 29 AddDescribeStatusHistory: migrated (0.0043s) ============================
==> default: == 30 AddSomeIndices: migrating ===============================================
==> default: -- execute("create index users_lower_email_index on users(lower(email))")
==> default:    -> 0.0138s
==> default: -- add_index(:info_requests, :created_at)
==> default:    -> 0.0043s
==> default: -- add_index(:info_requests, :title)
==> default:    -> 0.0035s
==> default: -- execute("create index public_bodies_url_short_name_index on public_bodies(regexp_replace(replace(lower(short_name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
==> default:    -> 0.0027s
==> default: -- execute("create index public_body_versions_url_short_name_index on public_body_versions(regexp_replace(replace(lower(short_name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
==> default:    -> 0.0026s
==> default: -- execute("create index users_url_name_index on users (regexp_replace(replace(lower(name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
==> default:    -> 0.0068s
==> default: -- add_index(:post_redirects, :email_token)
==> default:    -> 0.0032s
==> default: -- add_index(:post_redirects, :token)
==> default:    -> 0.0093s
==> default: == 30 AddSomeIndices: migrated (0.0558s) ======================================
==> default:
==> default: == 31 AddIndicesForSessionDeletion: migrating =================================
==> default: -- add_index(:post_redirects, :updated_at)
==> default:    -> 0.0033s
==> default: == 31 AddIndicesForSessionDeletion: migrated (0.0050s) ========================
==> default: == 32 Addforeignkeys: migrating ===============================================
==> default: -- execute("ALTER TABLE incoming_messages ADD CONSTRAINT fk_incoming_messages_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0076s
==> default: -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0021s
==> default: -- execute("ALTER TABLE info_requests ADD CONSTRAINT fk_info_requests_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0022s
==> default: -- execute("ALTER TABLE info_requests ADD CONSTRAINT fk_info_requests_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0026s
==> default: -- execute("ALTER TABLE outgoing_messages ADD CONSTRAINT fk_outgoing_messages_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0019s
==> default: -- execute("ALTER TABLE outgoing_messages ADD CONSTRAINT fk_incoming_message_followup_info_request FOREIGN KEY (incoming_message_followup_id) REFERENCES incoming_messages(id)")
==> default:    -> 0.0018s
==> default: -- execute("ALTER TABLE post_redirects ADD CONSTRAINT fk_post_redirects_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0021s
==> default: -- execute("ALTER TABLE public_body_versions ADD CONSTRAINT fk_public_body_versions_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0019s
==> default: == 32 Addforeignkeys: migrated (0.0304s) ======================================
==> default: == 33 AddProminence: migrating ================================================
==> default: -- add_column(:info_requests, :prominence, :string, {:null=>false, :default=>"normal"})
==> default:    -> 0.0069s
==> default: == 33 AddProminence: migrated (0.0088s) =======================================
==> default: == 34 RunSolrIndexing: migrating ==============================================
==> default: == 34 RunSolrIndexing: migrated (0.0001s) =====================================
==> default: == 35 TrackOverdueAlerts: migrating ===========================================
==> default: -- create_table(:user_info_request_sent_alerts)
==> default:    -> 0.0084s
==> default: -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_info_request_sent_alerts_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0071s
==> default: -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_info_request_sent_alerts_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0041s
==> default: == 35 TrackOverdueAlerts: migrated (0.0245s) ==================================
==> default: == 36 AddPublicBodyTags: migrating ============================================
==> default: -- create_table(:public_body_tags)
==> default:    -> 0.0044s
==> default: -- execute("ALTER TABLE public_body_tags ADD CONSTRAINT fk_public_body_tags_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0029s
==> default: -- add_index(:public_body_tags, [:public_body_id, :name], {:unique=>true})
==> default:    -> 0.0078s
==> default: == 36 AddPublicBodyTags: migrated (0.0258s) ===================================
==> default: == 37 AddUrlName: migrating ===================================================
==> default: -- add_column(:public_bodies, :url_name, :text)
==> default:    -> 0.0015s
==> default: -- add_column(:public_body_versions, :url_name, :text)
==> default:    -> 0.0017s
==> default: -- add_index(:public_bodies, :url_name, {:unique=>true})
==> default:    -> 0.0053s
==> default: -- change_column(:public_bodies, :url_name, :text, {:null=>false})
==> default:    -> 0.0070s
==> default: == 37 AddUrlName: migrated (0.0502s) ==========================================
==> default: == 38 AddMoreUrlNames: migrating ==============================================
==> default: -- add_column(:users, :url_name, :text)
==> default:    -> 0.0022s
==> default: -- add_index(:users, :url_name)
==> default:    -> 0.0032s
==> default: -- change_column(:users, :url_name, :text, {:null=>false})
==> default:    -> 0.0033s
==> default: == 38 AddMoreUrlNames: migrated (0.0157s) =====================================
==> default: == 39 RequestUrlNames: migrating ==============================================
==> default: -- add_column(:info_requests, :url_title, :text)
==> default:    -> 0.0015s
==> default: -- add_index(:info_requests, :url_title, {:unique=>true})
==> default:    -> 0.0030s
==> default: -- change_column(:info_requests, :url_title, :text, {:null=>false})
==> default:    -> 0.0030s
==> default: == 39 RequestUrlNames: migrated (0.0128s) =====================================
==> default: == 40 EmailIsUnique: migrating ================================================
==> default: -- execute("create unique index users_email_index on users (lower(email))")
==> default:    -> 0.0046s
==> default: -- execute("drop index users_url_name_index")
==> default:    -> 0.0025s
==> default: -- execute("drop index public_bodies_url_short_name_index")
==> default:    -> 0.0014s
==> default: -- execute("drop index public_body_versions_url_short_name_index")
==> default:    -> 0.0013s
==> default: == 40 EmailIsUnique: migrated (0.0156s) =======================================
==> default: == 41 IndexRequestsWithSolr: migrating ========================================
==> default: -- add_column(:info_requests, :solr_up_to_date, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0110s
==> default: -- add_index(:info_requests, :solr_up_to_date)
==> default:    -> 0.0097s
==> default: == 41 IndexRequestsWithSolr: migrated (0.0273s) ===============================
==> default: == 42 UniqueUserUrls: migrating ===============================================
==> default: -- remove_index(:users, :url_name)
==> default:    -> 0.0022s
==> default: -- add_index(:users, :url_name, {:unique=>true})
==> default:    -> 0.0057s
==> default: == 42 UniqueUserUrls: migrated (0.0237s) ======================================
==> default:
==> default: == 43 RemoveComplaintEmail: migrating =========================================
==> default: -- remove_column(:public_body_versions, :complaint_email)
==> default:    -> 0.0012s
==> default: -- remove_column(:public_bodies, :complaint_email)
==> default:    -> 0.0014s
==> default: == 43 RemoveComplaintEmail: migrated (0.0052s) ================================
==> default: == 44 RemoveIsBounce: migrating ===============================================
==> default: -- remove_column(:incoming_messages, :is_bounce)
==> default:    -> 0.0021s
==> default: == 44 RemoveIsBounce: migrated (0.0044s) ======================================
==> default: == 45 AddCircumstanceToPostRedirect: migrating ================================
==> default: -- add_column(:post_redirects, :circumstance, :text, {:default=>"normal"})
==> default:    -> 0.0121s
==> default: -- change_column(:post_redirects, :circumstance, :text, {:default=>"normal", :null=>false})
==> default:    -> 0.0199s
==> default: == 45 AddCircumstanceToPostRedirect: migrated (0.0837s) =======================
==> default: == 46 AddLastEventIdToAlertTable: migrating ===================================
==> default: -- add_column(:user_info_request_sent_alerts, :info_request_event_id, :integer, {:default=>nil})
==> default:    -> 0.0015s
==> default: -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_user_info_request_sent_alert_info_request_event FOREIGN KEY (info_request_event_id) REFERENCES info_request_events(id)")
==> default:    -> 0.0021s
==> default: -- execute("create unique index user_info_request_sent_alerts_unique_index on user_info_request_sent_alerts (user_id, info_request_id, alert_type, coalesce(info_request_event_id, -1))")
==> default:    -> 0.0051s
==> default: == 46 AddLastEventIdToAlertTable: migrated (0.0126s) ==========================
==> default:
==> default: == 47 AddCalculatedState: migrating ===========================================
==> default: -- add_column(:info_request_events, :calculated_state, :string, {:default=>nil})
==> default:    -> 0.0058s
==> default: == 47 AddCalculatedState: migrated (0.0083s) ==================================
==> default: == 48 AddCalculatedStateAt: migrating =========================================
==> default: -- add_column(:info_request_events, :last_described_at, :datetime)
==> default:    -> 0.0027s
==> default: == 48 AddCalculatedStateAt: migrated (0.0045s) ================================
==> default: == 49 TrackThings: migrating ==================================================
==> default: -- create_table(:track_things)
==> default:    -> 0.0046s
==> default: -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_tracking_user FOREIGN KEY (tracking_user_id) REFERENCES users(id)")
==> default:    -> 0.0163s
==> default: -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_tracked_user FOREIGN KEY (tracked_user_id) REFERENCES users(id)")
==> default:    -> 0.0058s
==> default: -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0030s
==> default: -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0033s
==> default: -- create_table(:track_things_sent_emails)
==> default:    -> 0.0039s
==> default: -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_info_request_event FOREIGN KEY (info_request_event_id) REFERENCES info_request_events(id)")
==> default:    -> 0.0024s
==> default: -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0023s
==> default: -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0071s
==> default: == 49 TrackThings: migrated (0.0570s) =========================================
==> default: == 50 ImproveTrackThings: migrating ===========================================
==> default: -- add_column(:track_things, :track_type, :string, {:null=>false, :default=>"internal_error"})
==> default:    -> 0.0057s
==> default: -- add_column(:track_things, :created_at, :datetime)
==> default:    -> 0.0010s
==> default: -- add_column(:track_things, :updated_at, :datetime)
==> default:    -> 0.0013s
==> default: -- add_column(:track_things_sent_emails, :created_at, :datetime)
==> default:    -> 0.0017s
==> default: -- add_column(:track_things_sent_emails, :updated_at, :datetime)
==> default:    -> 0.0011s
==> default: -- add_column(:users, :last_daily_track_email, :datetime)
==> default:    -> 0.0013s
==> default: -- change_column(:users, :last_daily_track_email, :datetime, {:default=>"2000-01-01"})
==> default:    -> 0.0148s
==> default: == 50 ImproveTrackThings: migrated (0.0443s) ==================================
==> default: == 51 AddTrackThingsUniqueIndices: migrating ==================================
==> default: -- add_index(:track_things, [:tracking_user_id, :track_query], {:unique=>true})
==> default:    -> 0.0037s
==> default: == 51 AddTrackThingsUniqueIndices: migrated (0.0045s) =========================
==> default: == 52 IncludeEventForeignReferences: migrating ================================
==> default: -- add_column(:info_request_events, :incoming_message_id, :integer)
==> default:    -> 0.0033s
==> default: -- add_column(:info_request_events, :outgoing_message_id, :integer)
==> default:    -> 0.0017s
==> default: -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_incoming_message_id FOREIGN KEY (incoming_message_id) REFERENCES incoming_messages(id)")
==> default:    -> 0.0020s
==> default: -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_outgoing_message_id FOREIGN KEY (outgoing_message_id) REFERENCES outgoing_messages(id)")
==> default:    -> 0.0026s
==> default: == 52 IncludeEventForeignReferences: migrated (0.0764s) =======================
==> default: == 53 ActsAsXapianMigration: migrating ========================================
==> default: -- create_table(:acts_as_xapian_jobs)
==> default:    -> 0.0077s
==> default: -- add_index(:acts_as_xapian_jobs, [:model, :model_id], {:unique=>true})
==> default:    -> 0.0035s
==> default: -- remove_index(:info_requests, :solr_up_to_date)
==> default:    -> 0.0035s
==> default: -- remove_column(:info_requests, :solr_up_to_date)
==> default:    -> 0.0014s
==> default: == 53 ActsAsXapianMigration: migrated (0.0277s) ===============================
==> default: == 54 AllowLongerComments: migrating ==========================================
==> default: -- change_column(:public_body_versions, :last_edit_comment, :text)
==> default:    -> 0.0016s
==> default: == 54 AllowLongerComments: migrated (0.0029s) =================================
==> default: == 55 StopNewResponses: migrating =============================================
==> default: -- add_column(:info_requests, :stop_new_responses, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0092s
==> default: == 55 StopNewResponses: migrated (0.0103s) ====================================
==> default: == 56 AddAttachmentText: migrating ============================================
==> default: -- add_column(:incoming_messages, :cached_attachment_text, :text)
==> default:    -> 0.0027s
==> default: == 56 AddAttachmentText: migrated (0.0046s) ===================================
==> default: == 57 AddLawUsed: migrating ===================================================
==> default: -- add_column(:info_requests, :law_used, :string, {:null=>false, :default=>"foi"})
==> default:    -> 0.0177s
==> default: == 57 AddLawUsed: migrated (0.0195s) ==========================================
==> default: == 58 RemoveSessions: migrating ===============================================
==> default: -- drop_table(:sessions)
==> default:    -> 0.0022s
==> default: == 58 RemoveSessions: migrated (0.0045s) ======================================
==> default: == 59 AddUrlNotes: migrating ==================================================
==> default: -- add_column(:public_bodies, :home_page, :text, {:null=>false, :default=>""})
==> default:    -> 0.0101s
==> default: -- add_column(:public_bodies, :notes, :text, {:null=>false, :default=>""})
==> default:    -> 0.0064s
==> default: -- add_column(:public_body_versions, :home_page, :text)
==> default:    -> 0.0018s
==> default: -- add_column(:public_body_versions, :notes, :text)
==> default:    -> 0.0057s
==> default: == 59 AddUrlNotes: migrated (0.0298s) =========================================
==> default: == 60 AddCachedMainText: migrating ============================================
==> default: -- add_column(:incoming_messages, :cached_main_body_text, :text)
==> default:    -> 0.0025s
==> default: == 60 AddCachedMainText: migrated (0.0048s) ===================================
==> default: == 61 IncludeResponsesInTracks: migrating =====================================
==> default: == 61 IncludeResponsesInTracks: migrated (0.1507s) ============================
==> default: == 62 AddComments: migrating ==================================================
==> default: -- create_table(:comments)
==> default:    -> 0.0051s
==> default: -- execute("ALTER TABLE comments ADD CONSTRAINT fk_comments_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0020s
==> default: -- execute("ALTER TABLE comments ADD CONSTRAINT fk_comments_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0021s
==> default: -- add_column(:info_request_events, :comment_id, :integer)
==> default:    -> 0.0015s
==> default: -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_comment_id FOREIGN KEY (comment_id) REFERENCES comments(id)")
==> default:    -> 0.0018s
==> default: == 62 AddComments: migrated (0.0179s) =========================================
==> default: == 63 AddAdminUsers: migrating ================================================
==> default: -- add_column(:users, :admin_level, :string, {:null=>false, :default=>"none"})
==> default:    -> 0.0143s
==> default: == 63 AddAdminUsers: migrated (0.0163s) =======================================
==> default:
==> default: == 64 IndicesForAnnotations: migrating ========================================
==> default: -- add_index(:info_request_events, :created_at)
==> default:    -> 0.0106s
==> default: -- add_index(:info_request_events, :info_request_id)
==> default:    -> 0.0060s
==> default: == 64 IndicesForAnnotations: migrated (0.0218s) ===============================
==> default: == 65 AddCommentsToUserTrack: migrating =======================================
==> default: == 65 AddCommentsToUserTrack: migrated (0.0393s) ==============================
==> default: == 66 AddFirstLetter: migrating ===============================================
==> default: -- add_column(:public_bodies, :first_letter, :string)
==> default:    -> 0.0053s
==> default: -- add_index(:public_bodies, :first_letter)
==> default:    -> 0.0034s
==> default: -- change_column(:public_bodies, :first_letter, :string, {:null=>false})
==> default:    -> 0.0176s
==> default: == 66 AddFirstLetter: migrated (0.0349s) ======================================
==> default: == 67 FactorOutRawEmail: migrating ============================================
==> default: -- create_table(:raw_emails)
==> default:    -> 0.0087s
==> default: -- add_column(:incoming_messages, :raw_email_id, :integer, {:null=>true})
==> default:    -> 0.0032s
==> default: -- change_column(:incoming_messages, :raw_data, :text, {:null=>true})
==> default:    -> 0.0038s
==> default: -- execute("ALTER TABLE incoming_messages ADD CONSTRAINT fk_incoming_messages_raw_email FOREIGN KEY (raw_email_id) REFERENCES raw_emails(id)")
==> default:    -> 0.0025s
==> default: -- change_column(:incoming_messages, :raw_email_id, :integer, {:null=>false})
==> default:    -> 0.0024s
==> default: -- remove_column(:incoming_messages, :raw_data)
==> default:    -> 0.0012s
==> default: == 67 FactorOutRawEmail: migrated (0.0339s) ===================================
==> default:
==> default: == 68 AddCensorTable: migrating ===============================================
==> default: -- create_table(:censor_rules)
==> default:    -> 0.0179s
==> default: -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0035s
==> default: -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0029s
==> default: -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0026s
==> default: == 68 AddCensorTable: migrated (0.0348s) ======================================
==> default: == 69 AddWhatDoing: migrating =================================================
==> default:
==> default: -- add_column(:outgoing_messages, :what_doing, :string)
==> default:    -> 0.0039s
==> default: -- add_index(:outgoing_messages, :what_doing)
==> default:    -> 0.0058s
==> default: -- change_column(:outgoing_messages, :what_doing, :string, {:null=>false})
==> default:    -> 0.0036s
==> default: == 69 AddWhatDoing: migrated (0.0851s) ========================================
==> default: == 70 SentAreWaitingResponse: migrating =======================================
==> default: == 70 SentAreWaitingResponse: migrated (0.0041s) ==============================
==> default: == 71 AddEximLog: migrating ===================================================
==> default: -- create_table(:exim_logs)
==> default:    -> 0.0047s
==> default: -- create_table(:exim_log_dones)
==> default:    -> 0.0184s
==> default:
==> default: -- add_index(:exim_log_dones, :last_stat)
==> default:    -> 0.0107s
==> default: -- execute("ALTER TABLE exim_logs ADD CONSTRAINT fk_exim_log_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
==> default:    -> 0.0043s
==> default: -- execute("ALTER TABLE exim_logs ADD CONSTRAINT fk_exim_log_done FOREIGN KEY (exim_log_done_id) REFERENCES exim_log_dones(id)")
==> default:    -> 0.0029s
==> default: == 71 AddEximLog: migrated (0.0490s) ==========================================
==> default: == 72 AddPublicationScheme: migrating =========================================
==> default: -- add_column(:public_bodies, :publication_scheme, :text, {:null=>false, :default=>""})
==> default:    -> 0.0078s
==> default: -- add_column(:public_body_versions, :publication_scheme, :text, {:null=>false, :default=>""})
==> default:    -> 0.0111s
==> default: == 72 AddPublicationScheme: migrated (0.0219s) ================================
==> default: == 73 AddBanUser: migrating ===================================================
==> default: -- add_column(:users, :ban_text, :text, {:null=>false, :default=>""})
==> default:    -> 0.0112s
==> default: == 73 AddBanUser: migrated (0.0127s) ==========================================
==> default: == 74 CreateHolidays: migrating ===============================================
==> default: -- create_table(:holidays)
==> default:    -> 0.0051s
==> default: -- add_index(:holidays, :day)
==> default:    -> 0.0036s
==> default: == 74 CreateHolidays: migrated (0.1110s) ======================================
==> default: == 75 AddCharityNumber: migrating =============================================
==> default: -- add_column(:public_bodies, :charity_number, :text, {:null=>false, :default=>""})
==> default:    -> 0.0067s
==> default: -- add_column(:public_body_versions, :charity_number, :text, {:null=>false, :default=>""})
==> default:    -> 0.0061s
==> default: == 75 AddCharityNumber: migrated (0.0153s) ====================================
==> default: == 76 AddIndices: migrating ===================================================
==> default: -- add_index(:track_things_sent_emails, :track_thing_id)
==> default:    -> 0.0039s
==> default: == 76 AddIndices: migrated (0.0056s) ==========================================
==> default: == 77 AddEximLogIndex: migrating ==============================================
==> default: -- add_index(:exim_logs, :exim_log_done_id)
==> default:    -> 0.0063s
==> default: == 77 AddEximLogIndex: migrated (0.0093s) =====================================
==> default: == 78 ExpandStopNewResponses: migrating =======================================
==> default: -- add_column(:info_requests, :allow_new_responses_from, :string)
==> default:    -> 0.0068s
==> default: -- change_column(:info_requests, :allow_new_responses_from, :string, {:null=>false, :default=>"anybody"})
==> default:    -> 0.0160s
==> default: -- remove_column(:info_requests, :stop_new_responses)
==> default:    -> 0.0038s
==> default: -- add_column(:info_requests, :handle_rejected_responses, :string)
==> default:    -> 0.0019s
==> default: -- change_column(:info_requests, :handle_rejected_responses, :string, {:null=>false, :default=>"bounce"})
==> default:    -> 0.0071s
==> default: == 78 ExpandStopNewResponses: migrated (0.0524s) ==============================
==> default: == 79 AddProfilePhoto: migrating ==============================================
==> default: -- create_table(:profile_photos)
==> default:    -> 0.0179s
==> default: -- add_column(:users, :profile_photo_id, :integer, {:null=>true})
==> default:    -> 0.0018s
==> default: -- execute("ALTER TABLE profile_photos ADD CONSTRAINT fk_profile_photos_user FOREIGN KEY (user_id) REFERENCES users(id)")
==> default:    -> 0.0028s
==> default: -- execute("ALTER TABLE users ADD CONSTRAINT fk_users_profile_photo FOREIGN KEY (profile_photo_id) REFERENCES profile_photos(id)")
==> default:    -> 0.0022s
==> default: == 79 AddProfilePhoto: migrated (0.0294s) =====================================
==> default: == 80 CacheOnlyClippedAttachmentText: migrating ===============================
==> default: -- remove_column(:incoming_messages, :cached_attachment_text)
==> default:    -> 0.0012s
==> default: -- add_column(:incoming_messages, :cached_attachment_text_clipped, :text)
==> default:    -> 0.0081s
==> default: == 80 CacheOnlyClippedAttachmentText: migrated (0.0166s) ======================
==> default: == 81 AddEventProminence: migrating ===========================================
==> default: -- add_column(:info_request_events, :prominence, :string, {:null=>false, :default=>"normal"})
==> default:    -> 0.0118s
==> default: == 81 AddEventProminence: migrated (0.0126s) ==================================
==> default: == 82 ChangeRawEmailToBinary: migrating =======================================
==> default: -- change_column(:raw_emails, :data, :text, {:null=>true})
==> default:    -> 0.0022s
==> default: -- rename_column(:raw_emails, :data, :data_text)
==> default:    -> 0.0023s
==> default: -- add_column(:raw_emails, :data_binary, :binary)
==> default:    -> 0.0012s
==> default: == 82 ChangeRawEmailToBinary: migrated (0.0084s) ==============================
==> default: == 83 AddIndicesTrackSent: migrating ==========================================
==> default: -- add_index(:track_things_sent_emails, :created_at)
==> default:    -> 0.0035s
==> default: == 83 AddIndicesTrackSent: migrated (0.0041s) =================================
==> default: == 84 AlterProfilePhoto: migrating ============================================
==> default: -- remove_column(:users, :profile_photo_id)
==> default:    -> 0.0016s
==> default: == 84 AlterProfilePhoto: migrated (0.0025s) ===================================
==> default: == 85 DraftProfilePhoto: migrating ============================================
==> default: -- add_column(:profile_photos, :draft, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0062s
==> default: == 85 DraftProfilePhoto: migrated (0.0075s) ===================================
==> default: == 86 AllowNullProfilePhotoUser: migrating ====================================
==> default: -- change_column(:profile_photos, :user_id, :integer, {:null=>true})
==> default:    -> 0.0088s
==> default: == 86 AllowNullProfilePhotoUser: migrated (0.0115s) ===========================
==> default: == 87 AddAboutMe: migrating ===================================================
==> default: -- add_column(:users, :about_me, :text, {:null=>false, :default=>""})
==> default:    -> 0.0117s
==> default: == 87 AddAboutMe: migrated (0.0126s) ==========================================
==> default: == 88 PublicBodyMachineTags: migrating ========================================
==> default: -- add_column(:public_body_tags, :value, :text)
==> default:    -> 0.0034s
==> default: -- add_index(:public_body_tags, :name)
==> default:    -> 0.0059s
==> default: == 88 PublicBodyMachineTags: migrated (0.0116s) ===============================
==> default: == 89 RemoveCharityNumber: migrating ==========================================
==> default: -- remove_column(:public_bodies, :charity_number)
==> default:    -> 0.0019s
==> default: == 89 RemoveCharityNumber: migrated (0.0039s) =================================
==> default: == 90 RemoveTagUniqueness: migrating ==========================================
==> default: -- remove_index(:public_body_tags, [:public_body_id, :name])
==> default:    -> 0.0035s
==> default: -- add_index(:public_body_tags, [:public_body_id, :name, :value], {:unique=>true})
==> default:    -> 0.0036s
==> default: == 90 RemoveTagUniqueness: migrated (0.0096s) =================================
==> default: == 91 AddCensorRulesIndices: migrating ========================================
==> default: -- add_index(:censor_rules, :info_request_id)
==> default:    -> 0.0085s
==> default: -- add_index(:censor_rules, :user_id)
==> default:    -> 0.0059s
==> default: -- add_index(:censor_rules, :public_body_id)
==> default:    -> 0.0043s
==> default: == 91 AddCensorRulesIndices: migrated (0.0234s) ===============================
==> default: == 92 CacheOnlyMarkedBodyText: migrating ======================================
==> default: -- remove_column(:incoming_messages, :cached_main_body_text)
==> default:    -> 0.0011s
==> default: -- add_column(:incoming_messages, :cached_main_body_text_folded, :text)
==> default:    -> 0.0022s
==> default: -- add_column(:incoming_messages, :cached_main_body_text_unfolded, :text)
==> default:    -> 0.0016s
==> default: == 92 CacheOnlyMarkedBodyText: migrated (0.0080s) =============================
==> default: == 93 MoveToHasTagString: migrating ===========================================
==> default: -- rename_table(:public_body_tags, :has_tag_string_tags)
==> default:    -> 0.0096s
==> default: -- rename_column(:has_tag_string_tags, :public_body_id, :model_id)
==> default:    -> 0.0105s
==> default: -- add_column(:has_tag_string_tags, :model, :string)
==> default:    -> 0.0014s
==> default: -- change_column(:has_tag_string_tags, :model, :string, {:null=>false})
==> default:    -> 0.0042s
==> default: -- add_index(:has_tag_string_tags, [:model, :model_id])
==> default:    -> 0.0039s
==> default: == 93 MoveToHasTagString: migrated (0.0561s) ==================================
==> default: == 94 RemoveOldTagsForeignKey: migrating ======================================
==> default: -- execute("ALTER TABLE has_tag_string_tags DROP CONSTRAINT fk_public_body_tags_public_body")
==> default:    -> 0.0015s
==> default: -- add_index(:has_tag_string_tags, [:model, :model_id, :name, :value], {:name=>"by_model_and_model_id_and_name_and_value"})
==> default:    -> 0.0173s
==> default: == 94 RemoveOldTagsForeignKey: migrated (0.0220s) =============================
==> default: == 95 AddPostRedirectUserIndex: migrating =====================================
==> default: -- add_index(:post_redirects, :user_id)
==> default:    -> 0.0080s
==> default: == 95 AddPostRedirectUserIndex: migrated (0.0086s) ============================
==> default: == 96 CreateTranslationTables: migrating ======================================
==> default: == 96 CreateTranslationTables: migrated (0.0292s) =============================
==> default: == 97 AddCommentLocale: migrating =============================================
==> default: -- add_column(:comments, :locale, :text, {:null=>false, :default=>""})
==> default:    -> 0.0056s
==> default: == 97 AddCommentLocale: migrated (0.0073s) ====================================
==> default: == 98 FixPublicBodyTranslations: migrating ====================================
==> default: -- execute("    update public_body_translations\n    set first_letter = upper(substr(name, 1, 1))\n    where first_letter is null\n    ;\n")
==> default:
==> default:    -> 0.0117s
==> default: -- execute("    update public_body_translations\n    set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE\n                              public_body_translations.public_body_id = public_bodies.id )\n    where public_body_translations.publication_scheme is null\n    ;\n")
==> default:    -> 0.0053s
==> default: == 98 FixPublicBodyTranslations: migrated (0.0208s) ===========================
==> default: == 99 MoveRawEmailToFilesystem: migrating =====================================
==> default: == 99 MoveRawEmailToFilesystem: migrated (0.0664s) ============================
==> default: == 100 RemoveRedundantRawEmailColumns: migrating ==============================
==> default: -- remove_column(:raw_emails, :data_text)
==> default:    -> 0.0014s
==> default: -- remove_column(:raw_emails, :data_binary)
==> default:    -> 0.0016s
==> default: == 100 RemoveRedundantRawEmailColumns: migrated (0.0040s) =====================
==> default: == 101 AddHashToInfoRequest: migrating ========================================
==> default: -- add_column(:info_requests, :idhash, :string)
==> default:    -> 0.0030s
==> default: -- change_column(:info_requests, :idhash, :string, {:null=>false})
==> default:    -> 0.0027s
==> default: == 101 AddHashToInfoRequest: migrated (0.0122s) ===============================
==> default: == 102 AddLocaleToUsers: migrating ============================================
==> default: -- add_column(:users, :locale, :string)
==> default:    -> 0.0023s
==> default: == 102 AddLocaleToUsers: migrated (0.0028s) ===================================
==> default: == 103 AddUserBounceColumns: migrating ========================================
==> default: -- add_column(:users, :email_bounced_at, :datetime)
==> default:    -> 0.0090s
==> default: -- add_column(:users, :email_bounce_message, :text, {:default=>"", :null=>false})
==> default:    -> 0.0309s
==> default: == 103 AddUserBounceColumns: migrated (0.0422s) ===============================
==> default: == 104 CreateFoiAttachments: migrating ========================================
==> default: -- create_table(:foi_attachments)
==> default:    -> 0.0089s
==> default: == 104 CreateFoiAttachments: migrated (0.0303s) ===============================
==> default: == 105 ExtendIncomingMessage: migrating =======================================
==> default: -- add_column(:incoming_messages, :sent_at, :time)
==> default:    -> 0.0036s
==> default:
==> default: -- add_column(:incoming_messages, :subject, :text)
==> default:    -> 0.0028s
==> default: -- add_column(:incoming_messages, :safe_mail_from, :text)
==> default:    -> 0.0021s
==> default: -- add_column(:incoming_messages, :mail_from_domain, :text)
==> default:    -> 0.0036s
==> default: -- add_column(:incoming_messages, :valid_to_reply_to, :boolean)
==> default:    -> 0.0018s
==> default: == 105 ExtendIncomingMessage: migrated (0.0178s) ==============================
==> default: == 106 AddHexDigestToFoiAttachment: migrating =================================
==> default: -- add_column(:foi_attachments, :hexdigest, :string, {:limit=>32})
==> default:    -> 0.0024s
==> default: == 106 AddHexDigestToFoiAttachment: migrated (0.0052s) ========================
==> default: == 107 AddDateParsedFieldToIncomingMessage: migrating =========================
==> default: -- add_column(:incoming_messages, :last_parsed, :datetime)
==> default:    -> 0.0025s
==> default: == 107 AddDateParsedFieldToIncomingMessage: migrated (0.0038s) ================
==> default: == 108 ChangeSafeMailFromToMailFrom: migrating ================================
==> default: -- remove_column(:incoming_messages, :safe_mail_from)
==> default:    -> 0.0035s
==> default: -- add_column(:incoming_messages, :mail_from, :text)
==> default:    -> 0.0029s
==> default:
==> default: == 108 ChangeSafeMailFromToMailFrom: migrated (0.0104s) =======================
==> default: == 109 ChangeSentAtToDatetime: migrating ======================================
==> default: -- remove_column(:incoming_messages, :sent_at)
==> default:    -> 0.0020s
==> default: -- add_column(:incoming_messages, :sent_at, :timestamp)
==> default:    -> 0.0159s
==> default: == 109 ChangeSentAtToDatetime: migrated (0.0253s) =============================
==> default: == 110 AddUserNoLimit: migrating ==============================================
==> default: -- add_column(:users, :no_limit, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0116s
==> default: == 110 AddUserNoLimit: migrated (0.0143s) =====================================
==> default:
==> default: == 111 CreatePurgeRequests: migrating =========================================
==> default: -- create_table(:purge_requests)
==> default:    -> 0.0628s
==> default: == 111 CreatePurgeRequests: migrated (0.0776s) ================================
==> default: == 112 AddApiKeyToPublicBodies: migrating =====================================
==> default: -- add_column(:public_bodies, :api_key, :string)
==> default:    -> 0.0020s
==> default: -- execute("      update public_bodies\n      set api_key = encode(decode(\n          lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n      , 'hex'), 'base64')\n")
==> default:    -> 0.0078s
==> default: -- change_column_null(:public_bodies, :api_key, false)
==> default:    -> 0.0015s
==> default: == 112 AddApiKeyToPublicBodies: migrated (0.0128s) ============================
==> default: == 113 AddExternalFieldsToInfoRequests: migrating =============================
==> default: -- change_column_null(:info_requests, :user_id, true)
==> default:    -> 0.0025s
==> default: -- add_column(:info_requests, :external_user_name, :string, {:null=>true})
==> default:    -> 0.0019s
==> default: -- add_column(:info_requests, :external_url, :string, {:null=>true})
==> default:    -> 0.0028s
==> default: -- execute("ALTER TABLE info_requests ADD CONSTRAINT info_requests_external_ck CHECK ( (user_id is null) = (external_url is not null) and (external_user_name is not null or external_url is null) )")
==> default:    -> 0.0016s
==> default: == 113 AddExternalFieldsToInfoRequests: migrated (0.0148s) ====================
==> default: == 114 AddAttentionRequestedFlagToInfoRequests: migrating =====================
==> default: -- add_column(:info_requests, :attention_requested, :boolean, {:default=>false})
==> default:    -> 0.0094s
==> default: == 114 AddAttentionRequestedFlagToInfoRequests: migrated (0.0106s) ============
==> default: == 115 AddReceiveEmailAlertsToUser: migrating =================================
==> default: -- add_column(:users, :receive_email_alerts, :boolean, {:default=>true, :null=>false})
==> default:    -> 0.0113s
==> default:
==> default: == 115 AddReceiveEmailAlertsToUser: migrated (0.0150s) ========================
==> default: == 116 AddCensorRuleRegexp: migrating =========================================
==> default: -- add_column(:censor_rules, :regexp, :boolean)
==> default:    -> 0.0032s
==> default: == 116 AddCensorRuleRegexp: migrated (0.0035s) ================================
==> default: == 117 CreateSessions: migrating ==============================================
==> default: -- create_table(:sessions)
==> default:    -> 0.0179s
==> default: -- add_index(:sessions, :session_id)
==> default:    -> 0.0054s
==> default:
==> default: -- add_index(:sessions, :updated_at)
==> default:    -> 0.0837s
==> default: == 117 CreateSessions: migrated (0.1165s) =====================================
==> default: == 118 RemoveSessionsAgain: migrating =========================================
==> default: -- drop_table(:sessions)
==> default:    -> 0.0022s
==> default: == 118 RemoveSessionsAgain: migrated (0.0037s) ================================
==> default: == 20120822145640 CorrectExternalRequestConstraint: migrating =================
==> default: -- execute("ALTER TABLE info_requests DROP CONSTRAINT info_requests_external_ck")
==> default:    -> 0.0012s
==> default: -- execute("ALTER TABLE info_requests ADD CONSTRAINT info_requests_external_ck CHECK ( (user_id is null) = (external_url is not null) and (external_url is not null or external_user_name is null) )")
==> default:    -> 0.0012s
==> default: == 20120822145640 CorrectExternalRequestConstraint: migrated (0.0052s) ========
==> default: == 20120910153022 CreateRequestClassifications: migrating =====================
==> default: -- create_table(:request_classifications)
==> default:    -> 0.0383s
==> default: -- add_index(:request_classifications, :user_id)
==> default:    -> 0.0058s
==> default: == 20120910153022 CreateRequestClassifications: migrated (0.0537s) ============
==> default: == 20120912111713 AddRawEmailIndexToIncomingMessages: migrating ===============
==> default: -- add_index(:incoming_messages, :raw_email_id)
==> default:    -> 0.0700s
==> default: == 20120912111713 AddRawEmailIndexToIncomingMessages: migrated (0.0783s) ======
==> default: == 20120912112036 AddInfoRequestIdIndexToEximLogs: migrating ==================
==> default: -- add_index(:exim_logs, :info_request_id)
==> default:    -> 0.0063s
==> default: == 20120912112036 AddInfoRequestIdIndexToEximLogs: migrated (0.0083s) =========
==> default: == 20120912112312 AddInfoRequestIdIndexToIncomingAndOutgoingMessages: migrating
==> default: -- add_index(:incoming_messages, :info_request_id)
==> default:    -> 0.0040s
==> default: -- add_index(:outgoing_messages, :info_request_id)
==> default:    -> 0.0040s
==> default: == 20120912112312 AddInfoRequestIdIndexToIncomingAndOutgoingMessages: migrated (0.0116s)
==> default: == 20120912112655 AddIncomingMessageIdIndexToFoiAttachments: migrating ========
==> default: -- add_index(:foi_attachments, :incoming_message_id)
==> default:    -> 0.0041s
==> default: == 20120912112655 AddIncomingMessageIdIndexToFoiAttachments: migrated (0.0050s)
==> default: == 20120912113004 AddIndexesToInfoRequestEvents: migrating ====================
==> default: -- add_index(:info_request_events, :incoming_message_id)
==> default:    -> 0.0067s
==> default: -- add_index(:info_request_events, :outgoing_message_id)
==> default:    -> 0.0057s
==> default: -- add_index(:info_request_events, :comment_id)
==> default:    -> 0.0051s
==> default: == 20120912113004 AddIndexesToInfoRequestEvents: migrated (0.0237s) ===========
==> default: == 20120912113720 AddPublicBodyIndexToInfoRequests: migrating =================
==> default: -- add_index(:info_requests, :public_body_id)
==> default:    -> 0.0062s
==> default: == 20120912113720 AddPublicBodyIndexToInfoRequests: migrated (0.0086s) ========
==> default: == 20120912114022 AddUserIndexToInfoRequests: migrating =======================
==> default:
==> default: -- add_index(:info_requests, :user_id)
==> default:    -> 0.0132s
==> default: == 20120912114022 AddUserIndexToInfoRequests: migrated (0.0147s) ==============
==> default: == 20120912170035 AddInfoRequestsCountToPublicBodies: migrating ===============
==> default: -- add_column(:public_bodies, :info_requests_count, :integer, {:null=>false, :default=>0})
==> default:    -> 0.0255s
==> default: == 20120912170035 AddInfoRequestsCountToPublicBodies: migrated (0.0288s) ======
==> default: == 20120913074940 AddIncomingMessageIndexToOutgoingMessages: migrating ========
==> default: -- add_index(:outgoing_messages, :incoming_message_followup_id)
==> default:    -> 0.0191s
==> default: == 20120913074940 AddIncomingMessageIndexToOutgoingMessages: migrated (0.0209s)
==> default: == 20120913080807 AddInfoRequestEventIndexToTrackThingsSentEmails: migrating ==
==> default: -- add_index(:track_things_sent_emails, :info_request_event_id)
==> default:    -> 0.0089s
==> default: == 20120913080807 AddInfoRequestEventIndexToTrackThingsSentEmails: migrated (0.0099s)
==> default: == 20120913081136 AddInfoRequestEventIndexToUserInfoRequestSentAlerts: migrating
==> default: -- add_index(:user_info_request_sent_alerts, :info_request_event_id)
==> default:    -> 0.0054s
==> default: == 20120913081136 AddInfoRequestEventIndexToUserInfoRequestSentAlerts: migrated (0.0067s)
==> default: == 20120913135745 AddUpdatedAtIndexToPublicBodyVersions: migrating ============
==> default: -- add_index(:public_body_versions, :updated_at)
==> default:    -> 0.0047s
==> default: == 20120913135745 AddUpdatedAtIndexToPublicBodyVersions: migrated (0.0060s) ===
==> default: == 20120919140404 AddCommentsAllowedToInfoRequest: migrating ==================
==> default: -- add_column(:info_requests, :comments_allowed, :boolean, {:null=>false, :default=>true})
==> default:    -> 0.0178s
==> default: == 20120919140404 AddCommentsAllowedToInfoRequest: migrated (0.0214s) =========
==> default: == 20121010214348 RenameEximLogTables: migrating ==============================
==> default: -- rename_table(:exim_logs, :mail_server_logs)
==> default:    -> 0.0646s
==> default: -- rename_table(:exim_log_dones, :mail_server_log_dones)
==> default:    -> 0.0126s
==> default: -- rename_column(:mail_server_logs, :exim_log_done_id, :mail_server_log_done_id)
==> default:    -> 0.0095s
==> default: == 20121010214348 RenameEximLogTables: migrated (0.0980s) =====================
==> default: == 20121022031914 AddDisclosureLog: migrating =================================
==> default: -- add_column(:public_bodies, :disclosure_log, :text, {:null=>false, :default=>""})
==> default:    -> 0.0244s
==> default: -- add_column(:public_body_versions, :disclosure_log, :text, {:null=>false, :default=>""})
==> default:    -> 0.0147s
==> default: -- add_column(:public_body_translations, :disclosure_log, :text)
==> default:    -> 0.0024s
==> default: == 20121022031914 AddDisclosureLog: migrated (0.0503s) ========================
==> default: == 20130731142632 RemoveProminenceFromInfoRequestEvent: migrating =============
==> default: -- remove_column(:info_request_events, :prominence)
==> default:    -> 0.0022s
==> default: == 20130731142632 RemoveProminenceFromInfoRequestEvent: migrated (0.0039s) ====
==> default: == 20130731145325 AddProminenceToIncomingMessage: migrating ===================
==> default: -- add_column(:incoming_messages, :prominence, :string, {:null=>false, :default=>"normal"})
==> default:    -> 0.0137s
==> default:
==> default: == 20130731145325 AddProminenceToIncomingMessage: migrated (0.0203s) ==========
==> default: == 20130801154033 AddProminenceReasonToIncomingMessage: migrating =============
==> default: -- add_column(:incoming_messages, :prominence_reason, :text)
==> default:    -> 0.0028s
==> default: == 20130801154033 AddProminenceReasonToIncomingMessage: migrated (0.0075s) ====
==> default: == 20130816150110 AddStatisticsToPublicBody: migrating ========================
==> default: -- add_column(:public_bodies, :info_requests_successful_count, :integer)
==> default:    -> 0.0019s
==> default: -- add_column(:public_bodies, :info_requests_not_held_count, :integer)
==> default:    -> 0.0021s
==> default: -- add_column(:public_bodies, :info_requests_overdue_count, :integer)
==> default:    -> 0.0012s
==> default: == 20130816150110 AddStatisticsToPublicBody: migrated (0.0173s) ===============
==> default: == 20130822161803 AddProminenceFieldsToOutgoingMessage: migrating =============
==> default: -- add_column(:outgoing_messages, :prominence, :string, {:null=>false, :default=>"normal"})
==> default:    -> 0.0166s
==> default: -- add_column(:outgoing_messages, :prominence_reason, :text)
==> default:    -> 0.0011s
==> default: == 20130822161803 AddProminenceFieldsToOutgoingMessage: migrated (0.0182s) ====
==> default: == 20130919151140 AddCanMakeBatchRequestsToUser: migrating ====================
==> default: -- add_column(:users, :can_make_batch_requests, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0104s
==> default: == 20130919151140 AddCanMakeBatchRequestsToUser: migrated (0.0112s) ===========
==> default: == 20131024114346 CreateInfoRequestBatches: migrating =========================
==> default: -- create_table(:info_request_batches)
==> default:    -> 0.0055s
==> default: -- add_column(:info_requests, :info_request_batch_id, :integer, {:null=>true})
==> default:    -> 0.0014s
==> default: -- execute("ALTER TABLE info_requests\n                    ADD CONSTRAINT fk_info_requests_info_request_batch\n                    FOREIGN KEY (info_request_batch_id) REFERENCES info_request_batches(id)")
==> default:    -> 0.0017s
==> default: -- add_index(:info_requests, :info_request_batch_id)
==> default:    -> 0.0034s
==> default: -- add_index(:info_request_batches, :user_id)
==> default:    -> 0.0048s
==> default: == 20131024114346 CreateInfoRequestBatches: migrated (0.0256s) ================
==> default: == 20131024152540 AddBodyToInfoRequestBatches: migrating ======================
==> default: -- add_column(:info_request_batches, :body, :text)
==> default:    -> 0.0020s
==> default: -- add_index(:info_request_batches, [:user_id, :body, :title])
==> default:    -> 0.0084s
==> default: == 20131024152540 AddBodyToInfoRequestBatches: migrated (0.0125s) =============
==> default: == 20131101155844 AddStatsDenominator: migrating ==============================
==> default: -- add_column(:public_bodies, :info_requests_visible_classified_count, :integer)
==> default:    -> 0.0015s
==> default: == 20131101155844 AddStatsDenominator: migrated (0.0047s) =====================
==> default: == 20131127105438 CreateInfoRequestBatchPublicBodiesJoinTable: migrating ======
==> default: -- create_table(:info_request_batches_public_bodies, {:id=>false})
==> default:    -> 0.0044s
==> default: == 20131127105438 CreateInfoRequestBatchPublicBodiesJoinTable: migrated (0.0078s)
==> default: == 20131127135622 AddSentAtToInfoRequestBatch: migrating ======================
==> default: -- add_column(:info_request_batches, :sent_at, :datetime)
==> default:    -> 0.0023s
==> default: == 20131127135622 AddSentAtToInfoRequestBatch: migrated (0.0035s) =============
==> default: == 20131211152641 CreatePublicBodyChangeRequests: migrating ===================
==> default: -- create_table(:public_body_change_requests)
==> default:    -> 0.0100s
==> default: == 20131211152641 CreatePublicBodyChangeRequests: migrated (0.0135s) ==========
==> default: == 20140325120619 CreateSpamAddresses: migrating ==============================
==> default: -- create_table(:spam_addresses)
==> default:    -> 0.0110s
==> default: == 20140325120619 CreateSpamAddresses: migrated (0.0170s) =====================
==> default: == 20140408145616 AddDefaultShortNameToPublicBodies: migrating ================
==> default: -- change_column_default(:public_bodies, :short_name, "")
==> default:    -> 0.0032s
==> default: == 20140408145616 AddDefaultShortNameToPublicBodies: migrated (0.0045s) =======
==> default: == 20140528110536 UpdateTrackThingsIndex: migrating ===========================
==> default: -- execute("ALTER TABLE track_things_sent_emails DROP CONSTRAINT fk_track_request_public_body")
==> default:    -> 0.0017s
==> default: -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
==> default:    -> 0.0035s
==> default: == 20140528110536 UpdateTrackThingsIndex: migrated (0.0073s) ==================
==> default: == 20140710094405 CreatePublicBodyHeadingsAndCategories: migrating ============
==> default: -- create_table(:public_body_headings, {:force=>true})
==> default:    -> 0.0063s
==> default: -- create_table(:public_body_categories, {:force=>true})
==> default:    -> 0.0068s
==> default: -- create_table(:public_body_categories_public_body_headings, {:id=>false})
==> default:    -> 0.0056s
==> default: == 20140710094405 CreatePublicBodyHeadingsAndCategories: migrated (0.0239s) ===
==> default: == 20140716131107 CreateCategoryTranslationTables: migrating ==================
==> default: -- remove_column(:public_body_headings, :locale)
==> default:    -> 0.0008s
==> default: -- remove_column(:public_body_categories, :locale)
==> default:    -> 0.0011s
==> default: -- remove_column(:public_body_headings, :name)
==> default:    -> 0.0012s
==> default: -- remove_column(:public_body_categories, :title)
==> default:    -> 0.0010s
==> default: -- remove_column(:public_body_categories, :description)
==> default:    -> 0.0011s
==> default: -- add_index(:public_body_categories, :category_tag, {:unique=>true})
==> default:    -> 0.0029s
==> default: == 20140716131107 CreateCategoryTranslationTables: migrated (0.0799s) =========
==> default: == 20140801132719 AddIndexToInfoRequestEvents: migrating ======================
==> default: -- add_index(:info_request_events, :event_type)
==> default:    -> 0.0037s
==> default: == 20140801132719 AddIndexToInfoRequestEvents: migrated (0.0049s) =============
==> default: == 20140804120601 AddDisplayOrderToCategoriesAndHeadings: migrating ===========
==> default: -- add_column(:public_body_categories_public_body_headings, :category_display_order, :integer)
==> default:    -> 0.0019s
==> default: -- rename_table(:public_body_categories_public_body_headings, :public_body_category_links)
==> default:    -> 0.0066s
==> default: -- add_column(:public_body_category_links, :id, :primary_key)
==> default:    -> 0.0045s
==> default: -- add_index(:public_body_category_links, [:public_body_category_id, :public_body_heading_id], {:name=>"index_public_body_category_links_on_join_ids"})
==> default:    -> 0.0031s
==> default: == 20140804120601 AddDisplayOrderToCategoriesAndHeadings: migrated (0.0283s) ==
==> default: == 20140824191444 CreateWidgetVotes: migrating ================================
==> default: -- create_table(:widget_votes)
==> default:    -> 0.0044s
==> default: -- add_index(:widget_votes, :info_request_id)
==> default:    -> 0.0032s
==> default: == 20140824191444 CreateWidgetVotes: migrated (0.0109s) =======================
==> default: == 20151006101417 AddOtpEnabledToUsers: migrating =============================
==> default: -- add_column(:users, :otp_enabled, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0132s
==> default: == 20151006101417 AddOtpEnabledToUsers: migrated (0.0155s) ====================
==> default: == 20151006104552 AddOtpSecretKeyToUsers: migrating ===========================
==> default: -- add_column(:users, :otp_secret_key, :string)
==> default:    -> 0.0063s
==> default: == 20151006104552 AddOtpSecretKeyToUsers: migrated (0.0098s) ==================
==> default: == 20151006104739 AddCounterForOtpToUsers: migrating ==========================
==> default: -- add_column(:users, :otp_counter, :integer, {:default=>1})
==> default:    -> 0.0198s
==> default: == 20151006104739 AddCounterForOtpToUsers: migrated (0.0218s) =================
==> default: == 20151009162421 AddInfoRequestsVisibleCountToPublicBodies: migrating ========
==> default: -- add_column(:public_bodies, :info_requests_visible_count, :integer, {:null=>false, :default=>0})
==> default:    -> 0.0254s
==> default: == 20151009162421 AddInfoRequestsVisibleCountToPublicBodies: migrated (0.0363s)
==> default: == 20151020112248 SetLongerLengthForTrackThingsTrackQuery: migrating ==========
==> default: -- change_column(:track_things, :track_query, :string, {:limit=>500})
==> default:    -> 0.0267s
==> default: == 20151020112248 SetLongerLengthForTrackThingsTrackQuery: migrated (0.0277s) =
==> default: == 20151104131702 AddLastPublicResponseAtToInfoRequest: migrating =============
==> default: -- add_column(:info_requests, :last_public_response_at, :datetime, {:null=>true})
==> default:    -> 0.0030s
==> default: == 20151104131702 AddLastPublicResponseAtToInfoRequest: migrated (0.0109s) ====
==> default: == 20160526154304 AddConfirmedNotSpamToUsers: migrating =======================
==> default: -- add_column(:users, :confirmed_not_spam, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0332s
==> default: == 20160526154304 AddConfirmedNotSpamToUsers: migrated (0.0358s) ==============
==> default: == 20160602143125 AddRejectIncomingAtMtaToInfoRequest: migrating ==============
==> default: -- add_column(:info_requests, :reject_incoming_at_mta, :boolean, {:default=>false, :null=>false})
==> default:    -> 0.0279s
==> default: == 20160602143125 AddRejectIncomingAtMtaToInfoRequest: migrated (0.0285s) =====
==> default: == 20160602145046 AddRejectedIncomingCountToInfoRequest: migrating ============
==> default: -- add_column(:info_requests, :rejected_incoming_count, :integer, {:default=>0})
==> default:    -> 0.0308s
==> default: == 20160602145046 AddRejectedIncomingCountToInfoRequest: migrated (0.0314s) ===
==> default: == 20160613145644 AddCommentsCountToUsers: migrating ==========================
==> default: -- add_column(:users, :comments_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0255s
==> default: == 20160613145644 AddCommentsCountToUsers: migrated (0.0846s) =================
==> default: == 20160613151127 AddInfoRequestsCountToUsers: migrating ======================
==> default: -- add_column(:users, :info_requests_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0284s
==> default: == 20160613151127 AddInfoRequestsCountToUsers: migrated (0.0338s) =============
==> default: == 20160613151912 AddTrackThingsCountToUsers: migrating =======================
==> default: -- add_column(:users, :track_things_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0081s
==> default: == 20160613151912 AddTrackThingsCountToUsers: migrated (0.0125s) ==============
==> default: == 20160613152433 AddRequestClassificationsCountToUsers: migrating ============
==> default: -- add_column(:users, :request_classifications_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0105s
==> default: == 20160613152433 AddRequestClassificationsCountToUsers: migrated (0.0555s) ===
==> default: == 20160613153739 AddPublicBodyChangeRequestsCountToUsers: migrating ==========
==> default: -- add_column(:users, :public_body_change_requests_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0140s
==> default: == 20160613153739 AddPublicBodyChangeRequestsCountToUsers: migrated (0.0671s) =
==> default: == 20160613154616 AddInfoRequestBatchesCountToUsers: migrating ================
==> default: -- add_column(:users, :info_request_batches_count, :integer, {:default=>0, :null=>false})
==> default:    -> 0.0231s
==> default: == 20160613154616 AddInfoRequestBatchesCountToUsers: migrated (0.0642s) =======
==> default: == 20160701155339 RemoveCommentTypeFromComment: migrating =====================
==> default: -- remove_column(:comments, :comment_type)
==> default:    -> 0.0019s
==> default: == 20160701155339 RemoveCommentTypeFromComment: migrated (0.0042s) ============
==> default: == 20160907144809 AddDeliveryStatusToMailServerLogs: migrating ================
==> default: -- add_column(:mail_server_logs, :delivery_status, :string)
==> default:    -> 0.0017s
==> default: == 20160907144809 AddDeliveryStatusToMailServerLogs: migrated (0.0049s) =======
==> default: == 20161006142352 CreateFlipperTables: migrating ==============================
==> default: -- create_table(:flipper_features)
==> default:    -> 0.0045s
==> default: -- add_index(:flipper_features, :key, {:unique=>true})
==> default:    -> 0.0029s
==> default: -- create_table(:flipper_gates)
==> default:    -> 0.0095s
==> default: -- add_index(:flipper_gates, [:feature_key, :key, :value], {:unique=>true})
==> default:    -> 0.0034s
==> default: == 20161006142352 CreateFlipperTables: migrated (0.0256s) =====================
==> default: == 20161101110656 CreateProAccounts: migrating ================================
==> default: -- create_table(:pro_accounts)
==> default:    -> 0.0046s
==> default: == 20161101110656 CreateProAccounts: migrated (0.0060s) =======================
==> default: == 20161101151318 CreateEmbargoes: migrating ==================================
==> default: -- create_table(:embargoes)
==> default:    -> 0.0181s
==> default: == 20161101151318 CreateEmbargoes: migrated (0.0203s) =========================
==> default: == 20161116121007 CreateDraftInfoRequests: migrating ==========================
==> default: -- create_table(:draft_info_requests)
==> default:    -> 0.0310s
==> default: == 20161116121007 CreateDraftInfoRequests: migrated (0.0317s) =================
==> default: == 20161128095350 AddDurationToEmbargo: migrating =============================
==> default: -- add_column(:embargoes, :embargo_duration, :string)
==> default:    -> 0.0027s
==> default: == 20161128095350 AddDurationToEmbargo: migrated (0.0036s) ====================
==> default: == 20161206174634 AddDateInitialRequestLastSentAtToInfoRequest: migrating =====
==> default: -- add_column(:info_requests, :date_initial_request_last_sent_at, :date)
==> default:    -> 0.0032s
==> default: == 20161206174634 AddDateInitialRequestLastSentAtToInfoRequest: migrated (0.0085s)
==> default: == 20161206175711 AddDateResponseRequiredByToInfoRequest: migrating ===========
==> default: -- add_column(:info_requests, :date_response_required_by, :date)
==> default:    -> 0.0019s
==> default: == 20161206175711 AddDateResponseRequiredByToInfoRequest: migrated (0.0030s) ==
==> default: == 20161206175737 AddDateVeryOverdueAfterToInfoRequest: migrating =============
==> default: -- add_column(:info_requests, :date_very_overdue_after, :date)
==> default:    -> 0.0031s
==> default: == 20161206175737 AddDateVeryOverdueAfterToInfoRequest: migrated (0.0045s) ====
==> default: == 20161207184708 CreateEmbargoExtensions: migrating ==========================
==> default: -- create_table(:embargo_extensions)
==> default:    -> 0.0200s
==> default: == 20161207184708 CreateEmbargoExtensions: migrated (0.0220s) =================
==> default: == 20161222101600 AddLastEventFormingInitialRequestIdToInfoRequests: migrating
==> default: -- add_column(:info_requests, :last_event_forming_initial_request_id, :integer)
==> default:    -> 0.0067s
==> default: == 20161222101600 AddLastEventFormingInitialRequestIdToInfoRequests: migrated (0.0080s)
==> default: == 20170216101547 AddAttentionRequestedToComment: migrating ===================
==> default: -- add_column(:comments, :attention_requested, :boolean, {:null=>false, :default=>false})
==> default:    -> 0.0072s
==> default: == 20170216101547 AddAttentionRequestedToComment: migrated (0.0091s) ==========
==> default: == 20170227140831 RolifyCreateRoles: migrating ================================
==> default: -- create_table(:roles)
==> default:    -> 0.0069s
==> default: -- create_table(:users_roles, {:id=>false})
==> default:    -> 0.0015s
==> default: -- add_index(:roles, :name)
==> default:    -> 0.0040s
==> default: -- add_index(:roles, [:name, :resource_type, :resource_id])
==> default:    -> 0.0030s
==> default: -- add_index(:users_roles, [:user_id, :role_id])
==> default:    -> 0.0034s
==> default: == 20170227140831 RolifyCreateRoles: migrated (0.0194s) =======================
==> default: == 20170301163735 CreateDraftInfoRequestBatches: migrating ====================
==> default: -- create_table(:draft_info_request_batches)
==> default:    -> 0.0058s
==> default: -- add_index(:draft_info_request_batches, :user_id)
==> default:    -> 0.0030s
==> default: == 20170301163735 CreateDraftInfoRequestBatches: migrated (0.0105s) ===========
==> default: == 20170301164705 CreateDraftInfoRequestBatchesPublicBodiesTable: migrating ===
==> default: -- create_table(:draft_info_request_batches_public_bodies, {:id=>false})
==> default:    -> 0.0076s
==> default: -- add_index(:draft_info_request_batches_public_bodies, [:draft_info_request_batch_id, :public_body_id], {:name=>"index_draft_batch_body_and_draft"})
==> default:    -> 0.0053s
==> default: -- add_index(:draft_info_request_batches_public_bodies, :public_body_id, {:name=>"index_draft_batch_body"})
==> default:    -> 0.0055s
==> default: == 20170301164705 CreateDraftInfoRequestBatchesPublicBodiesTable: migrated (0.0236s)
==> default: == 20170316170248 EditInfoRequestBatchIndex: migrating ========================
==> default: -- remove_index(:info_request_batches, {:column=>[:user_id, :body, :title]})
==> default:    -> 0.0106s
==> default: -- add_index(:info_request_batches, [:user_id, :title])
==> default:    -> 0.0103s
==> default: == 20170316170248 EditInfoRequestBatchIndex: migrated (0.0243s) ===============
==> default: + LOADED_INDICATOR=/home/vagrant/.alaveteli-sample-data-loaded
==> default: + '[' '!' -f /home/vagrant/.alaveteli-sample-data-loaded ']'
==> default: + echo Running load-sample-data
==> default: Running load-sample-data
==> default: + bundle exec script/load-sample-data
==> default: Loaded fixtures. You may now wish to run script/update-xapian-index
==> default: + echo Running rebuild-xapian-index
==> default: Running rebuild-xapian-index
==> default: + script/rebuild-xapian-index
==> default: + touch /home/vagrant/.alaveteli-sample-data-loaded
==> default: ALTER ROLE
==> default: Creating /etc/cron.d/alaveteli...
==> default: done
==> default: Creating /etc/init.d/alaveteli-alert-tracks...
==> default: done
==> default: Installation complete
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: stdin: is not a tty
==> default:
==> default: Welcome to your new Alaveteli development site!
==> default:
==> default: If you are planning to use a custom theme, you should create
==> default: an `alaveteli-themes` folder at the same level as your `alaveteli`
==> default: code folder to hold your theme repositories so that your
==> default: Vagrant box will see your theme folders when using the
==> default: switch-theme.rb script (take a look at the documentation in
==> default: the script/switch-theme.rb file for more information).
==> default:
==> default: Full instructions for customising your install can be found online:
==> default: http://alaveteli.org/docs/customising/
==> default:
==> default: Type `vagrant ssh` to log into the Vagrant box to start the site
==> default: or run the test suite
Keerti-Gautam commented 7 years ago

The documentation looks good now. I recreated VM and rails server is successfully installed on my machine now!

Thanks for a prompt response!

Closing this issue now.