#39369 [Opn]: PHP 5.2.0 will not compiled with MySQL support

ID: 39369 User updated by: nathan at officelink dot net dot au Reported By: nathan at officelink dot net dot au Status: Open Bug Type: Compile Failure Operating System: FreeBSD 6.1-RELEASE-p10 PHP Version: 5.2.0 New Comment: Thanks Rasmus, that has fixed my problem. I'm confused as to why this worked under versions earlier of PHP but I now understand what was wrong. I have now compiled MySQL with --enable-thread-safe-client. Thanks again, Nathan Previous Comments: ------------------------------------------------------------------------ [2006-11-04 09:38:22] rasmus@php.net Ok, and do you have libmysqlclient_r installed? You need the threadsafe version of that library or you need to use the prefork mpm with Apache. ------------------------------------------------------------------------ [2006-11-04 09:24:31] nathan at officelink dot net dot au Yes, here is my Apache configure line: ./configure --prefix=/usr/local/apache --enable-module=so --with-mpm=worker --enable-ssl --enable-deflate --enable-cern-meta --enable-expires --enable-headers --enable-vhost-alias --enable-rewrite --enable-access --enable-auth --enable-include --enable-log_config --enable-env --enable-setenvif --enable-http --enable-mime --enable-status --enable-autoindex --enable-asis --enable-cgi --enable-negotiation --enable-dir --enable-actions --enable-userdir --enable-alias -enable-mem-cache --enable-cache --enable-headers --enable-deflate ------------------------------------------------------------------------ [2006-11-04 09:19:38] rasmus@php.net Are you using a threaded mpm in Apache2? It is looking for the threadsafe mysqlclient library as a result. ------------------------------------------------------------------------ [2006-11-04 04:57:05] nathan at officelink dot net dot au Description: ------------ Unable to get PHP 5.2.0 to compile with MySQL support. PHP versions prior to this work perfectly with an identical ./configure line. Reproduce code: --------------- ./configure --with-apxs2=/usr/local/apache/bin/apxs --enable-ftp --enable-magic-quotes --enable-track-vars --enable-sockets --with-gettext --with-gd --with-zlib-dir=/usr/local --with-freetype-dir=/usr/local --enable-soap --with-mysqli=/usr/local/mysql/bin/mysql_config --with-xmlrpc --with-imap=/usr/local/src/imap-2004g --enable-mbstring=all --with-mime-magic=/usr/share/misc/magic.mime --with-mcrypt --with-iconv --enable-mbregex --enable-mime-magic --with-openssl=/usr/local/ssl --with-imap-ssl --with-mysql=/usr/local/mysql on PHP 5.2.0 I get: checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no configure: error: Cannot find libmysqlclient_r under /usr/local/mysql. Note that the MySQL client library is not bundled anymore! MySQL version is mysql Ver 14.12 Distrib 5.0.27, for unknown-freebsd6.1 (i386) using EditLine wrapper compiled from source with ./configure --prefix=/usr/local/mysql --without-debug Expected result: ---------------- on PHP 5.1.6 I get: checking for MySQL support... yes checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no checking for mysql_close in -lmysqlclient... yes checking for MySQLi support... yes checking whether to enable embedded MySQLi support... no checking for mysql_set_server_option in -lmysqlclient... yes checking for mysql_stmt_field_count in -lmysqlclient... yes ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39369&edit=1