Tag: mysql

Ruby on Rails, Passenger & MySQL PATH issues in Snow Leopard

Posted by – September 8, 2009

I recently did a clean installation of Snow Leopard, which is great by the way, and I ran into some issues after installing MySQL and Ruby on Rails based on the instructions from Dan Benjamin at Hivelogic.

Specifically, when I would try to access a site in development mode I would get an error from Passenger that “Rails 2.3.4 could not be found”. I also noticed that on reboot my PATH wasn’t being loaded properly either so the system could not find MySql, Ruby, or RubyGems.

I tried placing the path information that, according to the instructions goes in ~/.profile into my ~/.bash_profile.

Now when I restart the system, MySQL and Ruby on Rail can be found! Passenger is working now as well. I am not sure if there was a change in the way Snow Leopard loads bash profiles or if there is just a problem with my installation that was preventing it from working when the PATH was specified in ~/.profile, but it’s all working now so hopefully this will help someone else.

Ruby & Rails using Passenger

Posted by – July 28, 2008

I have been toying with a MySQL server at work for loading data from a legacy database and creating user accounts in Microsoft’s Active Directory. I am using linux along with MySQL, Ruby and the Rails framework. While I am certainly no über-expert at this, I am finding the task not only manageable, but altogether pleasant. My current workflow looks like this:

  1. Mount Windows share using Samba
  2. Load data into MySQL and perform a bunch of transformations on it
  3. TODO: script creation of Active Directory accounts from MySQL Database (Python??)

I found that I needed to view the data as I was testing the MySQL transformations, so I turned to Ruby and Rails. I have not had a great deal of luck in the past with configuring Apache to serve up dynamic content via Mongrel or lighty, so I decided to give Passenger a go. For those of you that are unaware, Passenger works directly with Apache and requires almost no configuration. It is dead simple to use. So, within a matter of minutes (minus the time to tweak my database to conform to the Rails conventions) I had a web site up and running to display my data as I was testing it!

Open Source Software is becoming (for me at least) a more viable solution to the problems I face than the proprietary alternatives. The wealth of information available and the relative ease with which a great deal of work can be done is amazing.