test error on installation of DBD::mysql v2.1026 with mysql v4.1.11

trying to compile on RedHat 9.0 with Perl 5.8.6 and MySQL 4.1.11
i have /usr/lib/mysql in the /etc/ld.so.conf and in $LD_RUN_PATH
i have also soft-linked the /usr/local/mysql/lib/* to /usr/lib
and /usr/local/mysql/include/mysql/* to /usr/include/mysql
 
i cannot find out why that symbol in undefined anywhere.
 
--------------------------------------------------------
error from make test, used simple 'perl Makefile.PL' to configure:
 
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'/var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_drop_db at
/usr/lib/perl5/5.8.6/i686-linux/DynaLoader.pm line 230.
 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
t/00base...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay
t/10dsnlist........install_driver(mysql) failed: Can't load
'/var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_drop_db at
/usr/lib/perl5/5.8.6/i686-linux/DynaLoader.pm line 230.
 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/10dsnlist.t line 45
t/10dsnlist........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
        Failed 9/9 tests, 0.00% okay

<... edit (same message) ...>
 
t/akmisc...........Had to create DBD::mysql::dr::imp_data_size
unexpectedly at /usr/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line
1167.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line 1167.
Can't locate object method "connect" via package "Mysql" at
/var/src/DBD-mysql-2.1026/blib/lib/Mysql.pm line 71.
t/akmisc...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-351
        Failed 351/351 tests, 0.00% okay
t/dbdadmin.........install_driver(mysql) failed: Can't load
'/var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: /var/src/DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_drop_db at
/usr/lib/perl5/5.8.6/i686-linux/DynaLoader.pm line 230.
 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/dbdadmin.t line 74
t/dbdadmin.........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-21
        Failed 21/21 tests, 0.00% okay

<... edit (same message) ...>
 
t/mysql2...........Had to create DBD::mysql::dr::imp_data_size
unexpectedly at /usr/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line
1167.
Use of uninitialized value in subroutine entry at
/usr/lib/perl5/site_perl/5.8.6/i686-linux/DBI.pm line 1167.
Can't locate object method "connect" via package "Mysql" at
/var/src/DBD-mysql-2.1026/blib/lib/Mysql.pm line 71.
t/mysql2...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
Failed Test       Stat Wstat Total Fail  Failed  List of Failed
------------------------------------------------------------------------
-------
t/00base.t         255 65280     5    4  80.00%  4-5
t/10dsnlist.t      255 65280     9   18 200.00%  1-9
t/20createdrop.t   255 65280     5   10 200.00%  1-5
t/30insertfetch.t  255 65280    11   22 200.00%  1-11
t/40bindparam.t    255 65280    28   56 200.00%  1-28
t/40blobs.t        255 65280    11   22 200.00%  1-11
t/40listfields.t   255 65280    16   32 200.00%  1-16
t/40nulls.t        255 65280    11   22 200.00%  1-11
t/40numrows.t      255 65280    25   50 200.00%  1-25
t/50chopblanks.t   255 65280    35   70 200.00%  1-35
t/50commit.t       255 65280    30   60 200.00%  1-30
t/ak-dbd.t         255 65280    90  180 200.00%  1-90
t/akmisc.t         255 65280   351  702 200.00%  1-351
t/dbdadmin.t       255 65280    21   42 200.00%  1-21
t/insertid.t       255 65280    12   24 200.00%  1-12
t/mysql.t          255 65280    68  136 200.00%  1-68
t/mysql2.t         255 65280    ??   ??       %  ??
1 test skipped.
Failed 17/18 test scripts, 5.56% okay. 725/728 subtests failed, 0.41%
okay.

--------------------------------------------------------
mysql v4.1.11 installation options/configuration (config.nice):
 
CFLAGS="-O3"; export CFLAGS
CXX="gcc"; export CXX
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"; export
CXXFLAGS
"./configure" \
"--prefix=/usr/local/mysql" \
"--exec-prefix=/usr" \
"--with-zlib-dir=/usr" \
"--with-debug" \
"--with-openssl" \
"--with-charset=latin1" \
"--with-extra-charsets=complex" \
"--enable-assembler" \
"--enable-thread-safe-client" \
"--enable-shared" \
"--enable-client-ldflags=-rdynamic" \
"--enable-mysqld-ldflags=-rdynamic" \
"--with-berkeley-db=/usr/local/BerkeleyDB.4.1" \
"--with-openssl-includes=/usr/local/ssl/include" \
"--with-openssl-libs=/usr/local/ssl/lib" \

--------------------------------------------------------
ldd ./DBD-mysql-2.1026/blib/arch/auto/DBD/mysql/mysql.so
 
 libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
(0x4000f000)
 libz.so.1 => /usr/lib/libz.so.1 (0x40201000)
 libcrypt.so.1 => /lib/libcrypt.so.1 (0x40221000)
 libnsl.so.1 => /lib/libnsl.so.1 (0x4024e000)
 libm.so.6 => /lib/tls/libm.so.6 (0x40263000)
 libssl.so.4 => /lib/libssl.so.4 (0x40286000)
 libcrypto.so.4 => /lib/libcrypto.so.4 (0x402bb000)
 libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
 libresolv.so.2 => /lib/libresolv.so.2 (0x403ac000)
 libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2
(0x403be000)
 libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x403d1000)
 libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40430000)
 libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40440000)
 libdl.so.2 => /lib/libdl.so.2 (0x40442000)
 /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

--------------------------------------------------------
ldd /usr/bin mysql
 
 libncurses.so.5 => /usr/lib/libncurses.so.5 (0x40029000)
 libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
(0x40068000)
 libcrypt.so.1 => /lib/libcrypt.so.1 (0x4025a000)
 libnsl.so.1 => /lib/libnsl.so.1 (0x40287000)
 libm.so.6 => /lib/tls/libm.so.6 (0x4029c000)
 libz.so.1 => /usr/lib/libz.so.1 (0x402bf000)
 libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
 /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

--------------------------------------------------------
perl v5.8.6 installation options/configuration (myconfig):
 
Summary of my perl5 (revision 5 version 8 subversion 6) configuration:
  Platform:
    osname=linux, osvers=2.4.20-6, archname=i686-linux
    uname='linux ranma 2.4.20-6 #1 thu feb 27 10:01:19 est 2003 i686
athlon i386 gnulinux '
    config_args=''
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
    optimize='-O2',
    cppflags='-fno-strict-aliasing -pipe -I/usr/local/include
-I/usr/include/gdbm'
    ccversion='', gccversion='3.2.2 20030222 (Red Hat Linux 3.2.2-5)',
gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
    perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
    libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version='2.3.2'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E
-Wl,-rpath,/usr/lib/perl5/5.8.6/i686-linux/CORE'
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'

--------------------------------------------------------
ldd /usr/bin/perl
 
 libperl.so => /usr/lib/perl5/5.8.6/i686-linux/CORE/libperl.so
(0x40017000)
 libnsl.so.1 => /lib/libnsl.so.1 (0x4011a000)
 libdl.so.2 => /lib/libdl.so.2 (0x4012f000)
 libm.so.6 => /lib/tls/libm.so.6 (0x40132000)
 libcrypt.so.1 => /lib/libcrypt.so.1 (0x40154000)
 libutil.so.1 => /lib/libutil.so.1 (0x40182000)
 libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
 /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

 
-- Tim Maynard
 
Redeye Distribution, Inc.
[email protected]
1.877.733.3931 x296