#40471 [NEW]: PHP 5.2.1 failed to be compiled with MySQl 5.0.33, MySQL 5.0.27, MySQL 5.1.15

[pcdinh at gmail dot com]

From: pcdinh at gmail dot com
Operating system: CentOS 4.4
PHP version: 5.2.1
PHP Bug Type: Compile Failure
Bug description: PHP 5.2.1 failed to be compiled with MySQl 5.0.33, MySQL 5.0.27, MySQL 5.1.15

Description:
------------
I can not configure to build PHP 5.2.1 with MySQL 5 on CentOS 4.4. PHP can
not find mysql_config that really exists.

User account used to build: root

Reproduce code:
---------------
MySQL (5.0.27/5.0.33/5.1.15) builds:

../configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--libexecdir=/usr/local/mysql/bin \
--libdir=/usr/local/mysql/lib \
--with-server-suffix=-max \
--enable-thread-safe-client \
--enable-local-infile \
--enable-shared \
--enable-assembler \
--with-vio \
--with-libwrap \
--with-zlib-dir=bundled \
--with-big-tables \
--with-readline \
--with-archive-storage-engine \
--with-innodb \
--with-blackhole-storage-engine \
--with-csv-storage-engine \
--with-federated-storage-engine \
--without-embedded-server \
--without-berkeley-db \
--with-ndbcluster \
--with-ndb-docs \
--with-partition \
--without-docs \
--without-bench \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-extra-charsets=all \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql

Built successfully and MySQL running


PHP built:

../configure --prefix=/usr/local/php \
--disable-cgi \
--with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--with-libxml-dir=/usr/local/lib \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-curl \
--with-curlwrappers \
--with-pdo-mysql \
--with-pdo-oci=instantclient,/usr/local/instantclient_10_2,10.2.0.3 \
--with-pdo-sqlite \
--with-oci8=instantclient,/usr/local/instantclient_10_2 \
--with-iconv \
--with-gd \
--with-png-dir=/usr/lib \
--with-jpeg-dir=/usr/lib \
--with-ttf \
--with-freetype-dir=/usr/include/freetype2 \
--with-dom=shared \
--with-dom-xslt=shared \
--with-dom-exslt=shared \
--with-xpm-dir \
--with-openssl \
--with-xml \
--with-zlib \
--with-bz2 \
--with-xmlrpc \
--with-mcrypt \
--with-tidy \
--with-mime-magic \
--without-pear \
--enable-dom \
--enable-png \
--enable-jpeg \
--enable-track-vars \
--enable-memory-limit \
--enable-memcache \
--enable-calendar \
--enable-sysvsem \
--enable-sysvshm \
--enable-bcmath \
--enable-ctype \
--enable-exif \
--enable-ftp \
--enable-sockets \
--enable-shmop \
--enable-wddx \
--enable-gd-native-ttf \
--enable-mbstring \
--enable-path-info \
--enable-inline-optimization \
--enable-debug=no \
--enable-mbregex \
--disable-magic-quotes \
--enable-zip \
--enable-spl \
--enable-libxml \
--enable-simplexml \
--enable-soap \
--enable-sigchild \
--disable-static

Error:

checking for MySQL support for PDO... yes
checking for mysql_config... not found
configure: error: Cannot find MySQL header files under

Screenshot:

[url]http://www.flickr.com/photos/pcdinh/389717146/[/url]

Config log:
[url]http://download.yousendit.com/63F59D0C1AA53E21[/url]

Expected result:
----------------
Be configured successfully.

mysql_config really exists. I have configured MySQL build with
--libexecdir=/usr/local/mysql/bin and have set /usr/local/mysql/bin into
the PATH variable



Actual result:
--------------
Failed to build

--
Edit bug report at [url]http://bugs.php.net/?id=40471&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=40471&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=40471&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=40471&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=40471&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=40471&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=40471&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=40471&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=40471&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=40471&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=40471&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=40471&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=40471&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=40471&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=40471&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=40471&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=40471&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=40471&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=40471&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=40471&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=40471&r=mysqlcfg[/url]

[pcdinh at gmail dot com]

ID: 40471
User updated by: pcdinh at gmail dot com
Reported By: pcdinh at gmail dot com
Status: Open
Bug Type: Compile Failure
Operating System: CentOS 4.4
PHP Version: 5.2.1
New Comment:

Hi,

I just found out why PHP 5.2.1 final refused to build

+ PHP 5.2.1 Rc4 does not require me to specify --with-pdo-mysql with
MySQL path
+ But PHP 5.2.1 final requires it

So I need to add --with-pdo-mysql=/usr/local/mysql


Previous Comments:
------------------------------------------------------------------------

[2007-02-14 02:49:29] pcdinh at gmail dot com

Description:
------------
I can not configure to build PHP 5.2.1 with MySQL 5 on CentOS 4.4. PHP
can not find mysql_config that really exists.

User account used to build: root

Reproduce code:
---------------
MySQL (5.0.27/5.0.33/5.1.15) builds:

../configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--libexecdir=/usr/local/mysql/bin \
--libdir=/usr/local/mysql/lib \
--with-server-suffix=-max \
--enable-thread-safe-client \
--enable-local-infile \
--enable-shared \
--enable-assembler \
--with-vio \
--with-libwrap \
--with-zlib-dir=bundled \
--with-big-tables \
--with-readline \
--with-archive-storage-engine \
--with-innodb \
--with-blackhole-storage-engine \
--with-csv-storage-engine \
--with-federated-storage-engine \
--without-embedded-server \
--without-berkeley-db \
--with-ndbcluster \
--with-ndb-docs \
--with-partition \
--without-docs \
--without-bench \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-extra-charsets=all \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql

Built successfully and MySQL running


PHP built:

../configure --prefix=/usr/local/php \
--disable-cgi \
--with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--with-libxml-dir=/usr/local/lib \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-curl \
--with-curlwrappers \
--with-pdo-mysql \
--with-pdo-oci=instantclient,/usr/local/instantclient_10_2,10.2.0.3 \
--with-pdo-sqlite \
--with-oci8=instantclient,/usr/local/instantclient_10_2 \
--with-iconv \
--with-gd \
--with-png-dir=/usr/lib \
--with-jpeg-dir=/usr/lib \
--with-ttf \
--with-freetype-dir=/usr/include/freetype2 \
--with-dom=shared \
--with-dom-xslt=shared \
--with-dom-exslt=shared \
--with-xpm-dir \
--with-openssl \
--with-xml \
--with-zlib \
--with-bz2 \
--with-xmlrpc \
--with-mcrypt \
--with-tidy \
--with-mime-magic \
--without-pear \
--enable-dom \
--enable-png \
--enable-jpeg \
--enable-track-vars \
--enable-memory-limit \
--enable-memcache \
--enable-calendar \
--enable-sysvsem \
--enable-sysvshm \
--enable-bcmath \
--enable-ctype \
--enable-exif \
--enable-ftp \
--enable-sockets \
--enable-shmop \
--enable-wddx \
--enable-gd-native-ttf \
--enable-mbstring \
--enable-path-info \
--enable-inline-optimization \
--enable-debug=no \
--enable-mbregex \
--disable-magic-quotes \
--enable-zip \
--enable-spl \
--enable-libxml \
--enable-simplexml \
--enable-soap \
--enable-sigchild \
--disable-static

Error:

checking for MySQL support for PDO... yes
checking for mysql_config... not found
configure: error: Cannot find MySQL header files under

Screenshot:

[url]http://www.flickr.com/photos/pcdinh/389717146/[/url]

Config log:
[url]http://download.yousendit.com/63F59D0C1AA53E21[/url]

Expected result:
----------------
Be configured successfully.

mysql_config really exists. I have configured MySQL build with
--libexecdir=/usr/local/mysql/bin and have set /usr/local/mysql/bin
into the PATH variable



Actual result:
--------------
Failed to build


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40471&edit=1[/url]

[tony2001@php.net]

ID: 40471
Updated by: [email]tony2001@php.net[/email]
Reported By: pcdinh at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: Compile Failure
Operating System: CentOS 4.4
PHP Version: 5.2.1
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.




Previous Comments:
------------------------------------------------------------------------

[2007-02-14 03:40:44] pcdinh at gmail dot com

Hi,

I just found out why PHP 5.2.1 final refused to build

+ PHP 5.2.1 Rc4 does not require me to specify --with-pdo-mysql with
MySQL path
+ But PHP 5.2.1 final requires it

So I need to add --with-pdo-mysql=/usr/local/mysql

------------------------------------------------------------------------

[2007-02-14 02:49:29] pcdinh at gmail dot com

Description:
------------
I can not configure to build PHP 5.2.1 with MySQL 5 on CentOS 4.4. PHP
can not find mysql_config that really exists.

User account used to build: root

Reproduce code:
---------------
MySQL (5.0.27/5.0.33/5.1.15) builds:

../configure --prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--libexecdir=/usr/local/mysql/bin \
--libdir=/usr/local/mysql/lib \
--with-server-suffix=-max \
--enable-thread-safe-client \
--enable-local-infile \
--enable-shared \
--enable-assembler \
--with-vio \
--with-libwrap \
--with-zlib-dir=bundled \
--with-big-tables \
--with-readline \
--with-archive-storage-engine \
--with-innodb \
--with-blackhole-storage-engine \
--with-csv-storage-engine \
--with-federated-storage-engine \
--without-embedded-server \
--without-berkeley-db \
--with-ndbcluster \
--with-ndb-docs \
--with-partition \
--without-docs \
--without-bench \
--with-charset=utf8 \
--with-collation=utf8_general_ci \
--with-extra-charsets=all \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql

Built successfully and MySQL running


PHP built:

../configure --prefix=/usr/local/php \
--disable-cgi \
--with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--with-libxml-dir=/usr/local/lib \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-curl \
--with-curlwrappers \
--with-pdo-mysql \
--with-pdo-oci=instantclient,/usr/local/instantclient_10_2,10.2.0.3 \
--with-pdo-sqlite \
--with-oci8=instantclient,/usr/local/instantclient_10_2 \
--with-iconv \
--with-gd \
--with-png-dir=/usr/lib \
--with-jpeg-dir=/usr/lib \
--with-ttf \
--with-freetype-dir=/usr/include/freetype2 \
--with-dom=shared \
--with-dom-xslt=shared \
--with-dom-exslt=shared \
--with-xpm-dir \
--with-openssl \
--with-xml \
--with-zlib \
--with-bz2 \
--with-xmlrpc \
--with-mcrypt \
--with-tidy \
--with-mime-magic \
--without-pear \
--enable-dom \
--enable-png \
--enable-jpeg \
--enable-track-vars \
--enable-memory-limit \
--enable-memcache \
--enable-calendar \
--enable-sysvsem \
--enable-sysvshm \
--enable-bcmath \
--enable-ctype \
--enable-exif \
--enable-ftp \
--enable-sockets \
--enable-shmop \
--enable-wddx \
--enable-gd-native-ttf \
--enable-mbstring \
--enable-path-info \
--enable-inline-optimization \
--enable-debug=no \
--enable-mbregex \
--disable-magic-quotes \
--enable-zip \
--enable-spl \
--enable-libxml \
--enable-simplexml \
--enable-soap \
--enable-sigchild \
--disable-static

Error:

checking for MySQL support for PDO... yes
checking for mysql_config... not found
configure: error: Cannot find MySQL header files under

Screenshot:

[url]http://www.flickr.com/photos/pcdinh/389717146/[/url]

Config log:
[url]http://download.yousendit.com/63F59D0C1AA53E21[/url]

Expected result:
----------------
Be configured successfully.

mysql_config really exists. I have configured MySQL build with
--libexecdir=/usr/local/mysql/bin and have set /usr/local/mysql/bin
into the PATH variable



Actual result:
--------------
Failed to build


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40471&edit=1[/url]