List:MySQL and Perl« Previous MessageNext Message »
From:Tim Maynard Date:May 5 2005 1:30pm
Subject:RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11
View as plain text  
installed it anyways and received seg faults on the test script
during the database connection, which is the same error given
by the test script.

ill look into binaries although i have always favored an
optimized/custom install of key applications on my servers

--------------------------------------------------------
test_mysql.pl

#!/usr/bin/perl -w

use strict;
use DBI;

# global values
my $host = 'host.ip.add.res';
my $db   = 'host_db';
my $tbl  = 'host_table';
my $idx  = 'table_key';
my $user = 'username';
my $pswd = 'password';

my( $dbh, $sql, $sth, $cur );

print qq~connecting to db...\n~;
$dbh = DBI->connect("dbi:mysql:$db:$host",$user,$pswd) or
       die(qq~cant open db connection: $!~);

$sql = qq~select distinct $idx from $tbl order by $idx desc limit 25~;

print qq~preparing sql statement...\n~;
$sth = $dbh->prepare( $sql );

print qq~executing statement...\n~;
$sth->execute();

print qq~fetching data by row arrays...\n~;
while( $cur = ($sth->fetchrow_array())[0] ){
	print qq~found: '$cur'\n~;
}

print qq~done.\n~;

--------------------------------------------------------
output:

connecting to db...
Segmentation fault

--------------------------------------------------------
still would like to know whats going on though...
test seems to be valid in my case.


-----Original Message-----
From: Yair Lapin [mailto:yairl@stripped] 
Sent: Thursday, May 05, 2005 4:53 AM
To: perl@stripped
Cc: Tim Maynard
Subject: FW: test error on installation of DBD::mysql v2.1026 with mysql
v4.1.11




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@stripped] 
Sent: Monday, April 25, 2005 11:03 PM
To: perl@stripped
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@stripped
1.877.733.3931 x296
 
Thread
test error on installation of DBD::mysql v2.1026 with mysql v4.1.11Tim Maynard25 Apr
RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11Tim Maynard5 May
  • RE: test error on installation of DBD::mysql v2.1026 with mysqlv4.1.11Rudy Lippan5 May
RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11Tim Maynard5 May
  • RE: test error on installation of DBD::mysql v2.1026 with mysqlv4.1.11Rudy Lippan5 May
RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11Tim Maynard5 May
RE: test error on installation of DBD::mysql v2.1026 with mysql v4.1.11Tim Maynard10 May