From: michael at halligan dot org Operating system: SLES9 SP3 PHP version: 5.1.6 PHP Bug Type: Compile Failure Bug description: Many. Configure system is horribly broken
Description: ------------ Not sure where to begin. PHP ignores --mysql and attempts to find everything via hardcoding. This is just broken. It is impossible to compile php if mysql is not in the standard directory. Beyond, that, http://bugs.mysql.com/bug.php?id=15828 was never actually fixed. Reproduce code: --------------- '--with-prefix=/wisdomark/services/apache' \ '--with-openssl=shared' \ '--with-apxs=/wisdomark/services/apache/sbin/apxs' \ '--with-pear=/wisdomark/services/apache' \ '--enable-mbstring' \ '--with-mysql=/wisdomark/lib64/' \ '--with-mysqli=/wisdomark/services/mysql' \ '--with-pdo-mysql=/wisdomark/services/mysql/usr/bin/mysql_config' \ '--with-zlib' \ '--with-gd' \ '--with-curl' \ '--with-curlwrappers' \ '--with-libxml-dir=/wisdomark' \ '--with-libdir=lib64' \ '--with-libexecdir=/wisdomark/services/apache/libexec' \ '--bindir=/wisdomark/services/apache/bin' \ '--sbindir=/wisdomark/services/apache/sbin' \ '--sysconfdir=/wisdomark/services/apache/conf' \ '--with-extension=shared,/wisdomark/services/apache/lib/php' \ '--includedir=/wisdomark/services/apache/include' \ '--sharedstatedir=/wisdomark/services/apache/lib/php/ext' \ '--enable-sysvshm' \ '--with-config-file-path=/wisdomark/services/apache/conf' \ Expected result: ---------------- I expect configure to work properly. Actual result: -------------- checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... no configure: error: Cannot find libmysqlclient under /usr. Note that the MySQL client library is not bundled anymore! is the first error. If I only compile with pdo-mysql, then I get: ext/pdo_mysql/.libs/pdo_mysql.o(.text+0xa): In function `zm_info_pdo_mysql': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/pdo_mysql.c:104: undefined reference to `mysql_get_client_info' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x4b9): In function `pdo_mysql_last_insert_id': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 265: undefined reference to `mysql_insert_id' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x541): In function `mysql_handle_quoter': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 274: undefined reference to `mysql_real_escape_string' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x601): In function `mysql_handle_closer': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 144: undefined reference to `mysql_close' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x684): In function `_pdo_mysql_error': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 68: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x6d4):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:81: undefined reference to `mysql_error' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x6fa):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:102: undefined reference to `mysql_sqlstate' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x751):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:63: undefined reference to `mysql_stmt_errno' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x774):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:63: undefined reference to `mysql_error' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x7e8):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:98: undefined reference to `mysql_stmt_sqlstate' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x8a1): In function `pdo_mysql_get_attribute': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 344: undefined reference to `mysql_get_host_info' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x911):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:336: undefined reference to `mysql_get_client_info' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x945):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:350: undefined reference to `mysql_stat' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x969):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:340: undefined reference to `mysql_get_server_info' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x9bf): In function `mysql_handle_doer': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 248: undefined reference to `mysql_real_query' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x9cc):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:252: undefined reference to `mysql_affected_rows' ext/pdo_mysql/.libs/mysql_driver.o(.text+0xc64): In function `pdo_mysql_handle_factory': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 450: undefined reference to `mysql_init' ext/pdo_mysql/.libs/mysql_driver.o(.text+0xecd):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:473: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o(.text+0xeed):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:478: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o(.text+0xf66):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:494: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o(.text+0xfe2):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:504: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x105e):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:514: undefined reference to `mysql_options' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x10db):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:531: undefined reference to `mysql_real_connect' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x16db): In function `mysql_handle_preparer': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c: 178: undefined reference to `mysql_get_server_version' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x1725):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:195: undefined reference to `mysql_stmt_init' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x1746):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:203: undefined reference to `mysql_stmt_prepare' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x1766):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:222: undefined reference to `mysql_stmt_param_count' ext/pdo_mysql/.libs/mysql_driver.o(.text+0x1835):/wisdomark/ sources/php-5.1.6/ext/pdo_mysql/mysql_driver.c:206: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x1e): In function `pdo_mysql_stmt_cursor_closer': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/ mysql_statement.c:602: undefined reference to `mysql_more_results' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x2d):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 609: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x3c):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 612: undefined reference to `mysql_store_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x49):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 614: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x54):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 614: undefined reference to `mysql_more_results' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x64):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 598: undefined reference to `mysql_stmt_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x73):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 603: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xd1): In function `pdo_mysql_stmt_next_rowset': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/ mysql_statement.c:265: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x11b):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 274: undefined reference to `mysql_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x135):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 280: undefined reference to `mysql_use_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x14d):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 290: undefined reference to `mysql_num_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x159):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 291: undefined reference to `mysql_fetch_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x169):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 261: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x181):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 257: undefined reference to `mysql_stmt_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x195):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 282: undefined reference to `mysql_store_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x999): In function `pdo_mysql_stmt_fetch': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/ mysql_statement.c:394: undefined reference to `mysql_stmt_fetch' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x9e2):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 416: undefined reference to `mysql_fetch_row' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x9f6):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 417: undefined reference to `mysql_errno' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xa15):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 422: undefined reference to `mysql_fetch_lengths' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xaa3): In function `pdo_mysql_stmt_execute': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/ mysql_statement.c:213: undefined reference to `mysql_real_query' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xaf1):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 218: undefined reference to `mysql_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xb15):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 97: undefined reference to `mysql_stmt_bind_param' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xb29):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 209: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xb45):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 102: undefined reference to `mysql_stmt_execute' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xb61):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 109: undefined reference to `mysql_stmt_result_metadata' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xb9e):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 113: undefined reference to `mysql_fetch_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xc0b):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 125: undefined reference to `mysql_num_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xcbf):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 223: undefined reference to `mysql_use_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xce4):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 235: undefined reference to `mysql_num_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xcf1):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 236: undefined reference to `mysql_fetch_fields' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xd07):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 225: undefined reference to `mysql_store_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xd35):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 188: undefined reference to `mysql_stmt_bind_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xd51):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 195: undefined reference to `mysql_stmt_store_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xd5a):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 200: undefined reference to `mysql_stmt_affected_rows' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xf1b):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 134: undefined reference to `mysql_stmt_attr_set' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xfeb): In function `pdo_mysql_stmt_dtor': /wisdomark/sources/php-5.1.6/ext/pdo_mysql/ mysql_statement.c:71: undefined reference to `mysql_more_results' ext/pdo_mysql/.libs/mysql_statement.o(.text+0xffa):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 73: undefined reference to `mysql_next_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x1009):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 77: undefined reference to `mysql_store_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x1016):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 79: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x1021):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 79: undefined reference to `mysql_more_results' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x103c):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 41: undefined reference to `mysql_free_result' ext/pdo_mysql/.libs/mysql_statement.o(.text+0x1071):/ wisdomark/sources/php-5.1.6/ext/pdo_mysql/mysql_statement.c: 50: undefined reference to `mysql_stmt_close' collect2: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 -- Edit bug report at http://bugs.php.net/?id=39042&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39042&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39042&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39042&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39042&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39042&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39042&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=39042&r=needscript Try newer version: http://bugs.php.net/fix.php?id=39042&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39042&r=support Expected behavior: http://bugs.php.net/fix.php?id=39042&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39042&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39042&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39042&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39042&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39042&r=dst IIS Stability: http://bugs.php.net/fix.php?id=39042&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39042&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39042&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39042&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=39042&r=mysqlcfg
