Archive

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 https://get.rvm.io | 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 user.name "USERNAME"
git config --global user.email "EMAIL@WEBSITE.COM"

Cheers,
Mikhail

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 http://support.apple.com/kb/ht3696

 

Second, download and install the appropriate MySQL version  from http://dev.mysql.com/downloads/mysql. 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 http://rubyforge.org/frs/download.php/60718/rubygems-1.3.5.tgz
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.