PHP 4.0 Bug #8749: Compile errors with IBM DB2 support

From: stuarth@generalsearch.net Operating system: Redhat 7.0 PHP version: 4.0.4pl1 PHP Bug Type: Compile Failure Bug description: Compile errors with IBM DB2 support When trying to compile with --with-ibm-db2, the PHP build works fine but the Apache build fails. The errors given are listed at the bottom of this slip. DB2 is version UDB EEE 7.1 and installed in all the default locations. My compile options are: CFLAGS="-O2 -I/root/webbuild/openssl-0.9.6/include" \ ./configure \ --with-mcrypt=/usr/local \ --with-apache=/root/webbuild/apache_1.3.14 \ --with-mysql=/usr/local/mysql \ --with-ibm-db2 \ --with-ldap \ --enable-memory-limit=yes \ --enable-debug=no I'm not sure if this has anything to do with it, but I noticed that Berkeley DB2 (in /usr/lib) and IBM DB2 (in /home/db2inst1/sqllib/lib) both have libraries named libdb2.so. I'm not sure if this is confusing the configure script into grabbing the Berkeley library or not. This is the error message that was returned: gcc -DLINUX=2 -DMOD_SSL=207101 -I/root/webbuild/php-4.0.4pl1 -I/root/webbuild/php-4.0.4pl1/main -I/root/webbuild/php-4.0.4pl1/main -I/root/webbuild/php-4.0.4pl1/Zend -I/root/webbuild/php-4.0.4pl1/Zend -I/root/webbuild/php-4.0.4pl1/TSRM -I/root/webbuild/php-4.0.4pl1/TSRM -I/root/webbuild/php-4.0.4pl1 -DEAPI -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED ./apaci -L/root/webbuild/openssl-0.9.6 -L/usr/local/ssl/lib/openssl -L/usr/local/mysql/lib -L/usr/lib \ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/ssl/libssl.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/local/lib -Wl,-rpath,/usr/local/mysql/lib/mysql -rdynamic -L/usr/local/lib -L/usr/local/mysql/lib/mysql -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -L/home/db2inst1/sqllib/lib -ldb2 -lpam -ldl -lmysqlclient -lmcrypt -lltdl -lldap -llber -lresolv -lm -ldl -lcrypt -lnsl -lresolv -lm -lcrypt -lssl -lcrypto modules/php4/libphp4.a(php_odbc.o): In function `_free_odbc_result': php_odbc.o(.text+0x6e): undefined reference to `SQLFreeStmt' modules/php4/libphp4.a(php_odbc.o): In function `_close_odbc_conn': php_odbc.o(.text+0x9c): undefined reference to `SQLDisconnect' php_odbc.o(.text+0xa5): undefined reference to `SQLFreeConnect' php_odbc.o(.text+0xad): undefined reference to `SQLFreeEnv' modules/php4/libphp4.a(php_odbc.o): In function `_close_odbc_pconn': php_odbc.o(.text+0xd4): undefined reference to `SQLDisconnect' php_odbc.o(.text+0xdd): undefined reference to `SQLFreeConnect' php_odbc.o(.text+0xe5): undefined reference to `SQLFreeEnv' modules/php4/libphp4.a(php_odbc.o): In function `odbc_sql_error': php_odbc.o(.text+0x883): undefined reference to `SQLError' modules/php4/libphp4.a(php_odbc.o): In function `odbc_bindcols': php_odbc.o(.text+0xa3f): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0xa93): undefined reference to `SQLColAttributes' php_odbc.o(.text+0xaaf): undefined reference to `SQLColAttributes' php_odbc.o(.text+0xaec): undefined reference to `SQLColAttributes' php_odbc.o(.text+0xb1d): undefined reference to `SQLBindCol' modules/php4/libphp4.a(php_odbc.o): In function `odbc_transact': php_odbc.o(.text+0xbaa): undefined reference to `SQLTransact' modules/php4/libphp4.a(php_odbc.o): In function `odbc_column_lengths': php_odbc.o(.text+0xd5a): undefined reference to `SQLColAttributes' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_prepare': php_odbc.o(.text+0xfba): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x1019): undefined reference to `SQLGetInfo' php_odbc.o(.text+0x103a): undefined reference to `SQLSetStmtOption' php_odbc.o(.text+0x105d): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x107a): undefined reference to `SQLPrepare' php_odbc.o(.text+0x109e): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x10be): undefined reference to `SQLNumParams' php_odbc.o(.text+0x10cb): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_execute': php_odbc.o(.text+0x131f): undefined reference to `SQLDescribeParam' php_odbc.o(.text+0x13c6): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x1455): undefined reference to `SQLBindParameter' php_odbc.o(.text+0x1488): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x14b5): undefined reference to `SQLExecute' php_odbc.o(.text+0x14e4): undefined reference to `SQLParamData' php_odbc.o(.text+0x1502): undefined reference to `SQLPutData' php_odbc.o(.text+0x1569): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x15d4): undefined reference to `SQLNumResultCols' php_odbc.o(.text+0x162e): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x1666): undefined reference to `SQLFreeStmt' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_cursor': php_odbc.o(.text+0x1714): undefined reference to `SQLGetInfo' php_odbc.o(.text+0x177d): undefined reference to `SQLGetCursorName' php_odbc.o(.text+0x17bf): undefined reference to `SQLError' php_odbc.o(.text+0x17f1): undefined reference to `SQLSetCursorName' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_exec': php_odbc.o(.text+0x1a64): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x1ab5): undefined reference to `SQLGetInfo' php_odbc.o(.text+0x1ad6): undefined reference to `SQLSetStmtOption' php_odbc.o(.text+0x1af9): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x1b12): undefined reference to `SQLExecDirect' php_odbc.o(.text+0x1b37): undefined reference to `SQLFreeStmt' php_odbc.o(.text+0x1b5e): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_fetch_into': php_odbc.o(.text+0x1d96): undefined reference to `SQLExtendedFetch' php_odbc.o(.text+0x1da6): undefined reference to `SQLFetch' php_odbc.o(.text+0x1f01): undefined reference to `SQLGetData' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_fetch_row': php_odbc.o(.text+0x2132): undefined reference to `SQLExtendedFetch' php_odbc.o(.text+0x2142): undefined reference to `SQLFetch' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_result': php_odbc.o(.text+0x2350): undefined reference to `SQLExtendedFetch' php_odbc.o(.text+0x2362): undefined reference to `SQLFetch' php_odbc.o(.text+0x240d): undefined reference to `SQLColAttributes' php_odbc.o(.text+0x2486): undefined reference to `SQLGetData' php_odbc.o(.text+0x2627): undefined reference to `SQLGetData' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_result_all': php_odbc.o(.text+0x2735): undefined reference to `SQLExtendedFetch' php_odbc.o(.text+0x274a): undefined reference to `SQLFetch' php_odbc.o(.text+0x2974): undefined reference to `SQLGetData' php_odbc.o(.text+0x2a3d): undefined reference to `SQLExtendedFetch' php_odbc.o(.text+0x2a52): undefined reference to `SQLFetch' modules/php4/libphp4.a(php_odbc.o): In function `odbc_sqlconnect': php_odbc.o(.text+0x2b87): undefined reference to `SQLAllocEnv' php_odbc.o(.text+0x2b98): undefined reference to `SQLAllocConnect' php_odbc.o(.text+0x2bae): undefined reference to `SQLSetConnectOption' php_odbc.o(.text+0x2bd6): undefined reference to `SQLFreeConnect' php_odbc.o(.text+0x2bfa): undefined reference to `SQLConnect' php_odbc.o(.text+0x2c23): undefined reference to `SQLFreeConnect' modules/php4/libphp4.a(php_odbc.o): In function `odbc_do_connect': php_odbc.o(.text+0x311e): undefined reference to `SQLGetInfo' php_odbc.o(.text+0x3147): undefined reference to `SQLDisconnect' php_odbc.o(.text+0x3153): undefined reference to `SQLFreeConnect' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_num_rows': php_odbc.o(.text+0x3452): undefined reference to `SQLRowCount' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_field_type': php_odbc.o(.text+0x3786): undefined reference to `SQLColAttributes' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_autocommit': php_odbc.o(.text+0x3a8c): undefined reference to `SQLSetConnectOption' php_odbc.o(.text+0x3abb): undefined reference to `SQLGetConnectOption' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_setoption': php_odbc.o(.text+0x3d8d): undefined reference to `SQLSetConnectOption' php_odbc.o(.text+0x3df8): undefined reference to `SQLSetStmtOption' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_tables': php_odbc.o(.text+0x415c): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x41f6): undefined reference to `SQLTables' php_odbc.o(.text+0x4228): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_columns': php_odbc.o(.text+0x45a8): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x4642): undefined reference to `SQLColumns' php_odbc.o(.text+0x4674): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_columnprivileges': php_odbc.o(.text+0x49a4): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x4a39): undefined reference to `SQLColumnPrivileges' php_odbc.o(.text+0x4a6c): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_foreignkeys': php_odbc.o(.text+0x4ec0): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x4f79): undefined reference to `SQLForeignKeys' php_odbc.o(.text+0x4fac): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_gettypeinfo': php_odbc.o(.text+0x5158): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x51ab): undefined reference to `SQLGetTypeInfo' php_odbc.o(.text+0x51dc): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_primarykeys': php_odbc.o(.text+0x547c): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x54fd): undefined reference to `SQLPrimaryKeys' php_odbc.o(.text+0x5530): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_procedurecolumns': php_odbc.o(.text+0x58a0): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x5935): undefined reference to `SQLProcedureColumns' php_odbc.o(.text+0x5968): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_procedures': php_odbc.o(.text+0x5c40): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x5cc1): undefined reference to `SQLProcedures' php_odbc.o(.text+0x5cf4): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_specialcolumns': php_odbc.o(.text+0x6150): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x61e6): undefined reference to `SQLSpecialColumns' php_odbc.o(.text+0x6218): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_statistics': php_odbc.o(.text+0x65e0): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x6671): undefined reference to `SQLStatistics' php_odbc.o(.text+0x66a4): undefined reference to `SQLNumResultCols' modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_tableprivileges': php_odbc.o(.text+0x694c): undefined reference to `SQLAllocStmt' php_odbc.o(.text+0x69cd): undefined reference to `SQLTablePrivileges' php_odbc.o(.text+0x6a00): undefined reference to `SQLNumResultCols' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/root/webbuild/apache_1.3.14/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/root/webbuild/apache_1.3.14' make: *** [build] Error 2 [root@cb737152-a webbuild]# -- Edit Bug report at: http://bugs.php.net/?id=8749&edit=1