UPGRADE.md

Upgrading

1.0 - 2.0.0

Install new dependencies:

% apt-get update
% apt-get install screen
% apt-get install php5-dev

% pip install celery

% pecl install redis

If you're using Ubuntu 10.04:

% add-apt-repository ppa:chris-lea/redis-server
% apt-get update
% apt-get install redis-server

% pip install requests
% pip install redis

If you're using Ubuntu 12.04 (or later):

% apt-get install redis-server python-redis python-requests

Add Redis to the list of registered PHP extensions and use its bundled session handler:

% cat <<EOF > /etc/php5/conf.d/20-redis.ini
extension=redis.so
session.save_handler = redis
session.save_path = "tcp://localhost"
EOF

Reload Apache:

% /etc/init.d/apache2 reload

Update your git clone:

% cd /usr/local/fieldpapers
% git fetch origin
% git checkout -b v2.0.0

Add REDIS_HOST to site/lib/init.php:

define('REDIS_HOST', 'localhost');

Drop the MySQL messages table (optional):

echo "drop table messages;" | mysql -u root

Remove the calls to poll.py from /etc/crontab:

% sensible-editor /etc/crontab

Add Celery to upstart:

% cp conf/celery.conf /etc/init
% start celery

Loosen the restrictions on where user ids are required:

cat <<EOF | mysql -u root fieldpapers
ALTER TABLE prints MODIFY COLUMN user_id VARCHAR(8);
ALTER TABLE scans MODIFY COLUMN user_id VARCHAR(8);
ALTER TABLE forms MODIFY COLUMN user_id VARCHAR(8);
EOF

Clean out the users table:

cat <<EOF | mysql -u root fieldpapers
DELETE users
FROM users
LEFT JOIN prints ON prints.user_id=users.id
LEFT JOIN scans ON scans.user_id=users.id
WHERE prints.id IS NULL
    AND scans.id IS NULL
    AND users.name IS NULL;
CREATE INDEX users_email ON users(email);
EOF

Feel free to clear out any pending session data (in /var/lib/php5 by default), as all new sessions will be stored in Redis.

Add an indexed private flag on prints:

ALTER TABLE prints ADD COLUMN private TINYINT NOT NULL;
CREATE INDEX prints_private ON prints(private);

Add additional columns on prints:

ALTER TABLE prints ADD COLUMN text MEDIUMTEXT;
ALTER TABLE prints ADD COLUMN cloned VARCHAR(20) DEFAULT NULL;
ALTER TABLE prints ADD COLUMN refreshed VARCHAR(20) DEFAULT NULL;