Ubuntu server setup with Redmine

ubuntu_redmine_setup.bash

# wget -O - https://raw.github.com/gist/3921725/ubuntu_redmine_setup.bash | bash

#add user gazza
adduser gazza

#add new user to list of sudoers
adduser gazza sudo

#now logout and re-login as gazza

sudo apt-get update
sudo apt-get -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" dist-upgrade

sudo apt-get -y install aptitude

#switch to aptitude

#fix locale
sudo aptitude -y install language-pack-en-base
sudo /usr/sbin/locale-gen en_SG.UTF-8
sudo /usr/sbin/update-locale LANG=en_SG.UTF-8

#set timezone info
sudo dpkg-reconfigure tzdata


#install packages recommended by RVM
sudo aptitude -y install build-essential curl git openssl libreadline6 libreadline6-dev zlib1g zlib1g-dev libssl-dev libyaml-dev libsqlite3-0 libsqlite3-dev sqlite3 libxml2-dev libxslt-dev autoconf libc6-dev ncurses-dev automake libtool bison subversion libgemplugin-ruby mysql-server libmysql-ruby libmysqlclient-dev apache2

#install rvm, check out the site for the command
curl -L https://get.rvm.io | bash -s stable
echo '[[ -s "$HOME/.rvm/scripts/rvm" ]] && . "$HOME/.rvm/scripts/rvm"' >> ~/.bashrc
source ~/.bashrc

#install latest ruby and set as default
rvm install 1.9.3
rvm use 1.9.3 --default

#install rails
gem install rails mysql2 bundler

#create redmine database
mysql -u root -p
create database redmine;
exit

#at this point, load redmine db backup through phpmyadmin
curl -O https://www.dropbox.com/s/bhz8nrdpjc58f9n/redmine.sql?dl=1 redmine.sql
wget redmine.sql https://www.dropbox.com/s/bhz8nrdpjc58f9n/redmine.sql?dl=1 
mv redmine.sql?dl=1 redmine.sql
mysql -u root -p redmine < redmine.sql
rm redmine.sql

#login to mysql as root and create user redmine
create user 'redmine'@'localhost' identified by 'redmine';
grant all privileges on redmine.* to 'redmine'@'localhost';

#checkout redmine(my own fork with custom report)
git clone https://github.com/gaza3g/redmine
cd redmine

#install gems required
bundle install  --without development test postgresql sqlite rmagick

#not sure if we need this step. no harm running tho.
rake generate_secret_token

#database config
wget redmine.sql https://www.dropbox.com/s/f96rlpfz8f00p6n/database.yml?dl=1
mv database.yml?dl=1 database.yml
cp database.yml ~/redmine/config/database.yml
rm database.yml

RAILS_ENV=production

ruby script/rails server webrick -e production

#passenger stuff
sudo chown www-data ~/redmine/config/environment.rb
sudo ln -s ~/redmine/public /var/www/redmine

#install passenger stuff

sudo apt-get install libapache2-mod-passenger

sudo vim /etc/apache2/mods-available/passenger.conf
#modify it to look like this:
#<IfModule mod_passenger.c>
#  PassengerDefaultUser www-data
#  PassengerRoot /usr
#  PassengerRuby /usr/bin/ruby
#</IfModule>

sudo vim /etc/apache2/sites-available/default
#append this:
<Directory /var/www/redmine>
    RailsBaseURI /redmine
    PassengerResolveSymlinksInDocumentRoot on
</Directory>

#restart apache
sudo service apache2 restart