3 messages in com.mysql.lists.perlDBD::mysql Installation Problem!
FromSent OnAttachments
Zaihua Ji02 Jun 2004 11:36 
Jochen Wiedmann02 Jun 2004 23:35 
Zaihua Ji03 Jun 2004 13:23 
Subject:DBD::mysql Installation Problem!
From:Zaihua Ji (zj@ucar.edu)
Date:06/02/2004 11:36:48 AM
List:com.mysql.lists.perl

Hi,

Versions: gcc => 3.3.2 perl => 5.6.1 mysql => 4.1.1 DBD:mysql => 2.9003

I have installed mysql from source with the same compiler. the make looked fine and make test failed. What dynamic lib I missed?

Thanks,

zj

eldora:DBD-mysql-2.9003% perl Makefile.PL I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/opt/sfw/mysql/include/mysql libs (mysql_config) = -L/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2 -lgcc -L/opt/sfw/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm nocatchstderr (default ) = 0 nofoundrows (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'.

Checking if your kit is complete... Looks good Using DBI 1.42 (for perl 5.006001 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI Writing Makefile for DBD::mysql

eldora:DBD-mysql-2.9003% make cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Mysql.pm blib/lib/Mysql.pm cc -c -I/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI -I/opt/sfw/mysql/include/mysql -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xdepend -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -KPIC -I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE dbdimp.c /bin/sh -c true /bin/sh -c true /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI/Driver.xst > mysql.xsi /usr/bin/perl -I/usr/perl5/5.6.1/lib/sun4-solaris-64int -I/usr/perl5/5.6.1/lib /usr/perl5/5.6.1/lib/ExtUtils/xsubpp -typemap /usr/perl5/5.6.1/lib/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 192 Warning: duplicate function definition 'rows' detected in mysql.xs, line 290 cc -c -I/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI -I/opt/sfw/mysql/include/mysql -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xO3 -xdepend -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -KPIC -I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2:/opt/sfw/mysql/lib/mysql:/lib" /usr/bin/perl myld cc -G dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2 -lgcc -L/opt/sfw/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm chmod 755 blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs chmod 644 blib/arch/auto/DBD/mysql/mysql.bs Manifying blib/man3/DBD::mysql::INSTALL.3 Manifying blib/man3/DBD::mysql.3 Manifying blib/man3/Bundle::DBD::mysql.3 Manifying blib/man3/Mysql.3

eldora:DBD-mysql-2.9003% make test /bin/sh -c true /bin/sh -c true PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/perl5/5.6.1/lib/sun4-solaris-64int -I/usr/perl5/5.6.1/lib -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: ld.so.1: /usr/bin/perl: fatal: relocation error: file /opt/sfw/mysql/lib/mysql/libmysqlclient.so.14: symbol __floatdisf: referenced symbol not found at /usr/perl5/5.6.1/lib/sun4-solaris-64int/DynaLoader.pm line 206. Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected t/00base...........dubious

Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay