Problem building the rlm_mysql module

[Alan]

I am having a problem building the rlm_mysql module. Can someone tell me
what im doing wrong here? Please help. 

OS:
RedHat Enterprise 3 WS - Clean install

Hardware:
Sunfire 20z AMD-64bit

Mysql Package:
MySQL-client-standard-5.0.22-0.rhel3.x86_64.rpm
MySQL-devel-standard-5.0.22-0.rhel3.x86_64.rpm
MySQL-server-standard-5.0.22-0.rhel3.x86_64.rpm
MySQL-shared-compat-5.0.22-0.rhel3.x86_64.rpm

--------------------

I tried to build the module just for debugging my problem directly in the
module sources directory.


[abaker at sip rlm_sql_mysql]$ make all
/home/abaker/src/freeradius-1.1.2/libtool --mode=compile gcc  -g -O2
-I../.. -I/home/abaker/src/freeradius-1.1.2/src/include -I/usr/include/mysql
-g -pipe  -c sql_mysql.c
mkdir .libs
gcc -g -O2 -I../.. -I/home/abaker/src/freeradius-1.1.2/src/include
-I/usr/include/mysql -g -pipe -c sql_mysql.c  -fPIC -DPIC -o
.libs/sql_mysql.lo
sql_mysql.c: In function `sql_error':
sql_mysql.c:333: warning: return discards qualifiers from pointer target
type
gcc -g -O2 -I../.. -I/home/abaker/src/freeradius-1.1.2/src/include
-I/usr/include/mysql -g -pipe -c sql_mysql.c -o sql_mysql.o >/dev/null 2>&1
mv -f .libs/sql_mysql.lo sql_mysql.lo
/home/abaker/src/freeradius-1.1.2/libtool --mode=link gcc -release 1.1.2 \
-module -export-dynamic   -o rlm_sql_mysql.la \
-rpath /clique/freeradius-1.1.2/lib sql_mysql.lo -L/usr/lib64/mysql
-lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread 
 
*** Warning: This library needs some functionality provided by
/usr/lib64/mysql/libmysqlclient_r.la.
*** I have the capability to make that library automatically link in when
*** you link to this library.  But I can only do this if you have a
*** shared version of the library, which you do not appear to have.
*** Therefore, libtool will create a static module, that should work 
*** as long as the dlopening application is linked with the -dlopen flag.
rm -fr .libs/rlm_sql_mysql.la .libs/rlm_sql_mysql.*
.libs/rlm_sql_mysql-1.1.2.*
ar cru .libs/rlm_sql_mysql.a  sql_mysql.o 
ranlib .libs/rlm_sql_mysql.a
creating rlm_sql_mysql.la
(cd .libs && rm -f rlm_sql_mysql.la && ln -s ../rlm_sql_mysql.la
rlm_sql_mysql.la)