install koko

1 - install a bunch of crap

apt-get install git-core libpcre3 libpcre3-dev libonig2 libonig-dev ruby1.8-dev irb ri rdoc libmysql-ruby libxml-ruby libsqlite3-ruby libmysqlclient15off libmysqlclient15-dev libsqlite3-0 libsqlite3-dev libxml2 libxml2-dev libopenssl-ruby1.8 libxslt-dev nginx libfcgi-dev libidn11 libidn11-dev mysql-client mysql-common mysql-server curl libcurl4-openssl-dev libexpat1-dev libreadline5-dev libssl-dev

# on fink
fink install oniguruma oniguruma-shlibs

sudo gem install --no-ri --no-rdoc rails rake ri rdoc mysql addressable chriseppstein-compass haml-edge mislav-will_paginate nokogiri oniguruma chronic tlsmail uuidtools eventmachine extlib htmlentities idn json hpricot RedCloth
sudo gem install --no-ri --no-rdoc aslakhellesoy-cucumber notahat-machinist flay flog rcov reek relevance-rcov roodi rspec rspec-rails brynary-webrat ZenTest railroad
sudo gem install --no-ri --no-rdoc mongrel thin mongrel_cluster passenger rack rack_csrf capistrano capistrano-ext capistrano_colors fiveruns-dash-activerecord fiveruns-dash-rails fiveruns-dash-ruby fiveruns_tuneup
sudo gem install --no-ri --no-rdoc authlogic authlogic-oid aws-s3 diff-lcs oauth oauth-plugin net-scp net-sftp net-ssh net-ssh-gateway
sudo gem install --no-ri --no-rdoc cheat git gravtastic grempe-amazon-ec2 annotate-models deprec fastercsv adamwiggins-rest-client right_aws ruby-debug ruby-openid ruby-prof ruby-yadis

# hold root password in temp env var but don't let it into your bash history. 
# Note the spaces at start of line are significant
export HISTIGNORE="ls:[bf]g:exit: *:history:histgrep:&" 
   DBPASS=YOUR_ROOT_MYSQL_PASSWORD

# Only run this if you have never set the mysql root password
mysqladmin -u root  password $DBPASS

# OK back to business
echo "CREATE USER 'koko'@'localhost' IDENTIFIED BY 'some_throwaway_password';"  | mysql -uroot --password=$DBPASS
echo "create database koko_dev"                                                 | mysql -uroot --password=$DBPASS
echo "GRANT ALL ON \`koko\\_%\`.* TO 'koko'@'localhost';"                       | mysql -uroot --password=$DBPASS
bzcat PATH_TO_THIS_FILE/koko_good-20090913-3-after_user_testing.sql.bz2         | mysql -uroot --password=$DBPASS koko_dev

# make sure nothing is in the .history file.. just look over the results and make sure you don't spot it.
history          | egrep -i 'DBPASS|password'
cat ~/.*history* | egrep -i 'DBPASS|password'

2 - you can run this in the mysql console if you prefer

CREATE USER 'koko'@'localhost' IDENTIFIED BY 'some_throwaway_password';
create database koko_dev;
GRANT ALL ON `koko\_%`.* TO 'koko'@'localhost';
GRANT PROCESS, FILE, CREATE TEMPORARY TABLES ON *.* TO 'koko'@'localhost';

3 - edit your database.yml

defaults: &defaults
  adapter:      mysql
  encoding:     utf8
  host:         localhost
  port:         3306               # grep port /etc/mysql/my.cnf
  pool:         5
  timeout:      5000

development:
  database:     koko_dev
  username:     koko
  password:     'MYSQL_PASSWORD_FOR_KOKO'
  <<: *defaults

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
  database:     koko_test
  username:     koko
  password:     'MYSQL_PASSWORD_FOR_KOKO'
  <<: *defaults

4 - in business maybe.sh

cd koko                   # wherever it was you put this
sudo rake gems:install
rake db:migrate           # this should do nothing
./script/server