[Webdev] PHP with MySQL support compile problem

[Fintan Ryan - Sun Ireland - Computer Systems - CQA Software Engineer]

Hmm,

Trying to compile up a httpd binary with mod_php3 enabled at the moment, and 
its not having any of it.

I'm getting the following error on my make (most snipped for brevity).

gcc  -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite 
-DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci`  
-L/usr/local/lib -R/usr/local/lib  \
      -o httpd buildmark.o modules.o modules/php3/libphp3.a 
modules/standard/libstandard.a main/libmain.a ./os/unix/libos.a ap/libap.a 
regex/libregex.a lib/expat-lite/libexpat.a  -R/usr/local/lib/mysql  
-L/usr/local/lib/mysql -Lmodules/php3 -L../modules/php3 -L../../modules/php3 
-lmodphp3                        -lpam -lm -ldl -lsocket -lnsl  -lresolv  
-lsocket -lnsl 
Undefined                       first referenced
 symbol                             in file
mysql_get_client_info               modules/php3/libphp3.a(mysql.o)
mysql_drop_db                       modules/php3/libphp3.a(mysql.o)
mysql_close                         modules/php3/libphp3.a(mysql.o)
mysql_fetch_lengths                 modules/php3/libphp3.a(mysql.o)
mysql_free_result                   modules/php3/libphp3.a(mysql.o)
mysql_create_db                     modules/php3/libphp3.a(mysql.o)
mysql_field_seek                    modules/php3/libphp3.a(mysql.o)
mysql_list_fields                   modules/php3/libphp3.a(mysql.o)
mysql_fetch_row                     modules/php3/libphp3.a(mysql.o)
mysql_real_query                    modules/php3/libphp3.a(mysql.o)
mysql_real_connect                  modules/php3/libphp3.a(mysql.o)
mysql_stat                          modules/php3/libphp3.a(mysql.o)
mysql_fetch_field                   modules/php3/libphp3.a(mysql.o)
mysql_list_dbs                      modules/php3/libphp3.a(mysql.o)
mysql_select_db                     modules/php3/libphp3.a(mysql.o)
mysql_store_result                  modules/php3/libphp3.a(mysql.o)
mysql_list_tables                   modules/php3/libphp3.a(mysql.o)
mysql_data_seek                     modules/php3/libphp3.a(mysql.o)
mysql_init                          modules/php3/libphp3.a(mysql.o)
ld: fatal: Symbol referencing errors. No output written to httpd
collect2: ld returned 1 exit status
make[2]: *** [target_static] Error 1
make[2]: Leaving directory `/scratch/webdev/apache_1.3.12/src'
make[1]: *** [build-std] Error 2
make[1]: Leaving directory `/scratch/webdev/apache_1.3.12'
make: *** [build] Error 2

So its a problem with ld, but what is it? I've gone as far as trying to do 
each step by hand, and it won't work. I've removed things such as Oracle 
support as well, checked the LIBS flags, CFLAGS etc, and I'm stumped.

Sytem is an E220, dual processor, 2 gigs ram running Solaris 8 with the 
recommended patch sets. All the standard gnu tools are installed. MySQL was 
installed from source and is working fine. MySQL configure had 
--prefix=/usr/local. There is a reason for using the old versions of both php 
and apache.

Any suggestions would be appreciated.

l8r,
Fintan


Fintan Ryan, Software Engineer, SunConfigs	
fintan.ryan at sun.com	http://www.sun.com