Kiterminal's Blog

$ curl -O http://sphinxsearch.com/files/sphinx-2.0.3-release.tar.gz
$ tar zxvf sphinx-2.0.3-release.tar.gz
$ cd sphinx-2.0.3-release
$ ./configure --with-mysql-includes=/usr/local/mysql/include/mysql --with-mysql-libs=/usr/local/mysql/lib/mysql
$ make
$ sudo make install

$ rvmsudo passenger-install-nginx-module

$ gem install rails

$ wget http://developer.axis.com/download/distribution/apps-sys-utils-start-stop-daemon-IR1_9_18-2.tar.gz
$ tar xvfz apps-sys-utils-start-stop-daemon-IR1_9_18-2.tar.gz
$ cd apps/sys-utils/start-stop-daemon-IR1_9_18-2/
$ gcc start-stop-daemon.c -o start-stop-daemon
$ cp start-stop-daemon /usr/sbin/

$ cd /etc/init.d

$ sudo yum install git
$ sudo yum install curl

$ su -
$ groupadd rvm
$ usermod -a -G rvm root
$ logout

$ sudo bash -s stable < <(curl -s https://raw.github.com/wayneeseguin/rvm/master/binscripts/rvm-installer )
$ echo '[[ -s "/usr/local/lib/rvm" ]] && . "/usr/local/lib/rvm"  # This loads RVM into a shell session.' >> ~/.bash_profile
$ source ~/.bash_profile
$ type rvm | head -1 # should print 'rvm is a function'

# in application_controller.rb
def current_ability
  @current_ability ||= Ability.new(current_user, session)
end

# in ability.rb
def initialize(user, session)
  # ...
  can :update, Comment, :id => session[:comments_ids].to_a
end

$ mysqldump --user=username --password=password --default-character-set=latin1 --skip-set-charset database_name > database_latin1.sql

$ sed -e 's/latin1/utf8/g' database_latin1.sql > database_utf8.sql

$ mysql --user=username --password=password --execute="DROP DATABASE database_name;"
$ mysql --user=username --password=password --execute="CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;"