FW: test error on installation of DBD::mysql v2.1026 with mysql v

FW: test error on installation of DBD::mysql v2.1026 with mysql v

am 05.05.2005 10:53:17 von gonchi

I had the similar problem with DBD::mysql in sparc solaris servers but I
think that the test isn't faithful when it fails. Binaries DBD::mysql
installed after this work without any problems, this driver works with the
same dynamics libraries I used to compile the DBD before. I think if I had
installed the driver compiled by me also it had worked. Few weeks ago I
installed in a new SuSe server DBD::msql and I got very similar error in the
test then I decided to install it although the test failed, I found
everything work fine. The test doesn't work correctly, I found directories
pointing to incorrect sites to load the drivers, the problem is I can't
understand the make files to fix it. I recommend to people have problems
with driver dynamics loading in the test stage to install the driver anyway
and to check it after installations, the test is not faithful.

-----Original Message-----
From: Tim Maynard [mailto:tim@redeyeusa.com]
Sent: Monday, April 25, 2005 11:03 PM
To: perl@lists.mysql.com
Subject: 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.
tim@redeyeusa.com
1.877.733.3931 x296


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org