PHP 4.0 Bug #5030: Apache fails to locate PHP-mysql functions

From: Haim_Barad@bigfoot.com Operating system: RedHat 6.1 PHP version: 4.0 Release Candidate 2 PHP Bug Type: Installation problem Bug description: Apache fails to locate PHP-mysql functions Sorry about the poor formatting. I've checked all the FAQs, etc. I'm sure that there just some missing pieces in the compilation. When apache is being built, it can't seem to find the mysql support withing PHP4. I’m using Apache/PHP/MYSQL/Linux – all most recent versions, except I’m on Redhat 6.1, not 6.2. I configure and build php4 with: ./configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.12 --enable-track-vars --with-xml --with-dbase and then configure and build apach-1.3.12 with: ./configure --with-layout=Apache --prefix=/www --enable-module=ssl --activate-module=src/modules/php4/libphp4.a the build seems to go ok, until the last part when httpd is built: gcc -DLINUX=2 -DMOD_SSL=206104 -I/home/admin/php-4.0.0 -I/home/admin/php-4.0.0/Zend -I/home/admin/php-4.0.0/Zend -I/home/admin/php-4.0.0 -DEAPI -DUSE_EXPAT -I./lib /expat-lite -DNO_DL_NEEDED ./apaci -L/home/admin/openssl-0.9.5a \ -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 -rdynamic -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lgdbm -lpam -ldl -lgd -lresolv -lm -ldl -lcrypt -lnsl -lresolv -lm -lcrypt -lssl -lcrypto modules/php4/libphp4.a(php_mysql.o): In function `_free_mysql_result': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:168: undefined reference to `mysql_free_result' modules/php4/libphp4.a(php_mysql.o): In function `_close_mysql_link': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:190: undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.o): In function `_close_mysql_plink': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:202: undefined reference to `mysql_close' modules/php4/libphp4.a(php_mysql.o): In function `php_info_mysql': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:300: undefined reference to `mysql_get_client_info' modules/php4/libphp4.a(php_mysql.o): In function `php_mysql_do_connect': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:432: undefined reference to `mysql_init' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:433: undefined reference to `mysql_real_connect' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:463: undefined reference to `mysql_stat' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:467: undefined reference to `mysql_real_connect' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:517: undefined reference to `mysql_init' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:518: undefined reference to `mysql_real_connect' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_select_db': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:639: undefined reference to `mysql_select_db' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_create_db': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:679: undefined reference to `mysql_create_db' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_drop_db': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:720: undefined reference to `mysql_drop_db' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_query': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:763: undefined reference to `mysql_real_query' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:771: undefined reference to `mysql_store_result' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_db_query': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:816: undefined reference to `mysql_select_db' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:823: undefined reference to `mysql_real_query' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:831: undefined reference to `mysql_store_result' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_list_dbs': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:872: undefined reference to `mysql_list_dbs' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_list_tables': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:913: undefined reference to `mysql_select_db' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:916: undefined reference to `mysql_list_tables' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_list_fields': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:957: undefined reference to `mysql_select_db' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:961: undefined reference to `mysql_list_fields' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_result': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1142: undefined reference to `mysql_data_seek' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1143: undefined reference to `mysql_fetch_row' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1143: undefined reference to `mysql_fetch_lengths' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1162: undefined reference to `mysql_field_seek' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1169: undefined reference to `mysql_fetch_field' modules/php4/libphp4.a(php_mysql.o): In function `php_mysql_fetch_hash': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1284: undefined reference to `mysql_fetch_row' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1284: undefined reference to `mysql_fetch_lengths' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1295: undefined reference to `mysql_field_seek' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1296: undefined reference to `mysql_fetch_field' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1296: undefined reference to `mysql_fetch_field' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_data_seek': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1380: undefined reference to `mysql_data_seek' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_fetch_lengths': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1403: undefined reference to `mysql_fetch_lengths' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_fetch_field': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1498: undefined reference to `mysql_field_seek' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1500: undefined reference to `mysql_fetch_field' modules/php4/libphp4.a(php_mysql.o): In function `php_if_mysql_field_seek': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1542: undefined reference to `mysql_field_seek' modules/php4/libphp4.a(php_mysql.o): In function `php_mysql_field_info': /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1574: undefined reference to `mysql_field_seek' /home/admin/php-4.0.0/ext/mysql/php_mysql.c:1575: undefined reference to `mysql_fetch_field' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/home/admin/apache_1.3.12/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/home/admin/apache_1.3.12' make: *** [build] Error 2 I have the most recent mysql installed in the correct place and the php build references the include files underneath it. Haim