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

ID: 8749 Updated by: kalowsky Reported By: stuarth@generalsearch.net Status: Open Bug Type: Compile Failure Assigned To: Comments: this looks like the configure process has somehow not found your DB2 libraries. can you share the configure log? at the very least check to make sure it finds these libraries properly Previous Comments: --------------------------------------------------------------------------- [2001-01-16 23:05:11] stuarth@generalsearch.net 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]# --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. Full Bug description available at: http://bugs.php.net/?id=8749