PIFR 2 client for postgres on Ubuntu 9.10

in-progress:

starting from http://qa.drupal.org/node/44, http://groups.drupal.org/node/39942

ec2-request-spot-instances -t m1.small -p 0.035 -k XXX -g pfir2 -v ami-bb709dd2

ssh -i XXX.pem ubuntu@ec2-99-201-0-242.compute-1.amazonaws.com

sudo apt-get update
sudo apt-get upgrade

sudo apt-get --no-install-recommends install build-essential postgresql postgresql-client apache2 apache2-threaded-dev php5 php5-cgi php5-cli php5-gd php5-common php-pear php5-curl php5-pgsql cvs curl php5-dev libapache2-mod-php5 gawk patch htop rsync cron wget openssh-blacklist-extra

check the data dir:

sudo ls -l /var/lib/postgresql/8.4/main/

check the conf:

more /etc/postgresql/8.4/main/postgresql.conf

sudo a2enmod rewrite
sudo perl -pi -e 's/(\s+AllowOverride)\s+None$/\1 All/g' /etc/apache2/sites-available/default
sudo /etc/init.d/apache2 restart

add drupal.ini to /etc/php5/conf.d with the following (sudo nano /etc/php5/conf.d/drupal.ini) :

Greatly reduce the number of apache processes allowed to run by adding to /etc/apache2/conf.d a file drupal.conf with:

Increase shhmax

sudo sysctl -w kernel.shmmax=73400320

cd /var
sudo chown ubuntu www
cvs -z6 -d :pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal checkout -r DRUPAL-6-15 -d www drupal
cd www
sudo rm index.html

use patch for postgres config (below) restart postgres.

sudo su - postgres
createuser -s ubuntu
exit

createuser --pwprompt --encrypted --no-createrole --createdb -S username
(type in 'password' as the password)
createdb --encoding=UNICODE --owner=username drupal
createdb --encoding=UNICODE --owner=username drupal_checkout

chmod 755 sites/default
cp sites/default/default.settings.php sites/default/settings.php

nano sites/default/settings.php

add:

$db_url = array();
$db_url['default'] = 'pgsql://username:password@localhost/drupal';
$db_url['pifr_checkout'] = 'pgsql://username:password@localhost/drupal_checkout';

mkdir sites/default/files
chmod 777 sites/default/files
touch sites/default/files/review.log
chmod 777 sites/default/files/review.log
sudo chown www-data:www-data sites/default/files/review.log
ln -s ./sites/default/files/checkout

mkdir sites/all/modules
cd sites/all/modules
cvs -z6 -d:pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal-contrib checkout -r DRUPAL-6--1 -d cvs_deploy contributions/modules/cvs_deploy

cvs -z6 -d:pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal-contrib checkout -r DRUPAL-6--2-2 -d project_issue_file_review contributions/modules/project_issue_file_review

Install Drupal, enable CVS Deploy, PIFR, PIFR Client, PIFR Assertion modules

crontab -e

prepare for tmpfs:

sudo mkdir /var/lib/postgresql/8.4/tmpfs
sudo chown postgres:postgres /var/lib/postgresql/8.4/tmpfs
sudo chmod 755 /var/lib/postgresql/8.4/main/

sudo mv sites/default/files/ sites/default/.files
mkdir sites/default/files/
sudo mount -t tmpfs -o rw,nosuid,nodev,noexec,uid=id -u www-data,gid=id -g www-data,size=50m tmpfs /var/www/sites/default/files
sudo chmod -R go+w /var/www/sites/default/files
sudo cp -r /var/www/sites/default/.files/* /var/www/sites/default/files

manual commands:

sudo mount -t tmpfs -o rw,nosuid,nodev,noexec,uid=id -u postgres,gid=id -g postgres tmpfs /var/lib/postgresql/8.4/tmpfs
sudo cp -a /var/lib/postgresql/8.4/main/* /var/lib/postgresql/8.4/tmpfs/
sudo chmod 700 /var/lib/postgresql/8.4/tmpfs

POSTGRES is a PITA:

http://www.cyberciti.biz/faq/psql-fatal-ident-authentication-failed-for-...
http://old.nabble.com/SAST-FATAL:-could-not-access-private-key-file-%22s...
http://www.postgresql.org/docs/8.3/static/ssl-tcp.html

more complete patch - some of this is probably not needed: