#30136 [Com]: Error when MySQL is not on /usr/local/mysql

ID: 30136 Comment by: hbaolong at yahoo dot com dot cn Reported By: akita_kobe at yahoo dot com Status: Bogus Bug Type: MySQL related Operating System: Solaris 8 PHP Version: 4.3.8 New Comment: I get the same result even my mysql is in /usr/local/mysql help me. Previous Comments: ------------------------------------------------------------------------ [2004-09-28 23:18:32] akita_kobe at yahoo dot com Where is that in the manual? I seem to not have seen that fact that LD_LIBRARY_PATH has to be set EVEN IF config allows to give it the path to the libraries. Thank you for your good manners! ------------------------------------------------------------------------ [2004-09-28 23:18:32] akita_kobe at yahoo dot com Where is that in the manual? I seem to not have seen that fact that LD_LIBRARY_PATH has to be set EVEN IF config allows to give it the path to the libraries. Thank you for your good manners! ------------------------------------------------------------------------ [2004-09-28 23:02:59] sniper@php.net Obviously that path you have mysql in is missing from your LD_LIBRARY_PATH setting. Not PHP bug, ask support questions elsewhere. ------------------------------------------------------------------------ [2004-09-17 19:44:56] akita_kobe at yahoo dot com Description: ------------ When configuring PHP with MySQL with the following config it fails: ./configure --prefix=/project/compiled/PHP \ --exec-prefix=/project/compiled/PHP \ --with-mysql=/project/compiled/MySQL \ --with-zlib=/usr/local The error message that config displays is: 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. From config.log: ld: fatal: Symbol referencing errors. No output written to conftest collect2: ld returned 1 exit status configure: failed program was: #line 56453 "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; } However, if I symlink /project/compiled/MySQL to /usr/local/mysql, everything works perfectly. I don't want that symlink in there. Is there a way to do so? Please let me know. Reproduce code: --------------- ./configure --prefix=/project/compiled/PHP \ --exec-prefix=/project/compiled/PHP \ --with-mysql=/project/compiled/MySQL \ --with-zlib=/usr/local Expected result: ---------------- Configure to run without errors 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=30136&edit=1