undefined symbol: mysql_real_escape_stromg

While I still have a little hair to pull out, someone please save me.

I've recently upgraded my Linux box to Perl 5.8 and I'm trying to
install the DBI::mysql module. CPAN failed miserably. So I'm trying to
do it by hand.

The make seemed to go ok (with some work), but maybe not. Make test
failed, though. Here is the bulk of the output from "perl Makefile.PL.
I had to pass several libraries to it since it complained that they
weren't there. I simply don't have libgz - could that be killing me?

---------------
cflags (guessed ) = -I/usr/local/include/mysql
libs (Users choice) = -L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc. a -L/usr/local/lib/mysql/libmysqlclient.a -L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc. a -lz -lgz
nocatchstderr (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Note (probably harmless): No library found for -lgz
Using DBI 1.30 installed in /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
-------------

The subsequent make ran ok. Here is the beginning of the output from make test:

-------------
PERL_DL_NONLAZY=1 /usr/local/bin/perl5.8 "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.tt/00base...........install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql /mysql.so' for module DBD::mysql: /root/.cpan/build/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/ mysql.so: undefined symbol: mysql_real_escape_string at /usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
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
-------------

I've searched through the mailing list archives but can't find anything useful.
Can anyone help? Thanks in advance.

--pat--
--
Pat Traynor
pat@ssih.com


------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1902@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.