Php with oracle and sqlrelay Print E-mail
Written by Administrator   
Tuesday, 23 January 2007

1. You will need:

This both files you can donwload from oracle.com 

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

oracle-instantclient-devel-10.2.0.3-1.i386.rpm 

 Php source code (php 5.2.0)

php-5.2.0.tar.gz

rudiments-0.30.tar.gz
sqlrelay-0.38.tar.gz

 2. Install the Oracle instantclient

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

rpm -ivh oracle-instantclient-devel-10.2.0.3-1.i386.rpm

3. Install rudiments

 rpmbuild -ta ./rudiments-0.30.tar.gz
rpm -ivh /usr/src/redhat/RPMS/i386/rudiments-*

4. Rebuild your php with oracle support

tar -xzvf php-5.2.0

cd php 5-2.0

Type: php --info |more and copy your configure options

./configure "your configure options --with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib"

(my example ./configure --with-apxs2=/usr/sbin/apxs --build=i686-redhat-linux-gnu --host=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --cache-file=../config.cache --with-config-file-path=/etc --with-config-file-scan-dir=/etc/php.d --enable-force-cgi-redirect --disable-debug--enable-pic--disable-rpath --enable-inline-optimization --with-bz2 --with-db4=/usr--with-curl --with-exec-dir=/usr/bin --with-png-dir=/usr --with-gd --enable-gd-native-ttf --without-gdbm --with-gettext --with-ncurses=shared --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-xml --with-expat-dir=/usr --with-dom=shared,/usr --with-dom-xslt=/usr --with-dom-exslt=/usr --with-xmlrpc=shared --with-pcre-regex --with-zlib --with-layout=GNU--enable-bcmath --enable-exif --enable-ftp --enable-magic-quotes --enable-sockets--enable-sysvsem --enable-sysvshm --enable-track-vars --enable-trans-sid --enable-yp--enable-wddx --with-pear=/usr/share/pear --with-kerberos--with-ldap=shared --with-mysql --enable-ucd-snmp-hack --enable-memory-limit --enable-shmop --enable-calendar --enable-dbx --enable-dio--enable-mbstring=shared --enable-mbstr-enc-trans --enable-mbregex--with-mime-magic=/usr/share/file/magic.mime --enable-force-cgi-redirect --enable-pcntl --with-oci8=instantclient,/usr/lib/oracle/10.2.0.3/client/lib)

make && make install 

5. Install sqlrelay

./configure --disable-postgresql --prefix=/usr

Be sure, that it found php-config file, if not, you will need to do ln -s /path/to/phpconfig/php-config /usr/bin/ 

make && make install 

6. Edit php.ini and restart apache

Now you need to add sql_relay extension to your php config file

open php.ini in your favourite editor

and add

extension=sql_relay.so

also be sure, that you have property configured the extension_dir directive, the best option is comment it out. 

Now restart your apache and see if is all working

That´s all :-) 


Add as favourites (53) | Quote this article on your site | Views: 658

Be first to comment this article
RSS comments

Write Comment
  • Please keep the topic of messages relevant to the subject of the article.
  • Personal verbal attacks will be deleted.
  • Please don't use comments to plug your web site. Such material will be removed.
  • Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button.
  • Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
E-mail
Homepage
Title:
BBCode:Web AddressEmail AddressLoad Image from WebBold TextItalic TextUnderlined TextQuoteCodeOpen ListList ItemClose List
Comment:



Code:* Code
I wish to be contacted by email regarding additional comments

Powered by AkoComment Tweaked Special Edition v.1.4.5

Last Updated ( Tuesday, 23 January 2007 )
 
< Prev   Next >
Main Menu
Home
Our Services
Contact Us
Search
News Feeds
Our offers
Linux Tutorials
Affiliate program
Links
CarTube.co.cc
PetTube.co.cc
Slick RSS
GetAFreelancer.com New Projects
Latest projects published at GetAFreelancer.com
ScriptLance Projects
The newest projects posted on ScriptLance.
Google AdSense
Last comments
Howto install memcached, setup...
Thanks! :)
08/05/08 09:38 More...
By Jupp

Howto install memcached, setup...
wery good site
26/01/08 12:18 More...
By u26stycznia2008

Script installation Services
Comment 13 2008
Helo1l, great site!
13/10/07 10:10 More...
By John 200809

Visitors Counter
73769 Visitors
Joomla Template by Joomlashack
components joomla modules Joomla Templates Joomla tutorials