Hello,

I wasn't subscribed to the list when I first sent out this message, and I'm not sure if it went out. If someone did respond, I would appreciate it if they forwarded the message(s) to me.

Sorry for the mixup, Kip

---------- Forwarded message ---------- Date: Fri, 28 Jun 2002 13:31:07 -0400 (EDT) From: Kip C. Lubliner <ki...@acm.jhu.edu> Reply-To: ki...@jhuacm.org To: msql...@lists.mysql.com Subject: 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.