#48715 [Opn->Fbk]: Configure php with mysql result "configure: error: mysql configure failed"

 ID:               48715
 Updated by:       [email protected]
 Reported By:      amiroot at yahoo dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQL related
 Operating System: RedHat EL5 64bit
 PHP Version:      5.2.10 / 5.3 CVS
 New Comment:

And did you try adding the obvious I omitted? (--with-zlib-dir..) 
I find it kinda hard to believe this would be any PHP bug since the 
config.m4 in ext/mysql has not changed between 5.2.9 and 5.2.10.


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

[2009-06-29 12:04:12] amiroot at yahoo dot com

Here you go~

checking for mysql_close in -lmysqlclient... no
checking for mysql_errno in -lmysqlclient... no
configure: error: Try adding --with-zlib-dir=<DIR>. Please check
config.log for more information.

The same "cannot find -lmysqlclient" error appear in config.log

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

[2009-06-29 11:57:24] [email protected]

Try this instead:

# rm config.cache
# ./configure --disable-all --with-mysql

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

[2009-06-29 11:17:50] amiroot at yahoo dot com

I tried even ./configure --with-mysql --with-zlib-dir=/usr but the
problem still exists.

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

[2009-06-29 09:42:12] [email protected]

1. Change to prefork MPM in Apache
2. Try again.

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

[2009-06-29 09:29:15] amiroot at yahoo dot com

Description:
------------
While doing configure in php-5.2.10 (also happened in PHP 5.3 RC4 and
the latest CSV). It works prefectly okay in PHP 5.2.9.

I installed both 32 and 64 version of libmysqlclient.so which located
in
/usr/lib/mysql and /usr/lib64/mysql respectively. Sounds like the
configure script seek for only /usr/lib/mysql. Here is the error in
config.log

configure:60459: gcc -o conftest -I/usr/include -g -O2 -pthread 
-D_REENTRANT -Wl,-rpath,/usr/lib/mysql -L/usr/lib/mysql -L/usr/lib 
-Wl,-rpath,/usr/kerberos/lib64 -L/usr/kerberos/lib64 -Wl,-rpath,/usr
-L/usr conftest.c -lmysqlclient_r  -lz -lmcrypt -lltdl -lcrypt -lpam
-lfreetype -lpng -lz -ljpeg -lgdbm -lcurl -lz -lresolv -lm -ldl -lnsl 
-lxml2 -lz -lm -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
-lresolv
-ldl -lidn -lssl -lcrypto -lz -lxml2 -lz -lm -lgssapi_krb5 -lkrb5
-lk5crypto -lcom_err -lssl -lcrypto -ldl -lz 1>&5
/usr/bin/ld: skipping incompatible /usr/lib/mysql/libmysqlclient_r.so
when searching for -lmysqlclient_r
/usr/bin/ld: skipping incompatible /usr/lib/mysql/libmysqlclient_r.a
when searching for -lmysqlclient_r
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
configure: failed program was:
#line 60448 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char mysql_error();

int main() {
mysql_error()
; return 0; }


Reproduce code:
---------------
./configure --with-apxs2=/usr/local/httpd/bin/apxs --with-gd
--with-jpeg-dir=/usr --with-png-dir=/usr --with-zlib-dir=/usr
--with-freetype-dir=/usr --with-zlib --enable-ftp --enable-sockets
--enable-mbstring=all --enable-zip --enable-soap --with-iconv
--with-gdbm --with-mcrypt --with-imap --with-kerberos --with-imap-ssl
--with-curl --with-mysql

Expected result:
----------------
No error

Actual result:
--------------
checking for mysql_close in -lmysqlclient... no
checking for mysql_error in -lmysqlclient... no
configure: error: mysql configure failed. Please check config.log for
more information.


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


-- 
Edit this bug report at http://bugs.php.net/?id=48715&edit=1