unixODBC and PHP

[kpate]

How do I compile php with unixODBC using /scripts/easyapache?

cPanel.net Support Ticket Number:

[ciphervendor]

Download & compile unixODBC:

cd /usr/local/src/
wget http://unc.dl.sourceforge.net/source...-2.0.11.tar.gz
tar zxf unixODBC-2.0.11.tar.gz
cd unixODBC-2.0.11
./configure --prefix=/usr/local/unixODBC 
make 
make install

You may have to fulfill dependancies before the above will compile. Check to make sure you have QT compiled on your box; if not:

cd /usr/local/src/
wget ftp://ftp.trolltech.com/qt/source/qt...e-3.1.2.tar.gz
tar zxf qt-x11-free-3.1.2.tar.gz
cd qt-x11-free-3.1.2
./configure
make
make install

Once you've got all of the above compiled, you will need to go to the PHP source directory within the buildapache directory:

cd /home/cpapachebuild/buildapache/php-4.3.2
make distclean
./configure --with-apxs=/usr/local/apache/bin/apxs --with-xml --enable-bcmath --enable-calendar --with-curl --with-swf=/usr/local/flash --enable-ftp --with-gd --with-jpeg-dir=/usr/local --with-png-dir=/usr --with-xpm-dir=/usr/X11R6 --with-imap --with-imap-ssl --with-kerberos --enable-mbstring --enable-mbstr-enc-trans --enable-mbregex --with-mcrypt --with-ming=../ming-0.2a --enable-magic-quotes --with-mysql=/usr --with-pear --enable-sockets --enable-track-vars --with-ttf --with-freetype-dir=/usr --enable-gd-native-ttf --enable-versioning --with-zlib --with-unixODBC
make
make install

If all went well the PHP compile should exit without error and then you need to restart Apache.

service httpd restart

Good luck. As always, no warranties and be sure to backup your configs first.

cPanel.net Support Ticket Number: