Ruby on Rails with Mongrel Clusters Connecting to Oracle Database

Note:
First disable selinux.
to check the config edit "/etc/sysconfig/selinux", if you made changes reboot the system.

Install the dependencies:

Development Libraries:
$ yum -v groupinstall "Development Libraries"
$ yum -v groupinstall "Development Tools"

Zlib:
$ yum install zlib zlib-devel

Readline:
$ yum install readline-devel

Freeimage:
$ wget http://nchc.dl.sourceforge.net/sourceforge/freeimage/FreeImage3120.zip
$ unzip FreeImage3120.zip
$ make
$ make install

1. Download and install Ruby 1.8.6 patch 111

Ruby download site : http://www.ruby-lang.org/en/downloads/

$ wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.6-p111.tar.gz
$ tar xzvf ruby-1.8.6-p111.tar.gz
$ cd ruby-1.8.6-p111
$ ./configure
$ make
$ make install

Try checking the version if the installation goes well

$ ruby -v

Output:
ruby 1.8.6 (2007-09-24 patchlevel 111) [i686-linux]

2. Download and install Gem 1.0.1

$ wget http://rubyforge.org/frs/download.php/29548/rubygems-1.0.1.tgz
$ tar xzvf rubygems-1.0.1.tgz
$ cd rubygems-1.0.1
$ ruby setup.rb

Do a version check again
$ gem -v

Output:
1.0.1

Install Rails 2.0.2 using the following command:

$ gem install rails -v 2.0.2 - (this would take time to install, in my test pc PentIII it took more than 2hrs)

3. Register to Oracle and download the following Oracle clients:

oracle-instantclient-basic-10.2.0.3-1.i386.rpm
oracle-instantclient-basic-10.2.0.3-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

$ rpm -ivh oracle-instantclient-basic-10.2.0.3-1.i386.rpm
$ rpm -ivh oracle-instantclient-basic-10.2.0.3-1.i386.rpm
$ rpm -ivh oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm

* run and add this in the /etc/profile

$ LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib
$ export LD_LIBRARY_PATH

5. Download and install Ruby-OCI8

Download from http://rubyforge.org/frs/download.php/28396/ruby-oci8-1.0.0.tar.gz
Uncompress and extract the file contents.
Execute the following from within the extracted directory:

ruby setup.rb

* (Rails installation has to be finished before this) Copy the Oracle Adapter to the correct directory:

cp /path/to/oracle_adapter.rb /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/ (directory might be different on different installations, just search for active_record/connection_adapters)

6. Install other Ruby gems:

$ gem install mongrel
$ gem install mongrel_cluster
$ gem install ruby-debug
$ gem install soap4r -v 1.5.7
$ gem install image_science

7. Install apache using yum.

$ yum install httpd

* Configure Apache. Your httpd.conf needs a configuration like that of below:

<Proxy balancer://test>
BalancerMember http://127.0.0.1:3000
BalancerMember http://127.0.0.1:3001
BalancerMember http://127.0.0.1:3002
</Proxy>
<VirtualHost *:80>
ServerAdmin testaccount@gmail.com
ServerName test.com
ServerAlias test
ProxyPass / balancer://test/
ProxyPassReverse / balancer://test/
ErrorLog /var/log/apache_error_log
CustomLog /var/log/apache_access_log combined
</VirtualHost>

* replace test and testaccount base on your server details

Comments

Post a Comment

Popular posts from this blog

Scraping an Entire Website using LINUX

Web scraping (also called Web harvesting or Web data extraction) is a computer software technique of extracting information from websites. Usually, such software programs simulate human exploration of the Web by either implementing low-level Hypertext Transfer Protocol (HTTP), or embedding certain full-fledged Web browsers, such as the Internet Explorer (IE) and the Mozilla Web browser. Web scraping is closely related to Web indexing, which indexes Web content using a bot and is a universal technique adopted by most search engines. In contrast, Web scraping focuses more on the transformation of unstructured Web content, typically in HTML format, into structured data that can be stored and analyzed in a central local database or spreadsheet. Web scraping is also related to Web automation, which simulates human Web browsing using computer software. Exemplary uses of Web scraping include online price comparison, weather data monitoring, website change detection, Web research, Web content ...
Read more

Linux OS Backup and Recovery

Image
Source :http://relax-and-recover.org/documentation/getting-started This quick start guide will show you how to run Relax-and-Recover from the git checkout and create a bootable USB backup. Start by cloning the Relax-and-Recover sources from Github: git clone https://github.com/rear/rear.git Move into the rear/ directory: cd rear/ Prepare your USB media. Change /dev/sdb to the correct device in your situation. Relax-and-Recover will ‘own’ the device in this example. This will destroy all data on that device. sudo usr/sbin/rear format /dev/sdb Relax-and-recover asks you to confirm that you want to format the device: Yes The device has been labeled REAR-000 by the ‘format’ workflow. Now edit the ‘etc/rear/local.conf’ configuration file: cat > etc/rear/local.conf < Now you are ready to create a rescue image. We want verbose output. sudo usr/sbin/rear -v mkrescue The output I get is: Relax-and-Recover 1.13.0 / $Date$ Using log file: /home/jeroen/tmp/...
Read more

Radiator Radius Installation connecting to ORACLE (CentOS)

1. Download and install the Oracle client connectors. http://www.oracle.com/index.html oracle-instantclient-basic-10.2.0.3-1.i386.rpm oracle-instantclient-devel-10.2.0.3-1.i386.rpm oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm rpm -Uvh oracle-instantclient-basic-10.2.0.3-1.i386.rpm rpm -Uvh oracle-instantclient-devel-10.2.0.3-1.i386.rpm rpm -Uvh oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm 2. Set the environment variables. # ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib # export ORACLE_HOME # export LD_LIBRARY_PATH=$ORACLE_HOME # TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin # export TNS_ADMIN # mkdir /usr/lib/oracle/10.2.0.3/client/admin 3. Edit /etc/profiles and insert the lines below. ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client/lib export ORACLE_HOME export LD_LIBRARY_PATH=$ORACLE_HOME TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/admin export TNS_ADMIN 4. Create a file "tnsnames.ora" and insert the settings below. SERVER1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ...
Read more