Archive for the ‘MySQL’ Category

Update to Rails, MySQL, Ubuntu stack on AWS post

September 7, 2012 1 comment

This is an update to my first post on how to setup a working environment on Amazon EC2 with Ruby on Rails, Passenger, MySQL, and Ubuntu.

Quiet a lot has changed in last three years, so I thought I’d do a quick post to improve the installation, seeing as how the old post still receives a bit of traffic.

I’m using the official Ubuntu Server 12.04 LTS ami. Here is the rundown:

# Setup Ruby on Rails, MySql, Apache + Passenger
# on Amazon Ubuntu instance (12.04 LTS)
# 9/7/2012

echo Updating operating system and components...

sudo apt-get update -y
sudo apt-get dist-upgrade -y
sudo apt-get install build-essential -y
sudo apt-get install libxslt-dev libxml2-dev -y
sudo apt-get install curl libcurl4-openssl-dev -y
sudo apt-get install zlib1g-dev libssl-dev libexpat1-dev -y

echo Installing apache server, mysql utils, ruby, and git

sudo apt-get install apache2 apache2-threaded-dev -y
sudo apt-get install mysql-server mysql-client-core-5.5 -y
sudo apt-get install git-core gitweb -y
sudo apt-get install ruby1.9.2 -y
sudo apt-get install imagemagick -y
sudo apt-get install libmagickwand-dev -y

sudo curl -L | bash -s stable
source /home/ubuntu/.rvm/scripts/rvm

sudo apt-get install automake -y
sudo apt-get install bison -y
rvm install 1.9.2-head

gem install passenger
sudo passenger-install-apache2-module

A couple of big items. First, you’ll notice the addition of RVM. I found it makes my life a lot easier when managing ruby installations. Second, no gems. This is because now you’ll be managing all your gems through the bundler, which will make your life a lot easier too.

If you are using git, don’t forget to set

git config --global "USERNAME"
git config --global "EMAIL@WEBSITE.COM"


Upgrading Rails, Gems, and MySQL to Snow Leopard

November 29, 2010 Leave a comment

Have been meaning to post this for a while. I have an older MBP that came with OS X version 10.4, and after upgrading to 10.6 my entire coding stack collapsed. After a couple of hours here is the solution I came up with.


First, find what processor you are running on, ie 32 or 64 bit. If you don’t know use this guide


Second, download and install the appropriate MySQL version  from In my case it was 64-bit MySQL 5.1.37.


After that you’ll need to install ruby gems from scratch. You can find more details in my other post How to setup RoR+Passenger+MySql+Ubuntu Server on EC2,but here is an excerpt bash script with all you need:

echo Installing ruby gems...
cd /usr/local/src
sudo wget
sudo tar -zvxf rubygems-1.3.5.tgz
cd rubygems-1.3.5/
sudo ruby setup.rb

echo Symlinking...
sudo ln -s /usr/bin/gem1.8 /usr/local/bin/gem
sudo ln -s /usr/bin/ruby1.8 /usr/local/bin/ruby
sudo ln -s /usr/bin/rdoc1.8 /usr/local/bin/rdoc
sudo ln -s /usr/bin/ri1.8 /usr/local/bin/ri
sudo ln -s /usr/bin/irb1.8 /usr/local/bin/irb

Note: If you find that the gem command still won’t run try this

sudo ln -s /usr/bin/gem /usr/local/bin/gem


Finally, execute the following:

sudo gem update --system
sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config

Note: make sure you set  ARCHFLAGS flag to the appropriate architecture.


Good luck and enjoy your new OS.