Installing Mongrel with Ruby 1.9

Installing mongrel on ruby 1.9 has caused problems for many different people as has been reported on isitruby19.com.

Running gem install mongrel produces the following error.

http11.c: In function ‘http_field’:
http11.c:77: error: ‘struct RString’ has no member named ‘ptr’
http11.c:77: error: ‘struct RString’ has no member named ‘len’
http11.c:77: warning: left-hand operand of comma expression has no effect
http11.c: In function ‘header_done’:
http11.c:172: error: ‘struct RString’ has no member named ‘ptr’
http11.c:174: error: ‘struct RString’ has no member named ‘ptr’
http11.c:176: error: ‘struct RString’ has no member named ‘ptr’
http11.c:177: error: ‘struct RString’ has no member named ‘len’
http11.c: In function ‘HttpParser_execute’:
http11.c:298: error: ‘struct RString’ has no member named ‘ptr’
http11.c:299: error: ‘struct RString’ has no member named ‘len’
make: *** [http11.o] Error 1

To install mongrel after receiving this error, just follow these steps: Read the rest of this entry »

Installing MySQL gem for Ruby 1.9.x

As of this writing, the MYSQL gem cannot be installed by simply doing a GEM INSTALL with ruby 1.9.1. In order to install the gem, follow these easy steps.

First download the mysql gem from rubyforge, and unzip it:

sudo wget https://rubyforge.org/frs/download.php/51087/mysql-ruby-2.8.1.tar.gz

 sudo tar -xzvf mysql-ruby-2.8.1.tar.gz

 cd mysql-ruby-2.8.1

Read the rest of this entry »

Replace Ruby 1.8.x with version 1.9.x

We recently replaced ruby 1.8.6 on a Ubuntu 8.04 Server with Ruby 1.9.1. Follow these steps to remove the old ruby from the system, but be warned that it may not be as simple for you.

First thing was to remove the old ruby1.8. We had installed this from the Ubuntu package installer so removing it was as simple as running:

sudo apt-get uninstall ruby

or

sudo apt-get uninstall ruby1.8

Read the rest of this entry »

ODBC.ini update did not work

After running the same database for quite some time for a rails application, we finally had to change the database in odbc.ini to point to the new server. Alas we changed the odbc.ini file, shut down the old database and relaunched the application. Expecting the application to immediately start talking to the database on reboot (since we just changed an IP) we were surprised to find that the application was not connecting to the database anymore.

The rails application was connecting to SQL Server as detailed in this previous post using ODBC and FreeTDS.
Read the rest of this entry »

Rails and Microsoft Sql Server

So you want to connect your rails application to Microsoft SQL Server. The following instructions will take you through setting this up quite simply. This setup is on a a Ubuntu 8.04 server connecting to SQL Server 2000 (we will use the Northwind sample database). The first thing you need to do is install the following gems:

$ gem install dbi --version 0.4.0
$ gem install dbd-odbc --version 0.2.4
$ gem install rails-sqlserver-2000-2005-adapter -s https://gems.github.com

More info can be found on the sqlserver adapter gem development page. This is just the first step. Read the rest of this entry »