#42056 [Opn->Bgs]: Does not compile with mysqli

ID: 42056 Updated by: jani@php.net Reported By: givanz at yahoo dot com -Status: Open +Status: Bogus Bug Type: MySQLi related Operating System: CentOS 4 PHP Version: 5.2.3 New Comment: There is no bug in PHP. It's doing exactly what it should be when building a thread-safe module for your Apache (which is obviously not configured to run prefork MPM..) and tries to link with the thread-safe mysql library. Previous Comments: ------------------------------------------------------------------------ [2007-07-21 13:36:02] givanz at yahoo dot com I found the problem Php searches mysqclient_r library and with default compilation mysql only compiles mysqlclient so i compiled mysql with --enable-thread-safe-client and then the compilation of php worked fine. I don't know why php wants mysqlclient_r and it doesn't compile with mysqlclient. ------------------------------------------------------------------------ [2007-07-21 13:05:16] jani@php.net Do you have any LDFLAGS or CFLAGS set prior to running configure or in your environment? ------------------------------------------------------------------------ [2007-07-21 06:24:19] givanz at yahoo dot com # /home/web/mysql/bin/mysql_config --libs_r //output is -L/home/web/mysql/lib/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread ------------------------------------------------------------------------ [2007-07-20 22:28:28] jani@php.net What does this output: # /home/web/mysql/bin/mysql_config --libs_r ------------------------------------------------------------------------ [2007-07-20 22:11:16] givanz at yahoo dot com Description: ------------ When i compile php with mysql or mysqli extension it doesn't work i have mysql 5.0.45 is this version suported ? //compile command ./configure --prefix=/home/web/php --with-apxs2=/home/web/apache/bin/apxs --enable-sockets --with-zip --enable-mbstring --with-zlib --without-sqlite --enable-spl --with-mysqli=/home/web/mysql/bin/mysql_config --without-pear --disable-cgi && make && make install //last lines checking for MSSQL support via FreeTDS... no checking for MySQL support... no checking for specified location of the MySQL UNIX socket... no checking for MySQLi support... yes checking whether to enable embedded MySQLi support... no checking for mysql_set_server_option in -lmysqlclient_r... no configure: error: wrong mysql library version or lib not found. Check config.log for more information. //config.log configure:58392: checking for MySQL support configure:58438: checking for specified location of the MySQL UNIX socket configure:59597: checking for MySQLi support configure:59643: checking whether to enable embedded MySQLi support configure:59793: checking for mysql_set_server_option in -lmysqlclient_r configure:59812: gcc -o conftest -I/usr/include -O3 -march=pentium4 -pipe -ftracer -fforce-addr -falign-functions=32 -mfpmath=sse -fprefetch-loop-arrays -momit-leaf-frame-pointer -fomit-frame-pointer -ffast-math -fexpensive-optimizations -mmmx -msse -msse2 -D_FORTIFY_SOURCE=2 -pthread -D_REENTRANT -Wl,-rpath,/home/web/mysql/lib/mysql -L/home/web/mysql/lib/mysql -L/usr/lib -lmysqlclient_r -lz -lcrypt -lnsl -lm conftest.c -lmysqlclient_r -lz -lresolv -lm -ldl -lnsl -lxml2 -lz -lm -lxml2 -lz -lm 1>&5 /usr/bin/ld: cannot find -lmysqlclient_r collect2: ld returned 1 exit status configure: failed program was: #line 59801 "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_set_server_option(); int main() { mysql_set_server_option() ; return 0; } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42056&edit=1