#40741 [NEW]: when --with-mysql used, it also takes the lib/includes from /usr/local/mysql ..

[d dot huijbers at apollo-ict dot nl]

From: d dot huijbers at apollo-ict dot nl
Operating system: FreeBSD
PHP version: 5.2.1
PHP Bug Type: *Compile Issues
Bug description: when --with-mysql used, it also takes the lib/includes from /usr/local/mysql ..

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system which
also has mysql3.x.x installed in /usr/local/mysql. I installed mysql-5.1.x
into /usr/local/mysql5. Now, when I use --with-mysql=/usr/local/mysql5/ it
still compiles to the libs in /usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/


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

[tony2001@php.net]

ID: 40741
Updated by: [email]tony2001@php.net[/email]
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Open
+Status: Feedback
Bug Type: *Compile Issues
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)


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

[2007-03-06 18:53:59] d dot huijbers at apollo-ict dot nl

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system
which also has mysql3.x.x installed in /usr/local/mysql. I installed
mysql-5.1.x into /usr/local/mysql5. Now, when I use
--with-mysql=/usr/local/mysql5/ it still compiles to the libs in
/usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/



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


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

[d dot huijbers at apollo-ict dot nl]

ID: 40741
User updated by: d dot huijbers at apollo-ict dot nl
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Feedback
+Status: Open
Bug Type: *Compile Issues
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.


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

[2007-03-06 19:02:29] [email]tony2001@php.net[/email]

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)

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

[2007-03-06 18:53:59] d dot huijbers at apollo-ict dot nl

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system
which also has mysql3.x.x installed in /usr/local/mysql. I installed
mysql-5.1.x into /usr/local/mysql5. Now, when I use
--with-mysql=/usr/local/mysql5/ it still compiles to the libs in
/usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/



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


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

[tony2001@php.net]

ID: 40741
Updated by: [email]tony2001@php.net[/email]
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Open
+Status: Feedback
-Bug Type: *Compile Issues
+Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

ls -l /usr/local/mysql5/include/mysql.h


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

[2007-03-06 23:10:15] d dot huijbers at apollo-ict dot nl

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.

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

[2007-03-06 19:02:29] [email]tony2001@php.net[/email]

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)

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

[2007-03-06 18:53:59] d dot huijbers at apollo-ict dot nl

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system
which also has mysql3.x.x installed in /usr/local/mysql. I installed
mysql-5.1.x into /usr/local/mysql5. Now, when I use
--with-mysql=/usr/local/mysql5/ it still compiles to the libs in
/usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/



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


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

[d dot huijbers at apollo-ict dot nl]

ID: 40741
User updated by: d dot huijbers at apollo-ict dot nl
-Summary: when --with-mysql used, it also takes the lib/includes
from /usr/local/mysql ..
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

-rw-r--r-- 1 mysql wheel 33723 Mar 6 14:49 mysql.h


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

[2007-03-07 07:36:11] [email]tony2001@php.net[/email]

ls -l /usr/local/mysql5/include/mysql.h

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

[2007-03-06 23:10:15] d dot huijbers at apollo-ict dot nl

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.

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

[2007-03-06 19:02:29] [email]tony2001@php.net[/email]

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)

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

[2007-03-06 18:53:59] d dot huijbers at apollo-ict dot nl

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system
which also has mysql3.x.x installed in /usr/local/mysql. I installed
mysql-5.1.x into /usr/local/mysql5. Now, when I use
--with-mysql=/usr/local/mysql5/ it still compiles to the libs in
/usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/



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


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

[tony2001@php.net]

ID: 40741
Updated by: [email]tony2001@php.net[/email]
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

ldd ./sapi/cli/php ?


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

[2007-03-07 08:16:05] d dot huijbers at apollo-ict dot nl

-rw-r--r-- 1 mysql wheel 33723 Mar 6 14:49 mysql.h

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

[2007-03-07 07:36:11] [email]tony2001@php.net[/email]

ls -l /usr/local/mysql5/include/mysql.h

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

[2007-03-06 23:10:15] d dot huijbers at apollo-ict dot nl

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.

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

[2007-03-06 19:02:29] [email]tony2001@php.net[/email]

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)

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

[2007-03-06 18:53:59] d dot huijbers at apollo-ict dot nl

Description:
------------
I've been trying to compile php-5.2.1 with mysql 5.1.x on my system
which also has mysql3.x.x installed in /usr/local/mysql. I installed
mysql-5.1.x into /usr/local/mysql5. Now, when I use
--with-mysql=/usr/local/mysql5/ it still compiles to the libs in
/usr/local/mysql/lib/....

I fixed this for my compilation by renaming the /usr/local/mysql into
/usr/local/mysql3 for the compilation time.

Reproduce code:
---------------
../configure \
--disable-all \
--enable-safe-mode \
--with-apxs2=/usr/local/apache2/bin/apxs \
--prefix=/usr/local/apache2/php5 \
--with-config-file-path=/usr/local/apache2/php5 \
--enable-track-vars \
--enable-ftp \
--enable-pcre-regex=yes \
--with-pdf-lib \
--with-session \
--enable-session \
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-bz2 \
--with-xml \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
--enable-curlwrappers \
--enable-versioning \
--enable-xml \
--with-gd \
--with-ttf \
--with-xml-rpc \
--enable-libxml \
--with-dom \
--with-mcrypt \
--with-gettext \
--enable-exif \
--enable-bcmath \
--enable-calendar \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-kerberos \
--enable-mbstring \
--with-libmbfl \
--with-mcve \
--with-mhash \
--with-mime-magic \
--with-ncurses \
--enable-shmop \
--enable-dom \
--enable-libxml \
--enable-soap \
--enable-sockets \
--without-sqlite \
--enable-sysvmsg \
--enable-sysvmem \
--enable-sysvshm \
--with-iconv-dir \
--with-xsl \
--with-mysql=/usr/local/mysql5

Expected result:
----------------
Just a correct compilation of php-5.2.1 which is linked against
/usr/local/mysql5 (a mysql 5.1.x installation)

Actual result:
--------------
PHP compiled against my older mysql3 installation that is found in
/usr/local/mysql/



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


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

[d dot huijbers at apollo-ict dot nl]

ID: 40741
User updated by: d dot huijbers at apollo-ict dot nl
-Summary: Permissions of mysql.h
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

After a day compiling, I found out that when I renamed the directory
/usr/local/mysql to /usr/local/mysql3 and than used
--with-mysql=/usr/local/mysql5 (my other mysql installation) id worked.
Therefore I do not have a 'old' ./sapi/cli/php, but I'm quite sure it
linked against libmysqlclient.so.10 not libmysqlclient.so.15

-- LDD FOR WORKING VERSION --

ldd php
php:
libcrypt.so.2 => /lib/libcrypt.so.2 (0x284f5000)
libexslt.so.8 => /usr/local/lib/libexslt.so.8 (0x2850d000)
libz.so.2 => /lib/libz.so.2 (0x2851d000)
libm.so.3 => /lib/libm.so.3 (0x2852d000)
libpanel.so.2 => /usr/lib/libpanel.so.2 (0x28547000)
libncurses.so.5 => /lib/libncurses.so.5 (0x2854b000)
libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x2858a000)
libmcrypt.so.8 => /usr/local/lib/libmcrypt.so.8 (0x285be000)
libltdl.so.4 => /usr/local/lib/libltdl.so.4 (0x285ee000)
libintl.so.6 => /usr/local/lib/libintl.so.6 (0x285f6000)
libfreetype.so.9 => /usr/local/lib/libfreetype.so.9
(0x285ff000)
libpng.so.5 => /usr/local/lib/libpng.so.5 (0x28663000)
libbz2.so.1 => /usr/lib/libbz2.so.1 (0x28685000)
libcurl.so.4 => /usr/local/lib/libcurl.so.4 (0x28694000)
libssl.so.3 => /usr/lib/libssl.so.3 (0x286c8000)
libcrypto.so.3 => /lib/libcrypto.so.3 (0x286f6000)
libmysqlclient.so.15 =>
/usr/local/mysql5/lib/mysql/libmysqlclient.so.15 (0x287eb000)
libxslt.so.2 => /usr/local/lib/libxslt.so.2 (0x28848000)
libxml2.so.5 => /usr/local/lib/libxml2.so.5 (0x28879000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x28991000)
libc.so.5 => /lib/libc.so.5 (0x28a7e000)


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

[2007-03-07 08:28:05] [email]tony2001@php.net[/email]

ldd ./sapi/cli/php ?

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

[2007-03-07 08:16:05] d dot huijbers at apollo-ict dot nl

-rw-r--r-- 1 mysql wheel 33723 Mar 6 14:49 mysql.h

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

[2007-03-07 07:36:11] [email]tony2001@php.net[/email]

ls -l /usr/local/mysql5/include/mysql.h

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

[2007-03-06 23:10:15] d dot huijbers at apollo-ict dot nl

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.

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

[2007-03-06 19:02:29] [email]tony2001@php.net[/email]

These lines are incorrect:
--with-zlib-dir=/usr/include \
--with-freetype-dir=/usr/local/include/freetype2 \
--with-libxml-dir=/usr/local/include/libxml2 \
--with-curl=/usr/local/include/curl/ \
The values are supposed to be prefixes, i.e. /usr or /usr/local.

>--with-mysql=/usr/local/mysql5

Where did you install MySQL headers? (mysql.h particularly)

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

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
[url]http://bugs.php.net/40741[/url]

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

[tony2001@php.net]

ID: 40741
Updated by: [email]tony2001@php.net[/email]
Reported By: d dot huijbers at apollo-ict dot nl
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

Ah, so it DOES work when you fix the mess with MySQL libs.
Ok, then I don't see any sense to keep this report open.


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

[2007-03-07 08:53:22] d dot huijbers at apollo-ict dot nl

After a day compiling, I found out that when I renamed the directory
/usr/local/mysql to /usr/local/mysql3 and than used
--with-mysql=/usr/local/mysql5 (my other mysql installation) id worked.
Therefore I do not have a 'old' ./sapi/cli/php, but I'm quite sure it
linked against libmysqlclient.so.10 not libmysqlclient.so.15

-- LDD FOR WORKING VERSION --

ldd php
php:
libcrypt.so.2 => /lib/libcrypt.so.2 (0x284f5000)
libexslt.so.8 => /usr/local/lib/libexslt.so.8 (0x2850d000)
libz.so.2 => /lib/libz.so.2 (0x2851d000)
libm.so.3 => /lib/libm.so.3 (0x2852d000)
libpanel.so.2 => /usr/lib/libpanel.so.2 (0x28547000)
libncurses.so.5 => /lib/libncurses.so.5 (0x2854b000)
libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x2858a000)
libmcrypt.so.8 => /usr/local/lib/libmcrypt.so.8 (0x285be000)
libltdl.so.4 => /usr/local/lib/libltdl.so.4 (0x285ee000)
libintl.so.6 => /usr/local/lib/libintl.so.6 (0x285f6000)
libfreetype.so.9 => /usr/local/lib/libfreetype.so.9
(0x285ff000)
libpng.so.5 => /usr/local/lib/libpng.so.5 (0x28663000)
libbz2.so.1 => /usr/lib/libbz2.so.1 (0x28685000)
libcurl.so.4 => /usr/local/lib/libcurl.so.4 (0x28694000)
libssl.so.3 => /usr/lib/libssl.so.3 (0x286c8000)
libcrypto.so.3 => /lib/libcrypto.so.3 (0x286f6000)
libmysqlclient.so.15 =>
/usr/local/mysql5/lib/mysql/libmysqlclient.so.15 (0x287eb000)
libxslt.so.2 => /usr/local/lib/libxslt.so.2 (0x28848000)
libxml2.so.5 => /usr/local/lib/libxml2.so.5 (0x28879000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x28991000)
libc.so.5 => /lib/libc.so.5 (0x28a7e000)

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

[2007-03-07 08:28:05] [email]tony2001@php.net[/email]

ldd ./sapi/cli/php ?

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

[2007-03-07 08:16:05] d dot huijbers at apollo-ict dot nl

-rw-r--r-- 1 mysql wheel 33723 Mar 6 14:49 mysql.h

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

[2007-03-07 07:36:11] [email]tony2001@php.net[/email]

ls -l /usr/local/mysql5/include/mysql.h

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

[2007-03-06 23:10:15] d dot huijbers at apollo-ict dot nl

I installed the mysql.h into both /usr/local/mysql/include/... for
mysql 3.x and for mysql 5.x into /usr/local/mysql5/include/

gr.

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

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
[url]http://bugs.php.net/40741[/url]

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

[d dot huijbers at apollo-ict dot nl]

ID: 40741
User updated by: d dot huijbers at apollo-ict dot nl
-Summary: ldd ./sapi/cli/php
Reported By: d dot huijbers at apollo-ict dot nl
Status: Bogus
Bug Type: MySQL related
Operating System: FreeBSD
PHP Version: 5.2.1
New Comment:

Well I do think it's important that when one specifies
--with-mysql=/path/to/mysql/to/be/used those libs are actually used and
not another lib as is the case now.


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

[2007-03-07 09:06:04] [email]tony2001@php.net[/email]

Ah, so it DOES work when you fix the mess with MySQL libs.
Ok, then I don't see any sense to keep this report open.

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

[2007-03-07 08:53:22] d dot huijbers at apollo-ict dot nl

After a day compiling, I found out that when I renamed the directory
/usr/local/mysql to /usr/local/mysql3 and than used
--with-mysql=/usr/local/mysql5 (my other mysql installation) id worked.
Therefore I do not have a 'old' ./sapi/cli/php, but I'm quite sure it
linked against libmysqlclient.so.10 not libmysqlclient.so.15

-- LDD FOR WORKING VERSION --

ldd php
php:
libcrypt.so.2 => /lib/libcrypt.so.2 (0x284f5000)
libexslt.so.8 => /usr/local/lib/libexslt.so.8 (0x2850d000)
libz.so.2 => /lib/libz.so.2 (0x2851d000)
libm.so.3 => /lib/libm.so.3 (0x2852d000)
libpanel.so.2 => /usr/lib/libpanel.so.2 (0x28547000)
libncurses.so.5 => /lib/libncurses.so.5 (0x2854b000)
libmhash.so.2 => /usr/local/lib/libmhash.so.2 (0x2858a000)
libmcrypt.so.8 => /usr/local/lib/libmcrypt.so.8 (0x285be000)
libltdl.so.4 => /usr/local/lib/libltdl.so.4 (0x285ee000)
libintl.so.6 => /usr/local/lib/libintl.so.6 (0x285f6000)
libfreetype.so.9 => /usr/local/lib/libfreetype.so.9
(0x285ff000)
libpng.so.5 => /usr/local/lib/libpng.so.5 (0x28663000)
libbz2.so.1 => /usr/lib/libbz2.so.1 (0x28685000)
libcurl.so.4 => /usr/local/lib/libcurl.so.4 (0x28694000)
libssl.so.3 => /usr/lib/libssl.so.3 (0x286c8000)
libcrypto.so.3 => /lib/libcrypto.so.3 (0x286f6000)
libmysqlclient.so.15 =>
/usr/local/mysql5/lib/mysql/libmysqlclient.so.15 (0x287eb000)
libxslt.so.2 => /usr/local/lib/libxslt.so.2 (0x28848000)
libxml2.so.5 => /usr/local/lib/libxml2.so.5 (0x28879000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x28991000)
libc.so.5 => /lib/libc.so.5 (0x28a7e000)

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

[2007-03-07 08:28:05] [email]tony2001@php.net[/email]

ldd ./sapi/cli/php ?

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

[2007-03-07 08:16:05] d dot huijbers at apollo-ict dot nl

-rw-r--r-- 1 mysql wheel 33723 Mar 6 14:49 mysql.h

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

[2007-03-07 07:36:11] [email]tony2001@php.net[/email]

ls -l /usr/local/mysql5/include/mysql.h

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

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
[url]http://bugs.php.net/40741[/url]

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