install using static libmysqlclient.a, not root

Hello,
I am trying to install DBD::Mysql on a freeBSD box. MySQL isn't installed
as root, it is installed in the user directory.

I wasn't the one to install the Mysql server, but the following files
exist:

~/usr/local/mysql/lib/mysql/libmysqlclient.a
~/usr/local/mysql/include/mysql/mysql.h



I have installed DBD and Data::ShowTable to
~/perllibs
by using CPAN, setting LIB= that dir.


I am trying to install DBD::Mysql via
perl LIB=~/perllibs --cflags=-I~/usr/local/mysql/include/mysql \
--libs='-L~/usr/local/mysql/lib/mysql -lmysqlclient'

Then 'make' works. When I try to do 'make test', I get the following
error message:

PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.
6.1/i386-freebsd -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD
/mysql/mysql.so' for module DBD::mysql: blib/arch/auto/DBD/mysql/mysql.so: Undef
ined symbol "mysql_real_escape_string" at /usr/local/lib/perl5/5.6.1/i386-freebs
d/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/00base.t line 38



If anyone knows what I am doing wrong, I would appreciate being clued in.
Thanks a bunch,
Kip.


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1836@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.