Re: compile problem with IBM DB2

well the snippet below is the Apache config. i don't see the difference between what i have and what you put below. jeff On Thu, 3 May 2001, Steve Brazill wrote: => Shouldn't your PHP config statement look like: => => => SSL_BASE=/usr/local/ssl => ./configure \ => --with-layout=Apache \ => --prefix=/opt/gr/oas/apache \ => --enable-module=ssl \ => --activate-module=src/modules/php4/libphp4.a \ => --activate-module=src/modules/perl/libperl.a \ => --enable-module=php4 \ => --enable-module=expires \ => --disable-module=include => => Jeff Warrington wrote: => => > hello all, => > => > i have had a frustrating time trying to get this one resolved. I am trying => > to compile PHP4 with support for IBM DB2 on Apache 1.19. I have done this => > in the past with success but lately am consistently getting a failure. => > => > This problem is essentially PHP bug #8749 I have not seen any followup => > to that bug report however. => > => > any help appreciated, => > Jeff => > => > I am compiling PHP 4.0.5 (fails with earlier releases too) w/ this: => > => > ./configure --with-apache=../apache_1.3.17 --enable-track-vars => > --with-xml => > --with-dom => > --with-ibm-db2=/usr/IBMdb2/V6.1 => > --with-zlib => > --with-curl => > --with-pspell => > --with-mcrypt => > --with-sablot => > --enable-sablot-errors-descriptive => > --enable-inline-optimization => > --enable-trans-sid => > --with-config-file-path=/opt/gr/oas/lib/ --enable-shmop => > => > PHP makes and installs fine. => > => > Apache 1.3.19 is configured with: => > => > SSL_BASE="/usr/local/ssl" \ => > ./configure \ => > "--with-layout=Apache" \ => > "--prefix=/opt/gr/oas/apache/" \ => > "--enable-module=ssl" \ => > "--activate-module=src/modules/php4/libphp4.a" \ => > "--activate-module=src/modules/perl/libperl.a" \ "--enable-module=php4" \ => > "--enable-module=expires" \ => > "--disable-module=include" \ => > => > the make is then failing w/error output of: => > => > gcc -c -I. -I/usr/lib/perl/5.6.0/CORE -I./os/unix -I./include -DLINUX=22 => > -DMOD_SSL=208101 -I/usr/local/buildSource/php-4.0.5 => > -I/usr/local/buildSource/php-4.0.5/main => > -I/usr/local/buildSource/php-4.0.5/main => > -I/usr/local/buildSource/php-4.0.5/Zend => > -I/usr/local/buildSource/php-4.0.5/Zend => > -I/usr/local/buildSource/php-4.0.5/TSRM => > -I/usr/local/buildSource/php-4.0.5/TSRM -I/usr/local/buildSource/php-4.0.5 => > -DMOD_PERL -DUSE_PERL_SSI -DDEBIAN -fno-strict-aliasing => > -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DEAPI => > -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED ./apaci modules.c gcc -c => > -I. -I/usr/lib/perl/5.6.0/CORE -I./os/unix -I./include -DLINUX=22 => > -DMOD_SSL=208101 -I/usr/local/buildSource/php-4.0.5 => > -I/usr/local/buildSource/php-4.0.5/main => > -I/usr/local/buildSource/php-4.0.5/main => > -I/usr/local/buildSource/php-4.0.5/Zend => > -I/usr/local/buildSource/php-4.0.5/Zend => > -I/usr/local/buildSource/php-4.0.5/TSRM => > -I/usr/local/buildSource/php-4.0.5/TSRM -I/usr/local/buildSource/php-4.0.5 => > -DMOD_PERL -DUSE_PERL_SSI -DDEBIAN -fno-strict-aliasing => > -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DEAPI => > -DUSE_EXPAT -I./lib/expat-lite => > -DNO_DL_NEEDED ./apaci buildmark.c => > gcc -DLINUX=22 -DMOD_SSL=208101 -I/usr/local/buildSource/php-4.0.5 -I/usr/local/buildSource/php-4.0.5/main -I/usr/local/buildSource/php-4.0.5/main -I/usr/local/buildSource/php-4.0.5/Zend -I/usr/local/buildSource/php-4.0.5/Zend -I/usr/local/buildSource/php-4.0.5/TSRM -I/usr/local/buildSource/php-4.0.5/TSRM -I/usr/local/buildSource/php-4.0.5 -DMOD_PERL -DUSE_PERL_SSI -DDEBIAN -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DEAPI -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED ./apaci -L/usr/local/ssl/lib \ => > -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/ssl/libssl.a modules/php4/libphp4.a modules/perl/libperl.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -L/usr/IBMdb2/V6.1/lib -ldb2 -ldl -lz -lexpat -lsablot -lpspell -lmcrypt -lltdl -lz -lxml2 -lcurl -lresolv -lm -ldl -lcrypt -lnsl -lresolv -lz -lm -lcrypt -lssl -lcrypto -rdynamic -L/usr/local/lib /usr/lib/perl/5.6.0/auto/DynaLoader/DynaLoader.a -L/usr/lib/perl/5.6.0/CORE -lperl -lnsl -ldl -lm -lc -lcrypt => > modules/php4/libphp4.a(php_odbc.o): In function `_free_odbc_result': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:162: undefined reference to `SQLFreeStmt' => > modules/php4/libphp4.a(php_odbc.o): In function `_close_odbc_conn': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:182: undefined reference to `SQLDisconnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:183: undefined reference to `SQLFreeConnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:184: undefined reference to `SQLFreeEnv' => > modules/php4/libphp4.a(php_odbc.o): In function `_close_odbc_pconn': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:194: undefined reference to `SQLDisconnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:195: undefined reference to `SQLFreeConnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:196: undefined reference to `SQLFreeEnv' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_sql_error': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:491: undefined reference to `SQLError' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_bindcols': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:553: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:561: undefined reference to `SQLColAttributes' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:566: undefined reference to `SQLColAttributes' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:589: undefined reference to `SQLColAttributes' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:592: undefined reference to `SQLBindCol' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_transact': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:613: undefined reference to `SQLTransact' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_column_lengths': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:671: undefined reference to `SQLColAttributes' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_prepare': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:765: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:781: undefined reference to `SQLGetInfo' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:787: undefined reference to `SQLSetStmtOption' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:790: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:800: undefined reference to `SQLPrepare' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:812: undefined reference to `SQLNumParams' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:813: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_execute': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:899: undefined reference to `SQLDescribeParam' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:916: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:936: undefined reference to `SQLBindParameter' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:945: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:951: undefined reference to `SQLExecute' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:958: undefined reference to `SQLParamData' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:961: undefined reference to `SQLPutData' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:978: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:992: undefined reference to `SQLNumResultCols' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:894: undefined reference to `SQLFreeStmt' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_cursor': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1023: undefined reference to `SQLGetInfo' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1035: undefined reference to `SQLGetCursorName' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1043: undefined reference to `SQLError' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1048: undefined reference to `SQLSetCursorName' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_exec': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1104: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1120: undefined reference to `SQLGetInfo' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1126: undefined reference to `SQLSetStmtOption' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1129: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1139: undefined reference to `SQLExecDirect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1147: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1152: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_fetch_into': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1393: undefined reference to `SQLExtendedFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1396: undefined reference to `SQLFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1432: undefined reference to `SQLGetData' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_fetch_row': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1531: undefined reference to `SQLExtendedFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1534: undefined reference to `SQLFetch' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_result': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1613: undefined reference to `SQLExtendedFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1616: undefined reference to `SQLFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1637: undefined reference to `SQLColAttributes' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1652: undefined reference to `SQLGetData' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1695: undefined reference to `SQLGetData' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_result_all': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1753: undefined reference to `SQLExtendedFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1756: undefined reference to `SQLFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1799: undefined reference to `SQLGetData' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1833: undefined reference to `SQLExtendedFetch' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1836: undefined reference to `SQLFetch' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_sqlconnect': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1884: undefined reference to `SQLAllocEnv' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1885: undefined reference to `SQLAllocConnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1902: undefined reference to `SQLSetConnectOption' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1905: undefined reference to `SQLFreeConnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1938: undefined reference to `SQLConnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:1943: undefined reference to `SQLFreeConnect' => > modules/php4/libphp4.a(php_odbc.o): In function `odbc_do_connect': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2089: undefined reference to `SQLGetInfo' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2095: undefined reference to `SQLDisconnect' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2096: undefined reference to `SQLFreeConnect' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_num_rows': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2206: undefined reference to `SQLRowCount' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_next_result': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2234: undefined reference to `SQLMoreResults' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2239: undefined reference to `SQLFreeStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2240: undefined reference to `SQLNumParams' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2241: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_field_type': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2340: undefined reference to `SQLColAttributes' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_autocommit': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2429: undefined reference to `SQLSetConnectOption' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2440: undefined reference to `SQLGetConnectOption' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_setoption': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2550: undefined reference to `SQLSetConnectOption' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2559: undefined reference to `SQLSetStmtOption' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_tables': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2618: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2634: undefined reference to `SQLTables' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2647: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_columns': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2701: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2714: undefined reference to `SQLColumns' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2727: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_columnprivileges': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2780: undefined referenceto `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2793: undefined reference to `SQLColumnPrivileges' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2806: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_foreignkeys': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2878: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2891: undefined reference to `SQLForeignKeys' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2906: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_gettypeinfo': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2957: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2970: undefined reference to `SQLGetTypeInfo' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:2979: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_primarykeys': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3029: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3042: undefined reference to `SQLPrimaryKeys' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3054: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_procedurecolumns': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3111: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3124: undefined reference to `SQLProcedureColumns' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3137: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_procedures': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3193: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3206: undefined reference to `SQLProcedures' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3218: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_specialcolumns': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3279: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3292: undefined reference to `SQLSpecialColumns' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3307: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_statistics': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3364: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3377: undefined reference to `SQLStatistics' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3391: undefined reference to `SQLNumResultCols' => > modules/php4/libphp4.a(php_odbc.o): In function `php_if_odbc_tableprivileges': => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3442: undefined reference to `SQLAllocStmt' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3455: undefined reference to `SQLTablePrivileges' => > /usr/local/buildSource/php-4.0.5/ext/odbc/php_odbc.c:3467: undefined reference to `SQLNumResultCols' => > collect2: ld returned 1 exit status => > make[2]: *** [target_static] Error 1 => > make[2]: Leaving directory `/usr/local/buildSource/apache_1.3.19/src' => > make[1]: *** [build-std] Error 2 => > make[1]: Leaving directory `/usr/local/buildSource/apache_1.3.19' => > make: *** [build] Error 2 => > => > =>