php5.2 mysqli模块安装出错

big_turnip

php已经安装完成
在添加mysqli模块的时候发生了错误

configure: error: wrong mysql library version or lib not found. Check config.log for more information.

编译参数

1. ./configure --with-php-config=/usr/local/php/bin/php-config --with-mysqli=/usr/local/mysql/bin/mysql_config
   

复制代码

系统中自带有mysql-server, /usr/local/mysql是我自己编译安装的版本为Percona-Server-5.5.31-rel30.3.tar.gz

1. rpm -aq|grep mysql
   
2. mysql-server-5.1.69-1.el6_4.x86_64
   
3. qt-mysql-4.6.2-24.el6.x86_64
   
4. mysql-libs-5.1.69-1.el6_4.x86_64
   
5. mysql-5.1.69-1.el6_4.x86_64
   
6. 
   
7. rpm -aq|grep MySQL
   
8. perl-DBD-MySQL-4.013-3.el6.x86_64
   
9. MySQL-devel-5.5.31-2.el6.x86_64
   

复制代码

求解
config.log片段

1. configure:4694: cc -o conftest -g -O2  -Wl,-rpath,/usr/local/mysql/lib -L/usr/local/mysql/lib  -lmysqlclient -lprobes_mysql -lm -lrt -ldl -lmygcc conftest.c -lmysqlclient   >&5
   
2. /usr/bin/ld: cannot find -lprobes_mysql
   
3. collect2: ld returned 1 exit status
   
4. configure:4701: $? = 1
   
5. configure: failed program was:
   
6. | /* confdefs.h.  */
   
7. | #define PACKAGE_NAME ""
   
8. | #define PACKAGE_TARNAME ""
   
9. | #define PACKAGE_VERSION ""
   
10. | #define PACKAGE_STRING ""
    
11. | #define PACKAGE_BUGREPORT ""
    
12. | /* end confdefs.h.  */
    
13. |
    
14. | /* Override any GCC internal prototype to avoid an error.
    
15. |    Use char because int might match the return type of a GCC
    
16. |    builtin and then its argument prototype would still apply.  */
    
17. | #ifdef __cplusplus
    
18. | extern "C"
    
19. | #endif
    
20. | char mysql_set_server_option ();
    
21. | int
    
22. | main ()
    
23. | {
    
24. | return mysql_set_server_option ();
    
25. |   ;
    
26. |   return 0;
    
27. | }
    
28. configure:4724: result: no
    
29. configure:5059: error: wrong mysql library version or lib not found. Check config.log for more information.
    

复制代码

chenyx

你重新解压下源文件,在源码目录下先用phpize,然后configure看看

big_turnip

回复 2# chenyx
[root@localhost php-5.2.17p1]# /usr/local/php/bin/phpize 
Cannot find config.m4. 
Make sure that you run '/usr/local/php/bin/phpize' in the top level source directory of the module

    14  rm php-5.2.17p1 -rf
   15  ls
   16  tar zxvf php-5.2.17p1.tar.gz
   17  cd php-5.2.17p1/ext/mysqli/
   18  /usr/local/php/bin/phpize
   19  ./configure --with-php-config=/usr/local/php/bin/php-config --with-mysqli=/usr/local/mysql/bin/mysql_config
   20  history
问题依旧

chenyx

你原来的php不是已经支持mysql了吗,直接configure,不加参数测试下

big_turnip

回复 4# chenyx

27  cd ext/mysqli/
   28  /usr/local/php/bin/phpize
   29  ./configure
   30  ./configure --with-php-config=/usr/local/php/bin/php-config
   31  history
一样的报错
我想问题的关键可能是在config.log里面的

/usr/bin/ld: cannot find -lprobes_mysql

但是不知道怎么搞
[root@localhost mysqli]# find / -name "probes_mysql*"
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/probes_mysql.o
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/include/probes_mysql.d.base
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/include/probes_mysql.h
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/include/probes_mysql.d
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/include/probes_mysql_nodtrace.h
/root/ltmp_install/Percona-Server-5.5.31-rel30.3/include/probes_mysql_dtrace.h

chenyx

还不行的话,只能重新编译php了.

big_turnip

回复 6# chenyx
这个php是我新编译的，只不过是在编译的时候加mysqli模块参数就一直不能通过，报错
安装完php后单独添加mysqli模块，也一样报错

1. [root@localhost php-5.2.17p1]# /usr/local/php/bin/php-config
   
2. Usage: /usr/local/php/bin/php-config [OPTION]
   
3. Options:
   
4.   --prefix            [/usr/local/php]
   
5.   --includes          [-I/usr/local/php/include/php -I/usr/local/php/include/php/main -I/usr/local/php/include/php/TSRM -I/usr/local/php/include/php/Zend -I/usr/local/php/include/php/ext -I/usr/local/php/include/php/ext/date/lib]
   
6.   --ldflags           [ -L/usr/local/mysql/lib]
   
7.   --libs              [-lcrypt   -lz -lcrypt -lrt -lmysqlclient -lpng -lz -lrt -lresolv -lm -ldl -lnsl  -lrt -lxml2 -lz -lm -lssl -lcrypto -ldl -lz -lxml2 -lz -lm -lssl -lcrypto -ldl -lz -lxml2 -lz -lm -lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lxml2 -lz -lm -lxml2 -lz -lm -lcrypt ]
   
8.   --extension-dir     [/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613]
   
9.   --include-dir       [/usr/local/php/include/php]
   
10.   --php-binary        [/usr/local/php/bin/php-cgi]
    
11.   --php-sapis         [cgi]
    
12.   --configure-options [--prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --with-openssl --with-gd --enable-fastcgi --enable-force-cgi-redirect --enable-discard-path --with-mysql=/usr/local/mysql --disable-debug --enable-mbstring --with-ttf --enable-gd-native-ttf --enable-gd-jis-conv --enable-fpm --enable-ftp --with-curlwrappers --enable-sockets --enable-zip --enable-bcmath --enable-calendar --enable-exif --enable-soap --disable-cli --enable-embedded-mysqli]
    
13.   --version           [5.2.17p1]
    
14.   --vernum            [50217]
    

复制代码

chenyx

/root/ltmp_install/Percona-Server-5.5.31-rel30.3/probes_mysql.o

这个软件是啥?是你安装的吗?

big_turnip

回复 8# chenyx


    Percona-Server-5.5.31-rel30.3
mysql-server 的一个分支

chenyx

/usr/bin/ld: cannot find -lprobes_mysql

应该是那个软件没安装好吧,找不到probes_mysql库.你要是缺人那个软件是正确的,将你/root下的那个拷贝到/usr/lib下看看