Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Compiling PHP 5.1.6 with PDO MySQL

I originally asked this question on ServerFault and haven't got any response and I figure it's programming related so, here goes...


A while ago a large client of ours moved to a single hosting provider who spec'd out a software environment which would be consistent accross all the live servers.

Amongs other things this includes Apache 2.2.8 and PHP 5.1.6.

We had an ubuntu 8.04 server for development and these versions of Apache and PHP are not the default installed. So I had to compile them from source. These versions have happily been running for over a year now.

We're starting a new site build and we want to use ZendFrameword which requires PDO_MySQL.

I've tried recompiling with the following... (underscore shows continuation of line)

./configure --with-apxs2=/usr/local/apache2/bin/apxs _
--with-config-file-path=/user/local/apache2/conf/php.ini _
--with-curl=/usr/lib/ --with-mysql=shared --with-mysqli=shared _
--with-zlib --with-gd --with-jpeg-dir=/usr/local/lib/ _
--with-freetype-dir=/usr/lib/ --enable-soap --enable-pdo=shared _
--with-pdo-mysql=shared --with-sqlite=shared
...
make
...
make install
...
libtool --finish /sources/php-5.1.6/libs

Which all works fine, and when I bring apache back up, it shows me the new ./configure in the phpinfo().

After doing this MySQL stops working, the MYSQL section disappears and msyql stops working.

The make, make install, libtool... puts the *.so files in

/usr/local/lib/php/extensions/no-debug-non-zts-20050922

The configure I have used previously which enabled MySQL but not PDO is

./configure --with-apxs2=/usr/local/apache2/bin/apxs _
--with-config-file-path=/user/local/apache2/conf/php.ini _
--with-curl=/usr/lib/ --with-mysql --with-mysqli _
--with-zlib --with-gd --with-jpeg-dir=/usr/local/lib/ _
--with-freetype-dir=/usr/lib/ --enable-soap

I'm not a massive *nix person, can anyone tell me where I'm going wrong.

Thanks

like image 948
Greg B Avatar asked May 27 '26 12:05

Greg B


1 Answers

I am not sure it will really help, but what if you remove every instance of "=shared" in your configure line ?

For example, here is an configure command I've used some time ago *(as given by phpinfo)* :

$ /usr/local/php-5.1.6/bin/php -i | grep 'configure'
Configure Command =>  './configure' '--prefix=/usr/local/php-5.1.6' '--with-config-file-path=/etc/php-5.1.6' 
  '--with-apxs2=/usr/bin/apxs2' '--disable-ipv6' '--with-openssl' '--with-zlib' '--enable-bcmath' 
  '--with-bz2' '--with-curl' '--enable-exif' '--enable-ftp' '--with-gd' '--with-ttf' 
  '--enable-gd-native-ttf' '--with-imap-ssl' '--with-ldap' '--enable-mbstring' '--with-mcrypt' 
  '--with-mhash' '--with-mysql' '--with-mysqli' '--enable-pcntl' '--with-pdo-mysql' '--with-pdo-sqlite' 
  '--enable-shmop' '--enable-soap' '--enable-sockets' '--enable-sqlite-utf8' '--with-xmlrpc' 
  '--with-xsl' '--with-pear'

(newlines added for the sake of readability)

Does it help ?

like image 177
Pascal MARTIN Avatar answered May 30 '26 06:05

Pascal MARTIN



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!