[Mod_log_sql] mod_log_sql will not configure on Solaris 8

[Steven K.Wieda]

Greetings.

I'm attempting to compile mod_log_sql on a Solaris 8 system running apache
2.0.47 and MySQL Ver 12.21 Distrib 4.0.14.  The configure script is pooting out
with the following lines:

checking for mysql_init in -lmysqlclient... no
configure: error: libmysqlclient is needed for MySQL support

The pertinent portion of the config.log file is as follows:

configure:2780: gcc -o conftest -g -O2 -I/opt/mysql/include
-I/opt/mysql/include/mysql -I/opt/mysql/mysql/include   -L/opt/mysql/lib -L/opt
/mysql/lib/mysql -L/opt/mysql/mysql/lib conftest.c -lmysqlclient  -lz -lm  >&5
Undefined                       first referenced
 symbol                             in file
getservbyname                       /opt/mysql/lib/libmysqlclient.a(libmysql.o)
gethostbyname_r                     /opt/mysql/lib/libmysqlclient.a(libmysql.o)
socket                              /opt/mysql/lib/libmysqlclient.a(libmysql.o)
setsockopt                          /opt/mysql/lib/libmysqlclient.a(viosocket.o)
connect                             /opt/mysql/lib/libmysqlclient.a(libmysql.o)
getpeername                         /opt/mysql/lib/libmysqlclient.a(viosocket.o)
inet_addr                           /opt/mysql/lib/libmysqlclient.a(libmysql.o)
inet_ntoa                           /opt/mysql/lib/libmysqlclient.a(my_net.o)
shutdown                            /opt/mysql/lib/libmysqlclient.a(viosocket.o)
ld: fatal: Symbol referencing errors. No output written to conftest
collect2: ld returned 1 exit status
configure:2783: $? = 1

********************************

libmysqlclient.a exists in the /opt/mysql/lib directory, and mysql.h can be
found in /opt/mysql/include.  Running nm on the libmysqlclient.a file for
mysql_init yields the following:

root$ nm libmysqlclient.a | grep mysql_init
[161]   |     12040|     132|FUNC |GLOB |0    |3      |mysql_init

*********************************

Unfortunately, I adopted the system as-is.  I know that mysql was compiled from
source but do not have the specifics of the compile options beyond what I can
find in the directory tree and through experimentation.  Any guidence on where
to go from here to get the module configured and compiled would be greatly
appreciated.

Many thanks, and regards,

--steve