#35432 [Asn->Fbk]: make fails with PDO and MySQL5

ID: 35432 Updated by: wez@php.net Reported By: mail at philipp-wagner dot com -Status: Assigned +Status: Feedback Bug Type: PDO related Operating System: SuSE Linux 8.0 PHP Version: 5CVS-2005-11-27 (snap) Assigned To: wez New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip Please try the next PHP 5.1 snapshot. It features an improved error message that should catch conflicting configure options. Previous Comments: ------------------------------------------------------------------------ [2005-11-28 17:53:13] mail at philipp-wagner dot com Yes, I see that now too, but it's not a problem for MySQL, as /usr/local/mysql is the prefix (it's a MySQL binary .tar.gz distribution). ------------------------------------------------------------------------ [2005-11-27 23:43:30] sniper@php.net One note about your usage of the configure options: There aren't any options that expect the path to the libraries. Every single one of them expects the install prefix. In most cases it's either /usr or /usr/local and not /usr/lib or /usr/local/lib.. ------------------------------------------------------------------------ [2005-11-27 22:40:17] tony2001@php.net Wez, one more for you. ------------------------------------------------------------------------ [2005-11-27 22:31:06] mail at philipp-wagner dot com Description: ------------ I get the same error as in bug #34939 with PHP 5.1.0 (official release) and also today's snapshot release. During the final linking process of make, I get the following error: ext/pdo_mysql/.libs/pdo_mysql.o: In function `zm_startup_pdo_mysql': /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:78: undefined referen ce to `php_pdo_declare_long_constant' /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:79: undefined referen ce to `php_pdo_declare_long_constant' /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:80: undefined referen ce to `php_pdo_declare_long_constant' /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:81: undefined referen ce to `php_pdo_declare_long_constant' /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:82: undefined referen ce to `php_pdo_declare_long_constant' /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:84: undefined referen ce to `php_pdo_register_driver' ext/pdo_mysql/.libs/pdo_mysql.o: In function `zm_shutdown_pdo_mysql': /usr/local/src/php5-200511271530/ext/pdo_mysql/pdo_mysql.c:92: undefined referen ce to `php_pdo_unregister_driver' ext/pdo_mysql/.libs/mysql_driver.o: In function `_pdo_mysql_error': /usr/local/src/php5-200511271530/ext/pdo_mysql/mysql_driver.c:109: undefined ref erence to `php_pdo_get_exception' ext/pdo_mysql/.libs/mysql_driver.o: In function `mysql_handle_preparer': /usr/local/src/php5-200511271530/ext/pdo_mysql/mysql_driver.c:178: undefined ref erence to `pdo_parse_params' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_last_insert_id': /usr/local/src/php5-200511271530/ext/pdo_mysql/mysql_driver.c:259: undefined ref erence to `php_pdo_int64_to_str' ext/pdo_mysql/.libs/mysql_driver.o: In function `pdo_mysql_handle_factory': /usr/local/src/php5-200511271530/ext/pdo_mysql/mysql_driver.c:412: undefined ref erence to `php_pdo_parse_data_source' ext/pdo_mysql/.libs/mysql_statement.o: In function `pdo_mysql_stmt_param_hook': /usr/local/src/php5-200511271530/ext/pdo_mysql/mysql_statement.c:338: undefined reference to `pdo_raise_impl_error' ext/pdo_sqlite/.libs/pdo_sqlite.o: In function `zm_startup_pdo_sqlite': /usr/local/src/php5-200511271530/ext/pdo_sqlite/pdo_sqlite.c:80: undefined refer ence to `php_pdo_register_driver' ext/pdo_sqlite/.libs/pdo_sqlite.o: In function `zm_shutdown_pdo_sqlite': /usr/local/src/php5-200511271530/ext/pdo_sqlite/pdo_sqlite.c:87: undefined refer ence to `php_pdo_unregister_driver' ext/pdo_sqlite/.libs/sqlite_driver.o: In function `_pdo_sqlite_error': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_driver.c:78: undefined re ference to `php_pdo_get_exception' ext/pdo_sqlite/.libs/sqlite_driver.o: In function `pdo_sqlite_last_insert_id': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_driver.c:197: undefined r eference to `php_pdo_int64_to_str' ext/pdo_sqlite/.libs/sqlite_driver.o: In function `zif_SQLite_sqliteCreateFuncti on': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_driver.c:471: undefined r eference to `pdo_raise_impl_error' ext/pdo_sqlite/.libs/sqlite_driver.o: In function `zif_SQLite_sqliteCreateAggreg ate': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_driver.c:543: undefined r eference to `pdo_raise_impl_error' ext/pdo_sqlite/.libs/sqlite_driver.o: In function `pdo_sqlite_handle_factory': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_driver.c:697: undefined r eference to `php_pdo_get_exception' ext/pdo_sqlite/.libs/sqlite_statement.o: In function `pdo_sqlite_stmt_param_hook ': /usr/local/src/php5-200511271530/ext/pdo_sqlite/sqlite_statement.c:116: undefine d reference to `pdo_raise_impl_error' ext/sqlite/.libs/sqlite.o: In function `zm_startup_sqlite': /usr/local/src/php5-200511271530/ext/sqlite/sqlite.c:1100: undefined reference t o `php_pdo_register_driver' ext/sqlite/.libs/sqlite.o: In function `zm_shutdown_sqlite': /usr/local/src/php5-200511271530/ext/sqlite/sqlite.c:1113: undefined reference to `php_pdo_unregister_driver' ext/sqlite/.libs/pdo_sqlite2.o: In function `_pdo_sqlite2_error': /usr/local/src/php5-200511271530/ext/sqlite/pdo_sqlite2.c:291: undefined reference to `php_pdo_get_exception' ext/sqlite/.libs/pdo_sqlite2.o: In function `pdo_sqlite2_last_insert_id': /usr/local/src/php5-200511271530/ext/sqlite/pdo_sqlite2.c:373: undefined reference to `php_pdo_int64_to_str' ext/sqlite/.libs/pdo_sqlite2.o: In function `pdo_sqlite2_handle_factory': /usr/local/src/php5-200511271530/ext/sqlite/pdo_sqlite2.c:579: undefined reference to `php_pdo_get_exception' Reproduce code: --------------- I am using MySQL 5.0.16 and my configure line was as follows: './configure' '--enable-trans-sid' '--enable-memory-limit' '--with-config-file-path=/etc' '--enable-xslt' '--with-xslt-sablot' '--enable-ftp' '--enable-bcmath' '--with-bz2' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql=/usr/local/mysql' '--with-gzip' '--with-bzip2' '--with-gd' '--with-jpeg-dir=/usr/lib' '--with-zlib-dir=/usr/lib' '--with-iconv-dir=/usr/local/lib' '--with-iconv=/usr/local/lib' '--with-freetype-dir' '--enable-gd-native-ttf' '--with-magickwand=/usr/local' --enable-pdo=shared --with-pdo-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --enable-mbstring I didn't get any error when I was compiling PHP without any PDO configure option, it built fine with PDO support for sqlite. Unfortunately it's hard for me to try every possible combination of configure lines which may cause the problem, as a make process takes about two hours on my machine. But if you need me to try a certain configure line, I'll be glad to provide you with the results. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35432&edit=1