#42515 [NEW]: MySQL Library Locations Incorrect

From: geoffers at gmail dot com Operating system: Mac OS 10.4.10 PHP version: 5.2.4 PHP Bug Type: MySQL related Bug description: MySQL Library Locations Incorrect Description: ------------ As #42464 is marked as bogus, and I cannot therefore comment on that: The official MySQL binaries install at /usr/local/mysql. PHP tries to read from /usr/local/mysql/lib/mysql, which does not exist. The prior bug was marked as bogus due to ./buildconf being used: on a non-"hackish" copy of PHP it fails too. Running just: % cd php-5.2.4 % ./configure --with-mysql=/usr/local/mysql ./configure doesn't fail like jani claimed. Instead, it says that a system library hasn't been found, and to email php-install. If you try to run make regardless, it succeeds, but you cannot do anything with the binary as it cannot load the libraries. Take a clean OS X install, install the mysql,org binary, then try to compile PHP as above. It'll fail. This isn't a bogus report. This is a real bug, which really makes PHP totally unusable. Reproduce code: --------------- % cd php-5.2.4 % ./configure --with-mysql=/usr/local/mysql % make Expected result: ---------------- Working PHP binary to be produced Actual result: -------------- A non-working PHP binary, trying to load dynamic libraries (which exist in /usr/local/mysql/lib) from /usr/local/mysql/lib/mysql). -- Edit bug report at http://bugs.php.net/?id=42515&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42515&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42515&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42515&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42515&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42515&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42515&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42515&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42515&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42515&r=support Expected behavior: http://bugs.php.net/fix.php?id=42515&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42515&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42515&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42515&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42515&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42515&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42515&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42515&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42515&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42515&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42515&r=mysqlcfg