ID: 42056
User updated by: givanz at yahoo dot com
Reported By: givanz at yahoo dot com
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: CentOS 4
PHP Version: 5.2.3
New Comment:
# /home/web/mysql/bin/mysql_config --libs_r
//output is
-L/home/web/mysql/lib/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl
-lm -lpthread
Previous Comments:
------------------------------------------------------------------------
[2007-07-20 22:28:28] [EMAIL PROTECTED]
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
